Etiqueta: alertlog

In oracle 19 the previously version ADRCI (Automatic Diagnostic Repository Command Interpreter) is a great tool to solve issues and deal with Oracle Errors and Trace files

We could verify in the alert the oracle error :

Here, we will review quickly and easily and introduction to know the most basic commands to start.

I will start, as common with an alert log file:

tail -f /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/alert_ORCL.log

For years, Oracle has provided us with the possibility of reviewing in the alert log, the most critical movements such as the behaviour of database engine processes.

Hands-on

Now, we start how to ADRCI we help us to understand our issue.

oracle@DSORA02:~/JuanAndresMercado $ adrci