ORACLE 11.2.0.3--11.2.0.4

停止監聽(雙節點grid執行)

lsnrctl stop

查看應用是否有連接(雙節點root執行)

ps -ef | grep rac | grep LOCAL=NO

創建目錄(雙節點root執行)

mkdir -p /u01/app/11.2.0.4/

chown -R grid:oinstall /u01/app/11.2.0.4/

上傳壓縮包解壓(節點一root執行)

mkdir -p /tmp/update/

chmod -R 777 /tmp/update/

su - grid

cd /tmp/update/

unzip p13390677_112040_Linux-x86-64_3of7.zip

集群升級前檢查(雙節點root執行)

節點一（grid）：

cd /tmp/update/grid/

/tmp/update/grid/runcluvfy.sh stage -pre crsinst -upgrade -n rac1,rac2 -rolling -src_crshome /u01/app/11.2.0/ -dest_crshome /u01/app/11.2.0.4/ -dest_version 11.2.0.4.0 -fixup -fixupdir /tmp

su - root

/tmp/CVU_11.2.0.4.0_grid/runfixup.sh

節點二：

su - root

/tmp/CVU_11.2.0.4.0_grid/runfixup.sh

升級集群軟件(節點一root執行)

unset ORACLE_HOME ORACLE_BASE ORACLE_SID

cd /tmp/update/grid/

./runInstaller

1.選擇 Skip software updates

2.選擇 Upgrade Oracle Grid Infrastructure or Oracle Automatic Storage Management

3.下一步

4.下一步

5.software Location 輸入 /u01/app/11.2.0.4/grid

6.安裝

7.76%執行腳本 雙節點輪流執行

集群軟件升級完成，修改環境變量(雙節點grid執行)

vi .bash_profile

ORACLE_HOME=/u01/app/11.2.0.4/grid

檢查監聽(雙節點grid執行)

節點一：

lsnrctl status

驗證升級后的版本(雙節點grid執行)

crsctl query crs softwareversion

Oracle Clusterware version on node [mailwwdb1] is [11.2.0.4.0]

crsctl query crs activeversion

Oracle Clusterware active version on the cluster is [11.2.0.4.0]

crsctl query crs releaseversion

Oracle High Availability Services release version on the local node is [11.2.0.4.0]

停止監聽(雙節點grid執行)

lsnrctl stop

查看應用是否有連接(雙節點root執行)

ps -ef | grep rac | grep LOCAL=NO

創建目錄(雙節點root執行)

mkdir -p /u01/app/oracle/product/11.2.0.4

chown -R oracle:oinstall /u01/app/oracle/product/11.2.0.4

上傳壓縮包解壓(節點一root執行)

su - oracle

cd /tmp/update/

unzip p13390677_112040_Linux-x86-64_1of7.zip

unzip p13390677_112040_Linux-x86-64_2of7.zip

升級數據庫軟件(節點一oracle執行)

cd /tmp/update/database/

./runInstaller

1.取消勾選 I wish to receive security ...

2.選擇 Skip software updates

3.選擇 Install database software only

4.下一步

5.下一步

6.下一步

7.software Location 輸入 /u01/app/oracle/product/11.2.0.4/db_1

8.選擇 dba/oinstall

9.忽略 下一步

10.安裝

預檢查升級，新軟件腳本檢查舊目錄(節點一oracle執行)

sqlplus / as sysdba

@/u01/app/oracle/product/11.2.0.4/db_1/rdbms/admin/utlu112i.sql

根據需要修改：

alter system set cluster_database=FALSE scope=spfile;

PURGE DBA_RECYCLEBIN；

EXECUTE dbms_stats.gather_dictionary_stats;

Events:

SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2

WHERE  UPPER(name) ='EVENT' AND  isdefault='FALSE';

Trace Events:

SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2

WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE';

檢查無效對象(節點一oracle執行)

select object_name,owner,object_type from dba_objects where status='INVALID';

關閉數據庫(雙節點oracle執行)

sqlplus / as sysdba

shutdown immediate;

修改環境變量(雙節點oracle執行)

vi .bash_profile

ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1

拷貝監聽文件和參數文件(雙節點oracle執行)

cp -r /u01/app/oracle/product/11.2.0/db_1/dbs/* /u01/app/oracle/product/11.2.0.4/db_1/dbs/

cp -r /u01/app/oracle/product/11.2.0/db_1/network/admin/* /u01/app/oracle/product/11.2.0.4/db_1/network/admin/

確認環境變量生效(雙節點oracle執行)

which sqlplus

/u01/app/oracle/product/11.2.0.4/db_1/bin/sqlplus

echo $ORACLE_HOME

/u01/app/oracle/product/11.2.0.4/db_1

修改/etc/oratab到新目錄(雙節點oracle執行)

vi /etc/oratab

+ASM1:/u01/app/11.2.0.4/grid:N          # line added by Agent

rac:/u01/app/oracle/product/11.2.0.4/db_1:N             # line added by Agent

執行升級腳本(節點一oracle執行)

startup upgrade;

spool /tmp/oracle.txt

@/u01/app/oracle/product/11.2.0.4/db_1/rdbms/admin/catupgrd.sql

spool off;

如果遇到權限問題：

( As the <asm_home sfw owner>:

$ cd <asm_home>/bin

$ ./setasmgidwrap o=<db_home>/bin/oracle

grid用戶

cd $ORACLE_HOME/bin

./setasmgidwrap o=/u01/app/oracle/product/11.2.0.4/db_1/bin/oracle

以正常模式啟動數據庫(節點一oracle執行)

sqlplus / as sysdba

startup;

@$ORACLE_HOME/rdbms/admin/catuppst.sql;

@$ORACLE_HOME/rdbms/admin/utlrp.sql;

確認數據庫無效對象和升級信息(節點一oracle執行)

select object_name,object_type,owner from dba_objects where status='INVALID';

select comp_name,version from dba_registry;

修改cluster_database并啟動數據庫(節點一oracle執行)

節點一：

show parameter cluster_database;

cluster_database      Boolean  FALSE

alter system set cluster_database=TRUE scope=spfile;

shutdown immediate;

startup;

啟動數據庫(節點二oracle執行)

sqlplus / as sysdba

startup;

修改集群信息(節點一oracle執行)

srvctl upgrade database -d rac -o $ORACLE_HOME

srvctl config database -d rac

修改集群信息(節點一grid執行)

crsctl stat res -t

srvctl start instance -d rac -i rac1

srvctl start instance -d rac -i rac2

crsctl stat res -t

srvctl stop database -d rac

crsctl stat res -t

srvctl start database -d rac

crsctl stat res -t

檢查驗證GI版本與集群資源狀態(雙節點grid執行)

節點一：

su - grid

crsctl query crs softwareversion

crsctl stat res -t

檢查數據庫版本(雙節點oracle執行)

sqlplus / as sysdba