《在一臺(tái)機(jī)器上安裝oracle rac》,詳細(xì)

1、 單機(jī)安裝Oracle RAC更多Oracle 資料下載，請(qǐng)收藏以下地址： 本文的試驗(yàn)環(huán)境：硬件 hp 服務(wù)器，1G 內(nèi)存,120G 硬盤 OS ：Windows2000 advance serverVmware: 800M 內(nèi)存,10G 硬盤, red hat advance server 3.0 Oracle: Oracle 9i Realease 2 安裝wmware 上的rhel 3.0這里不詳細(xì)的說明把下載了的oracle 9204 的三個(gè)文件ftp 到redhat 上面去。按照Oracle 的安裝指南，設(shè)置好oracle 的環(huán)境，目錄，oracle 用戶，環(huán)境變量等等

2、。注意，我選的是比較高版本的linux 和oracle ，否則又是要打這個(gè)補(bǔ)丁，那個(gè)補(bǔ)丁，很麻煩。但是，在安裝oracle 之前，需要以root 登錄，打上 3006854號(hào)補(bǔ)丁。文件名稱是p3006854_9204_linux.zip。這個(gè)是我安裝過程中唯一打過的補(bǔ)丁。su rootunzip p3006854_9204_linux.zipcd 3006854./rhel3_pre_install.sh如果安裝報(bào)告以下錯(cuò)誤：-bash: ./rhel3_pre_install.sh Permission denied 修改下權(quán)限 chmod +x *.sh下面開始進(jìn)行RAC 的安裝一 安裝

3、OCM( Oracle Cluster Manager首先需要生成一個(gè)Quorum Disk File，因?yàn)槲覀兪菃螜C(jī)，所以需要用命令來生成一個(gè)dd if=/dev/zero of=/u02/rac/Racfile bs=1024 count=1024這個(gè)文件至少需要4+(4*number_of_nodeKB,我們給它1M ，足夠了。把oracle 安裝的原文件解壓縮，這個(gè)時(shí)候，就可以運(yùn)行安裝ocm 了 ./runInstaller在產(chǎn)品選擇畫面，選擇 Oracle Cluster Manager, 出現(xiàn)Public Node Information 的時(shí)候，填好本機(jī)的hostname ，也就

4、是hostname 命令返回的值。因?yàn)槭菃螜C(jī)，只要填寫第一個(gè)，同樣，在Private Node Information中，也填寫hostname 。在出現(xiàn)Quorum Disk Information 選項(xiàng)的時(shí)候，填寫剛才生成的文件/u02/rac/RacFile二配置RAC ，并且啟動(dòng)我們需要啟動(dòng)oracm 服務(wù)首先我們要啟動(dòng)hangcheck_timer 加載hangcheck-timerinsmod hangcheck-timer hangcheck_tick=30 hangcheck_margin=180確認(rèn)模塊已經(jīng)加載： lsmod | grep hang為了在系統(tǒng)啟動(dòng)自動(dòng)加載，我們

5、在/etc/rc.local文件加入/sbin/insmod hangcheck-timer hangcheck_tick=30 hangcheck_margin=180下面準(zhǔn)備啟動(dòng)ocm 的腳本在ORACLE_HOME目錄下面的oracm 目錄下面有admin 目錄 下面有個(gè)文件cmcfg.ora.tmp cp cmcfg.ora.tmp cmcft.ora 并且修改成HeartBeat=15000ClusterName=Oracle Cluster Manager, version 9i PollInterval=1000 MissCount=210PrivateNodeNames=hp-

6、linux PublicNodeNames=hp-linux ServicePort=9888CmDiskFile=/u02/rac/RacFileKernelModuleName=hangcheck-timer 下面要以root 來執(zhí)行腳本 sucd $ORACLE_HOME/oracm/bin ./ocmstart.sh現(xiàn)在就已經(jīng)完成ocm 的啟動(dòng)了 三. 安裝oracle 軟件這個(gè)沒有什么好說的, 把oracle 安裝好, 我選擇了不創(chuàng)建數(shù)據(jù)庫.四準(zhǔn)備創(chuàng)建數(shù)據(jù)庫在創(chuàng)建數(shù)據(jù)庫之前, 要啟動(dòng)公共服務(wù)進(jìn)程. 以oracle 用戶身份運(yùn)行 gsdctl start我選擇了dbca 來創(chuàng)建數(shù)據(jù)庫,

7、 它能找到節(jié)點(diǎn). 如果找不到節(jié)點(diǎn), 說明ocm 安裝失敗, 或者啟動(dòng)失敗五配置監(jiān)聽和服務(wù)名我是使用netca 創(chuàng)建了兩個(gè)監(jiān)聽, 一個(gè)是rac1, 一個(gè)是rac2 listerer.ora 的內(nèi)容#LISTENER.ORA.HP-LINUXNetworkConfigurationFile:/opt/oracle/product/9.2.0/network/admin/listener.ora.hp-linux # Generated by Oracle configuration tools.SID_LIST_RAC2 = (SID_LIST = (SID_DESC =(SID_NAME = P

