Configuring BDA

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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 […]

Read More

Enterprise Manager Deleting Targets Manually With CLI

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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 # […]

Read More

EM12c agent high CPU spikes on Solaris SPARC.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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

Read More

OMS DB drop

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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/

Read More

Oracle Enterprise Manager Add BI publisher

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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 – […]

Read More