Site icon Database Tutorials

Learn the Cause of the Error and View the Suggestions with the OERR Utility

We can display the cause of an error that we received and troubleshooting suggestions, with the OERR Utility.

It is located under the $ORACLE_HOME/bin directory. We can use the OERR utility after setting the variables.

If you are not familiar with the error, OERR can quickly provide information on identifying the problem.

The use is as follows:

For ORA-03113 error;

For ORA-01555 error;

For RMAN-01009 error;

For CRS-00215 error;

Exit mobile version