Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 Issue# 22:

 

ATTENTION: All workers either have failed or are waiting:

 

           FAILED: file afffvst1.sql on worker  1.

 

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

 

Worker log:

sqlplus -s APPS/***** @/u03/dproappl/fnd/11.5.0/patch/115/sql/afffvst1.sql &un_fnd &pw_fnd

DECLARE

*

ERROR at line 1:

ORA-20100: File o3050794.tmp creation for FND_FILE failed.

You will find more information on the cause of the error in request log.

ORA-06512: at "APPS.FND_STATS", line 1830

ORA-06512: at line 28

 

 

Solution:

 

DB parameter “utl_file_dir” was configured incorrectly:

SQL> sho parameter utl

 

NAME                                                        TYPE VALUE

------------------------------------ ----------- ------------------------------

create_stored_outlines                                     string

utl_file_dir                                               string                /usr/tmp

                                                                                                 *.workarea_size_policy=, AUTO'

SQL>

 

SQL> create pfile='/tmp/pfile.ora' from spfile;

 

File created.

 

SQL>

 

-          Updated the pfile.ora with the correct value:

utl_file_dir='/usr/tmp'

 

SQL> shu immediate  

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> create spfile from pfile='/tmp/pfile.ora';

 

File created.

 

SQL> startup

ORACLE instance started.

 

Total System Global Area 6413680640 bytes

Fixed Size                                2265224 bytes

Variable Size                      1711279992 bytes

Database Buffers             4680843264 bytes

Redo Buffers                        19292160 bytes

Database mounted.

Database opened.

SQL>

 

-          Use adctrl to restart the failed worker