oracle 12c 12.1.0.2.5 패치작업

패치작업 12.1.0.2.5 (2015.10)

 

RAC 환경임

 

Patch 21523234 - Oracle Grid Infrastructure Patch Set Update 12.1.0.2.5 (Oct2015

Patch Number
21359755 : DB PSU 12.1.0.2.5 (OCT2015)
21359758 : OCW PSU 12.1.0.2.5

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

auto로 GRID_HOME, ORACLE_HOME 한꺼번에 해 버릴때(auto)

 

As the Grid home owner execute:

 

cd /tmp
$ <ORACLE_HOME>/OPatch/ocm/bin/emocmrsp

 

적용 (root)

opatchauto apply <UNZIPPED_PATCH_LOCATION>/21523234 -ocmrf <ocm response file>

롤백 (root)

opatchauto rollback <UNZIPPED_PATCH_LOCATION>/21523234

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

manual 로  GRID_HOME, ORACLE_HOME 각각 따로 (manually)

(root 유저)

<GI_HOME>/crs/install/rootcrs.pl -prepatch

crs 패치 (grid 유저)

<GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/21523234/21359755
<GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/21523234/21359758

 

db 패치 (oracle 유저)

<ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/21523234/21359755
<ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/21523234/21359758

(root 유저)

<GI_HOME>/rdbms/install/rootadd_rdbms.sh
<GI_HOME>/crs/install/rootcrs.pl -postpatch

 

Post 작업

1. sqlplus /nolog
2. SQL> Connect / as sysdba
3. SQL> startup
4. SQL> quit
5. cd $ORACLE_HOME/OPatch
6. ./datapatch -verbose

[롤백하는 경우]

(root로)
<GI_HOME>/crs/install/rootcrs.pl -prepatch -rollback

 

crs 패치 (grid 유저로)

$ <GI_HOME>/OPatch/opatch rollback -local -id 21359755 -oh <GI_HOME>
$ <GI_HOME>/OPatch/opatch rollback -local -id 21359758  -oh <GI_HOME>

 

db 패치 (oracle 유저로)
$ <ORACLE_HOME>/OPatch/opatch rollback -local -id 21359755 -oh <ORACLE_HOME>
$ <ORACLE_HOME>/OPatch/opatch rollback -local -id 21359758  -oh <ORACLE_HOME>

 

Run post script
(root로)
<GI_HOME>/rdbms/install/rootadd_rdbms.sh
<GI_HOME>/crs/install/rootcrs.pl -postpatch -rollback