SqlDbx
You are not logged in.
Pages: 1
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
Offline
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
Offline
Yes, I can see my server
Offline
Try to connect directly by specifying HOST:PORT,SERVICE_NAME in Server combo box
Offline
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)
Offline
Pages: 1