ORA-12154: TNS:could not resolve the connect identifier specified


#1

Hi,

I try to create connection to Oracle database 10.2 using toad 12.1.0.22, but I get this error.

2-11-2014 3-21-53 PM.png

I can TNSPING my database & SQLPLUS work fine.

Can anybody help me resolve this error?

Thanks,

Telo


#2

I’m having this exact same issue…

Everythings looks good, I can TNSPING, SQLPLUS works as well as Oracle Reports and Oracle Forms which use the same Oracle home as TOAD, yet TOAD will not connect.

Does anyone have a solution for this?

Thanks!


#3

I was actually able to solve this myself, I’ll post the solution here for future reference. I found a note the said there’s a bug in the Oracle client software that has problems with connections from software that is installed in a directory that has parenthesis in the directory path name. I checked and sure enough TOAD was installed in C:\Program Files (x86)\Quest Software…

I uninstalled TOAD and reinstalled it, this time specifying a different location path,C:\TOAD, and presto, I’m now able to successfully connect to my Oracle databases!


#4

just grep

www.google.hr/search;ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a&channel=sb&safe=images&gfe_rd=cr&ei=mX0-U__cG6ve8get54HQBg#channel=sb&newwindow=1&q=oracle+%22Program+Files+%28x86%29%22&rls=org.mozilla:en-US:official&safe=images

This is neverending story from MS!


#5

Yes that exactly I tried by searching over net on may site and still not get any relevant response but this works.

Its really product bug…

Thanku so much…


#6

It’s actually a bug in the Oracle Client. SQL*Plus version 10.x and older won’t connect either if it is installed in a path that contains ( or ).


#7

Hi guys, I’m having the same issue even I re-installed Toad under “C:/” iof "C:/“Program Files/…”. And then also changed Env Pro. of Path shown as below but still having this error:

ORA-12541: TNS:no listener

Items Checked
TNS_ADMIN environment variable is defined as “C:\app\xxx\product\11.2.0\client_1\network\admin”
“C:\app\xxx\product\11.2.0\client_1\network\admin\sqlnet.ora” was located
NAMES.DIRECTORY_PATH specifies EZCONNECT in the sqlnet.ora file

Steps to Take
Verify that the correct port is specified
Verify that the listener is running and that it is properly configured

Env Pro

C:\app\xxx\product\11.2.0\client_1\network\admin;C:\app\xxx\product\11.2.0\client_1\BIN;C:\app\xxx\product\11.2.0\client_1;C:\oracle\instantclient-basic-nt-12.1.0.2.0\instantclient_12_1;…

Sqlnet.ora

NAMES.DEFAULT_DOMAIN=xxx
DEFAULT_SERVER_LISTENER=xxx
xxx=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=xxx.11)
(PORT=xxx)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=xxx)
)
)

xxx2=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=xxx.12)
(PORT=xxx)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=xxx)
)
)

xxx3=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.xxx)
(PORT=xxx)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=xxx)
)
)

xxx4=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.xxx)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=xxx)
)
)

xxx5=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=mdmcdbpscan)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=xxx)
)
)

xxx6=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=mdmcdbpscan)
(PORT=xxx)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=xxx)
)
)
NAMES.DIRECTORY_PATH=(EZCONNECT,TNSNAMES,LDAP)
SQLNET.AUTHENTICATION_SERVICES=(NTS)
LOG_DIRECTORY_CLIENT=C:\app\xxx\product\11.2.0\client_1\Network\Log
LOG_FILE_CLIENT=sqlnet_log
SQLNET.EXPIRE_TIME=0
TRACE_DIRECTORY_CLIENT=C:\app\xxx\product\11.2.0\client_1\Network\Trace
TRACE_FILE_CLIENT=sqlnet_trc
TRACE_FILELEN_CLIENT=100
TRACE_FILENO_CLIENT=3
TRACE_LEVEL_CLIENT=OFF
TRACE_TIMESTAMP_CLIENT=ON
TRACE_UNIQUE_CLIENT=ON
USE_DEDICATED_SERVER=OFF

Tnsnames.ora

xxx12=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=xxx.11)
(PORT=xxx)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=xxx)
)
)

