Sorry to correct you, but you have the password just once in the file, the first time (line 3) it's the username. Besides, what doi you mean 'changing the other username/passwords in targets.xml', only dbsnmp should be there.
rgds On 9/21/06, Wojciech Skrzynecki <wojciech.skrzynecki@xxxxxxxxx> wrote:
On 9/19/06, Mercadante, Thomas F (LABOR) <Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote: > Wojciech, > > 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. > > **Warning** > > 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="sid.xxx.local"> 2. <Property NAME="OracleHome" VALUE="C:\oracle\ora92"/> 3. <Property NAME="UserName" VALUE="dbsnmp" ENCRYPTED="FALSE/> 4. <Property NAME="MachineName" VALUE="test1.xxx.local"/> 5. <Property NAME="Port" VALUE="1521"/> 6. <Property NAME="SID" VALUE="sid "/> 7. <Property NAME="ServiceName" VALUE=" sid.xxx.local"/> 8. <Property NAME="password" VALUE="dbsnmp" ENCRYPTED="FALSE/> </Target>
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: OCISessionBegin)
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?
Regards Wojtek -- http://www.freelists.org/webpage/oracle-l