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