How to identified issues with ADRCI

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

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

Sigue leyendo

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 on 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 operating system service.

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

You must be root user to run the configurations script. Login as root user and try again.
Sigue leyendo