R12.2 Apps DBA. Powered by Blogger.

R12.2.0 upgrade patch 13543062 ADZDWRKR.sql job error

No comments :
Below changes needs to be done in init.ora file:
Parameters to be set in init file
-----------------------------------------------
Please set o7_dictionary_accessibility to FALSE as its one of the mandatory parameter which needs to be set at this value.
Set compatible to 11.2.0 value
Set _optimizer_autostats_job to FALSE as it is also one of the mandatory parameter.
Set parallel_force_local to FALSE
Below parameter needs to be removed from init file:
optimizer_cost_based_transformation OFF Y
db_cache_size 80530636800
java_pool_size 201326592
large_pool_size 201326592
nls_language AMERICAN
optimizer_dynamic_sampling 4 Y
optimizer_features_enable 11.2.0.4 Y
plsql_optimize_level 2
undo_retention 72000
Please make these changes in the init file accordingly.
Also I could see from adzddbcc.lst file online patching enabled status is showing YES.
Can I have the output of below:
select ad_patch.is_patch_applied('R12',-1,13543062) from dual;
select ADOP_SESSION_ID, BUG_NUMBER, STATUS, APPLIED_FILE_SYSTEM_BASE, PATCH_FILE_SYSTEM_BASE, ADPATCH_OPTIONS, NODE_NAME, END_DATE, CLONE_STATUS
from ad_adop_session_patches where BUG_NUMBER='13543062';
After above changes issue resolved.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.