Wish you and your family good health and a very happy & prosperous Eid.
With all good wishes 🙂
” O Allah! Forgive me(my sins) that I have already done, and will do (in the future), and what i have done in private, and what I have done in public, and all(sins) that You know from me. ”
الله أكبر الله أكبرلااله الا الله والله أكبر الله أكبر ولله الحمد
அல்லாஹு அக்பர், அல்லாஹு அக்பர்., லாஇலாஹ இல்லல்லாஹு வல்லாஹு அக்பர், அல்லாஹு அக்பர் வலில்லாஹில் ஹம்து.
I would like to share you this information who willingly to apply patches in ebs environment
Step 1: Download appropriate patches
Step 2: Transfer this file to appropriate location
Step 3: change the application user permission read and write , execute of this file
Step 4: Unzip the patch file and then you should read the README.txt file before you go to apply patches because If this patch said you need to do preinstall a task , you should finish the job before you start the task.
Step 5: stop the application service $ADMIN_SCRIPTS_HOME\adstpall.sh apps/apps
Step 6: Enable maintenance mode using adadmin
Step 7: apply the patch using adpatch command.
It will ask where is your patch directory, please locate it.
Autopatch file : example.drv
Step 8 : After successfully applied the patch, you should disable maintenance mode using adadmin
Step 9 : Start the application service $ADMIN_SCRIPTS_HOME\adstrtal.sh apps/apps
Step 10: Finish the job and then go and take a cup of coffee 🙂
This is the issues may occur after power failures
SQL> alter database open;
alter database open
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], ,
, , , , , , , , , 
Alter database open fails with ORA-00600 kcratr_nab_less_than_odr (Doc ID 1296264.1)