How to trigger ORA-00600,ORA-7445 by manual

Sometime we’d like to trigger ORA-00600/7445 internal errors for testing purpose, But it’s not easy if you don’t know a little trick like below:

declare
a exception;
pragma exception_init(a,-600);
begin
raise a;
end;

declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [],
[], [], []
ORA-06512: at line 5

or
oradebug unit_test dbke_test dde_flow_kge_ora ouch! 0 0

7445:
select spidfrom v$processp, v$sessions
where p.addr= paddr
and sid= sys_context('USERENV','SID');

kill -SEGV $PID

or 

declare
a exception;
pragma exception_init(a,-7445);
begin
raise a;
end;

© 2009 – 2011, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

1. Summary of Bugs Containing ORA – 00600 [KCBNEW_3]
2. Troubleshooting Streams Apply Error ORA-1403, ORA-26787 or ORA-26786
3. ORA-600 quick reference guide
4. Streams Conflict Resolution
5. ORA-22813 When Using Bulk Collect in PL/SQL
6. ORA-1092 During Startup Using AUM (Automatic Undo Management)
7. Resloving ORA-12514/12541