Logo Background

Adadmin Error Unable To Extend Tablespace

  • By on February 27, 2009 | No Comments

    If you ever hit any tablespace error when running the adadmin, then you have to request the DBA to increase the tablespace by adding the data files.

    Your base language will be AMERICAN.

    Setting up module information.
    Reading database for information about the modules.
    Saving module information.
    Reading database for information about the products.
    Reading database for information about how products depend on each other.
    Reading topfile.txt …

    Saving product information.

    AD code level : [11i.AD.I.6]

    You chose to abandon your previous AD Administration session
    and to continue as a new session.

    Beginning database cleanup for previous session …

    AD Administration error:
    adptaskStoreTimInfoToHist: Error while inserting into AD_PATCH_RUN_SESS_ATTRIBS.

    AD Administration error:
    ORA-01653: unable to extend table APPLSYS.AD_PATCH_RUN_SESS_ATTRIBS by 16 in tablespace APPS_TS_TX_DATA

    AD Administration error:
    aimini(): Error calling adptaskStoreTimInfoToHist()

    You should check the file

    SQL> SELECT * FROM dba_data_files WHERE tablespace_name='APPS_TS_TX_DATA'
    SQL> ALTER tablespace APPS_TS_TX_DATA
    ADD datafile '/Develop_DB/Dev/devdata/a_txn_data19.dbf'
    SIZE 512M autoextend ON NEXT 512M maxsize 2048M;
    » Load Java Files To Oracle E-Business Suite 11i
Leave a Comment