Q
Problem solve Get help with specific problems with your technologies, process and projects.

Connecting to 10g database after rebooting server

I have installed a 10g Oracle database on a Windows 2003 server. After the server is rebooted I am unable to connect to the database. Can you please help me to resolve this?

I have installed a 10g Oracle database on a Windows 2003 server. Everything works fine and I am able to connect to this database; however after the Windows 2003 server is rebooted I am unable to connect to the database. Using Net Manager to test the connection to my database I receive the following error: "ORA-12514: TNS listener does not currently know of service requested in connect descriptor." My listener.ora and tnsnames.ora are very simple and they look fine for the service_name, etc. Can you please help me to resolve this?
One reason for an ORA-12514 error is that the instance itself is down. With service registration, the listener is aware of the state of the database and knows when it is not available so it does not allow connections. After a server reboot, check to see that the service and database have started automatically. If not, use the oradim utility to change the start mode of the database from manual to automatic.

Related to this is the possibility that the database and listener are both up but the database has not yet registered with the listener. Service registration can take 60 seconds or more. This may be the case if the server has just been rebooted.

Another reason for this error is that the database you are attempting to connect to is not registered with the listener. This may happen if the instance cannot find the correct listener address in order to register itself. If the LOCAL_LISTENER parameter is set in the init.ora file, the instance will attempt to connect to the listener at that address to register itself. If this parameter is not set, it will attempt to connect to the default listener on port 1521.

Finally, an ORA-12514 can occur if the instance has successfully registered with the listener but the SERVICE_NAME does not match what PMON has registered with the listener. To verify if the service name in tnsnames.ora matches what is registered with the listener, do the following:

  • At the DOS prompt, run the listener control utility:
    C:>lsnrctl
    
  • Set the display mode:
    LSNRCTL> set displaymode verbose
    
  • Display the services:
    LSNRCTL> services
    

Check that the service name registered with the listener matches what you have defined in the tnsnames.ora file.

This was last published in July 2005

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close