xxx2=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=xxx.12)
(PORT=xxx)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=xxx)
)
)

xxx3=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.xxx)
(PORT=xxx)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=xxx)
)
)

xxx=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.xxx)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=xxx)
)
)

xxx5=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=xxx)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=xxx)
)
)

xxx6=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=xxx)
(PORT=xxx)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=xxx)
)
)


#8

This might not work for you, depending on your environment, but maybe try moving your path entries in a different order - for instance, here what I have in my sqlnet.ora file…

SQLNET.AUTHENTICATION_SERVICES= (none)

NAMES.DIRECTORY_PATH= (TNSNAMES,LDAP,EZCONNECT)


#9

Hi Dennis, thnx for reply,

I tried this once and after your tried again but not worked.

BTW; targeted DB’s listener is up and operational


#10

Hi serhatsine,

I don’t know the subtle intricacies of Oracle Networking, but I’m pretty sure that net service (i.e. “connection”) information is not valid in the SQLNET.ORA file. See: docs.oracle.com/…/sqlnet.htm

It’s possible that some client connections are more sensitive to the client configuration files (sqlnet.ora, tnsnames.ora) than others. I would first correct the SQLNET.ORA contents.

Let us know how it goes!
Rich


#11

Rich,

Could you please elaborate when you say:“net service (i.e. “connection”) information is not valid in the SQLNET.ORA file”

You mean these lines?

xxx=

(DESCRIPTION=

(ADDRESS=

(PROTOCOL=TCP)

(HOST=xxx.11)

(PORT=xxx)

)

(CONNECT_DATA=

(SERVER=dedicated)

(SERVICE_NAME=xxx)

)

)

Even if so, it is giving same error message mentioned as in my first message.

Current sqlnet.ora content is shown as below

Sqlnet.ora

NAMES.DEFAULT_DOMAIN=xxx
DEFAULT_SERVER_LISTENER=xxx
NAMES.DIRECTORY_PATH=(EZCONNECT,TNSNAMES,LDAP)
SQLNET.AUTHENTICATION_SERVICES=(NTS)
LOG_DIRECTORY_CLIENT=C:\app\xxx\product\11.2.0\client_1\Network\Log
LOG_FILE_CLIENT=sqlnet_log
SQLNET.EXPIRE_TIME=0
TRACE_DIRECTORY_CLIENT=C:\app\xxx\product\11.2.0\client_1\Network\Trace
TRACE_FILE_CLIENT=sqlnet_trc
TRACE_FILELEN_CLIENT=100
TRACE_FILENO_CLIENT=3
TRACE_LEVEL_CLIENT=OFF
TRACE_TIMESTAMP_CLIENT=ON
TRACE_UNIQUE_CLIENT=ON
USE_DEDICATED_SERVER=OFF


#12

Hi serhatsine,

Yes, that’s exactly what I was referring to.

Also, perhaps this thread in the Beta forum might help you out? http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/22177.aspx

Let us know!
Rich


#13

He does indeed mean those entries. They belong in tnsnames.ora. which normally lives in the same location as sqlnet.ora.

Cheers,

Norm [ TeamT ]

On 8 January 2015 08:23:54 GMT+00:00, serhatsine bounce-serhatsine@toadworld.com wrote:

RE: ORA-12154: TNS:could not resolve the connect identifier specified

Reply by serhatsine
Rich,

Could you please elaborate when you say:“net service (i.e. “connection”) information is not valid in the SQLNET.ORA file”

You mean these lines?

xxx=

(DESCRIPTION=

(ADDRESS=

(PROTOCOL=TCP)

(HOST=xxx.11)

(PORT=xxx)

)

(CONNECT_DATA=

(SERVER=dedicated)

(SERVICE_NAME=xxx)

)

)

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

Sent from my Android device with K-9 Mail. Please excuse my brevity.


#14

Hi Rich,

Sorry mate, not worked :confused:


#15

Thank-you jmorrill, that worked for me


#16

Thanks jmorrill, I almost spent 3 hours debugging the issue… untill I found your post…

THANK YOU SO MUCH !! :slight_smile:


#17

Hi Everyone, I had the similar issue in a Windows environment and found Listener is the culprit. Just restart the listener. Hope it might help someone like me.