This is the official document when you need to relink Oracle after an o/s kernel upgrade.
How To Relink The Oracle Grid Infrastructure Standalone (Restart) Installation Or Oracle Grid Infrastructure RAC/Cluster Installation (11.2 or 12c). (Doc ID 1536057.1)
For RAC follow :
Instruction Steps
| ||
Task Steps
|
Reference/Screenshots
| |
1.
|
Verify that cluster services is running on all nodes
|
$GRID_HOME/bin/crsctl stat res -t
|
2.
|
Shutdown OEM agent – if available
|
$AGENT_HOME/bin/emctl
stop agent
|
3.
|
Shutdown or Failover Goldengate if required
| |
4.
|
As root, disable automatic restart for HAS
|
sudo
bash
.
/usr/local/bin/oraenv
+ASM1
(or active ASM instance)
$ORACLE_HOME/bin/crsctl
disable has
|
5.
|
Shutdown HA services to prepare for relinking
|
$ORACLE_HOME/crs/install/rootcrs.sh -prepatch
For pre-12c installs use:
perl $ORACLE_HOME/crs/install/rootcrs.pl -unlock
|
6.
|
Confirm all Oracle processes are down, apply O/S patches
and reboot
|
ps -ef | grep -E 'oracle|has'
|
7.
|
After reboot, login as oracle and verify HAS did not start
|
$GRID_HOME/bin/crsctl stat res -t
|
8.
|
As
oracle (or owner of $GRID_HOME), relink executables in GRID_HOME
|
.
/usr/local/bin/oraenv
+ASM1
(or active ASM instance)
$ORACLE_HOME/bin/relink all
|
9.
|
Check log for relink errors
|
egrep
'error|fail' $ORACLE_HOME/install/relink.log
|
10.
|
Double
check relinked binaries.
Files should have date stamp of
current date/time
|
ls
-ltr $ORACLE_HOME/bin
|
11.
|
As oracle, relink executables in DB_HOME
|
.
/usr/local/bin/oraenv
nextfare1
(or other db name on server)
$ORACLE_HOME/bin/relink
all
|
12.
|
Check log for relink errors
|
egrep
'error|fail' $ORACLE_HOME/install/relink.log
|
13.
|
Double
check relinked binaries.
Files should have date stamp of
current date/time
|
ls
-l $ORACLE_HOME/bin
|
14.
|
As root, re-enable HAS
|
sudo
bash
.
/usr/local/bin/oraenv
+ASM1
(or active ASM instance)
$ORACLE_HOME/bin/crsctl
enable has
|
15.
|
As root, run rootadd_rdbms.sh
|
$ORACLE_HOME/rdbms/install/rootadd_rdbms.sh
|
16.
|
If GRID_HOME is owned by a user other than oracle, ie
grid, verify <DB_HOME>/bin/oracle has correct permission/uid/gid as
below. If not, run setasmgidwrap to
reset the oracle binary owner/group.
Replace <DB_HOME> with correct path for database
home.
Verify permissions/uid/gid as below:
ls -l <DB_HOME>/bin/oracle
permissions: -rwsr-s—x
uid: oracle
gid: asmadmin
|
su – grid
$ORACLE_HOME/bin/setasmgidwrap o=<DB_HOME>/bin/oracle
|
17.
|
Restart HA services
|
$ORACLE_HOME/crs/install/rootcrs.sh -postpatch
For pre-12c installs use:
perl $ORACLE_HOME/crs/install/rootcrs.pl -patch
|
18.
|
Verify that HA services have restarted
|
$ORACLE_HOME/bin/crsctl stat res -t
|
19.
|
As
oracle, start OEM agent – if available
|
$AGENT_HOME/bin/emctl
start agent
|
20.
|
Start
Goldengate if required
| |
21.
|
Repeat
Steps 2-19 for each additional node replacing ASM instance and DB instance as
needed.
| |
22.
|
No comments:
Post a Comment