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.
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.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading