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.
Now, we start how to ADRCI we help us to understand our issue.
oracle@DSORA02:~/JuanAndresMercado $ adrci