CAUSE :
Typically occurs when writing a new record to oracle database, but there is not enough space to write it. The data file in oracle tablespace called APPS_TS_TX_DATA should be set to AUTOEXTEND. If it is not, Oracle will not auto-increase the size of the datafile, and will raise the above error.
SOLUTION :
If all the reports end in COMPLETE – NORMAL, means its work.
If not than follow below steps.
Run a Concurrent Manager Recovery :
1. Please stop Concurrent managers by adcmctl.sh.
2. If not stopped, please abort managers by adcmctl.sh.
adcmctl.sh abort apps/****
3. Please kill if a process remains.
4. relink all (ADADMIN)
5. Please retry Concurrent Manager Recovery.
Navigate :
Oracle Applications Manager > Concurrent Managers OR Concurrent Requests > Site Map > Diagnostics and Repair > Concurrent Manager Recovery.
OR
SOLUTION :
WARNING: This procedure should be performed by your ORACLE Database Administrator.
The SYSTEM user should have required privileges to perform this task.
Enable Autoextend on the APPS_TS_TX_DATAÂ tablespace by executing the following Oracle PL/SQL command:
SQL > ALTER DATABASE DATAFILE '/u01/ORACLE/ORADATA/APPS_TS_TX_DATA.ORA' AUTOEXTEND ON NEXT 3072K
Comments
Tags: APPS_TS_TX_DATA, apps-fnd-01564, apps-fnd-01564 oracle error 1653 in summit others, AUTOEXTEND, datafile, dba imam, dba immam, Imam Dba, Immam Dba, oracle error, Oracle PL/SQL, tablespace