ORACLE RAC的全自动 打补丁标准化文档

su - root

export GRID_HOME=/oracle/grid/crs_1

export   ORACLE_HOME=/oracle/app/product/11.2.0/db_1

cd   $GRID_HOME;mv OPatch OPatch.`date +%Y%m%d`

unzip   /soft/p6880880_112000_Linux-x86-64.zip -d $GRID_HOME

chown -R   grid:oinstall $GRID_HOME/OPatch

cd   $ORACLE_HOME;mv OPatch OPatch.`date +%Y%m%d`

unzip   /soft/p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME

chown -R   oracle:oinstall $ORACLE_HOME/OPatch

su - grid -c   ' $ORACLE_HOME/OPatch/opatch version'

OPatch   Version: 11.2.0.3.12

OPatch   succeeded.

su - oracle

$ORACLE_HOME/OPatch/opatch   version'

OPatch   Version: 11.2.0.3.12

OPatch   succeeded.

su - grid -c   'cd /soft ; unzip p26635745_112040_Linux-x86-64.zip'

su - grid

'$ORACLE_HOME/OPatch/opatch   prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/26635745 -oh   $ORACLE_HOME'

su - oracle

'$ORACLE_HOME/OPatch/opatch   prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/26635745 -oh   $ORACLE_HOME'

su - grid -c   'cd /soft; $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner'

root  用户执行：

/oracle/grid/crs_1/OPatch/opatch   auto /soft/26635745 -ocmrf /soft/ocm.rsp

su - grid -c   '$ORACLE_HOME/OPatch/opatch lsinv'

su - oracle   -c '$ORACLE_HOME/OPatch/opatch lsinv'

#############  若实例已建立，需要一下步骤  #############

只需要一个节点执行

su - oracle   -c 'sqlplus / as sysdba'<<EOF

@?/rdbms/admin/catbundle.sql   psu apply

EOF

su - oracle   -c 'sqlplus / as sysdba'<<EOF

@?/rdbms/admin/utlrp.sql

EOF

su - oracle   -c 'sqlplus / as sysdba'<<EOF

set line 150

col   ACTION_TIME for a30

col ACTION   for a8

col NAMESPACE   for a8

col VERSION   for a10

col   BUNDLE_SERIES for a5

col COMMENTS   for a20

select * from   dba_registry_history;

EOF

cd /soft

mv   /soft/ocm.rsp /soft/ocm.rsp.bak

su - oracle   -c 'cd /soft; $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner'

/oracle/app/product/11.2.0/db_1/OPatch/opatch   auto /soft/26635745 -oh /oracle/app/product/11.2.0/db_1 -ocmrf /soft/ocm.rsp