|
|
|
|
|
|
|
|
| Re: Unable to connect to remote database (Management Server Mode) [message #407008 is a reply to message #406906] |
Mon, 08 June 2009 02:59   |
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 #408013 is a reply to message #408012] |
Fri, 12 June 2009 23:44 |
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 #408023 is a reply to message #408020] |
Sat, 13 June 2009 00:33 |
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 #409198 is a reply to message #406888] |
Sat, 20 June 2009 04:50 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
