Guenadi N Jilevski's Oracle BLOG

Oracle EM Grid Control agent reconfiguration after database upgrade

Oracle EM Grid Control agent reconfiguration after database upgrade

If you upgrade an Oracle database or start the database from a new Oracle Home, the following needs to be done for Oracle EM Grid Control to recognize the change and for the database to be monitored via the OEM Grid Control.

Shutdown the agent on the box as show below.

cd $AGENT_HOME/bin

./emctl stop agent.

Next make a copy and then edit the following file as shown below.

Location – AGENT_HOME/sysman/emd/targets.xml

Targets AGENT_TOKEN=”1982fef1f5fe5b9c54e2d1e2edd8c4e875c889df”
Target TYPE=”oracle_emd” NAME=”linuxoel54:3872″/
Target TYPE=”host” NAME=”linuxoel54″/
Target TYPE=”oracle_listener” NAME=”LISTENER_linuxoel54″
Property NAME=”ListenerOraDir” VALUE=”/u01/app/oracle/product/10.2.0/network/admin”/
Property NAME=”LsnrName” VALUE=”LISTENER”/
Property NAME=”Machine” VALUE=”10.200.11.34″/
Property NAME=”OracleHome” VALUE=”/u01/app/oracle/product/10.2.0″/
Property NAME=”Port” VALUE=”1521″/
/Target
Target TYPE=”oracle_database” NAME=”linuxoel54.gj.com”
Property NAME=”OracleHome” VALUE=”/u01/app/oracle/product/10.2.0“/
Property NAME=”UserName” VALUE=”dbsnmp”/
Property NAME=”MachineName” VALUE=”10.200.11.34″/
Property NAME=”Port” VALUE=”1521″/
Property NAME=”SID” VALUE=”db10g”/
Property NAME=”ServiceName” VALUE=”linuxoel54.gj.com”/
Property NAME=”password” VALUE=”8b139e37c2544353″ ENCRYPTED=”TRUE”/
Property NAME=”Role” VALUE=”NORMAL”/
/Target
/Targets

Make changes to ORACLE_HOME – Notice above I have changed the OH to point to the 10g HOME.

Restart the agent as illustrated below.

cd $AGENT_HOME/bin

./emctl start agent –

After a minute or so –

./emctl status agent – to make sure uploads are happening to the repository on prdu010.

• ./emctl status agent
  Oracle Enterprise Manager 10g Release 4 Grid Control 10.2.0.4.0.
  Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
  —————————————————————
  Agent Version : 10.2.0.4.0
  OMS Version : 10.2.0.4.0
  Protocol Version : 10.2.0.4.0
  Agent Home : /u01/app/oracle/product/agent10g
  Agent binaries : /u01/app/oracle/product/agent10g
  Agent Process ID : 1593568
  Parent Process ID : 2007106
  Agent URL : https://linuxoel54:3872/emd/main/
  Repository URL : https://linuxoel64.gj.com:1159/em/upload
  Started at : 2009-04-17 13:20:18
  Started by user : unknown
  Last Reload : 2009-04-17 13:20:18
  Last successful upload : 2009-04-17 09:33:06
  Last attempted upload : 2009-04-17 09:37:39
  Total Megabytes of XML files uploaded so far : 102.26
  Number of XML files pending upload : 0
  Size of XML files pending upload(MB) : 0.00
  Available disk space on upload filesystem : 30.16%
  Last attempted heartbeat to OMS : 2009-04-17 10:43:55
  Last successful heartbeat to OMS : 2009-04-17 10:12:39
  —————————————————————
  Agent is Running and Ready
  

]

April 26, 2009 - Posted by gjilevski | oracle