R12 E-Business Suite Platform Migration Via Export and Import Results in Invalid Objects Related to APPS_TS_TX_DATA Tablespaces (Doc ID 2171880.1)

SYMPTOMS

E-Business Suite R12 Applications DBA, Issues with the Functionality of AD Utilities

During a system platform migration using the full export / import process, many objects are invalid after the import is completed.

The below case is from a Sun Solaris export and import to RHEL 6, where a substantial number of invalid objects resulted.

CAUSE

The user does not have privileges to allocate extents in the required tablespaces.

The main error received is:

ORA-01950: no privileges on tablespace 'APPS_TS_TX_DATA'

SOLUTION

To resolve the issue test the following steps in a development instance and then migrate accordingly:

1. Request the DBA issue the following statements for testing, which will allow extents to be allocated for the problem tablespaces:

ALTER USER ASG QUOTA UNLIMITED ON APPS_TS_TX_DATA;
ALTER USER ASG QUOTA UNLIMITED ON APPS_TS_ARCHIVE;
ALTER USER ASG QUOTA UNLIMITED ON APPS_TS_SEED;
ALTER USER ASG QUOTA UNLIMITED ON APPS_TS_TX_IDX;
GRANT UNLIMITED TABLESPACE TO APPS;
 

2. Recompile and resolve the invalid objects:

    A. On the target database server node, login as the owner of the Oracle 11g file system and database instance.

    B. Use SQL*Plus to connect to the target database as SYS

    C. Run the script $ORACLE_HOME/rdbms/admin/utlrp.sql to compile invalid objects.

         $ sqlplus "/ as sysdba" @$ORACLE_HOME/rdbms/admin/utlrp.sql

3. For future export / import process testing, ensure the proper privileges are in place and confirm the invalid objects no longer occur.