| Problem starting up database [message #424692] |
Mon, 05 October 2009 06:52  |
vags76 Messages: 11 Registered: February 2009 |
Junior Member |
|
|
dear all,
i installed oracle 10g (10.2.0.1) and patched it to 10.2.0.4. i created a database , set up the listener and oracle service instance but i m facing the folling problem. I succeed to shutdown immediate the database through sqlplus but when trying to start it up i get the following error.
ORA-12514: TNS:listener does not currently know of service requested
replacing in service with the oracle_sid i get the message
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
i tried to change either SID to database name and vice versa but still get the same. howevr restarting the service brings everything back to normal.
any suggestion pls??
|
|
|
| Re: Problem starting up database [message #424697 is a reply to message #424692] |
Mon, 05 October 2009 07:09   |
balakrishnay Messages: 53 Registered: September 2009 Location: Pune |
Member |
|
|
Hi,
1. Your DB should be up and running.
2. Check your tnsnames properly what you are specifying there.
3. Your SID and Db_name can be different.
4. Do you have two DB running in that box if yes ,most probably you would have independent listeners . List lsnrctl services for each listener and check if services are getting mismatched with each other.
Regards
Bala
|
|
|
| Re: Problem starting up database [message #424708 is a reply to message #424692] |
Mon, 05 October 2009 07:43   |
Michel Cadot Messages: 29416 Registered: March 2007 Location: Nanterre, France, http://... |
Senior Member |
|
|
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.
ORA-12505: TNS:listener does not currently know of SID given 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 SID for an instance (usually a database instance) 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 instances are currently known by the listener by executing:
lsnrctl services <listener name>
- Check that the SID parameter in the connect descriptor specifies
an instance known by the listener.
- Check for an event in the listener.log file.
Regards
Michel
|
|
|
|
|
|
|