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=”″/
Property NAME=”OracleHome” VALUE=”/u01/app/oracle/product/10.2.0″/
Property NAME=”Port” VALUE=”1521″/
Target TYPE=”oracle_database” NAME=””
Property NAME=”OracleHome” VALUE=”/u01/app/oracle/product/10.2.0“/
Property NAME=”UserName” VALUE=”dbsnmp”/
Property NAME=”MachineName” VALUE=”″/
Property NAME=”Port” VALUE=”1521″/
Property NAME=”SID” VALUE=”db10g”/
Property NAME=”ServiceName” VALUE=””/
Property NAME=”password” VALUE=”8b139e37c2544353″ ENCRYPTED=”TRUE”/
Property NAME=”Role” VALUE=”NORMAL”/

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
    Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
    Agent Version :
    OMS Version :
    Protocol Version :
    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 :
    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 | oracle

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: