FAILED: File xlaraslg4.sql While Running Patch 6678700

Posted by Vasudev Seeram on September 26, 2013 Leave a comment (0) Go to comments

Problem: While running patch 6678700, the following error occurs:

FAILED: file xlaraslg4.sql on worker  1.

Check adwork001.log for more information regarding the error:

sqlplus -s APPS/***** @D:\oracle\MFGPR12\apps\apps_st\appl\xla\12.0.0\patch\115\sql\xlaraslg4.sql &un_ax

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.
Action: Check your installation manual for the meaning of this code on this operating system.DECLARE
*
ERROR at line 1:
ORA-20100: glraslg4.sql: status_code=SETUP_PL_SLA_OPTIONS error_msg=ORA-20001:
-: XLA-95103: An internal error occurred.  Please inform your system 
administrator or support representative that:
An internal error has occurred in the program xla_acct_setup_pkg.insert_launch_options.  
ORA-01658: unable to create INITIAL extent for segment in tablespace APPS_TS_SEED.
ORA-06512: at line 97

Solution: Add another datafile to APPS_TS_SEED tablespace:

select * from dba_data_files where tablespace_name = 'APPS_TS_SEED';

alter tablespace apps_ts_seed add datafile 
'D:\ORACLE\MFGP\MFGPDB\ORADATA\MFGP\A_REF03.DBF' size 1000M;