DevTech101

DevTech101

Enterprise Manager 12c

Oracle Enterprise Manager, ASM Tips and Tricks

Contents 1 To set system password 2 EM Cloud control help 3 EM cloud control process order 4 How to deploy a plugin 5 References To set system password ALTER USER system IDENTIFIED BY password; EM Cloud control help #To stop Oracle Management Service GUI only emctl stop oms # To stop all services emctl …

Oracle Enterprise Manager, ASM Tips and Tricks Read More »

Enterprise Manager Deleting Targets Manually With CLI

Enterprise Manager deleting a target manually First stop the agent. ./emctl stop agent Oracle Enterprise Manager Cloud Control 13c Release 1 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. Stopping agent … stopped. emcli login -username=sysman emcli sync emcli delete_target -name=”em-host.domain.com:3872″ -type=”oracle_emd” -delete_monitored_targets Now Uninstall the agent export ORACLE_HOME=export ORACLE_HOME=/u01/app/agent/core/12.1.0.2.0 $ORACLE_HOME/oui/bin/runInstaller -deinstall -removeallfiles # …

Enterprise Manager Deleting Targets Manually With CLI Read More »

Enterprise Manager Cloud Control 12c startup issues

At startup first log directory /u01/app/oracle/gc_inst-r5/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.log After that log directory /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/log/ Note: By setting memory to low, like below OMS will hang and never complete startup emctl set property -name ‘JAVA_EM_MEM_ARGS’ -value ‘-Xms256m -Xmx1740m’ How to increase the memory on EM 12c https://community.oracle.com/community/support/support-blogs/enterprise-manager-support-blog/blog/2015/01/20/how-to-tune-the-jvm-heap-memory-arguments-for-12c-oms-and-agent

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/

Oracle Enterprise Manager Add BI publisher

As the oracle user backup the repo emctl exportconfig oms To install BI cd /oracle/middleware/oms/bin ./configureBIP Enter the password Example output Creating SYSMAN_BIPPLATFORM Schema in EM Repository Database Configuring BI Publisher in Oracle Home located in /oracle/middleware/Oracle_BI1 … Processing command line …. Repository Creation Utility – Checking Prerequisites Checking Global Prerequisites Repository Creation Utility – …

Oracle Enterprise Manager Add BI publisher Read More »