Q
Problem solve Get help with specific problems with your technologies, process and projects.

Accessing an Oracle instance with SQL*Plus

I have a problem accessing an Oracle instance remotely. I have three Microsoft Windows computers. One is running an Oracle 10g database server, the other two have Oracle 10g client software installed. The problem is accessing the instance 'conf' from client computer 1 using SQL*Plus.

I have a problem accessing an Oracle instance remotely. I have three Microsoft Windows computers. One is running an Oracle 10g database server, the other two have Oracle 10g client software installed.

The problem is accessing the instance 'conf' from client computer 1 using SQL*Plus. I can access the instance on the server using SQL*Plus. Also, I can access the instance from client computer 2. However, from client 1, I'm getting the following message:

% sqlplus username/password@conf
SQL*Plus: Release 10.1.0.3.0 - Production on Wed May 4 23:03:04 2005
Copyright (c) 1982, 2004, Oracle.  All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Please help me to resolve the above problem.
Since you are able to connect from one client and not another, I would say this message points to an error in the tnsnames.ora file of that client. Open the tnsnames.ora file located in the networkadmin subdirectory of where the Oracle client is installed and ensure that the SERVICE_NAME is correct and matches what is registered with the listener on the database server.

To verify if the service name in tnsnames.ora matches what is registered with the listener, do the following:

  • Log into the database server.
  • At the DOS prompt, run the listener control utility
    C:>lsnrctl
    
  • Set the display mode
    LSNRCTL> set displaymode verbose
    
  • Display the services
    LSNRCTL> services
    

Check that the service name registered with the listener matches what you have defined in the tnsnames.ora file of the client.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close