Home » RDBMS Server » Networking and Gateways » tns error (oracle 11g r2 )
tns error [message #525745] Wed, 05 October 2011 01:41 Go to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
Hi
I am connecting from my client machine to server.
I have made entries in tnsnames.ora in client machine but i get following error.


ERROR
ORA-12514: TNS: Listener does not currently know of service requested in connect descriptor

Pls Help
Re: tns error [message #525750 is a reply to message #525745] Wed, 05 October 2011 02:25 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a service name for a service (usually a database service)
 that either has not yet dynamically registered with the listener or has
 not been statically configured for the listener.  This may be a temporary
 condition such as after the listener has started, but before the database
 instance has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which services are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SERVICE_NAME parameter in the connect descriptor of the
    net service name used specifies a service known by the listener.
  - If an easy connect naming connect identifier was used, check that
    the service name specified is a service known by the listener.
  - Check for an event in the listener.log file.

Regards
Michel
Previous Topic: ORA-12514: TNS:listener does not currently know of service requested in connect
Next Topic: Oracle 10g client not getting connceted to Oracle 10g database
Goto Forum:
  


Current Time: Fri Apr 19 00:10:04 CDT 2024