TriniDBA

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

Assigned: file FNDGFU.exe   on worker  1 for product fnd username APPLSYS.

   FAILED: file FNDGFU.exe   on worker  1 for product fnd username APPLSYS.

 Deferred: file FNDGFU.exe   on worker  1 for product fnd username APPLSYS.

          (Deferment number 1 for this job)

Checked D:\ORACLE\MFGPR12\apps\apps_st\appl\admin\MFGP\log\ adwork001.log

ORA-01653: unable to extend table APPLSYS.FND_LOBS by 16 in tablespace APPS_TS_MEDIA

D:\oracle\MFGPR12\apps\apps_st\appl\fa\12.0.0\help\US\FA00019109.htm: upload failed

 

AD Worker error:

The above program failed with error code 1.

See the AD Worker log file and/or the program log file for details.

 Solution: Add datafile to APPS_TS_MEDIA tablespace:

select tablespace_name, file_name, bytes/1024/1024 from dba_data_files 
where tablespace_name = 'APPS_TS_MEDIA';

alter tablespace apps_ts_media add datafile 
'D:\ORACLE\MFGP\MFGPDB\ORADATA\MFGP\A_MEDIA02.DBF' size 1200M;