Monday, August 12, 2013

Oracle Enterprise Manager Installation and Configuraiton (OEM) 12C

Download Link:

Download Oracle Enterprise Manager from the following link:

http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html

Latest version as of Today is :

Oracle Enterprise Manager Cloud Control 12c Release 3 (12.1.0.3) for Windows x86-64 (64-bit)

Run this on db for avoiding following errors:

ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;
commit; 

and restart db. 

Errors: 


Check the processes instance parameter value The processes instance parameter needs to be set to at least 300.
Check the memory_target instance parameter value. Oracle recommends setting either memory_target (AMM) or sga_target (ASMM) to manage the EM repository instance memory.
Check the session_cached_cursors instance parameter value. The session_cached_cursors instance parameter should be set to any value between 200 and 500, inclusive, will be accepted.
Check the shared_pool_size instance parameter value. The shared_pool_size instance parameter should be set to at least 300000000 bytes or roughly one third of the sga_target size.


Installation Steps: 






                            





To avoid following errors run the sql scripts provided above.













Thanks!!!

No comments:

Post a Comment

Other Posts