connection problem with Db or instance [message #362994] |
Thu, 04 December 2008 14:33 |
patdev
Messages: 73 Registered: August 2008
|
Member |
|
|
Hi,
I am very confuse for this situation.
I have server with two db instance runing and also even one instance running.
I am trying to connect to server or db with OEM or any third party tool. but it fails with following error: but it works fine when i physically log in to server with putty or ther unix server. Oracle 9i and 10g on Unix
TNS-03505 Failed to resolve name
ORA-12154: TNS:could not resolve service name
I checked the tnsnames.ora is fine here is the following:
log =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = Servername)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = log)
)
)
here is the SQLnet.ora:
NAMES.DEFAULT_DOMAIN = domainname
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
|
|
|
|
|
|
|
|
|
|
|
Re: connection problem with Db or instance [message #363297 is a reply to message #363289] |
Fri, 05 December 2008 13:38 |
patdev
Messages: 73 Registered: August 2008
|
Member |
|
|
C:\>tnsping sid
TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 - Production on 05-DEC-2
008 12:31:53
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
C:\>tnsping sid.domianname
TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 - Production on 05-DEC-2
008 12:32:47
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
|
|
|
|
|