How to find the database alert log?

Monday, June 27, 2022

How to find the database alert log?

Database alert log location or How to find the database alert log path?

Method1:

$locate alert_DEVDB.log

Methode2:

$sqlplus / as sysdba

SQL> set pages 1000 lines 1000

SQL> col VALUE for a70

SQL> col NAME for a25

SQL> select * from v$diag_info;

Method3:

$adrci

adrci> show alert

logs:

[oracle@oraclelab1 trace]$ locate alert_DEVDB.log

/u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/alert_DEVDB.log

/u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/log/alert_DEVDB.log

[oracle@oraclelab1 trace]$

[oracle@oraclelab1 trace]$ tail -f /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/alert_DEVDB.log

Resize operation completed for file# 2, old size 221376K, new size 221440K

Resize operation completed for file# 2, old size 221440K, new size 221568K

Resize operation completed for file# 2, old size 221568K, new size 221632K

Resize operation completed for file# 2, old size 221632K, new size 221696K

Resize operation completed for file# 2, old size 221696K, new size 221760K

TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P262 (4561) VALUES LESS THAN (TO_DATE(' 2022-06-28 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

Resize operation completed for file# 2, old size 221760K, new size 221824K

TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P265 (4560) VALUES LESS THAN (TO_DATE(' 2022-06-27 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

2022-06-27T22:22:12.872442+05:30

Resize operation completed for file# 2, old size 221824K, new size 221888K

[oracle@oraclelab1 trace]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 27 22:25:26 2022

Version 19.3.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> set pages 1000 lines 1000

SQL> col VALUE for a70

SQL> col NAME for a25

SQL> select * from v$diag_info;

INST_ID NAME VALUE CON_ID

---------- ------------------------- ---------------------------------------------------------------------- ----------

1 Diag Enabled TRUE 0

1 ADR Base /u01/app/oracle 0

1 ADR Home /u01/app/oracle/diag/rdbms/devdb/DEVDB 0

1 Diag Trace /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace 0

1 Diag Alert /u01/app/oracle/diag/rdbms/devdb/DEVDB/alert 0

1 Diag Incident /u01/app/oracle/diag/rdbms/devdb/DEVDB/incident 0

1 Diag Cdump /u01/app/oracle/diag/rdbms/devdb/DEVDB/cdump 0

1 Health Monitor /u01/app/oracle/diag/rdbms/devdb/DEVDB/hm 0

1 Default Trace File /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/DEVDB_ora_6363.trc 0

1 Active Problem Count 1 0

1 Active Incident Count 3 0

1 ORACLE_HOME /u01/app/oracle/product/19.0.0.0/dbhome_1 0

12 rows selected.

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@oraclelab1 trace]$

[oracle@oraclelab1 trace]$ cd /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace

[oracle@oraclelab1 trace]$ ls -ltr alert*

-rw-r-----. 1 oracle oinstall 1527100 Jun 27 22:22 alert_DEVDB.log

[oracle@oraclelab1 trace]$ tail -f alert_DEVDB.log