ORA-12514 [message #336982] |
Tue, 29 July 2008 09:50 |
saikatermail
Messages: 20 Registered: November 2006 Location: Hyderabad
|
Junior Member |
|
|
Hello,
I have SHUTDOWN my Database using SHUDOWN ABORT command. Once I am trying to start it up using STARTUP MOUNT it is giving "ORA-12514". I have checked the "lsnrctl services", it is not listed as "READY". Please suggest
Saikat
|
|
|
|
Re: ORA-12514 [message #336989 is a reply to message #336982] |
Tue, 29 July 2008 10:04 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
12514, 00000, "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.
|
|
|