Q

Session is disconnected after shutting down an instance

I'm having problems with Oracle 10g: after shutting down an instance; the session is disconnected and can't be connected again (the error I get is ORA-12505). The only way I have found to solve it is to reinitialize the Oracle service for that instance. How can this be solved?
It looks like dynamic registration with the Oracle Listener is not working properly. The first thing to check is that you have your configuration defined properly.

You should have your SERVICE_NAMES and INSTANCE_NAME initialization parameters defined.

After you start the instance, it may take a minute or two from PMON to register the instance with the Listener. By default, PMON will attempt to contact your Listener on the default port (1521). If you are using a non-default port, then you will have to let PMON know where your Listener is listening. To do that, add an entry in your parameter file similar to the following:

LOCAL_LISTENER=listener1

Then bounce the database. The value for the LOCAL_LISTENER parameter should be found in your TNSNAMES.ORA file and the entry should look like the following:

 
listener1=
   (DESCRIPTION=
      (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1421))      
   )  
You may have to restart your database for all settings to take affect.
This was first published in March 2005

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close