This discussion is archived
10 Replies Latest reply: Feb 14, 2013 11:51 PM by 991269 RSS

Package compile faile with error ORA-03113: end-of-file on communication..

rsar001 Newbie
Currently Being Moderated
Hi There,
We're trying to compile a package and we're getting this error that we're not sure how to debug and/or tackle. Your assistance is highly appreciated.

create or replace
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 4252
Session ID: 1149 Serial number: 5910

The package use to compile without any issues; also we have it working in other environments. We can't see any differences at this stage.

Oracle Version:11.2.0.1 x64
OS: Windows 2008 Server R2

Thanks in advance for your help.

Thanks
  • 1. Re: Package compile faile with error ORA-03113: end-of-file on communication..
    sb92075 Guru
    Currently Being Moderated
    rsar001 wrote:
    Hi There,
    We're trying to compile a package and we're getting this error that we're not sure how to debug and/or tackle. Your assistance is highly appreciated.

    create or replace
    *
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel
    Process ID: 4252
    Session ID: 1149 Serial number: 5910

    The package use to compile without any issues; also we have it working in other environments. We can't see any differences at this stage.

    Oracle Version:11.2.0.1 x64
    OS: Windows 2008 Server R2

    Thanks in advance for your help.
    does package utilize any DB_LINK?
  • 2. Re: Package compile faile with error ORA-03113: end-of-file on communication..
    rsar001 Newbie
    Currently Being Moderated
    Sorry, the package is over 1000 lines of code, that's why I didn't post it. But to quickly answer your question, No, it doesn't.

    Thanks
  • 3. Re: Package compile faile with error ORA-03113: end-of-file on communication..
    rp0428 Guru
    Currently Being Moderated
    Can you recompile other packages, procedures, functions and triggers without error?

    Have you tried dropping the package and body and recreating them?
  • 4. Re: Package compile faile with error ORA-03113: end-of-file on communication..
    rsar001 Newbie
    Currently Being Moderated
    I have tried dropping the package and re-compiling it but to no avail. I can compile other packages/procedures/functions without any issues.

    Also, trying to run either EXEC UTL_RECOMP.recomp_parallel(4, 'SCHEMA_NAME'); or @?/rdbms/admin/UTLRP.SQL gives the following erros:
    *
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel
    Process ID: 7040
    Session ID: 388 Serial number: 9039
    
    
    ERROR:
    ORA-03114: not connected to ORACLE
    
    
    DOC> The following query reports the number of objects that have compiled
    DOC> with errors (objects that compile with errors have status set to 3 in
    DOC> obj$). If the number is higher than expected, please examine the error
    DOC> messages reported with each object (using SHOW ERRORS) to see if they
    DOC> point to system misconfiguration or resource constraints that must be
    DOC> fixed before attempting to recompile these objects.
    DOC>#
    ERROR:
    ORA-03114: not connected to ORACLE
    
    
    DOC> The following query reports the number of errors caught during
    DOC> recompilation. If this number is non-zero, please query the error
    DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
    DOC> are due to misconfiguration or resource constraints that must be
    DOC> fixed before objects can compile successfully.
    DOC>#
    ERROR:
    ORA-03114: not connected to ORACLE
    
    
    ERROR:
    ORA-03114: not connected to ORACLE
    
    
    ERROR:
    ORA-03114: not connected to ORACLE
    
    
    ERROR:
    ORA-03114: not connected to ORACLE
    
    
    ERROR:
    ORA-03114: not connected to ORACLE
  • 5. Re: Package compile faile with error ORA-03113: end-of-file on communication..
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Are there any error messages or trace files in the alert log ?

    Srini
  • 6. Re: Package compile faile with error ORA-03113: end-of-file on communication..
    rp0428 Guru
    Currently Being Moderated
    I'm thinking the package body may have an invalid character somewhere
    A couple of other things to try.
    Drop the package and confirm that the package spec itself will compile.
    >
    We can't see any differences at this stage
    >
    Did you actually do a DIFF with code from one of the other environments? Unprintable characters can't be seen.

    Here is how to confirm that you are using/compiling the same code in two environments.

    1. In another environment (e.g. 'test1') where you say it works extract the source for the spec and body.
    2. drop the package in 'test1'
    3. compile the spec in 'test1' using the extracted code from step #1 above. confirm no errors
    4. compile the body in 'test1' using the extracted code from step #1 above. confirm no errors
    5. repeat steps #3 and #4 in the problem environment using the extracted code from 'test1'.

    The above will confirm that exactly the same code is being used in both environments and that it compiles in 'test1' but not in the problem.
    Post the results of the tests.
  • 7. Re: Package compile faile with error ORA-03113: end-of-file on communication..
    rsar001 Newbie
    Currently Being Moderated
    Hi There,
    Actually after checking the alert log for the instance we found the following:
    Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x0] [PC:0x1B38933, kktget2()+1727]
    Errors in file c:\oracle\admin\diag\rdbms\gesd\gesd\trace\gesd_ora_3952.trc  (incident=80207):
    ORA-07445: exception encountered: core dump [kktget2()+1727] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x1B38933] [UNABLE_TO_READ] []
    Mon Feb 27 16:18:54 2012
    Errors in file c:\oracle\admin\diag\rdbms\gesd\gesd\cdump\gesdcore.log
    ORA-07445: caught exception [ACCESS_VIOLATION] at [kktget2()+1727] [0x0000000001B38933]
    I checked the kktget2()+1727 error under the ORA-600/ORA-7445 Error Look-up Tool on MOS and it led us to an oracle Bug "9734300 Dump under kxtivwt->kktget2 compiling PLSQL with DML and INSTEAD OF triggers". We have to apply the fix provided to solve the issue. Moreover, after checking the patch/fix number we noticed that ths fix has been applied to the other servers/dbs, hence the other instances do compile without any issues.

    Thanks everyone for your help and prompt reply.

    Thanks
  • 8. Re: Package compile faile with error ORA-03113: end-of-file on communication..
    rp0428 Guru
    Currently Being Moderated
    Glad to hear you found the problem by checking the alert log.

    Don't forget to give Srini credit for helping you since he is the one that told you to check the log. He may be an Oracle ACE but he likes to recognition to.
  • 9. Re: Package compile faile with error ORA-03113: end-of-file on communication..
    975937 Newbie
    Currently Being Moderated
    The same problem, but the solution is much simpler:
    I didn't realize that a view that the package has been used invalid. :(
  • 10. Re: Package compile faile with error ORA-03113: end-of-file on communication..
    991269 Newbie
    Currently Being Moderated
    I was facing the same problem during compile package body
    ORA-03113: end-of-file on communication channel

    Commented and changed different parts of code, then found the problem. In the call to a function, I was passing a static expression for "in out" parameter. Changed it to a variable and the package got compiled!

    Kshama

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points