Oracle Database Issue

pts.
Tags:
Database
IBM DB2
Linux
Oracle
Hi all We have a 10g oracle server but the problem is that it keeps dying out every now and then. we are usind it on red hat. i tried opening the emctl dbconsole for oem . it opens up but the instance status shows the error ORA-12537: TNS:connection closed (DBD ERROR: OCIServerAttach) and on top it is written cannot connect to the instance....but then if i restart the emctl the error is gone but the top error is still there that cannot connect to the instance....and again if after 5 min u check that again the error reappears ORA-12537: TNS:connection closed (DBD ERROR: OCIServerAttach)... i am a novice in this field...any help would be greatly appreciated... thanks in advance...

Answer Wiki

Thanks. We'll let you know when a new response is added.

I had a similiar issue where my listener locked up not allowing access to the database from an external source nor could I connect when using tnsnames via: sqlplus user/password@database.
The fix action I received was to perform one of the two following:
1 – In 10g ORACLE_HOME, rename $ORACLE_HOME/opnm/conf/ons.config to something else.
Example.
cd $ORACLE_HOME/opmn/conf
mv ons.config ons.config.orig
Then restart the listener

- or -
2 – Explicitly disable the 10g TNS Listener from subscribing to ONS.
Edit the active 10g listener.ora file and add the paramater:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_(listener_name)=OFF
Then restart the listener.

Example:
cd $ORACLE_HOME/network/admin
-Edit listener.ora and add to the beginning
-My listener name is LISTENER
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
-Save the file
-Then restart the listener

I used the second option and haven’t had any further tnsnames lockup issues.

Good luck.

Alan

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Newkipper
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/oracle-database-issue/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following