oracle RAC-11.2.0.3-升級(jí)至11.2.0.4重點(diǎn)講義

1、Linux-RAC升級(jí)11.2.0.3至11.2.0.4一、上傳及解壓相關(guān)文件3二、創(chuàng)建GI和DB軟件目錄（新）3三、安裝升級(jí)GI軟件4四、安裝升級(jí)DB軟件13五、修改環(huán)境變量26六、升級(jí)結(jié)果驗(yàn)證276.1 驗(yàn)證環(huán)境變量是否生效276.2 驗(yàn)證數(shù)據(jù)庫(kù)所有組件是否成功升級(jí)28七、關(guān)閉數(shù)據(jù)庫(kù)關(guān)閉CRS重啟服務(wù)器31一、 上傳及解壓相關(guān)文件將11204版的grid以及oracle軟件上傳至服務(wù)器。并在合適的位置進(jìn)行解壓，得到database以及grid文件夾。二、 創(chuàng)建GI和DB軟件目錄（新）mkdir -p /data/11.2.0.4/grid/basemkdir -p /data/11.2.0

2、.4/grid/crsmkdir -p /data/11.2.0.4/oracle/appchown grid:oinstall /data/11.2.0.4/grid/basechown grid:oinstall /data/11.2.0.4/grid/crschown -R oracle:oinstall /data/11.2.0.4/oracle/appchmod -R 775 /data/11.2.0.4/chown -R grid:oinstall /oracle_new三、 安裝升級(jí)GI軟件停止數(shù)據(jù)庫(kù)實(shí)例節(jié)點(diǎn)一腳本執(zhí)行情況：rootlinux1 # sh /oracle/app/

3、11.2.0/grid/rootupgrade.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /oracle/app/11.2.0/gridEnter the full pathname of the local bin directory: /usr/local/bin: The contents of "dbhome" have not changed. No

4、need to overwrite.The contents of "oraenv" have not changed. No need to overwrite.The contents of "coraenv" have not changed. No need to overwrite.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running

5、 generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /oracle/app/11.2.0/grid/crs/install/crsconfig_paramsCreating trace directoryUser ignored Prerequisites during installationInstalling Trace File AnalyzerCRS-2791: Starting shutdown of

6、Oracle High Availability Services-managed resources on 'linux1'CRS-2673: Attempting to stop 'ora.crf' on 'linux1'CRS-2673: Attempting to stop 'ora.mdnsd' on 'linux1'CRS-2677: Stop of 'ora.crf' on 'linux1' succeededCRS-2673: Attempting to stop &

7、#39;ora.gipcd' on 'linux1'CRS-2677: Stop of 'ora.mdnsd' on 'linux1' succeededCRS-2677: Stop of 'ora.gipcd' on 'linux1' succeededCRS-2673: Attempting to stop 'ora.gpnpd' on 'linux1'CRS-2677: Stop of 'ora.gpnpd' on 'linux1' su

8、cceededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'linux1' has completedCRS-4133: Oracle High Availability Services has been stopped.ASM 升級(jí)已在第一個(gè)節(jié)點(diǎn)上初始化。OLR initialization - successfulReplacing Clusterware entries in upstartclscfg: EXISTING configuration versi

9、on 5 detected.clscfg: version 5 is 11g Release 2.Successfully accumulated necessary OCR keys.Creating OCR keys for user 'root', privgrp 'root'.Operation successful.ASM 升級(jí)已在第一個(gè)節(jié)點(diǎn)上開始。Configure Oracle Grid Infrastructure for a Cluster . succeeded節(jié)點(diǎn)二腳本執(zhí)行情況：rootlinux2 # sh /oracle/app/11.

10、2.0/grid/rootupgrade.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /oracle/app/11.2.0/gridEnter the full pathname of the local bin directory: /usr/local/bin: The contents of "dbhome" have not changed. No nee

11、d to overwrite.The contents of "oraenv" have not changed. No need to overwrite.The contents of "coraenv" have not changed. No need to overwrite.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running ge

12、neric part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /oracle/app/11.2.0/grid/crs/install/crsconfig_paramsCreating trace directoryUser ignored Prerequisites during installationInstalling Trace File AnalyzerCRS-2791: Starting shutdown of Ora

13、cle High Availability Services-managed resources on 'linux2'CRS-2673: Attempting to stop 'ora.mdnsd' on 'linux2'CRS-2673: Attempting to stop 'ora.crf' on 'linux2'CRS-2677: Stop of 'ora.crf' on 'linux2' succeededCRS-2673: Attempting to stop '

