Home » RDBMS Server » Networking and Gateways » Problem starting up database (oracle 10g (10.2.0.4))
Problem starting up database [message #424692] Mon, 05 October 2009 06:52 Go to next message
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??
Re: Problem starting up database [message #424697 is a reply to message #424692] Mon, 05 October 2009 07:09 Go to previous messageGo to next message
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
Re: Problem starting up database [message #424708 is a reply to message #424692] Mon, 05 October 2009 07:43 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
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.

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

Re: Problem starting up database [message #424900 is a reply to message #424708] Tue, 06 October 2009 08:03 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Post your LISTENER.ORA & TNSNAMES.ORA Entry..

Thanks
Re: Problem starting up database [message #424931 is a reply to message #424692] Tue, 06 October 2009 09:09 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
SQL*Net is NOT required to start the DB

post contents of "hosts" file
Re: Problem starting up database [message #424960 is a reply to message #424931] Tue, 06 October 2009 14:38 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
I succeed to shutdown immediate the database through sqlplus but when trying to start it up i get the following error.


How your connecting sys user to start database. Post the details.

-Babu
Re: Problem starting up database [message #424981 is a reply to message #424960] Tue, 06 October 2009 22:16 Go to previous message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member
Hi,

What is that error you are getting while starting the DB paste complete error here ..

Regards

Bala
Previous Topic: Not able to login to oracle 9.2.0.6
Next Topic: JRE.EXE error when try to use sqleasy config in XP
Goto Forum:
  


Current Time: Wed Sep 28 19:21:51 CDT 2016

Total time taken to generate the page: 0.06073 seconds