10 Replies Latest reply: Feb 15, 2013 1:51 AM by 991269 RSS

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

    rsar001
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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..
                          user8187054
                          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
                            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