Tuesday, 25 July 2017

RA-00600: internal error code, arguments: [kcratr_nab_less_than_odr]


Solution:-
========================================================

Do cancel based reocvery, and apply 'current online redolog' manually
------------

SQL>Startup mount ;

SQL>Show parameter control_files

Query 1
------------

SQL> select a.member, a.group#, b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status='CURRENT' ;

Note down the name of the redo log

SQL> Shutdown abort ;

Take a OS Level backup of the controlfile (This is to ensure we have a backup of current state of controlfile)

SQL> Startup mount ;
SQL> recover database using backup controlfile until cancel ;

Enter location of redo log shown as current in Query 1 when prompted for recovery

Hit Enter

SQL> Alter database open resetlogs ;

Sunday, 23 July 2017

Relink of module "adwrknew" failed. while applying patch 9239089

Error:-
=====================
Relinking executables...

An error occurred while relinking application programs.

Continue as if it were successful [No] : No
 Freeing includes hash table
Freeing fixes hash table
 Freeing basedons hash table
Freeing entities hash table

You should check the file
/u02/apps/apps/apps_st/appl/admin/PROD/log/u9239089.log

for errors.

LOG:-
=======================================================
Relink of module "adwrknew" failed.
See error messages above (also recorded in log file) for possible
reasons for the failure.  Also, please check that the Unix userid
running adrelink has read, write, and execute permissions
on the directory /u02/apps/apps/apps_st/appl/ad/12.0.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.

Done with link of product 'ad' on Mon Jul 24 08:06:18 IST 2017


adrelink is exiting with status 1

End of adrelink session
Date/time is  Mon Jul 24 08:06:18 IST 2017
**********************************************************
**********************************************************

SOLUTION:-
------------------------------------------------------------

Download the patch  12415211 and do the below following :-
========================================================================

[applmgr@apps120 stubs]$ cd /u02/apps/apps/tech_st/10.1.2
[applmgr@apps120 lib]$ cp -p -R stubs stubsORIG
[applmgr@apps120 lib]$ cd stubs
[applmgr@apps120 stubs]$ pwd
/u02/apps/apps/tech_st/10.1.2/lib/stubs

[applmgr@apps120 stubs]$ cp -rvf /u02/Apps_patches/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
`/u02/Apps_patches/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so' -> `./libgcc_s-2.3.2-stub.so'
[applmgr@apps120 stubs]$  ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
[applmgr@apps120 stubs]$ ln -s libgcc_s.so.1 libgcc_s.so
[applmgr@apps120 stubs]$ pwd
/u02/apps/apps/tech_st/10.1.2/lib/stubs

[applmgr@apps120 stubs]$ cd /u02/apps/apps/tech_st/10.1.3
[applmgr@apps120 10.1.3]$ cd lib/stubs

[applmgr@apps120 lib]$ cp -p -R stubs stubsORIG
[applmgr@apps120 lib]$ cd stubs
[applmgr@apps120 stubs]$ cp -rvf /u02/Apps_patches/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
`/u02/Apps_patches/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so' -> `./libgcc_s-2.3.2-stub.so'
[applmgr@apps120 stubs]$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
[applmgr@apps120 stubs]$ ln -s libgcc_s.so.1 libgcc_s.so
[applmgr@apps120 stubs]$ pwd
/u02/apps/apps/tech_st/10.1.3/lib/stubs

Then apply the Patch 9239089