Help - Search - Members - Calendar
Full Version: Oracle Client
Oracle DBA Forums > Oracle > Oracle Forum
dima
Hello:
I am having difficulty to login to the database from my desk-top (Using SQL-Plus). However I can login to the database using SQL-Plus from the server. I am using same credentials for both.

Ex:
User Name: Administrator
Pwd:
Host String: UNANCPRD.WORLD

I got the host string from Ora file.

Can you please let me how to connect to the server from my PC ?
Thanks you,
Dima.
dave
why on earth dont you post the error?
dima
this is the errot I get. Thanks. I am new.

ORA-12154: TNS:could not resolve the connect identifier specified
dave
then what you are connecting to isnt in the tnsnames.ora file in your client
dima
But client have so many tnsnames.ora files. Do you know which one I should use ? (in which folder) or should I copy the same ora file from the server in to the local PC ?
hank you for your support.
burleson
Hi Dima,

The "ORA-12154: TNS could not resolve service name" error has many causes.

Please read:

http://www.dba-oracle.com/t_ora_12154_tns_...ervice_name.htm

*************************************************************************

>> But client have so many tnsnames.ora files. Do you know which one I should use ?

Use the one that's specified in your registry:

http://www.dba-oracle.com/t_windows_multip...try_entries.htm


*************************************************************************

You need to start debugging it. Start by opening a DOS window and try a "ping" to the server name.

Then, try a fully-qualified connect string to SQL*Plus.

See my checklist here, and report back where you hang:

http://www.dba-oracle.com/t_troubleshootin...vity_errors.htm
dima
Thank you Donald. It worked. You sent me very useful information.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.