一、安裝需知:
1、數據庫版本和grid版本號要一致
2、grid版本比oracle版本低,需要升級grid版本,否則dbca失敗。
3、本實驗采用oracle11.2.0.3.0
4、本實驗最先采用grid[11.2.0.1.0],最後又升級到grid[11.2.0.3.0]
5、系統采用linux RED5,linux6就不要用了,6不支持asmlib內核。
第2、4、5點需要注意。
二、系統環境:
操作系統版本:
[root@red1 ~]# uname -r
2.6.18-53.el5xen
[root@red1 ~]# uname -a
Linux red1 2.6.18-53.el5xen #1 SMP Wed Oct 10 16:48:44 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux
數據庫版本:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
查看grid版本---需要升級:
[grid@red1 bin]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [11.2.0.1.0]
grid版本---升級後的:
[grid@red1 bin]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [11.2.0.3.0]
grid升級到[11.2.0.3.0]
查看grid版本:
[grid@red1 bin]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [11.2.0.1.0]
升級到11.2.0.3.0
下載地址:
http://blog.csdn.net/tanguooo19866/article/details/8568357
升級包:https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_3of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_3of7.zip
升級手段:建立新的安裝目錄,需要足夠的磁盤空間安裝grid軟件。2g足夠!
1解壓:p10404530_112030_Linux-x86-64_3of7.zip
2、驗證
建立grid新目錄,並切換到升級包目錄,執行:
./runcluvfy.sh stage -pre crsinst -upgrade -n red1 -rolling -src_crshome /opt/grid -dest_crshome /opt/grid_11.2.0.3 -dest_version 11.2.0.3.0 -fixup -fixupdir /opt/grid_update_package
./runcluvfy.sh stage -pre crsinst -upgrade -n red1 -src_crshome /opt/grid -dest_crshome /opt/grid_11.2.0.3 -dest_version 11.2.0.3.0 -fixup -fixupdir /opt/grid_update_package
[grid@red1 grid]$ ./runcluvfy.sh stage -pre crsinst -upgrade -n red1 -src_crshome $ORACLE_HOME -dest_crshome /opt/grid_11.2.0.3 -dest_version 11.2.0.3.0 -fixup -fixupdir /tmp -verbose
Performing pre-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "red1"
Destination Node Reachable?
------------------------------------ ------------------------
red1 yes
Result: Node reachability check passed from node "red1"
Checking user equivalence...
Check: User equivalence for user "grid"
Node Name Status
------------------------------------ ------------------------
red1 failed
Result: PRVF-4007 : User equivalence check failed for user "grid"
ERROR:
User equivalence unavailable on all the specified nodes
Verification cannot proceed
Pre-check for cluster services setup was unsuccessful on all the nodes.
[grid@red1 grid]$
啟動圖形界面安裝,選擇update,點下一步就成。
最後執行1個root腳本,選擇y覆蓋目錄,提示
CRS-4664: Node red1 successfully pinned.
Replacing Clusterware entries in inittab
Replacing Clusterware entries in inittab
red1 2014/08/04 11:55:21 /opt/grid_11.2.0.3/cdata/red1/backup_20140804_115521.olr
red1 2014/08/01 15:39:17 /opt/grid/cdata/red1/backup_20140801_153917.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
安裝完成後修改環境變量到新目錄。
修改環境變量:
驗證新版本:
[grid@red1 ~]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [11.2.0.3.0]