Home » Server Options » Data Guard » ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor [message #323706] Thu, 29 May 2008 05:19 Go to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor



when i try to connect my database
Re: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor [message #323709 is a reply to message #323706] Thu, 29 May 2008 05:24 Go to previous message
Michel Cadot
Messages: 68625
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-00344: unable to re-create online log
Next Topic: ORA-00279:
Goto Forum:
  


Current Time: Thu Mar 28 14:04:53 CDT 2024