linux Oracle_RAC資料庫GI的PSU升級(11.2.0.4.0到11.2.0.4.8)
Oracle_RAC資料庫GI的PSU升級(11.2.0.4.0到11.2.0.4.8)
本次演示為升級oracle rac資料庫,用GI的psu升級,從11.2.0.4.0升級到11.2.0.4.8。
演示環境:
兩個節點:rac1、rac2
GI的PSU升級包(11.2.0.4.8):p21352635_112040_Linux-x86-64.zip
解壓縮後的目錄:/setup/oracleUp/21523375
grid的$GRID_HOME:/u01/app/11.2.0/grid
oracle的$ORACLE_HOME:/u01/app/oracle/product/11.2.0/db_1
一:升級OPatch
下載最新的opatch程式並替換GI_HOME和ORACLE_HOME下的OPatch目錄
注意:rac1和rac2兩個節點的grid和oracle都要升級OPatch版本
到OPatch目錄下:
[oracle@rac1 db_1] $ pwd
/u01/app/oracle/product/11.2.0/db_1
備份之前的OPatch目錄:
[oracle@rac1 db_1] $ mv OPatch/ OPatch_20151116/
解壓縮下載的最新的OPatch版本:
[oracle@rac1 db_1]$ unzip p6880880_112000_Linux-x86-64.zip
檢視opatch版本,已升級到最新的11.2.0.3.12版本
[oracle@rac1 db_1] $ cd OPatch/
[oracle@rac1 OPatch] $ ./opatch version
OPatch Version: 11.2.0.3.12
OPatch succeeded.
二:生成ocm檔案
在rac1和rac2分別生成ocm.rsp檔案。
[oracle@rac1 psu]$ pwd
/u01/app/oracle/psu
[oracle@rac1 psu]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/emocmrsp
[oracle@rac1 psu]$ ls
ocm.rsp
三:給GRID_HOME安裝補丁
1、rac1:
root使用者執行
[root@rac1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /setup/oracleUp/21523375 -oh /u01/app/11.2.0/grid/ -ocmrf /u01/app/oracle/psu/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /setup/oracleUp -patchn 21523375 -oh /u01/app/11.2.0/grid/ -ocmrf /u01/app/oracle/psu/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2015-11-16_15-39-09.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2015-11-16_15-39-09.report.log
2015-11-16 15:39:09: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping CRS...
Stopped CRS successfully
patch /setup/oracleUp/21523375/21352635 apply successful for home /u01/app/11.2.0/grid
patch /setup/oracleUp/21523375/21352649 apply successful for home /u01/app/11.2.0/grid
patch /setup/oracleUp/21523375/21352642 apply successful for home /u01/app/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
opatch auto succeeded.
2、上述執行完畢後,再在rac2上執行:
root使用者執行
[root@rac2 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /setup/oracleUp/21523375 -oh /u01/app/11.2.0/grid/ -ocmrf /u01/app/oracle/psu/ocm.rsp
四:給DB HOME安裝補丁集
1、rac1:
root使用者執行
[root@rac1 ~]# /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch auto /setup/oracleUp/21523375 -oh /u01/app/oracle/product/11.2.0/db_1 -ocmrf /u01/app/oracle/psu/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir /setup/oracleUp -patchn 21523375 -oh /u01/app/oracle/product/11.2.0/db_1 -ocmrf /u01/app/oracle/psu/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2015-11-16_16-31-45.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2015-11-16_16-31-45.report.log
2015-11-16 16:31:45: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully
patch /setup/oracleUp/21523375/21352635 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch /setup/oracleUp/21523375/21352649/custom/server/21352649 apply successful for home /u01/app/oracle/product/11.2.0/db_1
Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully
opatch auto succeeded.
2、上述執行完畢後,再在rac2上執行:
root使用者執行
[root@rac2 ~]# /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch auto /setup/oracleUp/21523375 -oh /u01/app/oracle/product/11.2.0/db_1 -ocmrf /u01/app/oracle/psu/ocm.rsp
五:更新dba_registry_history檢視資訊
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL> @?/rdbms/admin/catbundle.sql psu apply
確認升級後的dba_registry_history檢視:
SQL> select action,comments from registry$history;
ACTION COMMENTS
--------- ---------------
APPLY Patchset 11.2.0.2.0
APPLY PSU 11.2.0.4.8
2 rows selected.
六:檢查GI及oracle版本
檢視rac1和rac2兩個節點的GI和oracle版本,下面以rac1為例
檢視GI版本,已升級到11.2.0.4.8
檢視oracle版本,已升級到11.2.0.4.8
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25462274/viewspace-2087607/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 探索Oracle之資料庫升級四 11.2.0.4.0 PSU 11.2.0.4.3Oracle資料庫
- 探索Oracle之資料庫升級五 PSU 11.2.0.4.3 rollback 11.2.0.4.0Oracle資料庫
- 資料庫Oracle 11g RAC手動打GI PSU補丁(11.2.0.4.8)資料庫Oracle
- PSU的GI升級,ERROR: This patch is not applicable to GI home.ErrorAPP
- OJVM+GI PSU補丁升級JVM
- Oracle 11g RAC自動打GI PSU補丁(11.2.0.4.8)Oracle
- 升級到資料庫到10.2.0.5.0版本資料庫
- oracle資料庫升級11.2.0.3升級到11.2.0.4Oracle資料庫
- RAC資料庫升級到10.2.0.5資料庫
- rac 升級crs 升級資料庫軟體,升級資料庫資料庫
- Oracle資料庫從 9.2.0.1 到 9.2.0.8升級步驟for linuxOracle資料庫Linux
- 資料庫升級資料庫
- ♀♀資料庫升級♀♀資料庫
- RAC 資料庫升級 10.2.0.1.0 到 10.2.0.2.0 之升級catalog資料庫
- oracle資料庫11.2.0.3升級到11.2.0.4Oracle資料庫
- 【操作】升級資料庫軟體到10.2.0.3資料庫
- 升級資料庫到11.2.0.2需要注意的bug資料庫
- Oracle 資料庫升級Oracle資料庫
- oracle 資料庫從10.2.0.4升級到11.2.0.3Oracle資料庫
- (轉)手工升級資料庫10.1到10.2資料庫
- 【Oracle】RAC 11.2.0.4.0 PSU 11.2.0.4.170418Oracle
- 資料庫升級到mysql5.6遇到的資料表ENGINE問題資料庫MySql
- 資料庫升級之-Dataguard滾動升級資料庫
- oracle11.2.0.4.0 資料庫安裝Oracle資料庫
- 資料庫升級之-資料泵資料庫
- 探索Oracle之資料庫升級二 11.2.0.3升級到11.2.0.4完整步驟Oracle資料庫
- Oracle資料庫從 9.2.0.1 到 9.2.0.8升級步驟 for winOracle資料庫
- 手工升級9i資料庫到11g資料庫
- 資料庫升級和工具資料庫
- 資料庫升級之-XTTS資料庫TTS
- 資料庫升級報錯資料庫
- 9I 資料庫升級到10g的步驟資料庫
- 指令碼 - Oracle10g PSU後升級資料字典(RAC)指令碼Oracle
- 資料庫的升級及遷移資料庫
- 資料庫PSU的補丁升級 從10.2.0.5.2(10248542)升級至10.2.0.5.12(16619894)打補丁記錄資料庫
- Oracle10g RAC 資料庫升級為10.2.0.4 ,clusterware需要升級到10.2.0.4 ?Oracle資料庫
- Android版本升級同時Sqlite資料庫的升級及之前資料的保留AndroidSQLite資料庫
- 10g資料庫從10.2.0.4升級到10.2.0.5資料庫