2015. 11. 24. 10:18 오라클
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
