In oracle 19 as the previusly versions ADRCI (Automatic Diagnostic Repository Command Interpreter) its a great tool to solved issues and deal with Oracle Errors and Tracefiles

We could verified in the alert the oracle error :

Here, we will review quickly and easy and introduction to know the most basically commands to start.

I will start, as common with 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 behavior of database engine processes.

Hands on

Now, we starting how to ADRCI we help us to undestand our issue.

oracle@DSORA02:~/JuanAndresMercado $ adrci