標籤：let stp 知識 iptables Owner system spfile splay post
ORACLE LINUX 6.3 + ORACLE 11.2.0.3 RAC + VBOX安裝文檔2015-10-21 12:51 525人閱讀 評論(0) 收藏 舉報 分類：Oracle RAC
著作權聲明：本文為博主原創文章，未經博主允許不得轉載。
VBOX + Oracle Linux 6U3 + ORACLE 11.2.0.3.0 RAC 安裝
環境：
虛擬機器 VIRTUAL BOX
OS ORACLE LINUX 6.3_X86_64
ORACLE 11.2.0.3.0_X86_64
1, 安裝VITUAL BOX，略過.
2, 安裝ORACLE LINUX 6U3虛擬機器，安裝時只需選案頭選項.
硬體設定 CPU 1個，記憶體2048GB，硬碟100GB，共用磁碟30GB（6個5GB共用磁碟,固定大小，3塊用於ASM，3塊用於ORACLE）每3塊使用grid 的asmca命令建立一個ADMDISK ，2塊網卡（其中一塊橋接，另一塊內部網路）,
3, 配置配置網路環境，
伺服器1主機名稱 rac1 公橋接器接網卡IP:192.168.2.10 網關：192.168.2.1 私網內部網卡IP:172.168.1.10 子網路遮罩均為：255.255.255.0
伺服器2主機名稱 rac2 公橋接器接網卡IP:192.168.2.11 網關：192.168.2.1 私網內部網卡IP:172.168.1.11 子網路遮罩均為：255.255.255.0
4,並開機自動啟用。增加/etc/hosts檔案如下
#public
192.168.2.10 rac1 rac1.fengg.com
192.168.2.11 rac2 rac2.fengg.com
#vip
192.168.2.12 rac1-vip
192.168.2.13 rac2-vip
#scan
192.168.2.18 rac-cluster rac-cluster-scan
#priv
172.168.1.10 rac1-priv
172.168.1.11 rac2-priv
#public、vip、scan在同一網段，priv在同一網段
5,關閉FIREWALL和DISABLE SELINUX等服務
vim /etc/selinux/config ==> SELINUX=disabled
[[email protected] ~]# chkconfig --level 35 iptables off
[[email protected] ~]# chkconfig --level 35 ip6tables off
[[email protected] ~]# chkconfig --level 35 atd off
[[email protected] ~]# chkconfig --level 35 postfix off
[[email protected] ~]# chkconfig --level 35 bluetooth off
6, 建立使用者、組、目錄並設定口令
groupadd -g 5000 asmadmin
groupadd -g 5001 asmdba
groupadd -g 5002 asmoper
groupadd -g 6000 oinstall
groupadd -g 6001 dba
groupadd -g 6002 oper
useradd -g oinstall -G asmadmin,asmdba,asmoper,dba grid
useradd -g oinstall -G dba,asmdba oracle
echo ‘oracle‘ | passwd --stdin oracle
echo ‘oracle‘ | passwd --stdin grid
mkdir /s01
mkdir /g01
chown oracle:oinstall /s01
chown grid:oinstall /g01
7, 使用yum 安裝oracle-rdbms-server-11gR2-preinstall,準備RAC安裝環境
[[email protected] ~]# cd /etc/yum.repos.d
[[email protected] yum.repos.d]# mv public-yum-ol6.repo public-yum-ol6.repo.bak
[[email protected] yum.repos.d]# vim public-yum-ol6.repo
[oel6]
name = Enterprise Linux 6.3 DVD
baseurl=file:///media/"OL6.3 x86_64 Disc 1 20120626"/Server
gpgcheck=0
enabled=1
[[email protected] ~]# yum install oracle-rdbms-server-11gR2-preinstall*
vim /etc/security/limits.conf
#在檔案最後增加以下行
# grid-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024
grid soft nofile 1024
# grid-rdbms-server-11gR2-preinstall setting for nofile hard limit is 65536
grid hard nofile 65536
# grid-rdbms-server-11gR2-preinstall setting for nproc soft limit is 2047
grid soft nproc 2047
# grid-rdbms-server-11gR2-preinstall setting for nproc hard limit is 16384
grid hard nproc 16384
# grid-rdbms-server-11gR2-preinstall setting for stack soft limit is 10240KB
grid soft stack 10240
# grid-rdbms-server-11gR2-preinstall setting for stack hard limit is 32768KB
grid hard stack 32768
8, 複製RAC2虛擬機器並修改RAC2的主機名稱和IP地址
9, 配置兩台伺服器掛載共用儲存
[[email protected] ~]# for i in b c d e f g ;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /etc/udev/rules.d/99-oracle-asmdevices.rules
done
[[email protected] ~]# for i in b c d e f g ;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /etc/udev/rules.d/99-oracle-asmdevices.rules
done
/sbin/start_udev
10, 配置root、grid、oracle 使用者profile
mkdir /g01/orabase
RAC1節點：
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM1
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01/orabase
#export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
RAC2節點：
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM2
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01/orabase
#export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
RAC1和RAC2節點root使用者的環境變數
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
RAC1節點oracle使用者的環境變數
mkdir /s01/orabase
export ORACLE_HOME=/s01/orabase/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=RAC1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORACLE_BASE=/s01/orabase
#export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
RAC2節點oracle使用者的環境變數
mkdir /s01/orabase
export ORACLE_HOME=/s01/orabase/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=RAC2
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORACLE_BASE=/s01/orabase
#export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
11, 安裝LINUX下的XTERM軟體支援xmanger圖型化介面 yum install xterm*
12, 安裝GRID CLUSTWARE 軟體,不選gns選項.
注意：預先安裝檢查失敗可以忽略
Device check for asm warning no
Network Time Protocol(NTP) warning no
Task resolv.conf integrity failed no
安裝完失敗以下選項可以忽略
oracleoracle cluster verification utility failed, configure oracle grid infrastructure for a cluster failed
13, 再安裝ORACLE 軟體
14. 在RAC1和RAC2節點grid、oracle 打PSU補丁，補丁檔案p14727347_112030_Linux-x86-64.zip，unzip 解壓到/tmp/patch 目錄下，升級PSU之前先升級opatch命令軟體，軟體包為p6880880_112000_Linux-x86-64.zip，解壓到grid home目錄下覆蓋Opatch目錄
opatch lspatches ==> 檢查PSU補丁
su - root
$GRID_HOME/crs/install/rootcrs.pl -unlock
AIX上： su - root; slibclean
su - grid
opatch napply -oh $GRID_HOME -local /tmp/patch/14727310/
opatch napply -oh $GRID_HOME -local /tmp/patch/15876003/
su - oracle
[[email protected] scripts]$ /tmp/patch/15876003/custom/server/15876003/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
/tmp/patch/15876003/custom/server/15876003/custom/scripts/prepatch.sh completed successfully.
#注意patch許可權
opatch napply -oh $ORACLE_HOME -local /tmp/patch/15876003/custom/server/15876003
opatch napply -oh $ORACLE_HOME -local /tmp/patch/14727310
/tmp/patch/15876003/custom/server/15876003/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
su - root
[[email protected] ~]# /g01/11ggrid/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh
[[email protected] ~]# /g01/11ggrid/app/11.2.0/grid/crs/install/rootcrs.pl -patch
15,使用DBCA安裝ORACLE資料庫
16,RAC監聽安裝完GRID自動建立，tnsnames.ora檔案及相關命令如下：
/usr/bin/xterm -ls -display $DISPLAY
crsctl stat res -t
crsctl check crs
asmcmd
asmcmd>lsdg
ASMCMD> lsdsk
crs_stat|grep vip
crsctl stat res ora.scan1.vip
crsctl stat res ora.scan1.vip -p
crsctl stat res ora.net1.network
crsctl stat res ora.net1.network -p
opatch auto
opatch lspatches
opatch version
opatch lsinventory
crsctl check has
crsctl check crs
crsctl stop has -f
crsctl start has
srvctl stop database -d rac
srvctl start database -d rac
srvctl status database -d rac
srvctl config database -d rac
crsctl stop cluster -all
crsctl start cluster -all
crsctl start cluster -n rac1 rac2
crsctl status resource -t
crsctl check cluster
crsctl check ctss
srvctl status asm -a
cluvfy comp clocksync -verkbose
olsnodes -n
ocrcheck
crsctl query css votedisk
crs_stat -t -v
crsctl start cluster -all
crsctl stop cluster -all
srvctl start database -d rac
srvctl stop database -d rac
show parameter cluster_database;
show parameter local_listener;
show parameter remote_listener;
select * from v$instance;
select * from gv$instance;
參看叢集狀態
crs_stat -t
查看叢集資源資訊
srvctl config database -d rac -a
查看串連資訊
srvctl config database -d rac -t
查看服務資訊
srvctl config service -d rac -a
srvctl config service -d rac -s rac
srvctl config service -d rac -s rac -a
查看ASM資訊
srvctl config asm -n rac1
srvctl config asm -n rac2
查看監聽資訊
srvctl config listener -n rac1
srvctl config listener -n rac2
查看資料庫狀態
srvctl status database -d rac
srvctl status database -d rac -v
查看監聽狀態
srvctl status instance -d rac -i rac1,rac2
srvctl status instance -d rac -i rac1,rac2 -v
查看節點應用狀態
srvctl status nodeapps -n rac1
srvctl status nodeapps -n rac2
查看節點ASM狀態
srvctl status asm -n rac1
srvctl status asm -n rac2
關閉當前所串連的執行個體
srvctl stop instance -i rac1 -d rac -o abort
開啟當前執行個體
srvctl start instance -i rac1 -d rac
設定服務TAF模式為BASIC
RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
用戶端TNSNAMES.ORA
使用資料庫 tnsname串連如下：
RAC_12/13 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.12)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.13)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER=yes)
)
(CONNECT_DATA =
(SERVER=DEDICATED)
(SERVICE_NAME = RAC)
)
)
SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
FROM SYS.x$ksppi x, SYS.x$ksppcv y
WHERE x.inst_id = USERENV (‘Instance‘)
AND y.inst_id = USERENV (‘Instance‘)
AND x.indx = y.indx
AND x.ksppinm like ‘%high%‘;
虛擬機器可以關閉這個選項，提高效能
SQL> alter system set "_high_priority_processes"=‘LMS*‘ scope=spfile;
參考來自互連網
ORACLE LINUX 6.3 + ORACLE 11.2.0.3 RAC + VBOX安裝文檔
