This discussion is archived
2 Replies Latest reply: Jan 15, 2013 5:16 AM by Carlo den Otter RSS

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

WF001 Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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.

Legend

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