8、LSExtProc(ORACLE_HOME = /opt/oracle/product/9.2.0 (PROGRAM = extproc SID_LIST_RAC1 = (SID_LIST = (SID_DESC =(SID_NAME = PLSExtProc(ORACLE_HOME = /opt/oracle/product/9.2.0 (PROGRAM = extproc LISTENER =(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC(KEY = EXTPROC (ADDRESS_

9、LIST =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521 RAC2 =(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1523 RAC1 =(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1522 SID_LIST_LISTENER

10、 = (SID_LIST = (SID_DESC =(SID_NAME = PLSExtProc(ORACLE_HOME = /opt/oracle/product/9.2.0 (PROGRAM = extproc (SID_DESC =(ORACLE_HOME = /opt/oracle/product/9.2.0 (SID_NAME = rac1 tnsnames.ora 的內(nèi)容# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/tnsnames.ora# Generated

11、by Oracle configuration tools.LISTENERS_RAC =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521LISTENER_RAC1 =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521RAC1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521(CONNECT_DATA =(SERVICE_NAME = rac(INSTANCE

12、_NAME = rac1INST1_HTTP =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521(CONNECT_DATA =(SERVER = SHARED(SERVICE_NAME = MODOSE(PRESENTATION = http:/HRServiceRAC =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521 (CONNECT_DATA =(SERV

13、ER = DEDICATED(SERVICE_NAME = racRAC2 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521(CONNECT_DATA =(SERVICE_NAME = rac(INSTANCE_NAME = rac2EXTPROC_CONNECTION_DATA =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC(KEY = EXTPROC(CONNECT_DATA =(SID = PLSExtProc(PRESENTATIO

14、N = RO六, 啟動(dòng)數(shù)據(jù)庫安裝完成后, 應(yīng)該就可以啟動(dòng)第一個(gè)實(shí)例了.我的初試化參數(shù)文件的內(nèi)容是這樣的*.aq_tm_processes=1*.background_dump_dest='/opt/oracle/admin/rac/bdump'*.cluster_database_instances=2*.cluster_database=true*.compatible='.0'*.REMOTE_LOGIN_PASSWORDFILE = NONE*.control_files='/opt/oracle/oradata/rac/contro

15、l01.ctl','/opt/oracle/oradata/rac/control02.ctl','/opt/oracle/oradata/rac/control03.ctl' *.core_dump_dest='/opt/oracle/admin/rac/cdump'*.db_block_size=8192*.db_cache_size=33554432*.db_domain=''*.db_file_multiblock_read_count=16*.db_name='rac'*.dispatchers=

16、'(PROTOCOL=TCP (SERVICE=racXDB'*.fast_start_mttr_target=300*.hash_join_enabled=TRUErac1.instance_name='rac1'rac2.instance_name='rac2'rac1.instance_number=1rac2.instance_number=2rac1.thread=1rac2.thread=2*.service_names='rac'*.java_pool_size=83886080*.job_queue_process

17、es=10*.large_pool_size=16777216rac1.local_listener='LISTENER_RAC1'*.open_cursors=300*.pga_aggregate_target=25165824*.processes=150*.query_rewrite_enabled='FALSE'*.remote_listener='LISTENERS_RAC'*.remote_login_passwordfile='exclusive'*.shared_pool_size=83886080*.sort_a

18、rea_size=524288*.star_transformation_enabled='FALSE'rac1.thread=1*.timed_statistics=TRUE*.undo_management='AUTO'*.undo_retention=10800rac1.undo_tablespace='UNDOTBS1'*.user_dump_dest='/opt/oracle/admin/rac/udump'rac1.local_listener=rac1rac2.local_listener=rac2export Or

19、acle_SID=rac1sqlplus /nolog connect / as sysdbaStartup pfile=/opt/initracpfile.ora就可以啟動(dòng)第一個(gè)實(shí)例了啟動(dòng)完成之后，為需要為第二個(gè)實(shí)例準(zhǔn)備創(chuàng)建redo log,undo 表空間。 在第一個(gè)節(jié)點(diǎn)上SQL>shutdown immediateSQL>startup mount pfile=/opt/initracpfile.oraSQL> alter database add logfile thread 22 group 4 ('/opt/oracle/oradata/rac/redo0

20、4.log' size 10240K,3 group 5 ('/opt/oracle/oradata/rac/redo05.log' size 10240K,4 group 6 ('/opt/oracle/oradata/rac/redo06.log' size 10240k;SQL>alter database open;SQL> alter database enable public thread 2;SQL> create undo tablespace undotbs2 datafile2 '/opt/oracle/o

21、radata/rac/undotbs2_01.dbf' size 200m;Tablespace created.SQL> select instance_name,instance_number from v$instance;INSTANCE_NAME INSTANCE_NUMBER- -rac1 1然后開另外一個(gè)終端export Oracle_sid=rac2sqlplus /nologconnect / as sysdba;startup pfile=/opt/initracpfile.oraSQL> select instance_name,instance_number from v$instance;INSTANCE_NAME INSTANCE_NUMBER- -rac2 2就可以啟動(dòng)第二個(gè)實(shí)例了七. 無縫的實(shí)現(xiàn)切換. 在客戶端, 配置好服務(wù)名, 注意這個(gè)服務(wù)名跟一般的服務(wù)名不太一樣 我的客戶端的tnsnames.ora 文件是這樣的RAC.SZITOW N.NET.CN =(DESCRIPTION =(load_balance=on(failover=on(ADDRESS_LIST =(A