Oracle software Relink

Recently I upgraded the OS from RHEL 5.6 to 5.9.

In our environment we have,

> Database 11gR2 (ASM configured and Gird configured for standalone server)

> Oracle WebLogic Server 10.3.6.

> Oracle Portal, Forms, Reports, and Discoverer Software 11gR1.

After OS upgradation I performed following task in application and database part,

1. Database part:

High level steps:

> Stop the OHAS stack.

> Connect as root user (different session) and unlock the Oracle Grid Infrastructure Standalone installation.

> Relink the Oracle Grid Infrastructure Standalone installation.

> Connect as root user (different session) and lock back the Oracle Grid Infrastructure Standalone installation.

> Relink the Oracle Software Home

> Verify that the all the OHAS services

Stop the OHAS stack (as “grid” OS user):

[grid@test1 ~]$ id

uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1100(asmadmin),1200(dba),1300(asmdba),1301(asmoper)

[grid@test1 ~]$ . oraenv

ORACLE_SID = [+ASM] ? +ASM

The Oracle base remains unchanged with value /u01/app/grid

[grid@test1 ~]$ crsctl stop has

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'test1'

CRS-2673: Attempting to stop 'ora.SPFILE.dg' on 'test1'

CRS-2673: Attempting to stop 'ora.db1.db' on 'test1'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'test1'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'test1' succeeded

CRS-2677: Stop of 'ora.db1.db' on 'test1' succeeded

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'test1'

CRS-2673: Attempting to stop 'ora.RECO.dg' on 'test1'

CRS-2677: Stop of 'ora.DATA.dg' on 'test1' succeeded

CRS-2677: Stop of 'ora.RECO.dg' on 'test1' succeeded

CRS-2677: Stop of 'ora.SPFILE.dg' on 'test1' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'test1'

CRS-2677: Stop of 'ora.asm' on 'test1' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'test1'

CRS-2677: Stop of 'ora.cssd' on 'test1' succeeded

CRS-2673: Attempting to stop 'ora.evmd' on 'test1'

CRS-2677: Stop of 'ora.evmd' on 'test1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'test1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

Connect as root user (different session) and unlock the Oracle Grid Infrastructure Standalone installation as follows:

 [grid@test1 ~]$ su - root

Password:

[root@test1 ~]# id

uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel)

[root@test1 ~]# . oraenv

ORACLE_SID = [root] ? +ASM

The Oracle base has been set to /u01/app/grid

[root@test1 ~]# $ORACLE_HOME/crs/install/roothas.pl -unlock

Using configuration parameter file: /u01/app/grid/product/11.2.0/grid/crs/install/crsconfig_params

Successfully unlock /u01/app/grid/product/11.2.0/grid

Then relink the Oracle Grid Infrastructure Standalone installation as follows (as grid user):

First of all, rename the $ORACLE_HOME/rdbms/lib/config.o file (located at the Oracle Grid Infrastructure Standalone installation) to force a

regeneration:

[grid@test1 ~]$ ls -l $ORACLE_HOME/rdbms/lib/config.o

-rw-r--r-- 1 grid oinstall 1256 Sep 18 23:03 /u01/app/grid/product/11.2.0/grid/rdbms/lib/config.o

[grid@test1 ~]$ mv $ORACLE_HOME/rdbms/lib/config.o $ORACLE_HOME/rdbms/lib/config.o_BAK

[grid@test1 ~]$ ls -l $ORACLE_HOME/rdbms/lib/config.o*

-rw-r--r-- 1 grid oinstall 1256 Sep 18 23:03 /u01/app/grid/product/11.2.0/grid/rdbms/lib/config.o_BAK

Then relink the the Oracle Grid Infrastructure Standalone installation:

[grid@test1 ~]$ script /tmp/relink_gi.txt

Script started, file is /tmp/relink_gi.txt

[grid@test1 ~]$ id

uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1100(asmadmin),1200(dba),1300(asmdba),1301(asmoper)

[grid@test1 ~]$ env| egrep 'ORA|PATH' | sort

LD_LIBRARY_PATH=/u01/app/grid/product/11.2.0/grid/lib

ORACLE_BASE=/u01/app/grid

ORACLE_HOME=/u01/app/grid/product/11.2.0/grid

ORACLE_SID=+ASM

PATH=/usr/lib64/qt-

3.3/bin:/usr/NX/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/grid/bin:.:/u01/app/grid/product/11.2.0/grid/bin

[grid@test1 ~]$ $ORACLE_HOME/bin/relink all

writing relink log to: /u01/app/grid/product/11.2.0/grid/install/relink.log

[grid@test1 ~]$ exit

exit

Script done, file is /tmp/relink_gi.txt

[grid@test1 ~]$

Connect as root user (different session) and lock back the Oracle Grid Infrastructure Standalone installation as follows:

[grid@test1 ~]$ su - root

Password:

[root@test1 ~]# . oraenv

ORACLE_SID = [root] ? +ASM

The Oracle base has been set to /u01/app/grid

[root@test1 ~]# $ORACLE_HOME/crs/install/roothas.pl -patch

Using configuration parameter file: /u01/app/grid/product/11.2.0/grid/crs/install/crsconfig_params

CRS-4123: Oracle High Availability Services has been started.

Relink the Oracle Software Home:

[oracle@test1 ~]# . $ORACLE_HOME/bin/oraenv

ORACLE_SID = [root] ? test

The Oracle base has been set to /u01/app/db

[oracle@test1 ~]# $ORACLE_HOME/bin/relink all

Verify that the all the OHAS services (ASM instance, diskgroups, listeners, DB instances, etc.) started:

[oracle@test1 ~]# srvctl start database -d test

[root@test1 ~]# crsctl stat res -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE        SERVER                   STATE_DETAILS      

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

               ONLINE  ONLINE       test1                                      

ora.LISTENER.lsnr

               ONLINE  ONLINE       test1                                      

ora.asm

               ONLINE  ONLINE       test1                    Started            

ora.ons

               OFFLINE OFFLINE      test1                                      

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       test1                                      

ora.diskmon

      1        OFFLINE OFFLINE                                                  

ora.evmd

      1        ONLINE  ONLINE       test1                                      

ora.test.db

      1        ONLINE  ONLINE       test1                    Open  

2. Application Part:

No need to perform any special task. (Even I crosschecked with Oracle support also)