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
No comments:
Post a Comment