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)
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;
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. |
Thanks!!!
No comments:
Post a Comment