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

Problems with listener after installing Oracle 10.1.0.2

We have recently installed Oracle 10.1.0.2 on a Win2K Server machine. Our first issue is that when the server restarts, both the listener and OraService shows as started in services. However, when we do LSNRCTL>Status, the database service is BLOCKED. Next, once a day, users suddenly cannot connect to the database.

We have recently installed Oracle 10.1.0.2 on a Win2K Server machine which has 1GB RAM. The installation process was quite a pain as the machine sits within a domain. We had to do the installation by logging into the machine locally, i.e., as Administrator and not into the domain. Installation was then OK with changing the sqlnet.ora authentication from NTS to NONE for database creation.

Our first issue is that when the server restarts, both the listener and OraService shows as started in services....

However, when we do LSNRCTL>Status, the database service is BLOCKED. We will have to restart both the services. Then, status shows all databases are OK. Is this a time delay due to the server sitting in a domain? Or is it something else?

Next, this has been happening for the past few days, once a day. Users suddenly cannot connect to the database. When we do LSNRCTL>Status, nothing comes up. It seems the listener died. However, in the services window, the service shows status as started. We have to restart both the listener and OraService. Then, everything would be OK. This happens when the CPU is 100% or high load. I saw an earlier post in this forum and the advice was to try changing the port numbers in ons.config. Is that applicable here? The current port numbers are 6100 and 6200 in the file concerned. What are the recommended alternative port numbers?

Your advice is much appreciated.

The problem you are experiencing may be due to that reported bug where the suggestion is to rename the $ORACLE_HOME/opmn/conf/ons.config, but the bug refers to running Oracle 10giAS on the same server as the database, which you don't mention here.

Because you mention seeing a BLOCKED status when performing a listener status, I am more inclined to think it might be a resource issue. There is reference to a problem whereby when the maximum number of connections is reached, the service handler changes to blocked status during the next PMON registration. Any new connection requests to the service will be denied until the status changes. The status will change only when the resources are freed up, which would explain why everything works once the listener and database are recycled. If your processes parameter is set too low for the number of dedicated connections during peak load, you could try increasing this, assuming you have enough resources on the server. If this does not resolve your problem, I would recommend opening a TAR with Oracle Support Services.

This was last published in November 2005

Dig Deeper on Oracle database installation, upgrades and patches

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close