I am an Oracle DBA working with an organization in India. We are running Oracle 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.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

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
Sort by: OldestNewest

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: