pat98's always & forever

패치작업 11.2.0.4.160419 (2016.04)

BUG 22646198- GRID INFRASTRUCTURE SYSTEM PATCH 11.2.0.4.160419 contains

DB Patch Number : 22502456
OCW PATCH       : 22502549
ACFS PATCH      : 22502505

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

GRID_HOME, ORACLE_HOME 을 개별로 각각 할때

AIX 작업전 slibclean

export $GRID_HOME=/oragrid/product/11.2.0.4
export $ORACLE_HOME=/oracle/product/11.2.0.4
export $work=/arch

(root 유저)
$GRID_HOME/crs/install/rootcrs.pl -unlock (CRS 가 떠 있으면 script로 자동으로 내려버림)

(grid 유저)
$GRID_HOME/OPatch/opatch napply -oh /oragrid/product/11.2.0.4 -local /arch/22646198/22502549
$GRID_HOME/OPatch/opatch napply -oh /oragrid/product/11.2.0.4 -local /arch/22646198/22502505
$GRID_HOME/OPatch/opatch apply -oh /oragrid/product/11.2.0.4 -local /arch/22646198/22502456

(oracle 유저)
$work/22646198/22502549/custom/server/22502549/custom/scripts/prepatch.sh -dbhome /oracle/product/11.2.0.4 (권한체크)
$ORACLE_HOME/OPatch/opatch napply -oh /oracle/product/11.2.0.4 -local /arch/22646198/22502549/custom/server/22502549
$ORACLE_HOME/OPatch/opatch apply -oh /oracle/product/11.2.0.4 -local /arch/22646198/22502456
$work/22646198/22502549/custom/server/22502549/custom/scripts/postpatch.sh -dbhome /oracle/product/11.2.0.4 (권한체크)

(root 유저)
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.pl -patch (script로 자동으로 CRS를 올려 버림)

[롤백하는 경우]

GI Home
(root로)
$GRID_HOME/crs/install/rootcrs.pl -unlock

(grid 유저로)

$GRID_HOME/OPatch/opatch rollback -local -id 22502549 -oh /oragrid/product/11.2.0.4
$GRID_HOME/OPatch/opatch rollback -local -id 22502505 -oh /oragrid/product/11.2.0.4 
$GRID_HOME/OPatch/opatch rollback -local -id 22502456  -oh /oragrid/product/11.2.0.4

(oracle 유저로)
$work/22646198/22502549/custom/server/22502549/custom/scripts/prepatch.sh -dbhome /oracle/product/11.2.0.4
$ORACLE_HOME/OPatch/opatch rollback -local -id 22502549 -oh /oracle/product/11.2.0.4
$ORACLE_HOME/OPatch/opatch rollback -local -id 22502456  -oh /oracle/product/11.2.0.4
$work/22646198/22502549/custom/server/22502549/custom/scripts/postpatch.sh -dbhome /oracle/product/11.2.0.4

Run post script

(root로)
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.pl -patch

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT