停止監(jiān)聽(雙節(jié)點(diǎn)grid執(zhí)行)

在駐馬店等地區(qū)，都構(gòu)建了全面的區(qū)域性戰(zhàn)略布局，加強(qiáng)發(fā)展的系統(tǒng)性、市場(chǎng)前瞻性、產(chǎn)品創(chuàng)新能力，以專注、極致的服務(wù)理念，為客戶提供做網(wǎng)站、成都網(wǎng)站制作 網(wǎng)站設(shè)計(jì)制作按需設(shè)計(jì),公司網(wǎng)站建設(shè),企業(yè)網(wǎng)站建設(shè),品牌網(wǎng)站建設(shè),全網(wǎng)營(yíng)銷推廣,外貿(mào)網(wǎng)站建設(shè),駐馬店網(wǎng)站建設(shè)費(fèi)用合理。

lsnrctl stop

查看應(yīng)用是否有連接(雙節(jié)點(diǎn)root執(zhí)行)

ps -ef | grep rac | grep LOCAL=NO

創(chuàng)建目錄(雙節(jié)點(diǎn)root執(zhí)行)

mkdir -p /u01/app/11.2.0.4/

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

上傳壓縮包解壓(節(jié)點(diǎn)一root執(zhí)行)

mkdir -p /tmp/update/

chmod -R 777 /tmp/update/

su - grid

cd /tmp/update/

unzip p13390677_112040_Linux-x86-64_3of7.zip

集群升級(jí)前檢查(雙節(jié)點(diǎn)root執(zhí)行)

節(jié)點(diǎn)一（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

節(jié)點(diǎn)二：

su - root

/tmp/CVU_11.2.0.4.0_grid/runfixup.sh

升級(jí)集群軟件(節(jié)點(diǎn)一root執(zhí)行)

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%執(zhí)行腳本 雙節(jié)點(diǎn)輪流執(zhí)行

集群軟件升級(jí)完成，修改環(huán)境變量(雙節(jié)點(diǎn)grid執(zhí)行)

vi .bash_profile

ORACLE_HOME=/u01/app/11.2.0.4/grid

檢查監(jiān)聽(雙節(jié)點(diǎn)grid執(zhí)行)

節(jié)點(diǎn)一：

lsnrctl status

驗(yàn)證升級(jí)后的版本(雙節(jié)點(diǎn)grid執(zhí)行)

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]

停止監(jiān)聽(雙節(jié)點(diǎn)grid執(zhí)行)

lsnrctl stop

查看應(yīng)用是否有連接(雙節(jié)點(diǎn)root執(zhí)行)

ps -ef | grep rac | grep LOCAL=NO

創(chuàng)建目錄(雙節(jié)點(diǎn)root執(zhí)行)

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

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

上傳壓縮包解壓(節(jié)點(diǎn)一root執(zhí)行)

su - oracle

cd /tmp/update/

unzip p13390677_112040_Linux-x86-64_1of7.zip

unzip p13390677_112040_Linux-x86-64_2of7.zip

升級(jí)數(shù)據(jù)庫軟件(節(jié)點(diǎn)一oracle執(zhí)行)

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.安裝

預(yù)檢查升級(jí)，新軟件腳本檢查舊目錄(節(jié)點(diǎn)一oracle執(zhí)行)

sqlplus / as sysdba

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

根據(jù)需要修改：

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';

檢查無效對(duì)象(節(jié)點(diǎn)一oracle執(zhí)行)

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

關(guān)閉數(shù)據(jù)庫(雙節(jié)點(diǎn)oracle執(zhí)行)

sqlplus / as sysdba

shutdown immediate;

修改環(huán)境變量(雙節(jié)點(diǎn)oracle執(zhí)行)

vi .bash_profile

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

拷貝監(jiān)聽文件和參數(shù)文件(雙節(jié)點(diǎn)oracle執(zhí)行)

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/

確認(rèn)環(huán)境變量生效(雙節(jié)點(diǎn)oracle執(zhí)行)

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到新目錄(雙節(jié)點(diǎn)oracle執(zhí)行)

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

執(zhí)行升級(jí)腳本(節(jié)點(diǎn)一oracle執(zhí)行)

startup upgrade;

spool /tmp/oracle.txt

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

spool off;

如果遇到權(quán)限問題：

( 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

以正常模式啟動(dòng)數(shù)據(jù)庫(節(jié)點(diǎn)一oracle執(zhí)行)

sqlplus / as sysdba

startup;

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

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

確認(rèn)數(shù)據(jù)庫無效對(duì)象和升級(jí)信息(節(jié)點(diǎn)一oracle執(zhí)行)

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

select comp_name,version from dba_registry;

修改cluster_database并啟動(dòng)數(shù)據(jù)庫(節(jié)點(diǎn)一oracle執(zhí)行)

節(jié)點(diǎn)一：

show parameter cluster_database;

cluster_database      Boolean  FALSE

alter system set cluster_database=TRUE scope=spfile;

shutdown immediate;

startup;

啟動(dòng)數(shù)據(jù)庫(節(jié)點(diǎn)二oracle執(zhí)行)

sqlplus / as sysdba

startup;

修改集群信息(節(jié)點(diǎn)一oracle執(zhí)行)

srvctl upgrade database -d rac -o $ORACLE_HOME

srvctl config database -d rac

修改集群信息(節(jié)點(diǎn)一grid執(zhí)行)

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

檢查驗(yàn)證GI版本與集群資源狀態(tài)(雙節(jié)點(diǎn)grid執(zhí)行)

節(jié)點(diǎn)一：

su - grid

crsctl query crs softwareversion

crsctl stat res -t

檢查數(shù)據(jù)庫版本(雙節(jié)點(diǎn)oracle執(zhí)行)

sqlplus / as sysdba

文章名稱：ORACLE11.2.0.3--11.2.0.4
本文路徑：http://chinadenli.net/article26/ihdcjg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供外貿(mào)網(wǎng)站建設(shè)、網(wǎng)站收錄、全網(wǎng)營(yíng)銷推廣、網(wǎng)站策劃、網(wǎng)站制作、Google

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)