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.

why on earth dont you post the error?

this is the errot I get. Thanks. I am new.

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

then what you are connecting to isnt in the tnsnames.ora file in your client

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.

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

Thank you Donald. It worked. You sent me very useful information.