Home » RDBMS Server » Networking and Gateways » ORA-12154 ODBC Connection (Windows XP Client)
ORA-12154 ODBC Connection [message #504677] Wed, 27 April 2011 05:17 Go to next message
joergenV
Messages: 2
Registered: April 2011
Junior Member
I know this is a classic issue, though I have read lots of stuff, but I can't still get connected:
I connect to the Oracle DB through a SSH-tunnel (ussing Putty)

Connecting to an Oracle 11 DB, using the Oracle SQL Developer I can get connected without probs.
Though, when I try to get connected using the Windows ODBC Manager, I got the ORA-12154 error.
- I have checked the value of TNS-ADMIN path
- My SQLORA.NET is following:
NAMES.DEFAULT_DOMAIN = <internal domain>
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME,EZCONNECT)
- I have checked my local firewall on my client (port 1521)

I was wondering how importent the default_donamin is, when I actually got connected using the SQL Developer.

Can I use the ODBC-trace function - and how? I have tried pressing "Start Trace" but it seams that nothing is logged.

Any idears?

Thx
Joergen
Re: ORA-12154 ODBC Connection [message #504693 is a reply to message #504677] Wed, 27 April 2011 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 67462
Registered: March 2007
Location: Nanterre, France, http://...
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.


How did you connect with SQL Developer? Which method did you use?
What is the definition of your ODBC DSN? What is your ODBC Driver?

Regards
Michel
Re: ORA-12154 ODBC Connection [message #504870 is a reply to message #504693] Thu, 28 April 2011 04:44 Go to previous messageGo to next message
joergenV
Messages: 2
Registered: April 2011
Junior Member
solved!
I supposed the NAMES.DEFAULT_DOMAIN in the SQLNET.ORA had some effect, but by naming the net-service-name in the TNSNAMES.ORA with its full path (including the full domain-name) I got a ODBC-connection with success.

Thanks

Joergen
Re: ORA-12154 ODBC Connection [message #504878 is a reply to message #504870] Thu, 28 April 2011 05:47 Go to previous message
Michel Cadot
Messages: 67462
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.
However I would like to have the answer to my questions in order to make this topic useful for others.

Regards
Michel
Previous Topic: Problem to connect from client to server
Next Topic: Using a trigger in OID and updating EBS table
Goto Forum:
  


Current Time: Sat Oct 24 15:48:33 CDT 2020