Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
Subject: ora 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
Subject: Re: ORA 01722 invalid number
 
Subject: Making an ORA-600 (and other errors) happen

Subject: Making an ORA-600 (and other errors) happen

2007-10-31       - By Jeremiah Wilton

 Back
Back in August someone asked how to raise an ORA-600 (See http://ORA-600.ora-code.com) manually.  I don't
think there were any satisfactory answers.  This troubled me some, since
there clearly is some way to call the right function to raise errors.
Well, I still don't know how to call the right function, but thanks to
Dan Morgan from PSOUG pointing me at this particular unit test, I found
a way to raise ORA-600 (See http://ORA-600.ora-code.com) (and a  using one of the built-in unit tests in
oradebug.

Fun with OERI args:
SQL> oradebug unit_test dbke_test dde_flow_kge_ora you_big_dummy 0 0

Run this on a test system unless you want to give someone a heart attack.

I found a few nice options you can pass to this test, as well as a
section of the 11g binary that looks like it contains all the names of
all the unit tests available in oradebug.

All on my new blog!  oradeblog.blogspot.com.

Thanks,

Jeremiah Wilton
ORA-600 (See http://ORA-600.ora-code.com) Consulting
http://www.ora-600 (See http://ora-600.ora-code.com).net
--
http://www.freelists.org/webpage/oracle-l