Step by Step doc for relinking Oracle homes
Step by Step doc for relinking Oracle homes
If we have ASM on the server ,first we need to relink ORACLE_HOME
and then Grid infra (GI) (ASM) home
RDBMS Relink
Step 1) set the environment
|
[oracle@ORA_SRVR ~]$ . oraenv
ORACLP
|
|
[oracle@ORA_SRVR ~]$ cd $ORACLE_HOME
[oracle@ORA_SRVR db_1]$ cd $ORACLE_HOME/bin
|
Step 2 ) relink the RDBMS Home
|
[oracle@ORA_SRVR bin]$ ./relink all
writing relink log to: /u00/app/oracle/product/12201/db_1/install/relink.log
[oracle@ORA_SRVR bin]$
|
Step 3) Repeat the above step for all Oracle homes
GI (ASM) Relink
| [oracle@ORA_SRVR ~]$ cd $ORACLE_HOME |
connect as root user and follow below steps
|
[oracle@ORA_SRVR grid]$ sudo su –
Last login: Thu Feb 25 13:42:55 EST 2021 from ORA_VDI.xyz.com on pts/0
[root@ORA_SRVR ~]# . oraenv
ORACLE_SID = [root] ? +ASM
The Oracle base has been set to /u00/app/oracle
[root@ORA_SRVR ~]# cd $ORACLE_HOME
[root@ORA_SRVR grid]# cd crs
[root@ORA_SRVR crs]# cd install
[root@ORA_SRVR install]# ./roothas.sh -unlock
Using configuration parameter file: /u00/grid/oracle/product/12201/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u00/app/oracle/crsdata/ORA_SRVR/crsconfig/haunlock__2021-02-25_01-48-22PM.log
2021/02/25 13:48:50 CLSRSC-347: Successfully unlock /u00/grid/oracle/product/12201/grid
|
Step 4) Take backup of config.o file
|
[root@ORA_SRVR install]# ls -l $ORACLE_HOME/rdbms/lib/config.o
-rw-r–r– 1 oracle dba 1320 Jan 17 2020 /u00/grid/oracle/product/12201/grid/rdbms/lib/config.o
|
|
[root@ORA_SRVR install]# mv $ORACLE_HOME/rdbms/lib/config.o $ORACLE_HOME/rdbms/lib/config.o_BAK
mv: overwrite ‘/u00/grid/oracle/product/12201/grid/rdbms/lib/config.o_BAK’? n
[root@ORA_SRVR install]# mv $ORACLE_HOME/rdbms/lib/config.o $ORACLE_HOME/rdbms/lib/config.o_BAK_Feb25
|
|
[root@ORA_SRVR install]# ls -l $ORACLE_HOME/rdbms/lib/config.o*
-rw-r–r– 1 oracle dba 1320 Jul 11 2019 /u00/grid/oracle/product/12201/grid/rdbms/lib/config.o_BAK
-rw-r–r– 1 oracle dba 1320 Jan 17 2020 /u00/grid/oracle/product/12201/grid/rdbms/lib/config.o_BAK_Feb25
[root@ORA_SRVR install]# exit
logout
|
step 5) log the relink process in text file by using script command
|
[oracle@ORA_SRVR grid]$ id
uid=1000(oracle) gid=1000(dba) groups=1000(dba)
[oracle@ORA_SRVR grid]$ script /tmp/relink_gi_Feb25.txt
Script started, file is /tmp/relink_gi_Feb25.txt
[oracle@ORA_SRVR grid]$ id
uid=1000(oracle) gid=1000(dba) groups=1000(dba)
[oracle@ORA_SRVR grid]$ env| egrep ‘ORA|PATH’ | sort
LD_LIBRARY_PATH=/u00/grid/oracle/product/12201/grid/lib
MANPATH=/opt/quest/man:
ORACLE_BASE=/u00/app/oracle
ORACLE_HOME=/u00/grid/oracle/product/12201/grid
ORACLE_SID=+ASM
PATH=/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin:/usr/java/jdk1.8.0_271-amd64/bin:/usr/java/jdk1.8.0_271-amd64/jre/bin:/u00/grid/oracle/product/12201/grid/bin
|
Step 6 ) relink all on Grid home
|
[oracle@ORA_SRVR grid]$ $ORACLE_HOME/bin/relink all
writing relink log to: /u00/grid/oracle/product/12201/grid/install/relink.log
|
Step 7 ) connect to root user and run rootadd_rdbms.sh script
|
[oracle@ORA_SRVR grid]$ sudo su –
Last login: Thu Feb 25 13:47:23 EST 2021 on pts/1
[root@ORA_SRVR ~]# . oraenv
ORACLE_SID = [root] ? +ASM
The Oracle base has been set to /u00/app/oracle
[root@ORA_SRVR ~]# $ORACLE_HOME/rdbms/install/rootadd_rdbms.sh
|
Step 8)
|
[root@ORA_SRVR ~]# cd $ORACLE_HOME
[root@ORA_SRVR grid]# cd crs/install
[root@ORA_SRVR install]# ./roothas.sh -postpatch
Using configuration parameter file: /u00/grid/oracle/product/12201/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u00/app/oracle/crsdata/ORA_SRVR/crsconfig/hapatch_2021-02-25_02-01-02PM.log
2021/02/25 14:02:02 CLSRSC-329: Replacing Clusterware entries in file ‘oracle-ohasd.service’
You have mail in /var/spool/mail/root
[root@ORA_SRVR install]#
|
Step 9)
Verify if all DBs are up and running
See Also: