AIX+Hacmp雙機熱備oracle10g安裝和雙機切換

1、AIX+Hacmp 雙機熱備 oraclelOg安裝環(huán)境說明系統(tǒng)部署：Unix AIX 6.1 版本 + HACMP 5.4 版本 + ORACLE 10g雙機熱備的方式是 Oracle程序安裝在各自的主機上，只把數(shù)據(jù)庫實例安裝的共享存儲上雙機熱備原理：通過 Hacmp實現(xiàn)雙機熱備，a、b兩臺小機中，同一時刻只有一臺機器對外 提供服務(wù)，另一臺機器處于待命狀態(tài)。A為主機，b為備機，正常情況下是 a機對外提供服務(wù)，當a機發(fā)生故障無法提供服務(wù)時，b機會自動接管，將系統(tǒng)和oracle服務(wù)切換到b機上。這個自動切換的過程大概需要 3分鐘的樣子。當a機故障修改之后，啟動a機上的hacmp，這時系統(tǒng) 又 會

2、自動從備機b上自動切換 回主機a上。小機a、b都有各自的IP地址，不管是a在提供服務(wù)， 還是b在提供服務(wù)，他們對外提供的服務(wù)IP地址是不變的，即客戶端在連接的時候，不會因為 兩臺小機 之間的切換而需要改變配置。Oracle實例安裝步驟1、安裝前的準備1.1 修改root用戶下的fsize資源限制：# vi /etc/security/limitsroot:fsize = -11.2 修改用戶允許的最大進程數(shù)：# smit chgsys*it I r it I I |I no,滬磚 QUt Vrl 1ill Rll! 1' l 49 EolktF1LR 收 li 嘖 dllgL tlfl

3、s«licsiii cd10PJLfllry F Le IdsIDPartition 10外 HQGQWIFI1 即 MX?團ILL 川岬J科山卜肚htMbrr nFlh1 H LI 1 1 i| 1 mm廠1.3 修改root用戶在命令行中使用backspace鍵:# cd# vi .profile smit erase A!注A!代表 backspace 鍵。1.4在每個節(jié)點上檢查網(wǎng)絡(luò)配置 1.5編輯hosts文件,把主備節(jié)點相應(yīng)的主機名和IP寫入1.6在每個節(jié)點上建立dba，hagsuser ， oinstall組和oracle 用戶建立用戶組：dba用戶組:Group NAM

4、EdbaiADMINISTRATIVE group501ListADMINISTRATOR listProjectsGroup IDIINum.)USER listListListOKCommandResetCancel?br其中:hagsuser 組 ID : 502 oinstall 組 ID : 503注可以通過命令smit或smitty 操作。1.7 建立oracle 用戶：oracle 用戶：* User IMAjM tAOM | INI 15TFt A, TIUSE FTP*|-irsiaiidROUPdl'OLirP SETncoL匚呂AxeiI IIHtO PT 卜 &

5、lt;11 rr： rt-O!«nI Til al PRi：8-GFLAMCom main cl*_ an<ol注oracle的 primary group 為 dba ,Group Set 為 hagsuseroin stallHOME Directory 為/home/oracle1.8設(shè)置oracle 用戶密碼:# passwd oracle1.9 設(shè)置oracle用戶資源限制：# vi /etc/security/limits oracle:fsize = -1 data = -1 stack = -1scpu = -11.10 為每個節(jié)點建立相同的Oracle軟件主目

6、錄1 建立 ORALCE_HOME CRS_ORA_HOM呼改變權(quán)限# mkdir -p /database/product/10.2.0/db_1# chow n -R oracle:dba /database/product/10.2.0# chmod -R 775 /database/product/10.2.01.11為每個節(jié)點設(shè)置Oracle用戶的環(huán)境變量$ vi /oracle/home/.profileumask 022export ORACLE_BASE=/database/product/1O.2.Oexport ORACLE_HOME=$ORACLE_BASE/db_1 e

7、xport PATH=$ORACLE_HOME/bi n:/usr/bi n:/usr/sb in: $ORACLE_HOME/bi nexport ORACLE_SID= hdcrmexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/libexport AIXTHREAD_SCOPE=S2、登陸一臺小機a的unix系統(tǒng)，安裝庫軟件使用Xmanager管理工具(Xbrowser),輸入IP、用戶、密碼選擇 Terminal

