Oracle Systems DBA Reference

Database, UNIX, etc. @ 15zips

OEM

Remove an agent target that won’t delete.

Make sure all targets are deleted in OMS – may try force deletion. Then, run as sysman in repository: exec mgmt_admin.cleanup_agent(‘:‘);

OEM and OMS Clean reset of the logfiles (manual)

Reset OEM Agent Logs: cd $ORACLE_HOME/sysman/log mkdir old_logs_[date] cp -pf agabend.log emagent.log emagent.nohup emagent_perl.trc emagent.trc emctl.log emdctl.trc old_logs_[date] cat /dev/null > agabend.log cat /dev/null > emagent.log cat /dev/null > emagent.nohup cat /dev/null > emagent_perl.trc cat /dev/null > emagent.trc cat /dev/null > emctl.log cat /dev/null > emdctl.trc Reset OEM OMS Logs: cd $ORACLE_HOME/sysman/log mkdir old_logs_[date] cp […]

OEM Ports

What ports are used in communication between the Grid Control OMS and a Management Agent? Enterprise Manager Grid Control – Version: 10.2 Which ports need to be opened when a firewall is between an Enterprise Manager 10g, Release 2 OMS and an Oracle Management Agent? Oracle Management Server (OMS) > Oracle Management Agent (OMA) communication […]

How To Change The Sysman Password for Grid Control

(Note:270516.1) You need to change the sysman user password for Grid Control. Sysman is the owner of the EM 10g Repository schema so the password change must be made in the Database as well as in the EM configuration files. The instructions are listed below. To change the Sysman password: 1. Stop the OMS instances […]

Re-secure the agent in OEM

Solution 1. Re-secure the OMS: a)Stop the OMS and AS components: opmnctl stopall b)Secure the OMS: emctl secure oms c)Start the OMS and AS components: opmnctl startall 2. Re-secure the Agent: a)Stop the agent: emctl stop agent b)Secure the agent: emctl secure agent c)Start the agent: emctl start agent 3 Force a clearstate and an […]

OEM Clean Restart

1. Stop the agent /bin/emctl stop agent * This is the point where you would change emd.properties, etc. 2. Clean start the agent: 2.1. Delete any pending upload files from the agent home rm -r sysman/emd/state/* rm -r sysman/emd/collection/* rm -r sysman/emd/upload/* rm sysman/emd/lastupld.xml rm sysman/emd/agntstmp.txt rm sysman/emd/blackouts.xml rm sysman/emd/protocol.ini 2.2. Start the agent /bin/emctl […]

EMCTL & OEM AGENT commands

List the targets: emctl config agent listtargets Show agent status: emctl status agent Show if agent is secured: emctl secure status agent