Home » RDBMS Server » Server Administration » ORA-12514 (Oracle 9i, Windows 2000)
ORA-12514 [message #336982] Tue, 29 July 2008 09:50 Go to next message
Messages: 20
Registered: November 2006
Location: Hyderabad
Junior Member

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

Re: ORA-12514 [message #336988 is a reply to message #336982] Tue, 29 July 2008 10:03 Go to previous messageGo to next message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please suggest

Copy and paste what you did don't describe it.
And post your version with 4 decimals.

Re: ORA-12514 [message #336989 is a reply to message #336982] Tue, 29 July 2008 10:04 Go to previous message
Messages: 25525
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.
Previous Topic: DBconsole on Secondary after failover
Next Topic: Unable to startup database :ORA-38760: This database instance failed to turn on flashback database
Goto Forum:

Current Time: Fri Jul 21 21:49:36 CDT 2017

Total time taken to generate the page: 0.12863 seconds