DevTech101

DevTech101

Enterprise Manager

Configuring BDA

How to add scoop2 Doc ID 1922701.1 If it fails use Doc ID 1966882.1 Note: Clear the directory before starting as old junk will make it fail. P.S. Make sure you are not removing other jar files. rm -r /var/lib/sqoop2/* Hive issues, make sure to set full rights to the hive tmp dir hadoop fs …

Configuring BDA 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 »

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 »