Mallik034: 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