ORA-12154 ODBC Connection [message #504677] |
Wed, 27 April 2011 05:17 |
|
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 #504878 is a reply to message #504870] |
Thu, 28 April 2011 05:47 |
|
Michel Cadot
Messages: 68722 Registered: March 2007 Location: Saint-Maur, France, https...
|
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
|
|
|