【正文】 ；su grid$asmca(2) 創(chuàng)建DATA磁盤組(3) 創(chuàng)建BACK磁盤組(4) 創(chuàng)建完成14. 安裝Oracle11G(1) 啟動oracle安裝程序su oracle$cd /oracle11G安裝目錄$./runInstaller amp。(2) 僅安裝數(shù)據(jù)庫軟件(3) 選擇兩個節(jié)點(4) 添加簡體中文(5) 選擇企業(yè)版(6) 默認安裝目錄(7) 默認用戶分配(8) 安裝前檢查(9) 安裝概要(10) 執(zhí)行安裝(11) 用戶root在rac1和rac2執(zhí)行腳本(12) Oracle軟件安裝成功15. 創(chuàng)建數(shù)據(jù)庫(1) 啟動數(shù)據(jù)庫創(chuàng)建向?qū)u oracle$dbca(2) 創(chuàng)建數(shù)據(jù)庫(3) 安裝一般用途數(shù)據(jù)庫(4) 填寫數(shù)據(jù)庫名稱，選擇兩個節(jié)點(5) 使用默認選項(6) 使用統(tǒng)一口令（orcl）(7) 選擇數(shù)據(jù)文件存儲路徑(8) 選擇+DATA(9) 輸入ASM口令（Nortek123）(10) 選擇歸檔模式，添加歸檔參數(shù)(11) 添加參數(shù)“+BACK/”(12) 使用默認設置(13) 設置數(shù)據(jù)庫參數(shù)SGA（注：SGA不可大于/dev/shm）(14) 選擇數(shù)據(jù)庫字符集（utf8，根據(jù)需求）(15) 安裝概述(16) 點擊Finish設置完畢(17) 點擊OK，開始安裝(18) 正在安裝(19) 數(shù)據(jù)庫創(chuàng)建成功16. 創(chuàng)建表空間su oracle$sqlplus sys/orcl@orcl as sysdbaSQL create tablespace imatrix datafile 39。+DATA/orcl/39。 size 100M autoextend on next 10M segment space management auto extent management local。17. 創(chuàng)建用戶并指定默認表空間SQL create user jwj identified by jwj default tablespace imatrix。18. 用戶分權SQLgrant dba,connect,resource,create table,create session to jwj。19. 日常維護216。 RAC的啟停n 關閉crsctl stop cluster 停止本節(jié)點集群服務crsctl stop cluster –all 停止所有節(jié)點服務n 啟動crsctl start cluster 停止本節(jié)點集群服務crsctl start cluster –all 停止所有節(jié)點服務216。 RAC檢查運行狀態(tài)crsctl check cluster216。 DATABASE檢查實例狀態(tài)srvctl status database d orcl216。 檢查節(jié)點應用狀態(tài)及配置srvctl status nodeappssrvctl config nodeapps a g s l216。 查看數(shù)據(jù)配置srvctl config database d orcl a216。 檢查ASM狀態(tài)及配置srvctl status asmsrvctl config asm a216。 檢查TNS的狀態(tài)及配置srvctl status listenersrvctl config listener a216。 檢查SCAN狀態(tài)及配置srvctl status scansrvctl config scan216。 檢查VIP狀態(tài)及配置srvctl status vip n rac1srvctl status vip n rac2srvctl config vip n rac1srvctl config vip n rac2四、 RAC負載均衡配置1. RAC負載均衡概述RAC的負載均衡主要是指新會話連接到RAC數(shù)據(jù)庫時，如何判定這個新的連接要連到哪個節(jié)點進行工作。在RAC中，負載均衡分為兩種，一種是基于客戶端連接的，另外一種是基于服務器端的。2. 客戶端配置（PLSQL）(1) 修改客戶端hosts文件，添加如下內(nèi)容： rac1vip rac2vip(2) ：ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = rac1vip)(PORT = 1521)) (LOAD_BALANCE = on) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )3. 服務器配置(1) ： Network Configuration File: /orac/orahome/oracle/product/ Generated by Oracle configuration tools.ORCL1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) (INSTANCE_NAME = orcl1) ) )ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = rac2vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )LISTENERS_ORCL = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = rac2vip)(PORT = 1521)) )ORCL2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac2vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) (INSTANCE_NAME = orcl2) ) )(2) 在初始化參數(shù)中設置參數(shù)remote_listenersSQL alter system set remote_listener=39。LISTENERS_ORCL39。 sid=39。*39。五、 常見錯誤處理1. yum安裝失敗報錯信息：Loaded plugins: rhnplugin, securityThis system is not registered with RHN.RHN support will be disabled.Setting up Install ProcessNo package 包名 available.Nothing to do解決辦法：cd /etc/wget mv mv 2. NTP同步時間失敗報錯信息： 5 Mar 19:02:57 ntpdate[6293]: no server suitable for synchronization found解決辦法：關閉rac1和rac2的防火墻service iptables stop3. 權限不足報錯信息： bash: xxx: Permission denied解決辦法：用root用戶給予xxx所有(777)權限。chmod 777 xxx 或者chmod R 777 /xxx/xxx4. 執(zhí)行/u01/app/報錯信息： CRS is already configured on this node for crshome=0Cannot configure two CRS instances on the same cluster.Please deconfigure before proceeding with the configuration of new home.解決辦法：清除已有的CRS信息。 /u01/app/50 / 50