Home » SQL & PL/SQL » Client Tools » sqlplus at client
icon4.gif  sqlplus at client [message #265690] Fri, 07 September 2007 01:06 Go to next message
ramanathan manickam
Messages: 27
Registered: July 2007
Junior Member
We have installed oracle 10G in the server "ORAServer". Couple of database instance are created on the same server.

we could able to access it trough only two ways:


1.ServerSide:we need to login to the server either remotely or on the same server, and access using sqlplus,isqlplus(url) etc..

2.ClientSide: using isqlplus(url)

Problem:
Now we have installed oracle client at our local desktop and trying to access oracle database(using isqlplus or command prompt sqlplus), but we get ora-12154 error.

Though i could able to connect thru enterprise manager console from the client side.

We suspect the listener files| Any solution for the same?



Re: sqlplus at client [message #265696 is a reply to message #265690] Fri, 07 September 2007 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12154: TNS:could not resolve service name
 *Cause:  The service name specified is not defined correctly in the
 TNSNAMES.ORA file.
 *Action:  Make the following checks and correct the error:
           - Verify that a TNSNAMES.ORA file exists and is in the proper
             place and accessible. See the operating system specific manual
             for details on the required name and location.
           - Check to see that the service name exists in one of the
             TNSNAMES.ORA files and add it if necessary.
           - Make sure there are no syntax errors anywhere in the file.
             Particularly look for unmatched parentheses or stray characters.
             Any error in a TNSNAMES.ORA file makes it unusable. See
             Chapter 4 in the SQL*Net V2 Administrator's Guide. If
               possible, regenerate the configuration files using the Oracle
               Network Manager.

A look in Database Net Services Administrator's Guide will be a good help.
"netca" assistant can do the job for you, especially on client.

Regards
Michel
Re: sqlplus at client [message #265728 is a reply to message #265696] Fri, 07 September 2007 03:22 Go to previous messageGo to next message
wanghl2005_pmp
Messages: 2
Registered: September 2007
Location: china
Junior Member
ora 12154,00000, "TNS:could not resolve the connect identified specified"
*May Cause:A connection to a database or other service was requested using a connect identifier,and the connect identifier
specified could not be resolved into a connect descriptor using one of the naming methods configured.
*Action:If you are using local naming(TNSNAMES.ORA file):
Make sure that "TNSNAMES" is listed as a values of the NAMES.DIRECTORY_PATH parameter in the oracle Net profile.
Re: sqlplus at client [message #265753 is a reply to message #265728] Fri, 07 September 2007 04:53 Go to previous message
ramanathan manickam
Messages: 27
Registered: July 2007
Junior Member
Guys thanks for your replies, got it.

[Updated on: Fri, 07 September 2007 04:54]

Report message to a moderator

Previous Topic: DBArtisan checking o/p
Next Topic: what is the file that runs SQL Plus (Windows) in your system
Goto Forum:
  


Current Time: Mon Dec 05 10:53:45 CST 2016

Total time taken to generate the page: 0.08078 seconds