Re: Oracle 10 Agent Discovering 9i databases

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • Date: Mon, 11 Sep 2006 14:50:00 +0200

Thomas,

inside Grid Control, open up the problematic database's administration
pages. From there, choose "Monitoring Configuration". Enter the correct
username/password into the form, and test the connection. Once the
connection succeeds, apply the changes.

The agent should now connect just fine.

Stefan


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

Stefan,


Thanks for the reply. Below is a snip of the emagent.trc file. The Dbsnmp password has been changed. I attempted to change it in the targets.xml file and restarted the agent. The agent does connect successfully to our one 10g database.



Any ideas?



Thanks


Tom



2006-09-11 08:36:37 Thread-1032 WARN  vpxoci: OCI Error --
ErrorCode(1017): ORA-01017: invalid username/password; logon denied



SQL = "
OCISessionBegin"...

LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=
xx.xx.xxx.xxx)(PORT=1521))(CONNECT_DATA=(SID=ABSD)))

2006-09-11 08:36:37 Thread-1032 ERROR vpxoci: ORA-01017: invalid
username/password; logon denied

2006-09-11 08:36:37 Thread-1032 WARN  vpxoci: Login 0x200d29b8 failed,
error=ORA-01017: invalid username/password; log on denied

2006-09-11 08:36:37 Thread-1032 WARN  TargetManager: Exception in
computing dynamic properties of {ABSD.LABOR.STATE.NY.US, oracle_database
},MonitorConfigStatus::ORA-01017: invalid username/password; logon denied

2006-09-11 08:36:37 Thread-1032 WARN  vpxoci: OCI Error --
ErrorCode(1017): ORA-01017: invalid username/password; logon denied






------------------------------

*From:* Stefan Knecht [mailto:knecht.stefan@xxxxxxxxx]
*Sent:* Monday, September 11, 2006 8:04 AM
*To:* Mercadante, Thomas F (LABOR)
*Cc:* oracle-l
*Subject:* Re: Oracle 10 Agent Discovering 9i databases



Hi Thomas,

can you be a little more specific ?

Does the agent discover the 9i databases ? Or can it simply not connect ?
Verify $AGENT_HOME/sysman/log/emagent.trc  for any hints on what goes
wrong.

Stefan

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

All,



I am finally trying to get 10g Grid up and running.  I am trying to get
our 10g agents (10.1.0.2.0) to discover and connect to our 9i databases (
9.2.0.7).  I have successfully connected to our 10.2 databases.  I found
the targets.xml file in the 10g agent home that looks like it replaces the
snmp_rw.ora file that the 9i agent used.  But I am getting a connect error
(invalid usercode/password) when the 10g agent tries to connect.



Any ideas?



Thanks


Tom


------------------------------

This transmission may contain confidential, proprietary, or privileged
information which is intended solely for use by the individual or entity to
whom it is addressed.  If you are not the intended recipient, you are hereby
notified that any disclosure, dissemination, copying or distribution of this
transmission or its attachments is strictly prohibited.   In addition,
unauthorized access to this transmission may violate federal or State law,
including the Electronic Communications Privacy Act of 1985.  If you have
received this transmission in error, please notify the sender immediately by
return e-mail and delete the transmission and its attachments.





Other related posts: