Re: Do not see database on OEM 10g Grid Control

  • From: "Wojciech Skrzynecki" <wojciech.skrzynecki@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 21 Sep 2006 22:17:47 +0200

On 9/19/06, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote:

Look in your Oracle 10g Agent Oracle_home/sysman/emd directory for the
targets.xml file.  Look and see if your databases are all declared in
that file.


I do not know how this file gets created.  I updated my file to add and
correct database entries and it seems to work fine.  I have not found
any documentation saying how to discover targets nor if this is the
proper way to do things.

So update this file at your own risk.  Bounce the agent afterward to
make the changes sticky.

Good Luck!


Thanks Tomas for idea, I have edited targets.xml and set VALUE and PASSWORD (second, eighth lines) on dbsnmp and set ENCRYPTED on FALSE. I have also changed password for DBSNMP user in database on dbsnmp.

1.      <Property TYPE="oracle_database" NAME="">
2.      <Property NAME="OracleHome" VALUE="C:\oracle\ora92"/>
3.      <Property NAME="UserName" VALUE="dbsnmp" ENCRYPTED="FALSE/>
4.      <Property NAME="MachineName" VALUE=""/>
5.      <Property NAME="Port" VALUE="1521"/>
6.      <Property NAME="SID" VALUE="sid "/>
7.      <Property NAME="ServiceName" VALUE=""/>
8.      <Property NAME="password" VALUE="dbsnmp" ENCRYPTED="FALSE/>

Next I run 'emctl start agent' and success -  OEM GRID saw database.
Unfortunately nothing is perfect. When I changed all passwords on
other than dbsnmp in both database and targets.xml I can not see
database in GRID OEM. I have had error like below:

Thread-2984 WARN  collector: <nmecmc.c> Error exit. Error message:
ORA-01017: invalid username/password; logon denied (DBD ERROR:

Why I can not change password on other than dbsnmp for DBSNMP user? Could you explain me what do second and eighth lines mean? What for do I have to write a password twice?


Other related posts: