2 Replies Latest reply: Jan 15, 2013 7:16 AM by Carlo den Otter RSS

    All adworkers failed (ORA-01688: unable to extend table...)

    WF001
      Hi all,

      I'm starting to upgrade my EBS from 11.5.10.2 to 12.1.1 on AIX 6.1 and I am executing the merged patch 7303029 with 6678700(12.1.1 : Upgrade Patch),

      Now I found all worker are failed as below...

      The adctrl output is follows :
      Restarted: file ar120recpl.sql on worker 2 for product ar username AR.
      FAILED: file ar120recpl.sql on worker 2 for product ar username AR.

      ATTENTION: All workers either have failed or are waiting:

      FAILED: file ar120recpl.sql on worker 1.
      FAILED: file ar120recpl.sql on worker 2.
      FAILED: file ar120recpl.sql on worker 3.
      FAILED: file ar120recpl.sql on worker 4.
      FAILED: file ar120recpl.sql on worker 5.
      FAILED: file ar120recpl.sql on worker 6.
      FAILED: file ar120recpl.sql on worker 7.
      FAILED: file ar120recpl.sql on worker 8.
      FAILED: file ar120recpl.sql on worker 9.
      FAILED: file ar120recpl.sql on worker 10.

      <adwork001.log>
      DECLARE
      *
      ERROR at line 1:
      ORA-01688: unable to extend table XLA.XLA_AE_LINES partition AR by 16 in
      tablespace APPS_TS_TX_DATA
      ORA-06512: at line 70

      <alert error log>
      Incremental checkpoint up to RBA [0x2361.b9c.0], current log tail at RBA [0x2361.cec.0]
      Mon Jan 14 15:00:57 2013
      ORA-1691: unable to extend lobsegment SYS.SYS_LOB0000465832C00004$$ by 128 in tablespace SYSAUX
      ORA-1691: unable to extend lobsegment SYS.SYS_LOB0000465832C00004$$ by 128 in tablespace SYSAUX
      ORA-1691: unable to extend lobsegment SYS.SYS_LOB0000465832C00004$$ by 128 in tablespace SYSAUX
      ORA-1691: unable to extend lobsegment SYS.SYS_LOB0000465832C00004$$ by 128 in tablespace SYSAUX
      MMON Flush encountered SYSAUX out of space error(1691).
      MMON (emergency) purge of WR snapshots (32667) and older
      ...
      ORA-1688: unable to extend table XLA.XLA_AE_LINES partition AR by 16 in tablespace APPS_TS_TX_DATA
      ORA-1688: unable to extend table XLA.XLA_AE_LINES partition AR by 16 in tablespace APPS_TS_TX_DATA

      I've already add datafile to APPS_TS_TX_DATA (size 1M and autoextend on next 20M maxsize 2000M), but still failed again...

      Any idea what is the solution?

      Thanks in advance,
        • 1. Re: All adworkers failed (ORA-01688: unable to extend table...)
          Hussein Sawwan-Oracle
          Please see these docs.

          ORA-0691: unable to extend lob segment %s.%s by %s in tablespace %s during Import/Export [ID 1014629.102]
          When Booking Order Get ORA-1691: Unable To Extend Lobsegment Aso.Sys_lob00000XXXX$$ [ID 397470.1]
          iSupport: Cannot Upload Large Attachments [ID 298710.1]
          Publish and Presentation Program is Failed with ORA-01691: unable to extend lob segment FRM.SYS_LOBXXXX$$ by NN in tablespace APPS_TS_MEDIA [ID 946748.1]
          AFLOBBLD.sql runs for long time to create Index FND_LOBS_CTX [ID 374975.1]

          https://forums.oracle.com/forums/search.jspa?threadID=&q=ORA-1691&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

          Thanks,
          Hussein
          • 2. Re: All adworkers failed (ORA-01688: unable to extend table...)
            Carlo den Otter
            Hello Sam,

            It seems the SYSAUX tablespace also needs to be extended.

            In case the problem persists feel free to create a service request against the rdbms product to have the messages/cause analyzed.

            Regards, Carlo.