3 Replies Latest reply: Jul 11, 2011 4:24 AM by user10745179 RSS

    ORA- 03113

    user10745179
      Hi,

      Im using Oracle 11.2.0.1.0 on RHEL 4.8,

      While executing the users scripts, im getting the ORA-03113 error, the scripts includes the create user, import & creates new objects, & compile the objects,

      When im running the scrips, im getting the ora-03113 & scripts are getting failed..

      there is no specific object at where the script is getting failed.

      what can be reason behind ORA-03113?
        • 1. Re: ORA- 03113
          Dom Brooks
          There should be a trace file related to this forced disconnection in the udump dest on the server - there will normally be an underlying ORA-600 or ORA-7445 error the arguments of which you can use to find out more via the ORA-600/7445 lookup tool on [url http://support.oracle.com]Oracle Support.
          • 2. Re: ORA- 03113
            sybrand_b
            ora-3113 is in the same category as ora-600 and ora-7445. Usually untrapped errors, quite often caused by memory allocation and nil pointer issues.
            Generally speaking, you'd better conduct ora-3113 searches on My Oracle Support, if you have access to it.
            It can be anything.
            Typically ora-3113's are resolved by patches, 11.2.0.2 may be already out for your platform.

            ------------
            Sybrand Bakker
            Senior Oracle DBA
            • 3. Re: ORA- 03113
              user10745179
              Hi,

              I had a doubt related 2 memory,


              total memory of the server is 12G,

              what should be the shmmax value?...