DevTech101

DevTech101

Monitoring

How to clear an Oracle Enterprise Manager Ops Center stuck job

Solution to clear an Oracle Enterprise Manager Ops Center stuck job Solution Notes The solution below should work with any stuck job not willing to disappear, i.e. if you try stopping the job from the UI or CLI and its not working. The issue and solution below are even for the latest Oracle Enterprise Manager …

How to clear an Oracle Enterprise Manager Ops Center stuck job Read More »

To enable Ops Cenetr domain model (debug)

http://emoc1.domain.com:8072/xvm/ cacaoadm set-param -i oem-ec java-flags="-d64 -Xms200M -Xmx8192M -server -XX:StringTableSize=27001 -XX:PermSize=128m -XX:MaxPermSize=384m -Xss256k -XX:+UseParallelOldGC -Dsun.security.pkcs11.enable-solaris=false -Djava.endorsed.dirs=/usr/lib/cacao/lib/endorsed -Dxvmserver=false" #cacaoadm get-param -i oem-ec java-flags java-flags=-d64 -Xms200M -Xmx8192M -server -XX:StringTableSize=27001 -XX:PermSize=128m -XX:MaxPermSize=384m -Xss256k -XX:+UseParallelOldGC -Dsun.security.pkcs11.enable-solaris=false -Djava.endorsed.dirs=/usr/lib/cacao/lib/endorsed -Dxvmserver=false -Dcom.sun.cacao.debug  

Ops Center tablespcae configuration

sqlplus / as sysdba @createOCSchema_remote.sql "SQLTrace: Entering createOCSchema_remote.sql" Enter username for Ops Center database login: opsmon Enter password for Ops Center database login: Enter username for read only Ops Center database login: opsmon_ro Enter password for read only Ops Center database login: Enter default tablespace for Ops Center user: OC_USERS Enter report tablespace for Ops …

Ops Center tablespcae configuration Read More »

EM12c agent high CPU spikes on Solaris SPARC.

12c EM Agent CPU spiking and High Usage on Solaris with many Database and Listener Targets (Doc ID 1536871.1) File to modify the properties /u01/app/oracle/agent12c-u4/agent_inst/sysman/config/emd.properties Agent logs /u01/app/oracle/agent12c-u4/agent_inst/sysman/log Check agent status  /u01/app/oracle/agent12c-u4/core/12.1.0.4.0/bin/emctl status agent Check OMS status emctl status oms -details

OMS DB drop

First stop all process (make sure with ps -ef, if not the drop will fail) Stop the agent and OMS /u01/app/oracle/agent12c-u4/core/12.1.0.4.0/bin/emctl stop agent /u01/app/oracle/middleware/oms/bin/emctl stop oms -all Then drop the DB cd /u01/app/oracle/middleware/oms/sysman/admin/emdrep/bin ./RepManager emdb1.domain.com 1521 OEM -action drop -dbUser sys -dbPassword password -dbRole sysdba -reposName SYSMAN -mwHome /u01/app/oracle/middleware/ -mwOraHome /u01/app/oracle/middleware/ -oracleHome /u01/app/oracle/middleware/oms/