Sunday 18 May 2014

Solution for ORA-00603: ORACLE server session terminated by fatal error when compiling PL/SQL package

 

I was running some installation of DB objects with “sqlplus” utility and this is what I got

SQL> @XX_OM_DRH_PROCESS_UTIL.pkb

create or replace package body XX_OM_DRH_PROCESS_UTIL is

*

ERROR at line 1:

ORA-00603: ORACLE server session terminated by fatal error

The sad part is that the package is OK. If I open it in “PL/SQL Developer” I can compile it without any problems. But if I run it through “sqlplus” or “alter package XX_OM_DRH_PROCESS_UTIL  compile” it gives me the error above.

I spend several hours trying to understand what can be wrong. One of my managers eventually provided the solution. All you need to do is to execute the following

SQL> alter session set events = '10932 trace name context level 32768';

Session altered.

SQL> @XX_OM_DRH_PROCESS_UTIL.pkb

Package body created.

SQL>