Skip to content

Archive for

Eid Mubarak

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. ”
الله أكبر الله أكبرلااله الا الله والله أكبر الله أكبر ولله الحمد
அல்லாஹு அக்பர், அல்லாஹு அக்பர்., லாஇலாஹ இல்லல்லாஹு வல்லாஹு அக்பர், அல்லாஹு அக்பர் வலில்லாஹில் ஹம்து.

 

 

 

 

 

 

 

 

 

 

 

EBS Patch apply task

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 🙂

ORA-00600 kcratr_nab_less_than_odr when alter database open fails

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], [1],
[23], [81], [189], [], [], [], [], [], [], []

Solution :

SQL> Show parameter control_files;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string D:\APP\MAZAR\ORADATA\ORCL\CONT
ROL01.CTL, D:\APP\MAZAR\FLASH_
RECOVERY_AREA\ORCL\CONTROL02.C
TL
SQL> select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status='CURRENT';

MEMBER
--------------------------------------------------------------------------------

GROUP# STATUS
---------- ----------------
D:\APP\MAZAR\ORADATA\ORCL\REDO02.LOG
2 CURRENT
SQL> shutdown abort
ORACLE instance shut down.

Take the OS level backup for control files

C:\Windows\system32>COPY D:\APP\MAZAR\ORADATA\ORCL\CONTROL01.CTL D:\APP

1 file(s) copied.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1703624704 bytes
Fixed Size 2176408 bytes
Variable Size 1207962216 bytes
Database Buffers 486539264 bytes
Redo Buffers 6946816 bytes
Database mounted.

Specify the current redo log location
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1460665 generated at 10/08/2012 08:38:00 needed for thread
ORA-00289: suggestion :
D:\APP\MAZAR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012_10_14\O1_MF_1_23_%U_.AR
ORA-00280: change 1460665 for thread 1 is in sequence #23
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
D:\APP\MAZAR\ORADATA\ORCL\REDO02.LOG
Log applied.
Media recovery complete.

SQL> alter database open resetlogs;

Database altered.



Ref : Support ID 1296264.1