單實(shí)例GI環(huán)境怎么轉(zhuǎn)換為集群環(huán)境
這篇文章主要講解了“單實(shí)例GI環(huán)境怎么轉(zhuǎn)換為集群環(huán)境”，文中的講解內(nèi)容簡(jiǎn)單清晰，易于學(xué)習(xí)與理解，下面請(qǐng)大家跟著小編的思路慢慢深入，一起來研究和學(xué)習(xí)“單實(shí)例GI環(huán)境怎么轉(zhuǎn)換為集群環(huán)境”吧！
在宜春等地區(qū)，都構(gòu)建了全面的區(qū)域性戰(zhàn)略布局，加強(qiáng)發(fā)展的系統(tǒng)性、市場(chǎng)前瞻性、產(chǎn)品創(chuàng)新能力，以專注、極致的服務(wù)理念，為客戶提供網(wǎng)站制作、成都網(wǎng)站建設(shè) 網(wǎng)站設(shè)計(jì)制作按需網(wǎng)站建設(shè),公司網(wǎng)站建設(shè),企業(yè)網(wǎng)站建設(shè),高端網(wǎng)站設(shè)計(jì),成都全網(wǎng)營(yíng)銷,外貿(mào)營(yíng)銷網(wǎng)站建設(shè),宜春網(wǎng)站建設(shè)費(fèi)用合理。
----------------------------------------------------------------------------------------------------------------
1. 單機(jī)ASM轉(zhuǎn)換集群ASM
----------------------------------------------------------------------------------------------------------------
------------------------------
1.1 關(guān)閉GI環(huán)境資源.
------------------------------
[oracle@a42ams1 ~]$ sqlplus / as sysdba
SQL> shutdown immediate;
[grid@a42ams1 ~]$ crsctl stop has
------------------------------
1.2 檢查安裝環(huán)境信息
------------------------------
--1.2.1 配置互信
./sshUserSetup.sh -hosts "a42ams1 a42ams2" -user grid -advanced -noPromptPassphrase
./sshUserSetup.sh -hosts "a42ams1 a42ams2" -user oracle -advanced -noPromptPassphrase
more /etc/hosts | grep -Ev '^#|^$|127.0.0.1|vip|scan|:' | awk '{print "ssh " $2 " date;"}' > ping.sh
--1.2.2 執(zhí)行集群安裝校驗(yàn)
./runcluvfy.sh stage -pre crsinst -n a42ams1,a42ams2 -verbose
------------------------------
1.3 卸載單機(jī)環(huán)境GI,清除軟件文件
------------------------------
[root@a42ams1 ~]# cd /grid/app/11.2.0/
[root@a42ams1 grid]# cd crs/install/
[root@a42ams1 install]# ./roothas.pl -deconfig -force
Using configuration parameter file: ./crsconfig_params
CRS resources for listeners are still configured
PRKO-2573 : ONS daemon is already stopped.
CRS-2673: Attempting to stop 'ora.A42AMSARCH.dg' on 'a42ams1'
CRS-2673: Attempting to stop 'ora.A42AMSDATA1.dg' on 'a42ams1'
CRS-2673: Attempting to stop 'ora.A42AMSOCR.dg' on 'a42ams1'
CRS-2677: Stop of 'ora.A42AMSOCR.dg' on 'a42ams1' succeeded
CRS-2677: Stop of 'ora.A42AMSDATA1.dg' on 'a42ams1' succeeded
CRS-2677: Stop of 'ora.A42AMSARCH.dg' on 'a42ams1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'a42ams1'
CRS-2677: Stop of 'ora.asm' on 'a42ams1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'a42ams1'
CRS-2677: Stop of 'ora.cssd' on 'a42ams1' succeeded
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'a42ams1'
CRS-2673: Attempting to stop 'ora.evmd' on 'a42ams1'
CRS-2677: Stop of 'ora.evmd' on 'a42ams1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'a42ams1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully deconfigured Oracle Restart stack
--11.2.0.4已經(jīng)不支持 (How to Convert a Single-Instance ASM to Cluster ASM (文檔 ID 452758.1) )
[oracle@a42ams1 ~]$ cd $ORACLE_HOME/bin
[oracle@a42ams1 bin]$ dbca -silent -deleteASM
This is no longer a supported operation. Use Automatic Storage Management Configuration Assistant (ASMCA) from grid infrastructure/clusterware home to delete ASM.
--分離GI的ORACLE_HOME信息
[grid@a42ams1 ~]$
$ORACLE_HOME/oui/bin/runInstaller -silent -detachHome ORACLE_HOME=$ORACLE_HOME
------------------------------
1.4 新裝GI/DB環(huán)境 (注意調(diào)整目錄及環(huán)境變量)
------------------------------
--如果需要使用原有磁盤作為OCR磁盤,需要清空磁盤信息
[root@a42ams1 ~]# dd if=/dev/zero of=/dev/asm-ocr1 bs=1M count=100
[root@a42ams1 ~]# dd if=/dev/zero of=/dev/asm-ocr2 bs=1M count=100
[root@a42ams1 ~]# dd if=/dev/zero of=/dev/asm-ocr3 bs=1M count=100
----------------------------------------------------------------------------------------------------------------
2. 單機(jī)數(shù)據(jù)庫轉(zhuǎn)換集群數(shù)據(jù)庫
----------------------------------------------------------------------------------------------------------------
------------------------------
2.1 掛載原有DG (兩個(gè)節(jié)點(diǎn)都可以進(jìn)行掛載)
------------------------------
[grid@a42ams1 ~]$ kfod a='/dev/asm*' disks=all ds=true o=all
[grid@a42ams1 ~]$ sqlplus / as sysasm
SQL> alter diskgroup A42AMSDATA1 mount;
SQL> alter diskgroup A42AMSARCH mount;
------------------------------
2.2 啟動(dòng)原有數(shù)據(jù)庫 (需要修改oracle可執(zhí)行程序權(quán)限,否則啟動(dòng)數(shù)據(jù)庫時(shí)無法訪問磁盤組)
------------------------------
--2.2.1 復(fù)制原有的參數(shù)文件和口令文件到新安裝目錄下,啟動(dòng)數(shù)據(jù)庫
[oracle@a42ams1 ~]$ sqlplus / as sysdba
SQL> startup
ORA-01565: error in identifying file '+A42AMSDATA1/a42amsdb/spfilea42amsdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +A42AMSDATA1/a42amsdb/spfilea42amsdb.ora
ORA-15001: diskgroup "A42AMSDATA1" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
--2.2.2 調(diào)整oracle可執(zhí)行程序文件權(quán)限
[oracle@a42ams1 trace]$ ls -la $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle oinstall 239626689 Jun 14 10:23 /oracle/app/oracle/product/11.2.0.4/db_1/bin/oracle
[root@a42ams1 bin]# /grid/app/11.2.0.4/grid/bin/setasmgidwrap o=/oracle/app/oracle/product/11.2.0.4/db_1/bin/oracle
--2.2.3 啟動(dòng)數(shù)據(jù)庫
[oracle@a42ams1 ~]$ sqlplus / as sysdba
SQL> startup;
--2.2.4 將數(shù)據(jù)庫加入crs資源中,并校驗(yàn)環(huán)境信息
[oracle@a42ams1 ~]$ srvctl add database -d a42amsdb -o /oracle/app/oracle/product/11.2.0.4/db_1 -p +A42AMSDATA1/a42amsdb/spfilea42amsdb.ora -c Single -x a42ams1
[oracle@a42ams1 ~]$ srvctl config database -d a42amsdb
------------------------------
2.3 進(jìn)行rac數(shù)據(jù)庫轉(zhuǎn)換 (MOS ID 1362116.1)
------------------------------
[oracle@a42ams1 ~]$ cd $ORACLE_HOME/assistants/rconfig/sampleXMLs
[oracle@a42ams1 sampleXMLs]$ cp ConvertToRAC_AdminManaged.xml ~
--2.3.1 替換轉(zhuǎn)換信息
[oracle@a42ams1 ~]$ vi ConvertToRAC_AdminManaged.xml
--轉(zhuǎn)換路徑信息 (配置文件中提示源和目標(biāo)的目錄可以一致)
<!--Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome -->
:%s#/oracle/product/11.2.0/db_1#/oracle/app/oracle/product/11.2.0.4/db_1#g
--實(shí)例信息
<n:SourceDBInfo SID="sales">
替換為：
<n:SourceDBInfo SID="a42amsdb">
--節(jié)點(diǎn)信息
<n:NodeList>
<n:Node name="node1"/>
<n:Node name="node2"/>
</n:NodeList>
替換為：
<n:NodeList>
<n:Node name="a42ams1"/>
<n:Node name="a42ams2"/>
</n:NodeList>
--實(shí)例前綴信息
<n:InstancePrefix>sales</n:InstancePrefix>
替換為：
<n:InstancePrefix>a42amsdb</n:InstancePrefix>
--DG信息調(diào)整 (由于不需要進(jìn)行數(shù)據(jù)遷移,DG信息置空)
<n:TargetDatabaseArea>+ASMDG</n:TargetDatabaseArea>
替換為：
<n:TargetDatabaseArea></n:TargetDatabaseArea>
<n:TargetFlashRecoveryArea>+ASMDG</n:TargetFlashRecoveryArea>
替換為：
<n:TargetFlashRecoveryArea></n:TargetFlashRecoveryArea>
--2.3.2 修改sys用戶口令為oracle
SQL> alter user sys identified by oracle;
--2.3.3 對(duì)轉(zhuǎn)換文件進(jìn)行校驗(yàn)
[oracle@a42ams1 ~]$ vi ConvertToRAC_AdminManaged.xml
<n:Convert verify="YES">
替換為：
<n:Convert verify="ONLY">
[oracle@a42ams1 ~]$ $ORACLE_HOME/bin/rconfig ./ConvertToRAC_AdminManaged.xml
--2.3.4 執(zhí)行轉(zhuǎn)換
[oracle@a42ams1 ~]$ vi ConvertToRAC_AdminManaged.xml
<n:Convert verify="ONLY">
替換為：
<n:Convert verify="YES">
[oracle@a42ams1 ~]$ $ORACLE_HOME/bin/rconfig ./ConvertToRAC_AdminManaged.xml
Converting Database "a42amsdb" to Cluster Database. Target Oracle Home: /oracle/app/oracle/product/11.2.0.4/db_1. Database Role: PRIMARY.
Setting Data Files and Control Files
Adding Database Instances
Adding Redo Logs
Enabling threads for all Database Instances
Setting TEMP tablespace
Adding UNDO tablespaces
Adding Trace files
Setting Fast Recovery Area
Updating Oratab
Creating Password file(s)
Configuring Listeners
Configuring related CRS resources
Starting Cluster Database
--2.3.5 執(zhí)行轉(zhuǎn)換檢查轉(zhuǎn)換結(jié)果,修改環(huán)境變量
[oracle@a42ams1 ~]$ srvctl config database -d a42amsdb
[oracle@a42ams1 ~]$ crsctl stat res ora.a42amsdb.db -t
[oracle@a42ams1 ~]$ ps -ef | grep ora_smon
[oracle@a42ams2 ~]$ ps -ef | grep ora_smon
感謝各位的閱讀，以上就是“單實(shí)例GI環(huán)境怎么轉(zhuǎn)換為集群環(huán)境”的內(nèi)容了，經(jīng)過本文的學(xué)習(xí)后，相信大家對(duì)單實(shí)例GI環(huán)境怎么轉(zhuǎn)換為集群環(huán)境這一問題有了更深刻的體會(huì)，具體使用情況還需要大家實(shí)踐驗(yàn)證。這里是創(chuàng)新互聯(lián)，小編將為大家推送更多相關(guān)知識(shí)點(diǎn)的文章，歡迎關(guān)注！
當(dāng)前文章：單實(shí)例GI環(huán)境怎么轉(zhuǎn)換為集群環(huán)境
網(wǎng)站地址：http://bm7419.com/article12/jcijgc.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供商城網(wǎng)站、營(yíng)銷型網(wǎng)站建設(shè)、企業(yè)網(wǎng)站制作、服務(wù)器托管、品牌網(wǎng)站制作、網(wǎng)站策劃
聲明：本網(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)
