I have installed oracle application 12.2.5 with Database 12.1.2 On oracle linux 7.2 , I have used startCD51
My installation was successful and it was confirmed by oracle support.
Then i have move to the post installation Task on 1320300.1. And i am on following task.
2.3 Apply the latest AD and TXK Release Update Pack for Release 12.2
While applying the patch using following command
adop phase=apply patches=21841299 hotpatch=yes
Unfortunately patch was hang fore long time, this is my first 12.2 installation. So i have check the worker log files.
then i saw two workers are having following error
Exception in thread "main" java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 122
ORA-06512: at "APPS.AD_ZD_CTX", line 13
ORA-06512: at line 1
Since patch was hanging for long time i have used adctrl to exit the workers
then i have raise SR with support.
we try to restart the patching process and it's not working
After Analyzing the issue Support eng has explained that there's data corruption and need to restore the system through backups .
Since i am new to 12,2 , i thought we should not need to take backups before online patching ??
Does Any one face this kind of issue
If we need backup before online patching !!! what is the concept of online patching all about
Still support is checking the possibility of sorting the issue with out Any backups.