ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 【ora】ORA-0600 error with arguments: [17113].

【ora】ORA-0600 error with arguments: [17113].

原创 Linux操作系统 作者:yellowlee 时间:2011-05-25 14:32:50 0 删除 编辑

9i的bug,10g后才ok,plsql dev编译package报600错误。

ORA-0600 error with arguments: [17113].

ORA-0600 error with arguments: [17113].

You may be getting this ORA-600 when recompiling a PL/SQL package.
The Package shows in OEM as valid even though compiling gives ORA-600 error.

You can reproduce the error when a PL/SQL package is in an editor in the PL/SQL developer tool
and you select Compile. But if the package is selected to compile from the window
"navigator" - it compiles successfully.


The alert log shows an error message:

ORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []

 

The trace file shows the error originating from the execution of the
sys.dbms_cdc_publish.change_table_trigger procedure.

BEGIN
/* NOP UNLESS A TABLE OBJECT */
IF dictionary_obj_type = 'TABLE' AND sys.dbms_cdc_publish.active > 0
THEN
sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,'LOCK');
END IF;
END;

 

The trace file function stack also shows the error occurred when allocating a new extent in memory.


Call stack -
ksedmp ksfdmp kgeriv kgesiv kgesic1 kgherror
kghgex kghfnd kghprmalo kghalp parchk ptmak
pdtidc pdlifu phpcog phpcmp pcicog kkxcog
opitca kksctca rpiswu2 kkslod kglobld kglobpn . . . .

 

Cause
The issue is with the mechanism(s) that PL/SQL uses to determine if the compilation should be carried out in debug mode or not. This may have been resolved by the fix for unpublished Bug 2298751, which went into 10.1. However, that fix is complex, and cannot be provided as an interim patch.  It can only be provided as a Patchset.
Solution
Unpublished Bug 2298751 is fixed in 10.1 but cannot be provided as an interim patch.


The workaround options are
1) upgrade to latest release of 10g where this is fixed

-or-

2) Use the workarounds
       Make sure using the latest release of 3rd party tools

         -and

       Ensure debug is turned off:    alter session set plsql_debug=false;

-or-

if not using Change Data Capture (CDC) then simply disable the triggers associated with CDC by running these statements as SYSDBA:
 
ALTER TRIGGER sys.cdc_alter_ctable_before DISABLE;
ALTER TRIGGER sys.cdc_create_ctable_after DISABLE;
ALTER TRIGGER sys.cdc_create_ctable_before DISABLE;
ALTER TRIGGER sys.cdc_drop_ctable_before DISABLE;
 
This should stop the errors. If you later decide to use CDC then simply enable these four triggers.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16179598/viewspace-696235/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-12-27

  • 博文量
    316
  • 访问量
    664917