I am trying to generate ADR incident logs on two databases:
• Oracle Database 21c (production) – works correctly
• Oracle Database 23ai Free Developer Edition – incidents are not generated
The same commands succeed on 21c but fail to create an incident on 23ai:
1. ALTER SESSION SET EVENTS 'immediate trace name errorstack level 3';
2. ORADEBUG EVENT 942 TRACE NAME ERRORSTACK LEVEL 3
Reference followed:
http://www.juliandyke.com/Diagnostics/Dumps/ERRORSTACK.php
Diagnostic check on 23ai shows that ADR is enabled:
SELECT name, value FROM v$diag_info ORDER BY name;
Key rows returned
ADR Base : /opt/oracle
ADR Home : /opt/oracle/diag/rdbms/free/FREE
Diag Enabled : TRUE
Active Incident : 0
Active Problem : 0
Trace files are being written to
/opt/oracle/diag/rdbms/free/FREE/trace/
Question
1. Is there any functional gap in the 23ai Free Developer Edition that prevents incident creation with the commands above?
2. If not, what is the correct way to generate an ADR incident on Oracle 23ai?"
Also, can someone share any documentation or the exact steps required to generate an incident trace (.trc) file?