Home » RDBMS Server » Networking and Gateways » connection problem with Db or instance
connection problem with Db or instance [message #362994] Thu, 04 December 2008 14:33 Go to next message
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 #362999 is a reply to message #362994] Thu, 04 December 2008 14:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-12154: TNS:could not resolve the connect identifier specified
 *Cause:  A connection to a database or other service was requested using
 a connect identifier, and the connect identifier specified could not
 be resolved into a connect descriptor using one of the naming methods
 configured. For example, if the type of connect identifier used was a
 net service name then the net service name could not be found in a
 naming method repository, or the repository could not be
 located or reached.
 *Action:
   - If you are using local naming (TNSNAMES.ORA file):
      - Make sure that "TNSNAMES" is listed as one of the values of the
        NAMES.DIRECTORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA)
      - Verify that a TNSNAMES.ORA file exists and is in the proper
        directory and is accessible.
      - Check that the net service name used as the connect identifier
        exists in the TNSNAMES.ORA file.
      - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA
        file.  Look for unmatched parentheses or stray characters. Errors
        in a TNSNAMES.ORA file may make it unusable.
   - If you are using directory naming:
      - Verify that "LDAP" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Verify that the LDAP directory server is up and that it is
        accessible.
      - Verify that the net service name or database name used as the
        connect identifier is configured in the directory.
      - Verify that the default context being used is correct by
        specifying a fully qualified net service name or a full LDAP DN
        as the connect identifier
   - If you are using easy connect naming:
      - Verify that "EZCONNECT" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Make sure the host, port and service name specified
        are correct.
      - Try enclosing the connect identifier in quote marks.

   See the Oracle Net Services Administrators Guide or the Oracle
   operating system specific guide for more information on naming.

Regards
Michel
Re: connection problem with Db or instance [message #363002 is a reply to message #362999] Thu, 04 December 2008 14:56 Go to previous messageGo to next message
patdev
Messages: 73
Registered: August 2008
Member
I have tried everying listed and still get same error back!! please guide!!
Re: connection problem with Db or instance [message #363015 is a reply to message #363002] Thu, 04 December 2008 15:44 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


1/ Try to ping database using TNSPING

2/ As per your SQLNET.ORA Configuration; TNSENTRY Should be configure the below method.

TnsNames.ORA

Quote:
LOG.DOMAINNAME=(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = Servername)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = log)
)
)


Try & let us know

Babu
Re: connection problem with Db or instance [message #363208 is a reply to message #363015] Fri, 05 December 2008 06:33 Go to previous messageGo to next message
patdev
Messages: 73
Registered: August 2008
Member
I tried that and it gives same error, also it gives invalid log in /password.


I am loging in with Sys user is and password is right because from putty i can log in with same criteria!!

Thanks

help!!
Re: connection problem with Db or instance [message #363280 is a reply to message #363208] Fri, 05 December 2008 12:05 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
I tried that and it gives same error, also it gives invalid log in /password


Invalid Username/Password? Why ?? We are not aware of your password try to fix.

Don't try with Sys user

Also post TNSPING output

tnsping SID

tnsping SID.DomainName

Babu
Re: connection problem with Db or instance [message #363285 is a reply to message #363208] Fri, 05 December 2008 12:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
I tried that and it gives same error, also it gives invalid log in /password.

You can't have both error at the same time.

If you don't post that is copy and paste what you did we can't help.
If you don't post what you asked you to post we can't help you.
Do you want to be helped?

Regards
Michel
Re: connection problem with Db or instance [message #363287 is a reply to message #363280] Fri, 05 December 2008 12:36 Go to previous messageGo to next message
patdev
Messages: 73
Registered: August 2008
Member
for tnsping sid

i get error : failed to resolve name.

for tnsping sid.domainname

failed to resolve error.

with any user i try i get invalid username/password from OEM

but tnsping doesn't work at all.

Thanks
Re: connection problem with Db or instance [message #363289 is a reply to message #363287] Fri, 05 December 2008 12:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Don't SAY, copy and paste.
Last message I post to try to help.
No correct answer from you, no more answer from me.

Regards
Michel
Re: connection problem with Db or instance [message #363297 is a reply to message #363289] Fri, 05 December 2008 13:38 Go to previous messageGo to next message
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
Re: connection problem with Db or instance [message #363299 is a reply to message #363297] Fri, 05 December 2008 13:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>C:\>tnsping sid
No kidding! (unless you have masked the original entries)
You are supposed tnsping your_tnsservicename. Not "sid". That was just posted as an example.

[Updated on: Fri, 05 December 2008 13:51]

Report message to a moderator

Re: connection problem with Db or instance [message #363301 is a reply to message #363297] Fri, 05 December 2008 14:18 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Also read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and use code tags.
Use the "Preview Message" button to verify.

Now you first have to improve your knowledge before trying to use and manage Oracle.
Read documentation at http://tahiti.oracle.com

Regards
Michel
Previous Topic: Unable Connect Linux Db using WinOracle Client
Next Topic: Listner stoped unexpectedly
Goto Forum:
  


Current Time: Sat Nov 23 22:30:58 CST 2024