8、二IIztext bd itar'TerniinaJZ3 J3 | ' ' 獨由土曲：獨由竝魁出出曲：#由曲JU A.由出就也由址玄.由由整0.由土 JU：出由*竝，P 已£°|1 良 |-.lirTstJ.II l<onk： I二J下載數(shù)據(jù)庫軟件:以oracle 用戶解壓：$ cpio -ievd < 10gr2_aix5164_database.cpio以oralce用戶打開圖形界面XDM執(zhí)行安裝文件：$ cd /Disk1$ ./runln stall安裝時選擇只安裝軟件，結(jié)束時根據(jù)提示執(zhí)行root.sh3、用Oracle用戶登陸，

9、啟圖形界面：依次執(zhí)行入校命令：Su -oracle （回車）dbca （回車）export DISPLAY=00:0.0 （回車 本步驟即導(dǎo)入操作所在機器的IP地址，區(qū)分大小寫）sylonsdat a_b: 177 - Haan?per 2, 0 0notfQjr»J : l 垃 武；. ：iM=1 izfcsfjbiosiMz|畀代鬥：曲卅emir'jiNn-r、，*ri迪1勺，rN?n t/w、tsporr DispiAV-ir;. j . it，. im：o o4、進入 Oracle建庫界面:般選擇自定義建庫- 7 - 8 - 10 -5Datab

10、ase Configuration Assistant, Step 9 of 1 2 : Database ContentSample SchemasCustom ScriptSample Schemas illustrate the use of a laired approacri to complexity and are used by some demonstraiion programs, installing this will give you ihe following schemas in your datatoe: Human Resources, Order Entry

11、 Online 匚atalog * Product Media, Information Exchange, Sales History h will also create a tablespace calleid EXAMPLE The table space will be about 13Q NSSpecify whether or not to add the Sample Schemas to vor database廠 Sample Schema?Cancel丿Help BaekNcki p jFinish- 12 -Database Configuration Assistan

12、t, Step 1 2 of 1 2 : Creation Options一 IDatabase Configuration Assistant: Warnin<p35%Enterprise manager configuration failed due to lhe following error -nullYou tan reiry configuring this daiaba 詢th Enterprlie Manager later ey manually rur)NngJoafabase；product/lO.2.O/dbl/tiin/emca scripi.Clone ci

13、atatiase 匚佗at Ion in progressLog files farthe curnerrt operation arm located at ydatabase/protfuEt/10.2.0/db_ l/Ergtoollogs/dbca/hdappDatabase Configuration Assistant, Step 12 of 1 2 : Creation OptionsDatabase CcrDatabase Configuration AssistantDatabase creation complete. Check the logfiles at / dat

14、abase /product 10.2.0 dt)_ 1 /cfgtoollogs/dbca/hacnm for details.Database information.Global Database Name.nd ermSysiem ldentUler(5lD).hdermServer Parameter Filename: /daiabae/pnoaucl/10.2.0/db_ 1/dt)s>spfliehderm. oraAll daiabase accounts except ss, sitstem, dbsnmp, and sysman are locked. Select

15、 the Password Manage mem button to view a romplete list of locked accounts or tc manag e the dai abase act ounis (except DBSNMP and SVSMM). From The Pas sward Managemeni window, unlock only trie accounis you will ue. Oracle Corporation strongly recommends crangiing the default passwords Imnnedlatety

16、 after unlocking ihe account.Password Management.5、檢查監(jiān)聽配置文件檢查 listener.ora 禾口 tnsnames.ora 文件listener.ora文件配置如下：# listener.ora Network Configuration File:/database/product/10.2.0/db_1/ network/admi n/liste ner.ora# Gen erated by Oracle con figurati on tools.SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(

