How to identified issues with ADRCI

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
Alert log evidence

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

Seguir leyendo «How to identified issues with ADRCI»

How to Start , Stop and Restart database easy in Oracle 19.

Hello friends, here again.

It’s a minimal post to share this option to start, stop and restart the oracle databases as Linux services.

If you remember in my last article oracle installation, we used the file oracledb_ORCLCDB-19c to configure and install the databases and containers, we will use the same script as the operating system service.

We must run this script as a root user ever because will appear error as follow:

You must be root user to run the configurations script. Login as root user and try again.
Seguir leyendo «How to Start , Stop and Restart database easy in Oracle 19.»