14、;ora.gipcd' on 'linux2'CRS-2677: Stop of 'ora.mdnsd' on 'linux2' succeededCRS-2677: Stop of 'ora.gipcd' on 'linux2' succeededCRS-2673: Attempting to stop 'ora.gpnpd' on 'linux2'CRS-2677: Stop of 'ora.gpnpd' on 'linux2' succe

15、ededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'linux2' has completedCRS-4133: Oracle High Availability Services has been stopped.OLR initialization - successfulReplacing Clusterware entries in upstartclscfg: EXISTING configuration version 5 detected.clscfg:

16、 version 5 is 11g Release 2.Successfully accumulated necessary OCR keys.Creating OCR keys for user 'root', privgrp 'root'.Operation successful.Started to upgrade the Oracle Clusterware. This operation may take a few minutes.Started to upgrade the CSS.Started to upgrade the CRS.The CR

17、S was successfully upgraded.Successfully upgraded the Oracle Clusterware.Oracle Clusterware operating version was successfully set to 11.2.0.4.0ASM 升級(jí)已在最后一個(gè)節(jié)點(diǎn)上完成。Configure Oracle Grid Infrastructure for a Cluster . succeeded四、 安裝升級(jí)DB軟件節(jié)點(diǎn)一腳本執(zhí)行情況：rootlinux1 # sh /oracle/app/oracle/app/root.sh Performi

18、ng root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle/app/oracle/appEnter the full pathname of the local bin directory: /usr/local/bin: The contents of "dbhome" have not changed. No need to overwrite.The contents of

19、"oraenv" have not changed. No need to overwrite.The contents of "coraenv" have not changed. No need to overwrite.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now p

20、roduct-specific root actions will be performed.Finished product-specific root actions.節(jié)點(diǎn)二腳本執(zhí)行情況：rootlinux2 # sh /oracle/app/oracle/app/root.shPerforming root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle/app/oracle/appEnter th

21、e full pathname of the local bin directory: /usr/local/bin: The contents of "dbhome" have not changed. No need to overwrite.The contents of "oraenv" have not changed. No need to overwrite.The contents of "coraenv" have not changed. No need to overwrite.Entries will be a

22、dded to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions.這一步非常慢五、 修改環(huán)境變量節(jié)點(diǎn)一gridexport ORACLE_SID=+ASM1export ORACLE_BASE=

23、/oracle_new/app/11.2.0/gridexport ORACLE_HOME=/oracle_new/app/gridexport PATH=$ORACLE_HOME/bin:.:$PATHexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORACLE_HOSTNAME=linux1export LANG=en_US節(jié)點(diǎn)一oracleexport ORACLE_SID=zk1export ORACLE_BASE=/oracle_new/app/oracleexport ORACLE_HOME=$ORACLE_BASE/appexpor

24、t PATH=$ORACLE_HOME/bin:.:$PATHexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORACLE_UNQNAME=zkexport ORACLE_HOSTNAME=linux1export LANG=en_USexport PATH=$PATH:$ORACLE_HOME/OPatch節(jié)點(diǎn)二 gridexport ORACLE_SID=+ASM2export ORACLE_BASE=/oracle_new/app/11.2.0/gridexport ORACLE_HOME=/oracle_new/app/gridexpor

25、t PATH=$ORACLE_HOME/bin:.:$PATHexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORACLE_HOSTNAME=linux2export LANG=en_US節(jié)點(diǎn)二oracleexport ORACLE_SID=zk2export ORACLE_BASE=/oracle_new/app/oracleexport ORACLE_HOME=$ORACLE_BASE/appexport PATH=$ORACLE_HOME/bin:.:$PATHexport NLS_LANG=AMERICAN_AMERICA.ZHS16GB

26、Kexport ORACLE_UNQNAME=zkexport ORACLE_HOSTNAME=linux2export LANG=en_USexport PATH=$PATH:$ORACLE_HOME/OPatch六、 升級(jí)結(jié)果驗(yàn)證6.1 驗(yàn)證環(huán)境變量是否生效數(shù)據(jù)庫(kù)版本已經(jīng)為112046.2 驗(yàn)證數(shù)據(jù)庫(kù)所有組件是否成功升級(jí)節(jié)點(diǎn)一rootlinux1 bin# ./crsctl query crs activeversionOracle Clusterware active version on the cluster is 11.2.0.4.0集群軟件已經(jīng)為11204版本，且集群正常。rootlinux1 bin# ./crsctl stat res -t-NAME TARGET STATE SERVER STATE_DETAILS -Local Resources-ora.DATA.dg ONLINE ONLINE linux1 ONLINE ONLINE linux2 or