停止監(jiān)聽(雙節(jié)點grid執(zhí)行)
在駐馬店等地區(qū),都構建了全面的區(qū)域性戰(zhàn)略布局,加強發(fā)展的系統(tǒng)性、市場前瞻性、產(chǎn)品創(chuàng)新能力,以專注、極致的服務理念,為客戶提供做網(wǎng)站、成都網(wǎng)站制作 網(wǎng)站設計制作按需設計,公司網(wǎng)站建設,企業(yè)網(wǎng)站建設,品牌網(wǎng)站建設,全網(wǎng)營銷推廣,外貿網(wǎng)站建設,駐馬店網(wǎng)站建設費用合理。
lsnrctl stop
查看應用是否有連接(雙節(jié)點root執(zhí)行)
ps -ef | grep rac | grep LOCAL=NO
創(chuàng)建目錄(雙節(jié)點root執(zhí)行)
mkdir -p /u01/app/11.2.0.4/
chown -R grid:oinstall /u01/app/11.2.0.4/
上傳壓縮包解壓(節(jié)點一root執(zhí)行)
mkdir -p /tmp/update/
chmod -R 777 /tmp/update/
su - grid
cd /tmp/update/
unzip p13390677_112040_Linux-x86-64_3of7.zip
集群升級前檢查(雙節(jié)點root執(zhí)行)
節(jié)點一(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é)點二:
su - root
/tmp/CVU_11.2.0.4.0_grid/runfixup.sh
升級集群軟件(節(jié)點一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é)點輪流執(zhí)行
集群軟件升級完成,修改環(huán)境變量(雙節(jié)點grid執(zhí)行)
vi .bash_profile
ORACLE_HOME=/u01/app/11.2.0.4/grid
檢查監(jiān)聽(雙節(jié)點grid執(zhí)行)
節(jié)點一:
lsnrctl status
驗證升級后的版本(雙節(jié)點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é)點grid執(zhí)行)
lsnrctl stop
查看應用是否有連接(雙節(jié)點root執(zhí)行)
ps -ef | grep rac | grep LOCAL=NO
創(chuàng)建目錄(雙節(jié)點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é)點一root執(zhí)行)
su - oracle
cd /tmp/update/
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip
升級數(shù)據(jù)庫軟件(節(jié)點一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.安裝
預檢查升級,新軟件腳本檢查舊目錄(節(jié)點一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';
檢查無效對象(節(jié)點一oracle執(zhí)行)
select object_name,owner,object_type from dba_objects where status='INVALID';
關閉數(shù)據(jù)庫(雙節(jié)點oracle執(zhí)行)
sqlplus / as sysdba
shutdown immediate;
修改環(huán)境變量(雙節(jié)點oracle執(zhí)行)
vi .bash_profile
ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1
拷貝監(jiān)聽文件和參數(shù)文件(雙節(jié)點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/
確認環(huán)境變量生效(雙節(jié)點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é)點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í)行升級腳本(節(jié)點一oracle執(zhí)行)
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
以正常模式啟動數(shù)據(jù)庫(節(jié)點一oracle執(zhí)行)
sqlplus / as sysdba
startup;
@$ORACLE_HOME/rdbms/admin/catuppst.sql;
@$ORACLE_HOME/rdbms/admin/utlrp.sql;
確認數(shù)據(jù)庫無效對象和升級信息(節(jié)點一oracle執(zhí)行)
select object_name,object_type,owner from dba_objects where status='INVALID';
select comp_name,version from dba_registry;
修改cluster_database并啟動數(shù)據(jù)庫(節(jié)點一oracle執(zhí)行)
節(jié)點一:
show parameter cluster_database;
cluster_database Boolean FALSE
alter system set cluster_database=TRUE scope=spfile;
shutdown immediate;
startup;
啟動數(shù)據(jù)庫(節(jié)點二oracle執(zhí)行)
sqlplus / as sysdba
startup;
修改集群信息(節(jié)點一oracle執(zhí)行)
srvctl upgrade database -d rac -o $ORACLE_HOME
srvctl config database -d rac
修改集群信息(節(jié)點一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
檢查驗證GI版本與集群資源狀態(tài)(雙節(jié)點grid執(zhí)行)
節(jié)點一:
su - grid
crsctl query crs softwareversion
crsctl stat res -t
檢查數(shù)據(jù)庫版本(雙節(jié)點oracle執(zhí)行)
sqlplus / as sysdba
文章名稱:ORACLE11.2.0.3--11.2.0.4
本文路徑:http://muchs.cn/article26/ihdcjg.html
成都網(wǎng)站建設公司_創(chuàng)新互聯(lián),為您提供外貿網(wǎng)站建設、網(wǎng)站收錄、全網(wǎng)營銷推廣、網(wǎng)站策劃、網(wǎng)站制作、Google
聲明:本網(wǎng)站發(fā)布的內容(圖片、視頻和文字)以用戶投稿、用戶轉載內容為主,如果涉及侵權請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內容未經(jīng)允許不得轉載,或轉載時需注明來源: 創(chuàng)新互聯(lián)