RE: Oracle 10 Agent Discovering 9i databases

  • From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • Date: Mon, 11 Sep 2006 09:29:18 -0400

Thanks Stefan.  I solved the error.  Your help was much appreciated.

 

________________________________

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

 

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
<mailto: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)(POR
T=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: