{"id":9862,"date":"2016-02-11T12:28:34","date_gmt":"2016-02-11T16:28:34","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=9862"},"modified":"2016-03-10T05:35:19","modified_gmt":"2016-03-10T09:35:19","slug":"upgrading-oracle-apps-ebs-to-12-2-ora-29283-invalid-file-operation","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2016\/02\/11\/upgrading-oracle-apps-ebs-to-12-2-ora-29283-invalid-file-operation\/","title":{"rendered":"Upgrading Oracle Apps (EBS) to 12.2 ? ORA-29283: Invalid File Operation"},"content":{"rendered":"

This post covers issue while running American English\u00a0Upgrade patch driver<\/strong>\u00a0<\/strong>reported in our\u00a0Oracle EBS Upgrade R12.2<\/a>\u00a0training (next batch starts on\u00a020th Feb<\/strong><\/span>\u00a0and\u00a0only limited seats are available<\/strong><\/span>\u00a0. We limit number trainees to 15 and where we cover\u00a0Architecture, Overview of R12.2 & Major features in Upgrading to R12.2, Different upgrade paths available to R12.2,\u00a0Best practices for R12.2 Upgrade, How to minimize down time for R12.2 Upgrade, Difficulties\/Issues while upgrading to R12.2<\/strong>)<\/p>\n

One of the trainee from our previous batch, encountered \u00a0issue\u00a0\u201cORA-29283: Invalid File Operation\u201d <\/strong>while running American English\u00a0Upgrade patch driver.<\/p>\n

Issue:<\/u><\/strong><\/p>\n

1.<\/strong> Running the merged driver<\/strong> on the administration server node on Release 12.2 APPL_TOP using the following commands:<\/p>\n

cd $ORACLE_BASE\/fs1\/EBSapps\/appl\/au\/12.0.0\/patch\/115\/driver<\/strong><\/p>\n

adpatch options=nocopyportion,nogenerateportion<\/strong><\/p>\n

Note:<\/strong>\u00a0Merged driver must be applied using adpatch options=nocopyportion,nogenerateportion on RUN File System.<\/p>\n

2.<\/strong>\u00a0But Patch got failed with below error messages.<\/p>\n

\"ora_03113\"<\/a><\/p>\n

As it was showing issue on worker1 so we looked into log file of worker 1 located at<\/p>\n

$ORACLE_BASE\/fs1\/EBSapps\/appl\/admin\/PRD122\/log<\/strong>\u00a0and it was showing\u00a0below issue<\/p>\n

\"worker1_log_issue\"<\/a><\/p>\n

Cause:<\/strong><\/span><\/p>\n

Issue with the write permissions in $APPLPTMP\/UTL_FILE_DIR<\/strong>. wmsgrlspecn.sql<\/strong> creates a file under $APPLPTMP\/ UTL_FILE_DIR with the name GenRulepkgs.log.<\/strong><\/p>\n

The error will occur if this file exists under a different user (If you have multiple environments owned by different O.S. user on server then you could run into issues like this).<\/p>\n

Fix:<\/u><\/strong><\/p>\n

To resolve this issue follow the steps as given below:<\/p>\n

1.<\/strong> Ensure that the user running the patch or the script has write permissions to\u00a0$APPLPTMP\/UTL_FILE_DIR<\/strong> location. To find the value for utl_file_dir<\/p>\n

sqlplus apps\/<apps password><\/strong><\/p>\n

SELECT name, value FROM v$parameter WHERE name LIKE ‘utl_file_dir’;<\/strong><\/p>\n

2.<\/strong> If $APPLPTMP\/GenRulepkgs.log exists under a different user, then\u00a0change permissions to 755\u00a0<\/strong>on the\u00a0file so that current user can write to it.<\/p>\n

chmod 755\u00a0$APPLPTMP\/GenRulepkgs.log<\/strong><\/p>\n

3.<\/strong> Restart adpatch again as<\/p>\n

cd $ORACLE_BASE\/fs1\/EBSapps\/appl\/au\/12.0.0\/patch\/115\/driver<\/strong><\/p>\n

adpatch options=nocopyportion,nogenerateportion<\/strong><\/p>\n

And this time adpatch completed successfully.<\/p>\n

Reference:<\/u><\/strong><\/p>\n