Oracle error
Francesc
Hello,
We have a rule for monitoring Oracle which connects to the database. Our Oracle run under Unix HP-UX. Sometimes, the Servers Check returns the error "ORA-01033: ORACLE initialization or shutdown in progress".
Is this error returned by Oracle or Servers Check do an interpretation of the error number ORA-01033 to give the explanation text "ORACLE initialization or shutdown in progress"?
We look for in the Oracle log error and we don't see any message that informs about a shutting down or starting up process of the database.
Greetings,
Francesc
We have a rule for monitoring Oracle which connects to the database. Our Oracle run under Unix HP-UX. Sometimes, the Servers Check returns the error "ORA-01033: ORACLE initialization or shutdown in progress".
Is this error returned by Oracle or Servers Check do an interpretation of the error number ORA-01033 to give the explanation text "ORACLE initialization or shutdown in progress"?
We look for in the Oracle log error and we don't see any message that informs about a shutting down or starting up process of the database.
Greetings,
Francesc
This discussion has been closed.
Comments
You might want to use Oracle ODBC instead of using the ORACLE rule
I think that there is a bug in the Oracle rule:
When the error returned by Oracle is a known error, SC returns it normally, for example, ORA-01034: ORACLE not available
But when the server where Oracle is running has the CPU at 100% (this is what we see in our infrastructure), the error returned by Oracle is UNKNOWN.
And in this case, SC don't returns UNKNOWN, it returns the last known error. And as the last known error is ORA-01033: ORACLE initialization or shutdown in progress, this is the error shown, but this is not the true.
Could you test this?
Thank you very much,
Francesc
The last known error is always shown.
Could you do that if no error is returned SC returns UNKNOWN instead of last one?