Home » RDBMS Server » Enterprise Manager » Unable to connect to remote database (Management Server Mode) (Oracle 9i)
Unable to connect to remote database (Management Server Mode) [message #406888] Sun, 07 June 2009 02:38 Go to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
I am trying to connect to the database server (sun solaris) from my machine (Win XP). When I use discover nodes and put the IP of the database server it discovers the node successfuly but the database is not there under the database tree.

What am I missing here?

DB version: Oracle 9.2.0

Thanks Smile

[Updated on: Sun, 07 June 2009 02:44]

Report message to a moderator

Re: Unable to connect to remote database (Management Server Mode) [message #406892 is a reply to message #406888] Sun, 07 June 2009 02:45 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

what about tnsping ?

thanks
Re: Unable to connect to remote database (Management Server Mode) [message #406893 is a reply to message #406888] Sun, 07 June 2009 02:53 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
I did that and there is no problem with it.
Re: Unable to connect to remote database (Management Server Mode) [message #406906 is a reply to message #406893] Sun, 07 June 2009 08:18 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

post tnsping output

post error message; while connecting your database. (copy & paste from your sql session)

[Updated on: Sun, 07 June 2009 08:19]

Report message to a moderator

Re: Unable to connect to remote database (Management Server Mode) [message #407008 is a reply to message #406906] Mon, 08 June 2009 02:59 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
The other day it gave this output;
D:\tnsping uat

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 07-JUN-20
09 11:48:59

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
D:\oracle\oracle_home\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 12.1.1.1)(PORT = 1523))) (CONNECT_DATA = (SERVICE_NAME = uat)))
OK (140 msec)


I tried today and it gave me this:
D:\tnsping uat

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 08-JUN-20
09 08:35:11

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
D:\oracle\oracle_home\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name


And there was no error message because the discovey ends successfully yet there's no database under the databases tree in OEM.
Re: Unable to connect to remote database (Management Server Mode) [message #407486 is a reply to message #406888] Wed, 10 June 2009 05:43 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
I'm still not able to discover the remote database, any suggestion?
Re: Unable to connect to remote database (Management Server Mode) [message #407609 is a reply to message #407486] Wed, 10 June 2009 12:06 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Why your not able ping your database??

Babu
Re: Unable to connect to remote database (Management Server Mode) [message #408008 is a reply to message #406888] Fri, 12 June 2009 23:16 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
I have no idea, I checked tnsnames.ora and it's fine.
Re: Unable to connect to remote database (Management Server Mode) [message #408010 is a reply to message #406888] Fri, 12 June 2009 23:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>TNS-03505: Failed to resolve name
What changed?
Software does not spontaneously break.
Re: Unable to connect to remote database (Management Server Mode) [message #408011 is a reply to message #406888] Fri, 12 June 2009 23:32 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
^Have you ever used Windows??!

Hehehe.. I'm kidding.. I may have done some minor changes to SQLNET.ORA, unfortunately I didn't take backup of it before I did the changes.

What to do?
Re: Unable to connect to remote database (Management Server Mode) [message #408012 is a reply to message #406888] Fri, 12 June 2009 23:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>^Have you ever used Windows??!
I avoid Windoze like the plague which is why this message comes from an Ubuntu.


>Hehehe.. I'm kidding.. I may have done some minor changes to SQLNET.ORA, unfortunately I didn't take backup of it before I did the changes.
>What to do?

Revert the changes.
Alternatively, try renaming sqlnet.ora out of the way.
Re: Unable to connect to remote database (Management Server Mode) [message #408013 is a reply to message #408012] Fri, 12 June 2009 23:44 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
This is the outcome:
C:\tnsping uat

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 13-JUN-20
09 08:41:14

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST= 12.1.1.1)(POR
T= 1523)) (CONNECT_DATA= (SID= UAT)))
OK (20 msec)
Re: Unable to connect to remote database (Management Server Mode) [message #408014 is a reply to message #406888] Fri, 12 June 2009 23:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Why was this such a challenge?
Re: Unable to connect to remote database (Management Server Mode) [message #408016 is a reply to message #408014] Fri, 12 June 2009 23:59 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
Read the whole thread please, including the main topic.
Re: Unable to connect to remote database (Management Server Mode) [message #408018 is a reply to message #406888] Sat, 13 June 2009 00:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Is your problem solved?

Ready, Fire, Aim!
Re: Unable to connect to remote database (Management Server Mode) [message #408019 is a reply to message #408018] Sat, 13 June 2009 00:12 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
No.
Re: Unable to connect to remote database (Management Server Mode) [message #408020 is a reply to message #406888] Sat, 13 June 2009 00:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I am confused.
>TNS-03505: Failed to resolve name

v.s.
>Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST= 12.1.1.1)(POR
T= 1523)) (CONNECT_DATA= (SID= UAT)))
OK (20 msec)

Things changed

What answer do you expect/desire?
Re: Unable to connect to remote database (Management Server Mode) [message #408023 is a reply to message #408020] Sat, 13 June 2009 00:33 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
BlackSwan wrote on Sat, 13 June 2009 09:21
I am confused.
>TNS-03505: Failed to resolve name

v.s.
>Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST= 12.1.1.1)(POR
T= 1523)) (CONNECT_DATA= (SID= UAT)))
OK (20 msec)

Things changed

What answer do you expect/desire?


I seriously doubt that you've read the main topic.. that's why I'm going to copy and paste it BELOW:

I am trying to connect to the database server (sun solaris) from my machine (Win XP). When I use discover nodes and put the IP of the database server it discovers the node successfuly but the database is not there under the database tree.

What am I missing here?

DB version: Oracle 9.2.0


Now after trying tnsping which was "suggested" by MR. Gentlebabu, the problem still there. In other words, I'm still not able to discover the remote database.

Still confused?!!!

Re: Unable to connect to remote database (Management Server Mode) [message #408049 is a reply to message #408023] Sat, 13 June 2009 06:02 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>, the problem still there.

what's that?
Re: Unable to connect to remote database (Management Server Mode) [message #408050 is a reply to message #408049] Sat, 13 June 2009 06:04 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
Although I'm able to tnsping the database, I'm still not ablt to automatically discover it in OEM.
Re: Unable to connect to remote database (Management Server Mode) [message #408053 is a reply to message #408049] Sat, 13 June 2009 06:29 Go to previous messageGo to next message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
Just so we can be on the same page:
- I've modified listener.ora and added global_dbname variable with the name of the instance+domain name.
- I've deleted *.q, services.ora, snmp_ro.ora and snmp_rw.ora files and bounced the agent.
Re: Unable to connect to remote database (Management Server Mode) [message #409198 is a reply to message #406888] Sat, 20 June 2009 04:50 Go to previous message
amshajri
Messages: 20
Registered: June 2009
Location: Oman
Junior Member
I'm copying the nmiconf.log file..

DBSNMP for SunOS 5.9: release 9.2.0.7.0 - Production on 17-JUN-09 17:05:31

Discovering services on mbsun02 configured on host addresses {mbsun02 mbsun02.mbps.mbpo.com loghost 12.1.1.1 test1 12.1.1.2 test2 12.1.1.3}

Using oratab file /var/opt/oracle/oratab

Warning : /apps/oracle/dev/devdb/9.2.0/network/admin/UAT_mbsun02/UAT_mbsun02_ifile.ora does not exist

Warning : UAT defined in /apps/oracle/dev/devdb/9.2.0/network/admin/UAT_mbsun02/

listener.ora will be skipped, because it does not monitor any of the valid SIDs

{UAT}

Warning : No Listener found for SID UAT. UAT will be skipped

nmxwconf Error : Unable to open include file /apps/oracle/dev/devora/9i/iAS/Apache/Jserv/etc/jserv.conf

nmxwconf Error : Unable to open include file /apps/oracle/dev/devora/9i/iAS/Apac

he/Apache/conf/oracle_apache.conf

nmxwconf Error : Unable to open include file /apps/oracle/dev/devora/9i/iAS/Apache/Apache/conf/oprocmgr.conf

nmxwconf Error : Unable to open Oracle HTTP Server configuration file /apps/oracle/dev/devora/9i/iAS/Apache/Apache/conf/httpds.conf

Could not open emtab at /var/opt/oracle/emtab.


Any Suggestions?

[Updated on: Sat, 20 June 2009 04:53]

Report message to a moderator

Previous Topic: How to create snmp_rw.ora
Next Topic: database can't be opened through OEM
Goto Forum:
  


Current Time: Thu Mar 28 04:40:20 CDT 2024