?本文详细介绍了如何在Oracle/RedHatEnterpriseLinux5.4(x86,x86_64)上安装Oracl
e11gR2?参考文档?OracleDatabaseQuickInstallationGuide11gRelease
2(11.2)forLinuxx86E10857-01August2009OracleGridInfrastru
ctureInstallationGuide11gRelease2(11.2)forLinuxE10812-03
August2009??--适用范围本文档主要以Linux+Oracle11gR2RAC安装为主,详细说明了安装和配
置步骤?Oracle11gR2RAC＋存储使用ASM(包括RACOne)Oracle11gR2单机＋存储使用AS
M?RACOne与RAC的主要区别是使用dbca创建数据库时选择RACONE?#######################
###############################################一.准备SCAN解析方式（仅适
用于RAC）###########################################################
###########?--本步仅适用于RAC,在RAC环境中可以使用DNSServer解析SCAN,也可以使用hos
ts文件解析Oracle推荐使用DNSServer.?Oraclestronglyrecommendsthatyou
donotconfigureSCANVIPaddressesinthehostsfile.UseDNSre
solutionforSCANVIPs.IfyouusethehostsfiletoresolveSCANs
,thenyouwillonlybeabletoresolvetooneIPaddressandyou
willhaveonlyoneSCANaddress.??With11gR2the/etc/hosthackt
obypassusingDNStoresolvetheSCANIPnolongerworks.Youmus
thaveSCANIPsetupinyourDNStoinstallGRIDsuccessfully.??1
)方式一:配置DNSServer?(必须采用一台单独的WindowsServer做DNSserver)在DNS
中加入一个hostname对应3个不同的IP?[root@oelnode111gr2]#nslookupscan.ol
ive.comServer:172.17.78.10Address:172.17.78.10#5
3?Name:scan.olive.comAddress:172.17.78.122Name:scan.olive.
comAddress:172.17.78.123Name:scan.olive.comAddress:172.17.78
.121?2)方式二:配置/etc/hosts?--如果不使用DNSServer,则可以在/etc/hosts中
加入下一行172.17.78.151rhscan?#############################
#########################################二.准备环境#################
#####################################################?1.安装OS?大部
分采用默认安装--(RedHatEnterpriseLinux5.4x8632bit)--(RedHatEnt
erpriseLinux5.4x86_6464bit)?1)DesktopEnvirionments:只选择GNO
ME2)Applications:全部不选3)Development:全部不选4)Servers:只选一个FTP
SERVER5)BaseSystem:使用默认,一共有6个:AdministrationTool,Base,J
ava,DialupNetworkingsupport,Legacysoftwaresupport,XWind
owssystem6)Language:使用默认，全不选?2.关闭防火墙?[root@rhnode2sysconfig]
#iptables-LChainINPUT(policyACCEPT)targetprotoptsource
destination?ChainFORWARD(policyACCEPT)targetprot
optsourcedestination?ChainOUTPUT(policyACCEPT)
targetprotoptsourcedestination?3.关闭SELinux?vi
/etc/selinux/config确保以下内容SELINUX=disabled?[root@rh5node4~]#se
statusSELinuxstatus:disabled[root@rh5node4~]#
??4.OS没有安装OracleValidatedRPM包OS没有运行InstallationFixupSc
ripts?5.准备ORACLE11gR2介质?--11.2.0.1介质(3个包)x86[root@oel54s
oftwares]#md5sum.zip81e6288078b2b54068959b8df4ae789dlinux_11
gR2_database_1of2.zipaa4caca507ca0493444be84d0b11c647linux_11gR
2_database_2of2.zip38ff5f87dee3fa40d89ab16918c074c1linux_11gR2_
grid.zip?--11.2.0.1介质(3个包)x86_64?b86b3f97a55745302036ff2c8bb4d
f9dlinux.x64_11gR2_database_1of2.zipf070b470de2dbdf44d4e7f28a2d
67e93linux.x64_11gR2_database_2of2.zipeae96ea4dd53cc0c663e86602
e843eb2linux.x64_11gR2_grid.zip?--11.2.0.3介质(3个包)x86_64?[roo
t@rhnode1softwares]#md5sum.zipbdbf8e263663214dc60b0fdef5a30b0
ap10404530_112030_Linux-x86-64_1of7.zipe56b3d9c6bc54b7717e14b6c
549cef9ep10404530_112030_Linux-x86-64_2of7.zip695cbad744752239c
76487e324f7b1abp10404530_112030_Linux-x86-64_3of7.zip??6.准备附加软
件包(OS包和ASMLib包可选)?--RedHat5.4x86?E:\Home\02_Softwares\02_Ora
cle>md5sumpackage_on_redhat54_x86_for_ora11gr2.tar.gz42957cf5b03
6c2d794b3bb215e2e5f95package_on_redhat54_x86_for_ora11gr2.tar.g
z?--RedHat5.4x86_64?E:\Home\02_Softwares\02_Oracle>md5sumpack
age_on_redhat54_x64_for_ora11gr2.tar.gzd4ce51f69bfb5845affbb48b16
2ede2bpackage_on_redhat54_x64_for_ora11gr2.tar.gz?7.检查2个节点的时间
(仅适用于RAC)?不需要配置NTPServer?######################################
################################三.检查硬件要求########################
##############################################?1)内存最小需要：1.5G?2)
系统交换区SWAP最小需要：1.5GB或2倍内存容量的空间，如果内存大于等于2GB那么SWAP在1倍或2倍内存容量之间。?Av
ailableRAMSwapSpaceRequiredBetween1GBa
nd2GB1.5timesthesizeofRAMBetween2GBand16GBEqua
ltothesizeofRAMMorethan16GB16GB?[root@
rhnode1softwares]#free-mtotalusedfreesharedb
ufferscachedMem:2007192581
031767-/+buffers/cache:1541852
Swap:403104031??3)/tmp最小需要：1GB?[root@
rhnode1softwares]#df-k/tmpFilesystem1K-blocks
UsedAvailableUse%Mountedon/dev/mapper/VolGroup-lv_root26391
62456645521938645223%/??4)磁盘空间最小需要：4.5GB?5)系统结构必须是：32位or
64位??可以用以下命令检测系统是否符合安装要求：?#grepMemTotal/proc/meminfo#grep
SwapTotal/proc/meminfo#df-k/tmp#free#uname-m?--RedHat5.4
x86?[root@rhnode1~]#grepSwapTotal/proc/meminfoSwapTotal:
5701624kB?[root@rhnode1~]#grepMemTotal/proc/meminfoMemTotal
:3652264kB?[root@rhnode1~]#df-k/tmpFilesystem
1K-blocksUsedAvailableUse%Mountedon/dev/mapper/VolGro
up00-LogVol00146645285128336877925237%/?[root@rhnode1~]#
freetotalusedfreesharedbufferscachedMem:
3652264353736011490402096424123
44-/+buffers/cache:11040522548212Swap:5701624
712325630392??--RedHat5.4x86_64?#########################
#############################################四.检查软件要求###########
###########################################################?1.查
看系统信息?--RedHat5.4x86?[root@rhnode1network-scripts]#cat/etc/
redhat-releaseRedHatEnterpriseLinuxServerrelease5.4(Tikang
a)?[root@rhnode1network-scripts]#uname-rm2.6.18-164.el5i686?-
-RedHat5.4x86_64?[root@rh5node1softwares]#cat/etc/redhat-re
leaseRedHatEnterpriseLinuxServerrelease5.4(Tikanga)?[root@
rh5node1softwares]#uname-rm2.6.18-164.el5x86_64?--RedHat6.1
x86_64?[root@rhnode1~]#cat/etc/redhat-releaseRedHatEnterpri
seLinuxServerrelease6.1(Santiago)[root@rhnode1~]#uname-rm
2.6.32-131.0.15.el6.x86_64x86_64?--RedHat6.3x86_64?[root@rhno
de1softwares]#cat/etc/redhat-releaseRedHatEnterpriseLinux
Serverrelease6.3(Santiago)[root@rhnode1softwares]#uname-rm2
.6.32-279.el6.x86_64x86_64???2.检查内核要求?Linuxx86(32-bit)Opera
tingSystemKernelRequirements--Linuxx86_64的内核要求也相同?AsianuxD
istributions■Asianux2,kernel2.6.9orlater■AsianuxServer3
,kernel2.6.18orlater?EnterpriseLinuxDistributions■Enterpri
seLinux4Update7,kernel2.6.9orlater■EnterpriseLinux5Up
date2,kernel2.6.18orlater?RedHatEnterpriseLinuxDistribu
tions■RedHatEnterpriseLinux4Update7,kernel2.6.9orlater
■RedHatEnterpriseLinux5Update2,kernel2.6.18orlater?SUS
EEnterpriseLinuxDistributions■SUSE10,kernel2.6.16.21orla
ter■SUSE11,kernel2.6.27.19orlater??3.检查需要的软件包(x86平台)?Asian
uxServer3,EnterpriseLinux5,andRedHatEnterpriseLinux5Th
efollowingpackages(orlaterversions)mustbeinstalled:?binut
ils-2.17.50.0.6compat-libstdc++-33-3.2.3elfutils-libelf-0.125elfu
tils-libelf-devel-0.125elfutils-libelf-devel-static-0.125gcc-4.1.
2gcc-c++-4.1.2glibc-2.5-24glibc-common-2.5glibc-devel-2.5glibc-he
aders-2.5kernel-headers-2.6.18ksh-20060214libaio-0.3.106libaio-de
vel-0.3.106libgcc-4.1.2libgomp-4.1.2libstdc++-4.1.2libstdc++-deve
l-4.1.2make-3.81sysstat-7.0.2unixODBC-2.2.11unixODBC-devel-2.2.11
??4.检查需要的软件包(x86_64平台)?AsianuxServer3,EnterpriseLinux5,and
RedHatEnterpriseLinux5Thefollowingpackages(orlaterversi
ons)mustbeinstalled:binutils-2.17.50.0.6compat-libstdc++-33-3.
2.3compat-libstdc++-33-3.2.3(32bit)elfutils-libelf-0.125elfutil
s-libelf-devel-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-2.5-2
4(32bit)glibc-common-2.5glibc-devel-2.5glibc-devel-2.5(32bit)
glibc-headers-2.5ksh-20060214libaio-0.3.106libaio-0.3.106(32bit
)libaio-devel-0.3.106libaio-devel-0.3.106(32bit)libgcc-4.1.2lib
gcc-4.1.2(32bit)libstdc++-4.1.2libstdc++-4.1.2(32bit)libstdc+
+-devel4.1.2make-3.81sysstat-7.0.2unixODBC-2.2.11unixODBC-2.2.11
(32bit)unixODBC-devel-2.2.11unixODBC-devel-2.2.11(32bit)?关于附加
软件包的安装可以参考:?注意：11.2.0.1的脚本中compat-libstdc++的检查有问题经检查compat-lib
stdc++已经安装,如下[root@pscljj01Server]#rpm-qa|grepcompat-libst
dc++compat-libstdc++-296-2.96-138compat-libstdc++-33-3.2.3-61comp
at-libstdc++-33-3.2.3-61??#######################################
###############################五.配置OS系统#########################
#############################################?1.关闭系统的NTP(仅用于R
AC)?#/sbin/servicentpdstop#chkconfigntpdoff?#下面这个文件必须要改名移除
-2012/08/01?#mv/etc/ntp.conf/etc/ntp.conf.bak??[root@rhnode1
network-scripts]#chkconfig--list|grepntpntpd0:off1:off
2:off3:off4:off5:off6:off??Toconfirmthatctssdis
activeafterinstallation,enterthefollowingcommandastheGri
dinstallationowner:$crsctlcheckctss?2.调整system参数?--可以使用界面
上的自动生成fix的脚本?modify/etc/sysctl.conf文件Byspecifyingthevaluesi
nthe/etc/sysctl.conffile,theypersistwhenyourestartthesy
stem.?--推荐设置?fs.aio-max-nr=1048576fs.file-max=6815744kernel.
shmall=2097152kernel.shmmax=536870912kernel.shmmni=4096kern
el.sem=25032000100128net.ipv4.ip_local_port_range=9000655
00net.core.rmem_default=262144net.core.rmem_max=4194304net.co
re.wmem_default=262144net.core.wmem_max=1048586??--RHEL5.4X
64?实际修改下面8个参数?fs.aio-max-nr=1048576fs.file-max=6815744net
.core.rmem_default=262144net.core.rmem_max=4194304net.core.wm
em_default=262144net.core.wmem_max=1048576net.ipv4.ip_local_p
ort_range=900065500kernel.sem=25032000100128?以下3个参数可以
用默认值kernel.shmall=2097152kernel.shmmax=2147483648kernel.shmmn
i=4096?--RHEL6.1X64?实际修改下面9个参数?fs.aio-max-nr=1048576fs.
file-max=6815744net.core.rmem_default=262144net.core.rmem_max
=4194304net.core.wmem_default=262144net.core.wmem_max=10485
76net.ipv4.ip_local_port_range=900065500kernel.sem=25032000
100128kernel.shmmni=8192?以下2个参数可以用默认值kernel.shmall=2097
152kernel.shmmax=2147483648??--RHEL6.3X64?实际修改下面9个参数?fs.a
io-max-nr=1048576fs.file-max=6815744net.core.rmem_default=2
62144net.core.rmem_max=4194304net.core.wmem_default=262144net
.core.wmem_max=1048576net.ipv4.ip_local_port_range=900065500
kernel.sem=25032000100128kernel.shmmni=8192?以下2个参数可以用默
认值kernel.shmall=2097152kernel.shmmax=2147483648???--reboot使
配置生效#sysctl-p?3.SetShellLimits?Toimprovetheperformanceo
fthesoftware,youmustincreasethefollowingshelllimitsfor
theoracleuser:Toincreasetheshelllimits:?a.nofile:Maximum
numberofopenfiledescriptorsb.nproc:Maximumnumberofproce
ssesavailabletoasingleuser?1).Addthefollowinglinesint
he/etc/security/limits.conffile:?#vi/etc/security/limits.conf
#ORACLESETTINGgridsoftnproc2047gridhardnproc1638
4gridsoftnofile1024gridhardnofile65536oraclesoft
nproc2047oraclehardnproc16384oraclesoftnofile
1024oraclehardnofile65536?2).Addthefollowinglinetoth
e/etc/pam.d/loginfile,ifitdoesnotalreadyexist:#vi/etc/p
am.d/login#ORACLESETTINGsessionrequiredpam_limits.so??4.
配置网卡(仅用于RAC)?至少需要2块网卡，一块为public,一块作为private.--建议将设备名和IP绑定?--
RedHat5.4x86?[root@rhnode1network-scripts]#catifcfg-eth0#A
dvancedMicroDevices[AMD]79c970[PCnet32LANCE]DEVICE=eth0BOOT
PROTO=staticBROADCAST=172.17.255.255HWADDR=00:0C:29:E5:84:6CIPADD
R=172.17.78.131NETMASK=255.255.0.0NETWORK=172.17.0.0ONBOOT=yes?[r
oot@rhnode1network-scripts]#catifcfg-eth1#AdvancedMicroDev
ices[AMD]79c970[PCnet32LANCE]DEVICE=eth1BOOTPROTO=staticBROAD
CAST=10.0.0.255HWADDR=00:0C:29:E5:84:76IPADDR=10.0.0.1NETMASK=255
.255.255.0NETWORK=10.0.0.0ONBOOT=yes[root@rhnode1network-scripts
]#?--RedHat5.4x86_64?[root@rh5node2network-scripts]#catifcf
g-eth0#IntelCorporation82575EBGigabitBackplaneConnectionDEV
ICE=eth0BOOTPROTO=staticBROADCAST=172.17.255.255HWADDR=00:23:8B:B
D:C2:E4IPADDR=172.17.5.32NETMASK=255.255.0.0NETWORK=172.17.0.0ONB
OOT=yes?[root@rh5node2network-scripts]#catifcfg-eth2#IntelCo
rporation82575EBGigabitBackplaneConnectionDEVICE=eth2BOOTPROT
O=staticBROADCAST=10.0.0.255HWADDR=00:23:8B:BD:C2:E6IPADDR=10.0.0
.2NETMASK=255.255.255.0NETWORK=10.0.0.0ONBOOT=yes?--RedHat6.1x
86_64??[root@rhnode1network-scripts]#moreifcfg-eth1DEVICE="eth
1"HWADDR="00:50:56:93:42:25"#NM_CONTROLLED="yes"ONBOOT=yesIPADDR=
172.17.13.81NETMASK=255.255.0.0NETWORK=172.17.0.0TYPE=EthernetBOO
TPROTO=staticBROADCAST=172.17.255.255?[root@rhnode1network-scrip
ts]#moreifcfg-eth2DEVICE="eth2"HWADDR="00:50:56:93:42:23"#NM_CO
NTROLLED="yes"ONBOOT=yesIPADDR=10.10.13.1NETMASK=255.255.255.0NET
WORK=10.10.13.0TYPE=EthernetBOOTPROTO=staticBROADCAST=10.10.13.25
5???5.配置主机名?--RAC环境的例子?在/etc/hosts中加入主机名?[root@rhnode1netwo
rk-scripts]#cat/etc/hosts#Donotremovethefollowingline,or
variousprograms#thatrequirenetworkfunctionalitywillfail.1
27.0.0.1localhost.localdomainlocalhost172.17.78.131rh
node1172.17.78.132rhnode2172.17.78.141rhnod
e1-vip172.17.78.142rhnode2-vip10.0.0.1
rhnode1-priv10.0.0.2rhnode2-priv172.17.78.151
rhscan?--本例使用/etc/hosts解析SCAN?--单节点的例子?[root@pscljj01
Server]#cat/etc/hosts#Donotremovethefollowingline,orva
riousprograms#thatrequirenetworkfunctionalitywillfail.127.
0.0.1localhost.localdomainlocalhost172.17.13.201psclj
j01?6.配置DNS客户端(仅用于RAC，且可选)?如果使用了DNSServer解析SCAN,则必须配置DN
S客户端?1)修改/etc/nsswitch.conf中的下一行#vi/etc/nss.confhosts:
filesdns?2)在/etc/resolv.conf中加入下2行?#cat/etc/resolv.c
onfsearcholive.comnameserver172.17.78.10?3)测试#nslookupsolsca
nServer:172.17.78.10Address:172.17.78.10#53?Name
:solscan.olive.comAddress:172.17.78.133Name:solscan.olive.
comAddress:172.17.78.131Name:solscan.olive.comAddress:172.17
.78.132??########################################################
##############六.安装前准备###########################################
###########################?1.创建安装必须的组和用户（单机环境）?for单机且只使用文件系统不需
要ASM?/usr/sbin/groupadd-g501oinstall/usr/sbin/groupadd-g502
dba/usr/sbin/groupadd-g503oper?/usr/sbin/useradd-u501-goin
stall-Gdba,oper-s/bin/bash-m-d/home/oracleoracle?1.创建安装必
须的组和用户（RAC环境或单机+ASM的环境）?forRAC环境或单机+ASM的环境?/usr/sbin/gro
upadd-g501oinstall/usr/sbin/groupadd-g502dba/usr/sbin/group
add-g503oper/usr/sbin/groupadd-g504asmadmin/usr/sbin/groupa
dd-g505asmoper/usr/sbin/groupadd-g506asmdba/usr/sbin/userad
d-u501-goinstall-Gdba,asmdba,oper-s/bin/bash-m-d/home/
oracleoracle/usr/sbin/useradd-u502-goinstall-Gasmadmin,asm
dba,asmoper,oper,dba-s/bin/bash-m-d/home/gridgrid?#passwd
grid#passwdoracle?[root@rhnode1network-scripts]#passwdgridCh
angingpasswordforusergrid.Newpassword:gridBADPASSWORD:it
istooshortBADPASSWORD:istoosimpleRetypenewpassword:gridp
asswd:allauthenticationtokensupdatedsuccessfully.[root@rhnod
e1network-scripts]#passwdoracleChangingpasswordforuserorac
le.Newpassword:oracleBADPASSWORD:itisbasedonadictionary
wordBADPASSWORD:istoosimpleRetypenewpassword:oraclepasswd:
allauthenticationtokensupdatedsuccessfully.?[root@rhnode1ne
twork-scripts]#id-aoracleuid=501(oracle)gid=501(oinstall)gro
ups=501(oinstall),502(dba),503(oper),506(asmdba)[root@rhnode1net
work-scripts]#id-agriduid=502(grid)gid=501(oinstall)groups=5
01(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(as
mdba)[root@rhnode1network-scripts]#??2.创建安装目录?1)forRAC环境或
单机+ASM的例子?-分别为oracle和grid建2个ORACLE_BASE目录-所有Oracle软件共享
一个OracleInventory目录?mkdir/oraclemkdir/gridmkdir/opt/ora
Inventory?chown-Roracle:oinstall/oraclechown-Rgrid:oinstall
/gridchown-Rgrid:oinstall/opt/oraInventory?chmod-R775/o
raclechmod-R775/gridchmod-R775/opt/oraInventory?2)for单机?m
kdir/oraclemkdir/opt/oraInventory?chownoracle:oinstall/oracle
chownoracle:oinstall/opt/oraInventory?chmod-R755/oraclechmod
-R775/opt/oraInventory?3.设置用户环境变量(仅适用于RAC环境或单机+ASM)?编辑~/.
bash_profile?1)grid用户?注意grid用户的ORACLE_HOME与ORACLE_BASE目录不同?TMP=
/tmp;exportTMPTMPDIR=$TMP;exportTMPDIR?ORACLE_HOSTNAME=rhnode
1;exportORACLE_HOSTNAMEORACLE_SID=+ASM1;exportORACLE_SIDORACL
E_BASE=/grid/base;exportORACLE_BASE#ORACLE_BASE=/grid;exportO
RACLE_BASE--onlyforstandaloneORACLE_HOME=/grid/11gr2;expor
tORACLE_HOME?PATH=$ORACLE_HOME/bin:$PATH;exportPATH?#以下可以不用设置i
f[$USER="oracle"]||[$USER="grid"];thenif[$SHELL=
"/bin/ksh"];thenulimit-p16384ulimit-n65536elseulimit-u
16384-n65536fiumask022fi?2)oracle用户??TMP=/tmp;exportTMP
TMPDIR=$TMP;exportTMPDIR?ORACLE_HOSTNAME=rhnode1;exportORACLE
_HOSTNAMEORACLE_BASE=/oracle;exportORACLE_BASEORACLE_HOME=$ORAC
LE_BASE/product/11.2.0/db_1;exportORACLE_HOMEORACLE_SID=olive1;
exportORACLE_SIDORACLE_TERM=xterm;exportORACLE_TERMORACLE_UNQ
NAME=olive;exportORACLE_UNQNAME?PATH=/usr/sbin:$PATH;exportPA
THPATH=$ORACLE_HOME/bin:$PATH;exportPATH?LD_LIBRARY_PATH=$ORACL
E_HOME/lib:/lib:/usr/lib;exportLD_LIBRARY_PATHCLASSPATH=$ORACLE
_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;exportCLASS
PATH?#以下可以不用设置if[$USER="oracle"]||[$USER="grid"];then
if[$SHELL="/bin/ksh"];thenulimit-p16384ulimit-n65536
elseulimit-u16384-n65536fiumask022fi?3.设置用户环境变量(仅适用于单机环
境)?设置oracle用户环境变量?编辑~/.bash_profile?TEMP=/tmpTMPDIR=/tmp?ORACLE
_SID=testORACLE_BASE=/oracleORACLE_HOME=/oracle/product/11.2.0/d
b_1PATH=$ORACLE_HOME/bin:$PATH?exportLD_LIBRARY_PATH=$ORACLE_HOM
E/lib:$ORACLE_HOME/rdbms/lib:/lib64:/usr/lib64:/usr/local/lib64:/
usr/X11R6/lib64/:$LD_LIBRARY_PATHexportCLASSPATH=$ORACLE_HOME/JR
E:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexportLD_ASSUME_KERNE
L=2.6.18?exportTEMPexportTMPDIRexportORACLE_SIDexportORACLE_B
ASEexportORACLE_HOMEexportPATH??--下面几个可以不加?LC_CTYPE=zh_CN.UTF8
LC_ALL=zh_CN.UTF8LANG=zh_CN.UTF8?4.配置ssh互信任关系(仅适用于RAC环境)??2个用
户grid和oracle都要配置参考<<01_配置ssh互信任关系>>?5.给root设置环境变量(仅适用于RA
C环境或使用了ASM)??在/root/.bash_profile中添加?ORACLE_HOME=/grid/11gr2;e
xportORACLE_HOMEPATH=$ORACLE_HOME/bin:$PATH;exportPATH??######
################################################################七
.准备ASM磁盘(仅适用于RAC环境或使用了ASM)#####################################
#################################?1.安装cvuqdisk包(仅用于RAC)?2个节点都
需要安装??Installtheoperatingsystempackagecvuqdisk.Withoutcvuq
disk,ClusterVerificationUtilitycannotdiscovershareddisks,a
ndyoureceivetheerrormessage"Packagecvuqdisknotinstalled"
whenyourunClusterVerificationUtility.?Ifyouprefer,youcan
choosetodisableClusterVerificationUtilityshareddiskchecks
byaddingthefollowinglinetothefilegrid_home/cv/admin/cvuco
nfig:CV_RAW_CHECK_ENABLED=FALSE??SettheenvironmentvariableCVU
QDISK_GRPtopointtothegroupthatwillowncvuqdisk,typically
oinstall.Forexample:#CVUQDISK_GRP=oinstall;exportCVUQDISK_GR
P??文件在grid安装包内,以root用户进行安装?/softwares/grid/rpm?[root@oelnode1r
pm]#ls-lttotal8-rw-rw-r--1oracleoinstall7831Jun314:13
cvuqdisk-1.0.7-1.rpm[root@oelnode1rpm]#pwd/softwares/grid/rpm[r
oot@oelnode1rpm]#rpm-ivhcvuqdisk-1.0.7-1.rpmPreparing...
###########################################[100%]Usi
ngdefaultgroupoinstalltoinstallpackage1:cvuqdisk#########
##################################[100%][root@oelnode1rpm]#idu
id=0(root)gid=0(root)groups=0(root),1(bin),2(daemon),3(sys),4(a
dm),6(disk),10(wheel)[root@oelnode1rpm]#?2.对磁盘进行分区?整个磁盘划分一个大的分
区?[root@oelnode1~]#fdisk/dev/sdb(磁盘分区)?[root@rhnode1rpm]#f
disk/dev/sdbDevicecontainsneitheravalidDOSpartitiontable,
norSun,SGIorOSFdisklabelBuildinganewDOSdisklabel.Chang
eswillremaininmemoryonly,untilyoudecidetowritethem.Aft
erthat,ofcourse,thepreviouscontentwon''tberecoverable.?War
ning:invalidflag0x0000ofpartitiontable4willbecorrected
byw(rite)?Command(mforhelp):nCommandactioneextendedppri
marypartition(1-4)pPartitionnumber(1-4):1Firstcylinder(1-2
61,default1):Usingdefaultvalue1Lastcylinderor+sizeor+s
izeMor+sizeK(1-261,default261):Usingdefaultvalue261?Comm
and(mforhelp):wThepartitiontablehasbeenaltered!?Calling
ioctl()tore-readpartitiontable.Syncingdisks.[root@rhnode1rp
m]#???[root@rhnode1~]#fdisk-l/dev/sdb?Disk/dev/sdb:17.2GB
,17179869184bytes64heads,32sectors/track,16384cylindersUni
ts=cylindersof2048512=1048576bytesSectorsize(logical/
physical):512bytes/512bytesI/Osize(minimum/optimal):512b
ytes/512bytesDiskidentifier:0xc9cd39b5?DeviceBootSta
rtEndBlocksIdSystem/dev/sdb11
163841677720083Linux??在另一个节点上执行下命令或重启[root@rhnode2~]#p
artprobeWarning:WARNING:thekernelfailedtore-readthepartit
iontableon/dev/sda(Deviceorresourcebusy).Asaresult,it
maynotreflectallofyourchangesuntilafterreboot.????3.使用
ASMLib方式配置ASM磁盘(可选）?1）安装ASMLib软件包以root用户进行安装?注意：Oracle的
ASMLib已经没有看到支持Redhat??EnterpriseLinux6系列的ASMLlib包了，Oracle
不会为RedhatLinux6系统提供此包。??ASMLib包的下载URL(注意oracleasm包每个平台的文件
都不一样)http://www.oracle.com/technology/software/tech/linux/asmlib/
index.htmlhttp://www.oracle.com/technology/software/tech/linux/as
mlib/index.html?--RedHat5.4x86[root@redhat01source]#rpm-ivh
oracleasm-support-2.1.3-1.el5.i386.rpm[root@redhat01source]#rpm
-ivhoracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm[root@redhat01
source]#rpm-ivhoracleasmlib-2.0.4-1.el5.i386.rpm?--RedHat5.4
x86_64?[root@rh5node1package_on_redhat54_x64_for_ora11gr2]#rpm
-ivhoracleasm-support-2.1.3-1.el5.x86_64.rpmwarning:oracleasm-
support-2.1.3-1.el5.x86_64.rpm:HeaderV3DSAsignature:NOKEY,k
eyID1e5e0159Preparing...#######################
####################[100%]1:oracleasm-support############
###############################[100%][root@rh5node1package_on_r
edhat54_x64_for_ora11gr2]#rpm-ivhoracleasm-2.6.18-164.el5-2.0.
5-1.el5.x86_64.rpmwarning:oracleasm-2.6.18-164.el5-2.0.5-1.el5.x
86_64.rpm:HeaderV3DSAsignature:NOKEY,keyID1e5e0159Prepari
ng...###########################################
[100%]1:oracleasm-2.6.18-164.el#################################
##########[100%][root@rh5node1package_on_redhat54_x64_for_ora11
gr2]#rpm-ivhoracleasmlib-2.0.4-1.el5.x86_64.rpmwarning:oracle
asmlib-2.0.4-1.el5.x86_64.rpm:HeaderV3DSAsignature:NOKEY,ke
yID1e5e0159Preparing...########################
###################[100%]1:oracleasmlib#######################
####################[100%][root@rh5node1package_on_redhat54_x64
_for_ora11gr2]#???2）配置asm磁盘?以下都以root用户执行?[root@oelnode1~]#
/etc/init.d/oracleasmconfigure-i?或?[root@oelnode1~]#/etc/ini
t.d/oracleasmconfigureConfiguringtheOracleASMlibrarydriver.
?Thiswillconfiguretheon-bootpropertiesoftheOracleASMlib
rarydriver.Thefollowingquestionswilldeterminewhetherthed
riverisloadedonbootandwhatpermissionsitwillhave.Thecu
rrentvalueswillbeshowninbrackets(''[]'').Hittingwi
thouttypingananswerwillkeepthatcurrentvalue.Ctrl-Cwill
abort.?Defaultusertoownthedriverinterface[]:gridDefaultg
rouptoownthedriverinterface[]:asmadminStartOracleASMlib
rarydriveronboot(y/n)[n]:yScanforOracleASMdisksonboot
(y/n)[y]:yWritingOracleASMlibrarydriverconfiguration:don
eInitializingtheOracleASMLibdriver:[OK]Scanningthesyste
mforOracleASMLibdisks:[OK]?[root@oelnode1~]#/usr/sbin/o
racleasminit??[root@rhnode1asmlib]#/etc/init.d/oracleasmcreat
ediskDISK1/dev/sdb1Markingdisk"DISK1"asanASMdisk:[OK]
[root@rhnode1asmlib]#/etc/init.d/oracleasmcreatediskDISK2/de
v/sdc1Markingdisk"DISK2"asanASMdisk:[OK][root@rhnode1a
smlib]#/etc/init.d/oracleasmcreatediskDISK3/dev/sdd1Markingd
isk"DISK3"asanASMdisk:[OK]?[root@rhnode1asmlib]#oracle
asmlistdisksDISK1DISK2DISK3?在另外一个节点上执行scandisk:?/usr/sbin/oracle
asmscandisks??4.使用手工方式配置ASM磁盘(与上一步选一种）??如果不使用ASMLIB,需要修改磁盘权限
：chmod775/dev/sdb1chowngrid:oinstall/dev/sdb1?如果使用ASMLIB，则不需
要设置权限??ConfiguringDiskDevicesManuallyforOracleASM,可参考下连接
tmhttp://docs.oracle.com/cd/E11882_01/install.112/e22489/storage.
htm>或onenote:ConfiguringDiskDevicesManuallyforOracleASM??r
hel6.1x64+11.2.0.3的例子：?1)查看设备的scsi-id?[root@rhnode1Packages]#/s
bin/scsi_id-g-u/dev/sdb136000c290c5663a6cc3c82762c1ff0282?2)修改
/etc/udev/rules.d/99-oracle-asmdevices.rules文件KERNEL=="sd?1",B
US=="scsi",PROGRAM=="/sbin/scsi_id-g-u/dev/$name",RESULT=="36
000c290c5663a6cc3c82762c1ff0282",NAME="asm-disk1",OWNER="grid",
GROUP="asmadmin",MODE="0660"?3)重启UDEV[root@rac1dev]#start_udevS
tartingudev:?[?OK?]?4)检查共享设备的所属关系和权限?[root@rhnode1dev]#ls-l
/dev/asmbrw-rw----1gridasmadmin8,17Jul2519:11/dev/asm
-disk1?5)重启OS?6)再检查共享设备的所属关系和权限[root@rhnode1~]#ls-l/dev/asm
brw-rw----1gridasmadmin8,17Jul2519:18/dev/asm-disk1???rh
el6.3x64+11.2.0.3的例子：?1)查看设备的scsi-id?[root@rhnode1~]#/sbin/scsi
_id-g-u/dev/sdb36000c2914f61a51281a9557a9d24e4ad[root@rhnode1
~]#/sbin/scsi_id-g-u/dev/sdc36000c29302f06160de7a0faa956af0aa
[root@rhnode1~]#/sbin/scsi_id-g-u/dev/sdd36000c2902e57c0d3da
ac148e9b6e5274??2)修改/etc/udev/rules.d/99-oracle-asmdevices.rules
文件?KERNEL=="sd?",BUS=="scsi",PROGRAM=="/sbin/scsi_id-g-u/de
v/$name",RESULT=="36000c2914f61a51281a9557a9d24e4ad",NAME="asm-di
sk1",OWNER="grid",GROUP="asmadmin",MODE="0660"KERNEL=="sd?",BUS
=="scsi",PROGRAM=="/sbin/scsi_id-g-u/dev/$name",RESULT=="3600
0c29302f06160de7a0faa956af0aa",NAME="asm-disk2",OWNER="grid",GR
OUP="asmadmin",MODE="0660"KERNEL=="sd?",BUS=="scsi",PROGRAM=="/s
bin/scsi_id-g-u/dev/$name",RESULT=="36000c2902e57c0d3daac148e9
b6e5274",NAME="asm-disk3",OWNER="grid",GROUP="asmadmin",MODE="0
660"???##########################################################
############八.安装前检查系统环境(CVU)(仅适用于RAC环境或使用了ASM)##################
####################################################?以grid用户执行[
oracle@rh5node1cluvfy]$./runcluvfy.shstage-precrsinst-nrhn
ode1,rhnode2-verbose[oracle@rh5node1cluvfy]$./runcluvfy.shcom
psys-nrhnode1,rhnode2-pcrs-verbose[oracle@rh5node1cluvfy]$
./runcluvfy.shcompssa-nrhnode1,rhnode2-verbose[oracle@rh5no
de1cluvfy]$./runcluvfy.shcompnodecon-nrhnode1,rhnode2-verb
ose?具体请参考03_使用cluvfy检查环境1/2/3/4?注意：检查过程中,报pdksh-5.2.14包未安装，不用管
此警告?onenote:[ID1454982.1]Installing11.2.0.364-bit(x86-64)on
RHEL6ReportsThatPackages"elfutils-libelf-devel-0.97"and"pdk
sh-5.2.14"aremissing(PRVF-7532)?对于grid，可以更改下文件1.Changedirect
oryto/grid/stage/cvu/cv/admin2.Backupcvu_config%cpcvu
_configbackup_cvu_config3.Editcvu_configandchangethefollow
ingline:CV_ASSUME_DISTID=OEL4to:CV_ASSUME_DISTID=OEL6??#########
#############################################################八.安
装和配置Grid(仅适用于RAC环境或使用了ASM)######################################
################################?1.以grid用户login?2.以grid用户解压
软件包?[grid@rhnode1softwares]$unziplinux_11gR2_grid.zip?3.runcl
uvfy?[grid@rh5node1grid]$./runcluvfy.shcompsys-nrh5node1,rh
5node2-pcrs-r11gR2-verbose?4.开始安装grid?$cdgrid$./runInst
aller?4.安装步骤1)选择InstallandConfigureGridInfrastructurefor
aCluster?如果是单机版本的安装(只使用ASM功能),请选择InstallandConfigureGrid
InfrastructureforaStandaloneServer?2)选择AdvancedInstallatio
n3)ClusterName:rhclusterSCANname:rhscan<-这里填的名字必须与/etc/hos
ts中定义的相同,否则不能解析SCANPort:15214)选择DonotuseIPMI5)OracleBas
e:/grid/basesoftwarelocation:/grid/11gr26)InventoryLocation
:/opt/oraInventory?5.最后运行root.sh?root.sh的log参见附件root.sh.lo
g????--RHEL6.1x64+Oracle11.2.0.3,运行root.sh时报如下错误：?Userignore
dPrerequisitesduringinstallationFailedtocreatekeysintheO
LR,rc=127,Message:/grid/11gr2/bin/clscfg.bin:errorwhilelo
adingsharedlibraries:libcap.so.1:cannotopensharedobjectfi
le:Nosuchfileordirectory?FailedtocreatekeysintheOLRa
t/grid/11gr2/crs/install/crsconfig_lib.pmline7497./grid/11gr2/
perl/bin/perl-I/grid/11gr2/perl/lib-I/grid/11gr2/crs/install/g
rid/11gr2/crs/install/rootcrs.plexecutionfailed[root@rhnode1~]
#?解决办法：?[root@rhnode2~]#find/-name"libcap.so"/lib64/libcap
.so.2.16/lib64/libcap.so.2[root@rhnode2~]#ln-s/lib64/libcap.s
o.2.16/lib64/libcap.so.1[root@rhnode2~]#find/-name"libcap.s
o"/lib64/libcap.so.2.16/lib64/libcap.so.2/lib64/libcap.so.1[root
@rhnode2~]#??在所有的节点上执行完root脚本后,在窗口界面点OK退出?校验集群时出现下面的错误?查看log:?I
NFO:Checkingnameresolutionsetupfor"rhscan"...INFO:ERROR:IN
FO:PRVG-1101:SCANname"rhscan"failedtoresolveINFO:ERROR:I
NFO:PRVF-4657:Nameresolutionsetupcheckfor"rhscan"(IPadd
ress:172.17.13.113)failedINFO:ERROR:INFO:PRVF-4664:Foundin
consistentnameresolutionentriesforSCANname"rhscan"INFO:Ve
rificationofSCANVIPandListenersetupfailed?主要是由于没有配置DNS导致?这
是因为你使用了hosts文件代替了dnsorgnsd所导致的。没关系，现在只要两个节点能够ping通scanvi
p即可?[root@rhnode2~]#cat/etc/hosts127.0.0.1localhostlocalhost
.localdomain172.17.13.101rhnode1172.17.13.102rhnode2172.17
.13.111rhnode1-vip172.17.13.112rhnode2-vip172.17.13.113r
hscan10.10.14.1rhnode1-priv10.10.14.2rhnode1-priv[roo
t@rhnode2~]#pingrhscanPINGrhscan(172.17.13.113)56(84)bytes
ofdata.64bytesfromrhscan(172.17.13.113):icmp_seq=1ttl=64
time=0.217ms64bytesfromrhscan(172.17.13.113):icmp_seq=2ttl
=64time=0.312ms64bytesfromrhscan(172.17.13.113):icmp_seq=3
ttl=64time=0.741ms^C---rhscanpingstatistics---3packetstr
ansmitted,3received,0%packetloss,time2685msrttmin/avg/max
/mdev=0.217/0.423/0.741/0.228ms??6.检查grid状态?[grid@rhnode1~
]$crsctlcheckcluster-all
rhnode1:CRS-4537:ClusterReadyServices
isonlineCRS-4529:ClusterSynchronizationServicesisonlineCRS
-4533:EventManagerisonline
rhnode2:CRS-4537:ClusterReadyServic
esisonlineCRS-4529:ClusterSynchronizationServicesisonlineC
RS-4533:EventManagerisonline
?[grid@rhnode1~]$crsctlcheckcrsC
RS-4638:OracleHighAvailabilityServicesisonlineCRS-4537:Clu
sterReadyServicesisonlineCRS-4529:ClusterSynchronizationSe
rvicesisonlineCRS-4533:EventManagerisonline?[grid@rhnode1~
]$crsctlcheckctssCRS-4701:TheClusterTimeSynchronizationSe
rviceisinActivemode.CRS-4702:Offset(inmsec):0?[grid@rhnod
e1~]$crsctlcheckcssCRS-4529:ClusterSynchronizationServices
isonline?[grid@rhnode1~]$crs_stat-tNameType
TargetStateHost------------------------------------
------------------------ora.DATA.dgora....up.typeONLINEONLI
NErhnode1ora....ER.lsnrora....er.typeONLINEONLINErh
node1ora....N1.lsnrora....er.typeONLINEONLINErhnode2ora
.asmora.asm.typeONLINEONLINErhnode1ora.eonsora
.eons.typeONLINEONLINErhnode1ora.gsdora.gsd.type
OFFLINEOFFLINEora....networkora....rk.typeONLINEONLINE
rhnode1ora.oc4jora.oc4j.typeOFFLINEOFFLINEora.onsor
a.ons.typeONLINEONLINErhnode1ora....ry.acfsora....fs.
typeONLINEONLINErhnode1ora....SM1.asmapplicationONL
INEONLINErhnode1ora....E1.lsnrapplicationONLINEO
NLINErhnode1ora....de1.gsdapplicationOFFLINEOFFLINEor
a....de1.onsapplicationONLINEONLINErhnode1ora....de1
.vipora....t1.typeONLINEONLINErhnode1ora....SM2.asmapp
licationONLINEONLINErhnode2ora....E2.lsnrapplication
ONLINEONLINErhnode2ora....de2.gsdapplicationOFFL
INEOFFLINEora....de2.onsapplicationONLINEONLINErh
node2ora....de2.vipora....t1.typeONLINEONLINErhnode2ora
.scan1.vipora....ip.typeONLINEONLINErhnode2[grid@rhnod
e1~]$??[root@rhnode2~]#crsctlstatres-t--------------------
------------------------------------------------------------NAMET
ARGETSTATESERVERSTATE_DETAILS--------------
-----------------------------------------------------------------
-LocalResources-------------------------------------------------
-------------------------------ora.DB.dgONLINEONLINErhnode1O
NLINEONLINErhnode2ora.GRIDDATA.dgONLINEONLINErhnode1ONLIN
EONLINErhnode2ora.LISTENER.lsnrONLINEONLINErhnode1ONLINE
ONLINErhnode2ora.asmONLINEONLINErhnode1St
artedONLINEONLINErhnode2Startedora.gsdOFFL
INEOFFLINErhnode1OFFLINEOFFLINErhnode2ora.net1.net
workONLINEONLINErhnode1ONLINEONLINErhnode2ora.onsONLINE
ONLINErhnode1ONLINEONLINErhnode2---------------------------
-----------------------------------------------------ClusterReso
urces------------------------------------------------------------
--------------------ora.LISTENER_SCAN1.lsnr1ONLINEONLINErhnod
e1ora.cvu1ONLINEONLINErhnode1ora.oc4j1ONLINEONLINErhnode1
ora.olive.db1ONLINEONLINErhnode1Open2ONLIN
EONLINErhnode2Openora.rhnode1.vip1ONLINEO
NLINErhnode1ora.rhnode2.vip1ONLINEONLINErhnode2ora.scan1.vip
1ONLINEONLINErhnode1[root@rhnode2~]#??7.配置ASM磁盘组?如有必要使用g
rid用户运行asmca配置ASM??查看ASM磁盘组信息?[grid@rhnode1~]$echo$ORACLE_S
ID+ASM1[grid@rhnode1~]$sqlplus/nolog?SQLPlus:Release11.2.0.
3.0ProductiononThuAug210:59:122012?Copyright(c)1982,201
1,Oracle.Allrightsreserved.?SQL>conn/assysasmConnected.?
SQL>showuserUSERis"SYS"?SQL>setlinesize220?SQL>selectgro
up_number,name,state,type,total_mb,free_mb,VOTING_FILESfr
omv$asm_diskgroup;?GROUP_NUMBERNAMES
TATETYPETOTAL_MBFREE_MBV-----------------------
---------------------------------------------------------1
DBMOUNTEDNORMAL40960
36122N2GRIDDATAMOUNTEDNORMAL
30722146Y??SQL>colCOMPATIBILITYformata20SQL>colDA
TABASE_COMPATIBILITYformata20?SQL>selectgroup_number,name,t
ype,VOTING_FILES,COMPATIBILITY,DATABASE_COMPATIBILITYfromv$a
sm_diskgroup;?GROUP_NUMBERNAMETYPE
VCOMPATIBILITYDATABASE_COMPATIBILI---------------------
-------------------------------------------------------------
-------1DBNORMALN11.2.0.0.0
10.1.0.0.02GRIDDATANORMALY11.2.0
.0.010.1.0.0.0???8.EnablingTheGlobalServicesDaemo
n(GSD)forOracleDatabaseRelease9.2?WhenOracleDatabase9ir
elease2(9.2)isinstalledonan11grelease2(11.2)Oraclegrid
infrastructureforaclusterconfiguration,theGlobalServices
daemon(GSD)isdisabledbydefault.Usethefollowingcommandsto
enabletheGSDbeforeyouinstallarelease9.2OracleDatabase:s
rvctlenablenodeapps-gsrvctlstartnodeapps??9.再次校验集群配置?使用grid
用户执行?[grid@rhnode1~]$cluvfystage-postcrsinst-nrhnode1,rhno
de2-verbose[grid@rhnode1cfgtoollogs]$cluvfycompscan-verbose
??###############################################################
#######九.安装ORACLE软件############################################
##########################?1.以oracle用户login?2.以oracle用户解压软件
包(都解压到database目录)?[oracle@rhnode1softwares]$unziplinux_11gR2_d
atabase_1of2.zip[oracle@rhnode1softwares]$unziplinux_11gR2_dat
abase_2of2.zip?对RHEL6进行以下修改1).Changedirectoryto/databas
e/stage/cvu/cv/admin2).Backupcvu_config%cpcvu_configbackup_c
vu_config3).Editcvu_configandchangethefollowingline:CV_ASS
UME_DISTID=OEL4to:CV_ASSUME_DISTID=OEL64).Savetheupdatedcvu_c
onfigfile5).Installthe11.2.0.3softwareusing/database
/runInstaller%cd/database%./runInstaller??3.开始安装oracle
database?$cddatabase$./runInstaller?4.安装步骤?对于单机安装将invent
ory目录设置到/opt/inventory?选择仅安装软件?5.创建Listener(仅适用于单机环境)RAC环境中
的监听器已经创建,可以跳过次步?#netca?#########################################
#############################十.CreatingRACDatabase############
##########################################################??$dbc
a?选择创建RAC数据库?[grid@rhnode1~]$crs_stat-tNameType
TargetStateHost----------------------------------
--------------------------ora.DATA.dgora....up.typeONLINEON
LINErhnode1ora....ER.lsnrora....er.typeONLINEONLINE
rhnode1ora....N1.lsnrora....er.typeONLINEONLINErhnode2o
ra.asmora.asm.typeONLINEONLINErhnode1ora.eonso
ra.eons.typeONLINEONLINErhnode1ora.gsdora.gsd.type
OFFLINEOFFLINEora....networkora....rk.typeONLINEONLIN
Erhnode1ora.oc4jora.oc4j.typeOFFLINEOFFLINEora.ons
ora.ons.typeONLINEONLINErhnode1ora.psc.dbora....se.ty
peONLINEONLINErhnode1ora....ry.acfsora....fs.typeONLIN
EONLINErhnode1ora....SM1.asmapplicationONLINEONL
INErhnode1ora....E1.lsnrapplicationONLINEONLINEr
hnode1ora....de1.gsdapplicationOFFLINEOFFLINEora....de1.o
nsapplicationONLINEONLINErhnode1ora....de1.vipora..
..t1.typeONLINEONLINErhnode1ora....SM2.asmapplication
ONLINEONLINErhnode2ora....E2.lsnrapplicationONLINE
ONLINErhnode2ora....de2.gsdapplicationOFFLINEOFFL
INEora....de2.onsapplicationONLINEONLINErhnode2ora..
..de2.vipora....t1.typeONLINEONLINErhnode2ora.scan1.vip
ora....ip.typeONLINEONLINErhnode2?-11.2.0.3+RHEL6.1x64
，注意上图要选择2个节点,默认只选中了一个节点,只会创建一个Instance第一次运行完DBCA后，只在一个节点上有数据库实例，需
要在另一个节点上运行DBCA再添加一个实例?[grid@rhnode2~]$crs_stat-tName
TypeTargetStateHost-------------------------
-----------------------------------ora.DATA.dgora....up.typeONL
INEONLINErhnode1ora....ER.lsnrora....er.typeONLINEO
NLINErhnode1ora....N1.lsnrora....er.typeONLINEONLINE
rhnode1ora.asmora.asm.typeONLINEONLINErhnode1
ora.cvuora.cvu.typeONLINEONLINErhnode1ora.gsdora.gsd.typeOFFLINEOFFLINEora....networkora....rk.typeONLINEONLINErhnode1ora.oc4jora.oc4j.typeONLINEONLINErhnode1ora.onsora.ons.typeONLINEONLINErhnode1ora.psc.dbora....se.typeONLINEONLINErhnode1ora....SM1.asmapplicationONLINEONLINErhnode1ora....E1.lsnrapplicationONLINEONLINErhnode1ora....de1.gsdapplicationOFFLINEOFFLINEora....de1.onsapplicationONLINEONLINErhnode1ora....de1.vipora....t1.typeONLINEONLINErhnode1ora....SM2.asmapplicationONLINEONLINErhnode2ora....E2.lsnrapplicationONLINEONLINErhnode2ora....de2.gsdapplicationOFFLINEOFFLINEora....de2.onsapplicationONLINEONLINErhnode2ora....de2.vipora....t1.typeONLINEONLINErhnode2ora.scan1.vipora....ip.typeONLINEONLINErhnode1[grid@rhnode2~]$ps-ef??######################################################################十.CreatingRACOneDatabase######################################################################??$dbca?选择创建RACOneNode数据库??######################################################################十一.访问EM######################################################################??如果创建db时选了DatabaseControl,可用下面的URL访问访问em:??https://172.17.78.131:1158/emhttps://172.17.78.131:1158/em????重配置请参考下面的连接：onenote:..\..\23_Enterprise_Manager(EM)\01_Database_Control\02_11gR2_RAC_EM.one使用EMCA重建oracle11gR2RACdbconsole???[oracle@rhnode1~]$emctlstatusdbconsoleOracleEnterpriseManager11gDatabaseControlRelease11.2.0.1.0Copyright(c)1996,2009OracleCorporation.Allrightsreserved.https://rhnode1:1158/em/console/aboutApplicationhttps://rhnode1:1158/em/console/aboutApplicationOracleEnterpriseManager11gisrunning.------------------------------------------------------------------Logsaregeneratedindirectory/oracle/product/11.2.0/dbhome_1/rhnode1_psc/sysman/log[oracle@rhnode1~]$emctlstopdbconsoleOracleEnterpriseManager11gDatabaseControlRelease11.2.0.1.0Copyright(c)1996,2009OracleCorporation.Allrightsreserved.https://rhnode1:1158/em/console/aboutApplicationhttps://rhnode1:1158/em/console/aboutApplicationStoppingOracleEnterpriseManager11gDatabaseControl......Stopped.[oracle@rhnode1~]$emctlstartdbconsoleOracleEnterpriseManager11gDatabaseControlRelease11.2.0.1.0Copyright(c)1996,2009OracleCorporation.Allrightsreserved.https://rhnode1:1158/em/console/aboutApplicationhttps://rhnode1:1158/em/console/aboutApplicationStartingOracleEnterpriseManager11gDatabaseControl..............................started.------------------------------------------------------------------Logsaregeneratedindirectory/oracle/product/11.2.0/dbhome_1/rhnode1_psc/sysman/log[oracle@rhnode1~]$?? |
|