17、SID_NAME = PLSExtProc)(ORACLE_HOME = /database/product/10.2.0/db_1)(PROGRAM = extproc)(SID_DESC =(GLOBAL_DBNAME = hdcrm)(ORACLE_HOME = /database/product/10.2.0/db_1)(SID_NAME = hdcrm)LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PORTOCOL = IPC)(KEY = EXTPROCO) (ADDRESS = (PROTOCOL = TCP)

18、(HOST = )(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521) )tnsnames.ora 文件配置如下：# tnsnames.ora Network Configuration File: /database/product/10.2.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.HDCRM =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS

19、= (PROTOCOL = TCP)(HOST = )(PORT = 1521)(CONNECT_DATA =(SERVICE_NAME = hdcrm)EXTPROC_CONNECTION_DATA =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)(CONNECT_DATA =(SID = PLSExtProc)(PRESENTATION = RO)修改oracle啟動文件,dbstart.sh和dbstop.sh文件，將新增的數(shù)據(jù)庫加進入dbstart.sh 文件配置如下

20、：su - oracle<<EOFexport ORACLE_SID=hdcrmsqlplus sys/hd40 as sysdbastartupexitEOFecho "DB is STARTED"dbstop.sh文件配置如下： su - oracle«EOF export ORACLE_SID=hdcrm sqlplus sys/hd40 as sysdba shutdow n immediate exitEOFecho "DB is STOPED"6、切換到另外一臺小機 b 上:6.1 在小機a上，輸入命令：smitty c

21、lstop （回車）出現(xiàn)如下界面，光標移到第四行按F4,選擇Move Resource Groups，然后按三次回車，系統(tǒng)自動 進行切換到b，大概需要3-5 分鐘- 20 -PelpWindow Edit Options- 21 - # -Stop ClusteServicesType or seisct values nri entry f-ields,Press Enter AFTER making al 1 desired changes.* stop nowj on system restart or both Stop Cluster Services on these nodes

22、BROADCAST cluster shutdown?Entry Fields nowsyltrueseiect an Action on Resource Groups十+4-Brlng Resource Groups> +Seiecr an Action on Resource croupsMove cursor- to desi ed item and press Enter.Eri 廣 g R 電 sourui Groups Of fl IneMove Resource 匚roupslJnmanage Resource GroupsFl =HelpF2-RefreshF3=ca.

23、ncelF8=ImageFiAExitEnter=Do/-Findn-«F-ind Next- # - # -切換OK- # - # - 22 - # -6.2參考前面步驟1，登陸小機b的Unix操作系統(tǒng)- # -6.3檢查系統(tǒng)及oracle服務(wù)是否切換到b上Lspv檢查 卷組是否切換過 來，datavg應(yīng)為active狀態(tài)ps -ef|grep ora_ 檢查原有的數(shù)據(jù)庫實例是 否已啟動Urd'dttermWindow £di【OptionsJHelp0000000 0 00000000000000-00000000000000 0 00-0000 00004 0

24、00-0000000 -JI .1 1 .1 1 .1 J1 1 .1 JI .1 JI .1 1 .1 41- JCCCCCCCCCCCCCCCCCC7CCCCCCCCCC eil1ee?eeee<DeEeeeee2eeQJe巳eeeee DDDDDDDDDDDDDDDDDD :DDDDDDDDDD32- 24 -6.4參考前面步驟2-4,在小機b上創(chuàng)建同樣的數(shù)據(jù)庫實例，并且一定 要保證配置相同在b機上安裝相同數(shù)據(jù)庫實例的時 候，由于是安裝在同一個存儲的同一個 路徑下，要采用覆蓋安裝的方式。Database Configuration Assistant, Step 12 of II2

25、 : Creation OptionsHelpBrowse.,.ye st .Finish廠How5e.b.CancelBackFinishDatabase Con figuration Assistant, Step 12 of 1 2 : Creation OptionsDatabase Configuration AssistantDatabase Configurarion AssistaiLoq files for the current operation are located ar/ d atabase /p ro du cr/10.2.0/db. l/cfgtoolloas/dbca/hdccmDatabase Configuration Assistant, Step 12 of 1 2 : Creation Options6.5啟動小機a上的Hacmp，讓系統(tǒng)自動從小機b上再切回到a上輸入命令smitty clstart （回車）,選擇第一項，然后再回車，啟動HACMP程序。H.elpStart Cluster Seryices