SqlDbx Forum

garbuya

Member

Cannot create new connection

I cannot create new connection to the ORACLE server
I can select it from the list of available connections in tnsnames.ora file, but when I click OK I'm getting error

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

TOAD and SQL Developer can connect to this box using the same tnsnames entry without any problems

sqldbxhelp

Administrator

Re: Cannot create new connection

Click on '...' button on Login screen. Do you see your server?
Below list of servers you should see tnsnames.ora file SqlDbx found.
Also you can try start SqlDbx with -l command line switch and check generated log file for
information where SqlDbx was looking for tnsnames.ora

garbuya

Member

Re: Cannot create new connection

Yes, I can see my server

sqldbxhelp

Administrator

Re: Cannot create new connection

Try to connect directly by specifying HOST:PORT,SERVICE_NAME in Server combo box

garbuya

Member

Re: Cannot create new connection

This is so weird - it is related to tnsnames entry to be on a single line!
If all on one line then it is a problem
(CONNECT_DATA =  (SERVICE_NAME = XXXXXX) )

and if you break it into multiple lines then no problems!
(CONNECT_DATA =
    (SERVICE_NAME = XXXXXX)
)

Probably i need to reinstall Oracle client

Last edited by garbuya (2013-04-05 13:44:30)