Where/How to Check Alert Log File in Oracle 12c?(Step By Step)
Alert log find better way;
step 1
select * from v$diag_info;
Step 2
$ORACLE_BASE/diag/rdbms/<sid>/<sid>/trace and is named alert_<sid>.log
or
desc v$diag_info
Name Null? Type
------------------------------------------------------------------- -------- ---------------
INST_ID NUMBER
NAME VARCHAR2(64)
VALUE VARCHAR2(512)
CON_ID NUMBER
Quick sql*plus script to get it out
-- diag_info
-- quick check of the new v$diag_info view that came in with 11
col inst_id form 9999 head inst
col name form a25
col value form a60 wrap
spool diag_info.lst
set lines 120
select * from v$diag_info
order by name
/
spool off
INST_ID NAME VALUE CON_ID
-------- -------------------- ---------------------------------------------------------------- -------
1 Diag Enabled TRUE 0
1 ADR Base D:\APP\ORACLE 0
1 ADR Home D:\APP\ORACLE\diag\rdbms\ora122\ora122 0
1 Diag Trace D:\APP\ORACLE\diag\rdbms\ora122\ora122\trace 0
1 Diag Alert D:\APP\ORACLE\diag\rdbms\ora122\ora122\alert 0
1 Diag Incident D:\APP\ORACLE\diag\rdbms\ora122\ora122\incident 0
1 Diag Cdump D:\app\oracle\diag\rdbms\ora122\ora122\cdump 0
1 Health Monitor D:\APP\ORACLE\diag\rdbms\ora122\ora122\hm 0
1 Default Trace File D:\APP\ORACLE\diag\rdbms\ora122\ora122\trace\ora122_ora_7416.trc 0
1 Active Problem Count 0 0
1 Active Incident Count 0
Within each database directory are subdirectories where different files are stored. Here is each primary directory and its purpose.
Directory
|
Purpose
|
alert
|
Stores very important XML-formatted alert log for database.
|
cdump
|
Core dump location of memory stack when a process fails.
|
incident
|
Subdirectories relating to individual events or incidents.
|
trace
|
Trace and dump files for background and user processes; also
contains text formatted alert log. |
