Help - Search - Members - Calendar
Full Version: Oracle Client
Oracle DBA Forums > Oracle > Oracle Forum
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.

User Name: Administrator

I got the host string from Ora file.

Can you please let me how to connect to the server from my PC ?
Thanks you,
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:


>> 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:


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:
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-2016 Invision Power Services, Inc.