OraFAQ Forum: Networking and Gateways » Problem starting up database

Home » RDBMS Server » Networking and Gateways » Problem starting up database (oracle 10g (10.2.0.4))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem starting up database [message #424692]

Mon, 05 October 2009 06:52

vags76
Messages: 12
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??

Report message to a moderator

Re: Problem starting up database [message #424697 is a reply to message #424692]

Mon, 05 October 2009 07:09

balakrishnay
Messages: 54
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

Report message to a moderator

Re: Problem starting up database [message #424708 is a reply to message #424692]

Mon, 05 October 2009 07:43

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Code: [Select all] [Show/ hide]

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.

Code: [Select all] [Show/ hide]

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

Report message to a moderator