Sunday, July 12, 2009

ORA-29282: invalid file ID. ORA-06512: at "SYS.UTL_FILE", line 1

During the 12.0.6 to 12.1.1 upgrade , Main patch (7303030 -12.1.1 Maintenance Pack) is failed with the below error:

Error message in the worker logs is:-
DECLARE*ERROR at line 1:
ORA-29282: invalid file ID
ORA-06512: at "SYS.UTL_FILE",
line 1ORA-06512: at line 41
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE",
line 449ORA-29283: invalid file operation

Cause:
In this case the utl_file_dir was set to /usr/tmp for both instances.


The utl_file package does not give a suitable error message when it finds an existing file with the same name as the file it is attempting to write.

The same errors can be reported when the system does not have permissions to write to the utl_file_dir.

Solution:
Change the utl_file_dir variable in both init.ora files for each instance and bounce the RDBMS.

Initially Instance-VIS and Instance-CRP both had utl_file_dir=/usr/tmp .
They should be set to something like:-
For VIS Instance- utl_file_dir=/usr/tmp/VIS/

For CRP Instance- utl_file_dir=/usr/tmp/CRP/

6 comments: