【正文】 ；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é)點(diǎn)(4) 添加簡體中文(5) 選擇企業(yè)版(6) 默認(rèn)安裝目錄(7) 默認(rèn)用戶分配(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é)點(diǎn)(5) 使用默認(rèn)選項(xiàng)(6) 使用統(tǒng)一口令（orcl）(7) 選擇數(shù)據(jù)文件存儲路徑(8) 選擇+DATA(9) 輸入ASM口令（Nortek123）(10) 選擇歸檔模式，添加歸檔參數(shù)(11) 添加參數(shù)“+BACK/”(12) 使用默認(rèn)設(shè)置(13) 設(shè)置數(shù)據(jù)庫參數(shù)SGA（注：SGA不可大于/dev/shm）(14) 選擇數(shù)據(jù)庫字符集（utf8，根據(jù)需求）(15) 安裝概述(16) 點(diǎn)擊Finish設(shè)置完畢(17) 點(diǎn)擊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)建用戶并指定默認(rèn)表空間SQL create user jwj identified by jwj default tablespace imatrix。18. 用戶分權(quán)SQLgrant dba,connect,resource,create table,create session to jwj。19. 日常維護(hù)216。 RAC的啟停n 關(guān)閉crsctl stop cluster 停止本節(jié)點(diǎn)集群服務(wù)crsctl stop cluster –all 停止所有節(jié)點(diǎn)服務(wù)n 啟動crsctl start cluster 停止本節(jié)點(diǎn)集群服務(wù)crsctl start cluster –all 停止所有節(jié)點(diǎn)服務(wù)216。 RAC檢查運(yùn)行狀態(tài)crsctl check cluster216。 DATABASE檢查實(shí)例狀態(tài)srvctl status database d orcl216。 檢查節(jié)點(diǎn)應(yīng)用狀態(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負(fù)載均衡配置1. RAC負(fù)載均衡概述RAC的負(fù)載均衡主要是指新會話連接到RAC數(shù)據(jù)庫時(shí)，如何判定這個新的連接要連到哪個節(jié)點(diǎn)進(jìn)行工作。在RAC中，負(fù)載均衡分為兩種，一種是基于客戶端連接的，另外一種是基于服務(wù)器端的。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. 服務(wù)器配置(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è)置參數(shù)remote_listenersSQL alter system set remote_listener=39。LISTENERS_ORCL39。 sid=39。*39。五、 常見錯誤處理1. yum安裝失敗報(bào)錯信息：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同步時(shí)間失敗報(bào)錯信息： 5 Mar 19:02:57 ntpdate[6293]: no server suitable for synchronization found解決辦法：關(guān)閉rac1和rac2的防火墻service iptables stop3. 權(quán)限不足報(bào)錯信息： bash: xxx: Permission denied解決辦法：用root用戶給予xxx所有(777)權(quán)限。chmod 777 xxx 或者chmod R 777 /xxx/xxx4. 執(zhí)行/u01/app/報(bào)錯信息： 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