Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA 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 | oracle

No comments yet.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: