《在一臺機器上安裝oracle rac》,詳細

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

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

3、OCM( Oracle Cluster Manager首先需要生成一個Quorum Disk File，因為我們是單機，所以需要用命令來生成一個dd if=/dev/zero of=/u02/rac/Racfile bs=1024 count=1024這個文件至少需要4+(4*number_of_nodeKB,我們給它1M ，足夠了。把oracle 安裝的原文件解壓縮，這個時候，就可以運行安裝ocm 了 ./runInstaller在產品選擇畫面，選擇 Oracle Cluster Manager, 出現Public Node Information 的時候，填好本機的hostname ，也就

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

5、在/etc/rc.local文件加入/sbin/insmod hangcheck-timer hangcheck_tick=30 hangcheck_margin=180下面準備啟動ocm 的腳本在ORACLE_HOME目錄下面的oracm 目錄下面有admin 目錄 下面有個文件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現在就已經完成ocm 的啟動了 三. 安裝oracle 軟件這個沒有什么好說的, 把oracle 安裝好, 我選擇了不創(chuàng)建數據庫.四準備創(chuàng)建數據庫在創(chuàng)建數據庫之前, 要啟動公共服務進程. 以oracle 用戶身份運行 gsdctl start我選擇了dbca 來創(chuàng)建數據庫,

7、 它能找到節(jié)點. 如果找不到節(jié)點, 說明ocm 安裝失敗, 或者啟動失敗五配置監(jiān)聽和服務名我是使用netca 創(chuàng)建了兩個監(jiān)聽, 一個是rac1, 一個是rac2 listerer.ora 的內容#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 的內容# 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六, 啟動數據庫安裝完成后, 應該就可以啟動第一個實例了.我的初試化參數文件的內容是這樣的*.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就可以啟動第一個實例了啟動完成之后，為需要為第二個實例準備創(chuàng)建redo log,undo 表空間。 在第一個節(jié)點上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然后開另外一個終端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就可以啟動第二個實例了七. 無縫的實現切換. 在客戶端, 配置好服務名, 注意這個服務名跟一般的服務名不太一樣 我的客戶端的tnsnames.ora 文件是這樣的RAC.SZITOW N.NET.CN =(DESCRIPTION =(load_balance=on(failover=on(ADDRESS_LIST =(A