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.
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