Q

Listener not responding

We are running Oracle 10.1.0.3 on Sun OS 5.9 and we have been facing serious problems for the last month. Sometimes our listener stops responding. If I check the status of the listener, it shows successfully. But if I reload or start the listener again, it does not show the respective handler for my particular server. Then, to make my database normal I need to shut it down and start it again.

This Content Component encountered an error
I am an Oracle DBA working with an organization in India. We are running Oracle 10.1.0.3 on Sun OS 5.9. We have been facing serious problems for the last month. Sometimes our listener stops responding. I recevied complaints from our clients that the listener was unable to find a handler for the service. If I check the status of the listener, it shows successfully. But if I reload or start the listener again, it does not show the respective handler for my particular server. Then, to make my database normal I need to shut it down and start it again. After restarting, the listener starts working again. One thing I noticed is that my CPU utilization goes very high. Due to lack of resources it is not possible to add more processor. Please suggest what steps need to be taken.
I have seen mention of this problem under the exact circumstances you are describing. This problem with the listener hanging and high CPU utilization can happen when both Oracle 10g database and application server are installed on the same server. If you have 10giAS installed on the database server, you can try renaming the file $ORACLE_HOME/opmn/conf/ons.config and then restarting the listener. This file defines ports used by Oracle Notification Service (ONS), which may conflict with the listener and cause it to hang. If this does not resolve the problem, I would recommend opening a TAR with Oracle Support. For more information on this bug, you can review Doc ID # 284602.1 on Oracle's Metalink Web site.
This was first published in October 2005

Dig deeper on Oracle database installation, upgrades and patches

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close