wmware10+redhat65+oracle11204+RAC+asmlib方式安装配置.docx
《wmware10+redhat65+oracle11204+RAC+asmlib方式安装配置.docx》由会员分享，可在线阅读，更多相关《wmware10+redhat65+oracle11204+RAC+asmlib方式安装配置.docx（47页珍藏版）》请在冰点文库上搜索。
wmware10+redhat65+oracle11204+RAC+asmlib方式安装配置
1.Wmware上安装上创建共享磁盘：
网络设置：
使用NAT模式，配置子网为192.168.59.0，两个虚拟机的网络选择NAT方式，并且配置192.168.59网段的IP地址，在笔记本电脑上可以直接访问。
创建一个虚拟机安装redhat6.5操作系统后，要禁用Firewall和SElinux，调整参数：
增加共享存储：
A.创建共享磁盘
在cmd中进入WMwareWorkstation10.0安装目录:
1.创建存储OracleClusterware文件（OracleClusterRegistryandvotingdisk）的磁盘：
vmware-vdiskmanager.exe-c-s1Gb-alsilogic-t2"D:
\vm-linux6.5-rac-storage\ShareDiskOCR.vmdk"
2.创建存储Oracle共享数据文件的磁盘：
vmware-vdiskmanager.exe-c-s10Gb-alsilogic-t2"D:
\vm-linux6.5-rac-storage\ShareDiskData01.vmdk"
编辑虚拟机配置文件
B.关闭两台虚拟机，用记事本打开虚拟机名字.wmx，到虛拟机的目录比如E:
\SoftwareInstall\vmware\linuxrac1，直接编辑*.vmx文件,加上下面语句（所有虛拟机节点）：
或者直接在两台VM上使用图形界面上直接添加磁盘－>选择已有的磁盘->选择上面创建的共享磁盘，然后点高级中选择scsi卡，最后确定。
scsi1:
1.deviceType="disk"
scsi1:
1.present="TRUE"
scsi1:
1.fileName="D:
\vm-linux6.5-rac-storage\ShareDiskOCR.vmdk"
scsi1:
1.mode="independent-persistent"
scsi1:
1.redo=""
scsi1:
2.deviceType="disk"
scsi1:
2.present="TRUE"
scsi1:
2.fileName="D:
\vm-linux6.5-rac-storage\ShareDiskData01.vmdk"
scsi1:
2.mode="independent-persistent"
scsi1:
2.redo=""
scsi1:
1.deviceType="disk"――加入配置文件中。
2.采用UEK内核来创建共享ASMLIB存储：
2.1.在redhat6.5操作系统上安装如下RPM包：
kmod-oracleasm-2.0.6.rh1-3.el6.x86_64.rpm
oracleasm-support-2.1.8-1.el6.x86_64.rpm
oracleasmlib-2.0.4-1.el6.x86_64.rpm
kernel-uek-firmware-2.6.39-300.17.3.el6uek.noarch.rpm
kernel-uek-2.6.39-300.17.3.el6uek.x86_64.rpm
#rpm–ihv*.rpm
2.2创建ASMDiskVolumes
对磁盘需要新进行fdisk分区，oracleasmconfigure-i之后两个节点需要重启！
#oracleasmconfigure-i――两个节点上都要操作
节点一上：
[root@oradb1soft]#oracleasmconfigure-i
ConfiguringtheOracleASMlibrarydriver.
Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrary
driver.Thefollowingquestionswilldeterminewhetherthedriveris
loadedonbootandwhatpermissionsitwillhave.Thecurrentvalues
willbeshowninbrackets（'[]'）.Hittingwithouttypingan
answerwillkeepthatcurrentvalue.Ctrl-Cwillabort.
Defaultusertoownthedriverinterface[]:
grid
Defaultgrouptoownthedriverinterface[]:
asmadmin
StartOracleASMlibrarydriveronboot（y/n）[n]:
y
ScanforOracleASMdisksonboot（y/n）[y]:
y
WritingOracleASMlibrarydriverconfiguration:
done
配置后reboot重启主机！
节点二上：
[root@oradb2disks]#oracleasmconfigure-i
ConfiguringtheOracleASMlibrarydriver.
Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrary
driver.Thefollowingquestionswilldeterminewhetherthedriveris
loadedonbootandwhatpermissionsitwillhave.Thecurrentvalues
willbeshowninbrackets（'[]'）.Hittingwithouttypingan
answerwillkeepthatcurrentvalue.Ctrl-Cwillabort.
Defaultusertoownthedriverinterface[grid]:
Defaultgrouptoownthedriverinterface[asmadm]:
asmadmin
StartOracleASMlibrarydriveronboot（y/n）[y]:
ScanforOracleASMdisksonboot（y/n）[y]:
WritingOracleASMlibrarydriverconfiguration:
done
配置后reboot重启主机！
#oracleasmconfigure――查看配置
[root@oradb2~]#oracleasmconfigure
ORACLEASM_ENABLED=true
ORACLEASM_UID=grid
ORACLEASM_GID=asmadmin
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false
[root@oradb1soft]#oracleasminit
Loadingmodule"oracleasm":
oracleasm
MountingASMlibdriverfilesystem:
/dev/oracleasm
[root@oradb1soft]#
[root@oradb2soft]#oracleasminit
Loadingmodule"oracleasm":
oracleasm
MountingASMlibdriverfilesystem:
/dev/oracleasm
[root@oradb2soft]#
在节点一上创建即可，节点二上可以直接扫描出来：
[root@oradb1soft]#oracleasmcreatediskCRSVOL/dev/sdb1
Writingdiskheader:
done
Instantiatingdisk:
done
[root@oradb1soft]#oracleasmcreatediskDATAVOL/dev/sdc1
Writingdiskheader:
done
Instantiatingdisk:
done
[root@oradb1soft]#
[root@oradb1soft]#oracleasmlistdisks
CRSVOL
DATAVOL
[root@oradb1soft]#oracleasm-discover
UsingASMLibfrom/opt/oracle/extapi/64/asm/orcl/1/libasm.so
[ASMLibrary-GenericLinux,version2.0.4（KABI_V2）]
Discovereddisk:
ORCL:
CRSVOL[2088387blocks（1069254144bytes）,maxio512]
Discovereddisk:
ORCL:
DATAVOL[20964762blocks（10733958144bytes）,maxio512]
[root@oradb1soft]#
在节点二上直接scandisks后就会出现已创建的asmdisk.
[root@oradb2soft]#oracleasmscandisks
Reloadingdiskpartitions:
done
CleaninganystaleASMdisks...
ScanningsystemforASMdisks...
Instantiatingdisk"CRSVOL"
Instantiatingdisk"DATAVOL"
[root@oradb2soft]#oracleasmlistdisks
CRSVOL
DATAVOL
[root@oradb2soft]#
[grid@oradb1disks]$ls-atl/dev/oracleasm/disks――查看属性grid：
asmadmin
total0
brw-rw----1gridasmadmin8,33May708:
42DATAVOL
brw-rw----1gridasmadmin8,17May708:
42CRSVOL
drwxr-xr-x1rootroot0May708:
37.
drwxr-xr-x4rootroot0May708:
37..
3.redhat6.5操作系统上配置
3.1主机IP配置：
192.168.59.130oradb1
192.168.59.131oradb2
192.168.59.132oradb1-vip
192.168.59.133oradb2-vip
192.168.59.134scan-ip
10.10.10.130oradb1-priv
10.10.10.131oradb2-priv
3.2创建组及用户：
groupadd-g1000oinstall
groupadd-g1020asmadmin
groupadd-g1021asmdba
groupadd-g1022asmoper
groupadd-g1031dba
groupadd-g1032oper
useradd-u1100-goinstall-Gasmadmin,asmdba,asmoper,oper,dbagrid
useradd-u1101-goinstall-Gdba,asmdba,operoracle
mkdir-p/oracle/app/grid_base
mkdir-p/oracle/app/grid_home
mkdir-p/oracle/app/oracle/product/11.2.0/db_1
chown-Rgrid:
oinstall/oracle/
chown-Roracle:
oinstall/oracle/app/oracle
chmod-R775/oracle/
3.3配置limits.conf
vi/etc/security/limits.conf
gridsoftnproc2047
gridhardnproc16384
gridsoftnofile1024
gridhardnofile65536
oraclesoftnproc2047
oraclehardnproc16384
oraclesoftnofile1024
oraclehardnofile65536
3.4配置内核参数
#vi/etc/sysctl.conf
fs.aio-max-nr=1048576
fs.file-max=6815744
kernel.shmmni=4096
kernel.sem=25032000100128
net.ipv4.ip_local_port_range=900065500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
3.5检查需要的包:
#rpm-qbinutilscompat-libstdc++-33elfutils-libelfelfutils-libelf-develgccgcc-c++glibcglibc-commonglibc-develglibc-headerskernel-headerskshlibaiolibaio-devellibgcclibgomplibstdc++libstdc++-develmakenumactl-develsysstatunixODBCunixODBC-devel
3.6设置用户环境变量
节点一：
#su-grid
#cat.bash_profile
TMP=/tmp;exportTMP
TMPDIR=$TMP;exportTMPDIR
ORACLE_SID=+ASM1;exportORACLE_SID
ORACLE_BASE=/oracle/app/grid_base;exportORACLE_BASE
ORACLE_HOME=/oracle/app/grid_home;exportORACLE_HOME
NLS_DATE_FORMAT="yyyy-mm-ddHH24:
MI:
SS";exportNLS_DATE_FORMAT
THREADS_FLAG=native;exportTHREADS_FLAG
PATH=$ORACLE_HOME/bin:
$PATH;exportPATH
THREADS_FLAG=native;exportTHREADS_FLAG
PATH=$ORACLE_HOME/bin:
$PATH;exportPATH
if[$USER="oracle"]||[$USER="grid"];then
if[$SHELL="/bin/ksh"];then
ulimit-p16384
ulimit-n65536
else
ulimit-u16384-n65536
fi
umask022
fi
#su-oracle
cat.bash_profile
TMP=/tmp;exportTMP
TMPDIR=$TMP;exportTMPDIR
ORACLE_BASE=/oracle/app/oracle;exportORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0;exportORACLE_HOME
ORACLE_SID=racdb1;exportORACLE_SID
ORACLE_UNQNAME=racdb;exportORACLE_UNQNAME
ORACLE_TERM=xterm;exportORACLE_TERM
PATH=/usr/sbin:
$PATH;exportPATH
PATH=$ORACLE_HOME/bin:
$PATH;exportPATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:
/lib:
/usr/lib;exportLD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:
$ORACLE_HOME/jlib:
$ORACLE_HOME/rdbms/jlib;exportCLASSPATH
NLS_DATE_FORMAT="yyyy-mm-ddHH24:
MI:
SS";exportNLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;exportNLS_LANG
if[$USER="oracle"]||[$USER="grid"];then
if[$SHELL="/bin/ksh"];then
ulimit-p16384
ulimit-n65536
else
ulimit-u16384-n65536
fi
umask022
fi
节点二：
#su-grid
#cat.bash_profile
TMP=/tmp;exportTMP
TMPDIR=$TMP;exportTMPDIR
ORACLE_SID=+ASM2;exportORACLE_SID
ORACLE_BASE=/oracle/app/grid_base;exportORACLE_BASE
ORACLE_HOME=/oracle/app/grid_home;exportORACLE_HOME
NLS_DATE_FORMAT="yyyy-mm-ddHH24:
MI:
SS";exportNLS_DATE_FORMAT
THREADS_FLAG=native;exportTHREADS_FLAG
PATH=$ORACLE_HOME/bin:
$PATH;exportPATH
THREADS_FLAG=native;exportTHREADS_FLAG
PATH=$ORACLE_HOME/bin:
$PATH;exportPATH
if[$USER="oracle"]||[$USER="grid"];then
if[$SHELL="/bin/ksh"];then
ulimit-p16384
ulimit-n65536
else
ulimit-u16384-n65536
fi
umask022
fi
#su-oracle
cat.bash_profile
TMP=/tmp;exportTMP
TMPDIR=$TMP;exportTMPDIR
ORACLE_BASE=/oracle/app/oracle;exportORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0;exportORACLE_HOME
ORACLE_SID=racdb2;exportORACLE_SID
ORACLE_UNQNAME=racdb;exportORACLE_UNQNAME
ORACLE_TERM=xterm;exportORACLE_TERM
PATH=/usr/sbin:
$PATH;exportPATH
PATH=$ORACLE_HOME/bin:
$PATH;exportPATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:
/lib:
/usr/lib;exportLD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:
$ORACLE_HOME/jlib:
$ORACLE_HOME/rdbms/jlib;exportCLASSPATH
NLS_DATE_FORMAT="yyyy-mm-ddHH24:
MI:
SS";exportNLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;exportNLS_LANG
if[$USER="oracle"]||[$USER="grid"];then
if[$SHELL="/bin/ksh"];then
ulimit-p16384
ulimit-n65536
else
ulimit-u16384-n65536
fi
umask022
fi
3.7建立信任关系
Grid用户：
#su-grid
oradb1主机上：
$ssh-keygen-trsa
$ssh-keygen-tdsa
oradb2主机上：
$ssh-keygen-trsa
$ssh-keygen-tdsa
$cat~/.ssh/id_rsa.pub>>./.ssh/authorized_keys
$cat~/.ssh/id_dsa.pub>>./.ssh/authorized_keys
$sshoradb2cat~/.ssh/id_rsa.pub>>~/.ssh/authorized_keys
$sshoradb2cat~/.ssh/id_dsa.pub>>~/.ssh/authorized_keys
$scp~/.ssh/authorized_keysoradb2:
~/.ssh/authorized_keys
Oracle用户：
#su-oracle
oradb1主机上：
$ssh-keygen-trsa
$ssh-keygen-tdsa
oradb2主机上：
$ssh-keygen-trsa
$ssh-keygen-tdsa
升级会员 