oracle11g grid asm centos53

InfoSVC 发表于 2011-12-22 08:54

<DIV>
 
1．  新建用户以及组
 
新建oinstall、asmadmin、asmdba、asmoper、dba、oper组
#groupadd –g 500 oinstall
#groupadd –g 501 asmadmin
#groupadd –g 502 asmdba
#groupadd –g 503 asmoper
#groupadd –g 504 dba
#groupadd –g 505 oper
新建grid、oracle用户
#useradd –u 500 –d /home/grid –g 500 –G asmadmin asmdba asmoper grid
#useradd –u 501 –d /home/oracle –g 500 –G dba oper oracle
具体描述以及对应关系见下表
 
<DIV align=center>
<TABLE class=MsoNormalTable style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; MARGIN: auto auto auto 61.4pt; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt" cellSpacing=0 cellPadding=0 border=1>
<TBODY>
<TR style="HEIGHT: 27.55pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes">
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 3pt double; PADDING-LEFT: 5.4pt; BACKGROUND: #e0e0e0; PADDING-BOTTOM: 0cm; BORDER-LEFT: black 3pt double; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt">
Description</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 3pt double; PADDING-LEFT: 5.4pt; BACKGROUND: #e0e0e0; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; mso-border-left-alt: double black 3.0pt">
OS Group Name</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 3pt double; PADDING-LEFT: 5.4pt; BACKGROUND: #e0e0e0; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; mso-border-left-alt: double black 3.0pt">
OS Users Assigned to this Group</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 3pt double; PADDING-LEFT: 5.4pt; BACKGROUND: #e0e0e0; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; mso-border-left-alt: double black 3.0pt">
Oracle Privilege</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 3pt double; PADDING-LEFT: 5.4pt; BACKGROUND: #e0e0e0; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; mso-border-left-alt: double black 3.0pt">
Oracle Group Name</TD></TR>
<TR style="HEIGHT: 27.55pt; mso-yfti-irow: 1">
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: black 3pt double; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-top-alt: double black 3.0pt">
Oracle Inventory and Software Owner</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
oinstall</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
grid, oratest</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
 </TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
 </TD></TR>
<TR style="HEIGHT: 27.55pt; mso-yfti-irow: 2">
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: black 3pt double; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-top-alt: double black 3.0pt">
Oracle Automatic Storage Management Group</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
asmadmin</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
grid</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
SYSASM</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
OSASM</TD></TR>
<TR style="HEIGHT: 27.55pt; mso-yfti-irow: 3">
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: black 3pt double; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-top-alt: double black 3.0pt">
ASM Database Administrator Group</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
asmdba</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
grid, oratest</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
SYSDBA for ASM</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
OSDBA for ASM</TD></TR>
<TR style="HEIGHT: 27.55pt; mso-yfti-irow: 4">
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: black 3pt double; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-top-alt: double black 3.0pt">
ASM Operator Group</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
asmoper</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
grid</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
SYSOPER for ASM</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 27.55pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
OSOPER for ASM</TD></TR>
<TR style="HEIGHT: 11.95pt; mso-yfti-irow: 5">
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: black 3pt double; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 11.95pt; BACKGROUND-COLOR: transparent; mso-border-top-alt: double black 3.0pt">
Database Administrator</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 11.95pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
dba</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 11.95pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
oratest</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 11.95pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
SYSDBA</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 11.95pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
OSDBA</TD></TR>
<TR style="HEIGHT: 11.95pt; mso-yfti-irow: 6; mso-yfti-lastrow: yes">
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: black 3pt double; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 11.95pt; BACKGROUND-COLOR: transparent; mso-border-top-alt: double black 3.0pt">
Database Operator</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 11.95pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
oper</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 11.95pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
oratest</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 11.95pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
SYSOPER</TD>
<TD style="BORDER-RIGHT: black 3pt double; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: black 3pt double; HEIGHT: 11.95pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: double black 3.0pt; mso-border-top-alt: double black 3.0pt">
OSOPER</TD></TR></TBODY></TABLE></DIV>
注1：两台主机上新建的用户以及组的id都必须完全相同，最好能将用户的首要组也设置成一样
注2：用户和组的对应关系必须和上表严格一致，否则日后安装grid以及建库的时候会报错
 
 
 
 
2．新建文件系统或者目录
 
本次实施过程中，是将两块根盘做了raid1，然后使用lvm方式进行的划分，具体新建新的文件系统方法如下：（系统的根盘对应的vg是vg00）
#lvcreate –L 20480 –n lvu09 vg00  ＃划分出一个20G的lvu09
#fsadm –e ext3 /dev/vg00/lvu09
#mkdir /u09
#vi fstab   ＃编辑fstab，让文件系统可以随即mount
#mount /dev/vg00/lvu09 /u09
#cd /u09
#mkdir –p /u09/grid
#mkdir –p /u09/11.2.0/grid
#mkdir –p /u09/11.2.0/oracle
#chown grid:oinstall /u09
#chown oracle:oinstall /u09/11.2.0/oracle
如果不是使用的lvm方式，只需要在/下面新建目录，在赋予权限就可以了
 
3．调整系统参数
 
3．1修改sysctl.conf，增加或修改以下参数: 
kernel.shmmni=4096 
kernel.sem = 250 32000 100 128 
net.ipv4.ip_local_port_range = 9000 65500 
net.core.rmem_default = 262144 
net.core.rmem_max = 4194304 
net.core.wmem_default = 262144 
net.core.wmem_max = 1048576 
fs.file-max=6815744 
fs.aio-max-nr=1048576 
 
3．2修改/etc/security/limits.conf文件中增加以下: 
oracle soft nproc 2047 
oracle hard nproc 16384 
oracle soft nofile 1024 
oracle hard nofile 65536 
grid soft nproc 2047 
grid hard nproc 16384 
grid soft nofile 1024 
grid hard nofile 65536 
 
3．3在/etc/pam.d/login 文件中增加： 
session    required     /lib/security/pam_limits.so 
session    required     pam_limits.so 
 
3．4修改/etc/profile,增加： 
if [ $USER = "oratest" ] || [ $USER = "grid" ]; then 
                if [ $SHELL = "/bin/ksh" ]; then 
                      ulimit -p 16384 
                      ulimit -n 65536 
                else 
                      ulimit -u 16384 -n 65536 
                fi 
        fi 
 
3．5修改/etc/hosts文件
127.0.0.1               localhost.localdomain localhost 
::1             localhost6.localdomain6 localhost6 
 #public 
192.168.161.63 tydic63 
192.168.161.64 tydic64 
 #private 
10.10.10.1 tydic63-priv 
10.10.10.2 tydic64-priv 
 #virtual 
192.168.161.73 tydic63-vip 
192.168.161.74 tydic64-vip 
 #scan 
192.168.161.65 tydic-cluster-scan 
 
3．6配置网卡
将两台机器的eth0配置成192.168.161.网段，eth1配置成10.10.10网段
#ifconfig eth0 192.168.161.63 netmask 255.255.255.0
#ifconfig eth1 10.10.10.1 netmask 255.255.255.0
 
3．7配置网关
修改/etc/sysconfig/network-scripts/ifcfg-eth0
修改default gateway  192.168.161.1
即时生效:
# route add default gw 192.168.161.1
 
3．8配置dns
修改/etc/sysconfig/network-scripts/ifcfg-eth0
修改dns 202.96.134.133
修改/etc/resolv.conf
 
3．9修改hostname
#hostname tydic63
 
完成上面的修改后执行
#/sbin/sysctl –p
使修改生效，或者重启主机（个人建议重启一下，看看修改后是否主机重启是否存在问题）
 
 
3．10配置环境变量
配置grid用户的环境变量（tydic63上的ORACLE_SID=+ASM1，tydic64上的ORACLE_SID=+ASM2）
export ORACLE_HOSTNAME=tydic63
ORACLE_SID=+ASM1; export ORACLE_SID
ORACLE_BASE=/u09/app/grid; export ORACLE_BASE
ORACLE_HOME=/u09/app/11.2.0/grid; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
PATH=${PATH}:/u09/app/common/oracle/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
umask 022
配置oracle用户的环境变量（tydic63上的ORACLE_SID=1oratest1，tydic64上的ORACLE_SID=oratest2）
export ORACLE_HOSTNAME=tydic63
ORACLE_SID=oratest1; export ORACLE_SID
ORACLE_UNQNAME=oratest; export ORACLE_UNQNAME
ORACLE_BASE=/u09/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
PATH=${PATH}:/u09/app/common/oracle/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
umask 022
 
4．Centos5.3 64bit  安装数据库必须安装的系统包如下：
binutils 
compat-libstdc++
elfutils-libelf 
elfutils-libelf-devel
glibc
glibc-common
glibc-devel 
gcc
gcc-c++ 
libaio
libaio-devel  (含i386）
libgcc- 
libstdc++ 
libstdc++-devel
make
sysstat
unixODBC   (含i386）
unixODBC-devel   (含i386）
pdksh
注：上述包都必须安装64位的，即x86-64的，但是带（i386）的包，就必须同时安装32位的包
安装方法如下：
首先检测上述包是否安装：
#rpm –q pdksh
没有就使用yum命令搜索
#yum search pdksh
再用yum命令将搜索出来的包安装
#yum install pdksh .x86_64
注：本次安装的操作系统centos53（64bit）所有的系统包都可以在网络上搜索，所以配置网络的时候可以将dns配置好，直接利用网络资源
 
5．配置ssh信任
配置群集每个节点上的SSH。在每个节点上以grid用户登陆执行下列任务： 
#su - grid 
#mkdir ~/.ssh 
#chmod 700 ~/.ssh 
#/usr/bin/ssh-keygen -t rsa 这里可以接受其默认设置 
RSA公钥被写入~/.ssh/id_rsa.pub文件，私钥写入~/.ssh/id_rsa文件。 
在tydic63节点上以Grid用户登陆，生成一个authorized_keys文件，然后复制到tydic64上： 
#su - grid 
#cd ~/.ssh 
#cat id_rsa.pub >> authorized_keys 
#scp authorized_keys tydic64:/home/grid/.ssh/ 
接下来，在tydic64上以Grid用户登陆，执行下面的命令： 
#su - grid 
#cd ~/.ssh 
#cat id_rsa.pub >> authorized_keys 
#scp authorized_keys tydic63:/home/grid/.ssh/ 
现在在两台服务器上的authorized_keys文件都包括了所有节点的公钥。 
为了使每个群集成员节点上的SSH用户都对等，在每个节点上执行下面的命令： 
#su - grid 
#ssh tydic63 date 
#ssh tydic64 date 
#exec /usr/bin/ssh-agent $SHELL 
#/usr/bin/ssh-add 
使用oracle用户也进行一次同样的操作 
现在在这两台服务器之间grid、oracle用户应该可以不要密码使用SSH和SCP了。
注：这里也可以不配置ssh，在后面安装grid和oracle程序的时候，系统有选项可以自动配置（经过了验证），但个人建议，我们先配置好，到时候在验证，否则如果系统自动配置出现问题，再去解决可能会比较麻烦
 
6．配置ntp
修改/etc/sysconfig/ntpd 增加一个-x参数 
# Drop root to id 'ntp:ntp' by default. 
OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid" 
# Set to 'yes' to sync hw clock after successful ntpdate 
SYNC_HWCLOCK=no 
# Additional options for ntpdate 
NTPDATE_OPTIONS="" 
改完后，重起ntp服务  
#/sbin/service ntpd restart
 
 
7．安装ASM、划分存储并配置ASM
7．1安装ASM的rpm包
oracleasm-2.6.18-128.el5-2.0.5-1.el5.x86_64.rpm 
oracleasmlib-2.0.4-1.el5.x86_64.rpm 
oracleasm-support-2.1.3-1.el5.x86_64.rpm 
上面使ASM对于linux的rpm包
#rpm -Uvh oracleasm-****.x86_64.rpm
 
7．2配置ASMLIB
#/usr/sbin/oracleasm configure ；显示当前配置 
ORACLEASM_ENABLED=false 
ORACLEASM_UID= 
ORACLEASM_GID= 
ORACLEASM_SCANBOOT=true 
ORACLEASM_SCANORDER="" 
ORACLEASM_SCANEXCLUDE="" 
 
#/usr/sbin/oracleasm configure –i;开始配置 
 
Default user to own the driver interface []: grid 
Default group to own the driver interface []: asmadmin 
Start Oracle ASM library driver on boot (y/n) : y 
Scan for Oracle ASM disks on boot (y/n) : y 
Writing Oracle ASM library driver configuration: done 
完成后将在系统中建立 /etc/sysconfig/oracleasm 、/dev/oracleasm 并Mounts ASMLib driver file system  
#/etc/init.d/oracleasm start
Creating /dev/oracleasm mount point:                       [  OK  ]
#/etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration:   [ OK ]
Loading module "oracleasm":                        [ OK ]
Mounting ASMlib driver filesystem:                 [ OK ]
Scanning system for ASM disks:                     [ OK ]
或者执行
#/usr/sbin/oracleasm init  
 
7．3划分存储
#fdisk /dev/sdb
 
Command (m for help): n
Command action
e   extended
p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-261, default 1): 
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-261, default 261): 
Using default value 261
 
Command (m for help): w 
The partition table has been altered!
注1：如果该硬盘之前已经被ASM使用过了，就需要重新格式化，再划分
注2：ASM对硬盘的大小是有限制的，不能太小，太小后面安装grid的时候会报错，具体值暂时没有查到。
#fdisk -l /dev/sdb
检查划分的结果
依次操作，分别在三个磁盘完成建立分区操作
 
7．4ASM划分空间
# oracleasm createdisk CRSVOL1 /dev/sdb1 
Writing disk header: done 
Instantiating disk: done 
# oracleasm createdisk DATAVOL1 /dev/sdc1 
Writing disk header: done 
Instantiating disk: done 
# oracleasm createdisk FRAVOL1 /dev/sdd1 
Writing disk header: done 
Instantiating disk: done 
 
到tydi64，找到tydic63建好的三个asm磁盘: 
# oracleasm scandisks 
Reloading disk partitions: done 
Cleaning any stale ASM disks... 
Scanning system for ASM disks... 
Instantiating disk "CRSVOL1" 
Instantiating disk "DATAVOL1" 
Instantiating disk "FRAVOL1" 
 
确认在两个节点都能看到已建好的asm磁盘： 
# oracleasm listdisks 
CRSVOL1 
DATAVOL1 
FRAVOL1 
# oracleasm listdisks 
CRSVOL1 
DATAVOL1 
FRAVOL1
注1：磁盘名称是ASCII大写字母、数字和下划线。它们必须以字母开始。
注2：ASMLib只可以配置磁盘分区，不可以配置整个磁盘
 
 
 
8．安装grid软件（Oracle Grid Infrastructure for a Cluster）
8．1安装 cvuqdisk Package for Linux（两个节点都要安装）
按以下方式完成安装： 
先从grid用户开始:   
$su  转到root用户
改环境变量  
#CVUQDISK_GRP=oinstall; export CVUQDISK_GRP  
开始安装 
#rpm -iv cvuqdisk-1.0.7-1.rpm 
Preparing packages for installation... 
cvuqdisk-1.0.7-1
 
8．2安装环境检测
上传grid软件、database软件到/public目录下
用grid用户登入系统
$cd /public/grid （该目录是grid安装文件存在目录）
$./runcluvfy.sh stage -pre crsinst -n tydic63,tydic64 -fixup -verbose
获得结果Pre-check for cluster services setup was successful on all the nodes.则表明安装环境具备。
如果出现Please run the following script on each node as "root" user to execute the fixups:‘/tmp/CVU_11.2.0.1.0_grid/runfixup.sh'
则需要使用root用户执行上面额命令，然后再检查环境，直到环境具备。
 
8．3安装grid软件（Oracle Grid Infrastructure for a Cluster）
使用xwindows软件进行安装
使用grid用户登入系统
$export DISPLAY=IP:0.0
$cd /public/grid  （该目录是grid安装文件存在目录）
$./runInstaller

选"Advanced Installation 

 
 
 
选择语言，添加Simplified Chinese

配置SCAN参数，不需配GNS

 
添加tydic64节点，并测试ssh，如前面配置ssh正确，测试顺利通过。（该处ssh connectivity选项，可以在线配置ssh）

/etc/hosts文件无误，系统可正确识别出公、私网段 

OCR磁盘选用ASM类型

为OCR磁盘建立并选择ASM磁盘组，如下图配置

选Use same passwords for these accounts

选Do not use Intelligent Platform Management Interface (IPMI) 

 
 
配置asm的各个组 
分配安装路径，如环境变量无配置失误，则自动填写的路径与环境变量一致 

 
 
OUI路径 开始检查

检查结果 

安装 

用root用户在两节点执行下图脚本 
orainstaRoot.sh这个脚本执行很容易通过
执行root.sh的结果：
Tydic63
# ./root.sh
Running Oracle 11g root.sh script...
 
The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u09/app/11.2.0/grid
 
Enter the full pathname of the local bin directory: : 
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n) 
: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
: y
   Copying coraenv to /usr/local/bin ...
 
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
2010-02-08 15:39:09: Parsing the host name
2010-02-08 15:39:09: Checking for super user privileges
2010-02-08 15:39:09: User has super user privileges
Using configuration parameter file: /u09/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
LOCAL ADD MODE 
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
  root wallet
  root wallet cert
  root cert export
  peer wallet
  profile reader wallet
  pa wallet
  peer wallet keys
  pa wallet keys
  peer cert request
  pa cert request
  peer cert
  pa cert
  peer root cert TP
  profile reader root cert TP
  pa root cert TP
  peer pa cert TP
  pa peer cert TP
  profile reader pa cert TP
  profile reader peer cert TP
  peer user cert
  pa user cert
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
ADVM/ACFS is not supported on centos-release-5-3.el5.centos.1
 
 
 
CRS-2672: Attempting to start 'ora.gipcd' on 'tydic63'
CRS-2672: Attempting to start 'ora.mdnsd' on 'tydic63'
CRS-2676: Start of 'ora.gipcd' on 'tydic63' succeeded
CRS-2676: Start of 'ora.mdnsd' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'tydic63'
CRS-2676: Start of 'ora.gpnpd' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'tydic63'
CRS-2676: Start of 'ora.cssdmonitor' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'tydic63'
CRS-2672: Attempting to start 'ora.diskmon' on 'tydic63'
CRS-2676: Start of 'ora.diskmon' on 'tydic63' succeeded
CRS-2676: Start of 'ora.cssd' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'tydic63'
CRS-2676: Start of 'ora.ctssd' on 'tydic63' succeeded
 
ASM created and started successfully.
 
DiskGroup CRS created successfully.
 
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-2672: Attempting to start 'ora.crsd' on 'tydic63'
CRS-2676: Start of 'ora.crsd' on 'tydic63' succeeded
CRS-4256: Updating the profile
Successful addition of voting disk 0c3ca42e13dc4f52bf3845185dc9c0cc.
Successfully replaced voting disk group with +CRS.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   0c3ca42e13dc4f52bf3845185dc9c0cc (ORCL:CRSVOL1) 
Located 1 voting disk(s).
CRS-2673: Attempting to stop 'ora.crsd' on 'tydic63'
CRS-2677: Stop of 'ora.crsd' on 'tydic63' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'tydic63'
CRS-2677: Stop of 'ora.asm' on 'tydic63' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'tydic63'
CRS-2677: Stop of 'ora.ctssd' on 'tydic63' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'tydic63'
CRS-2677: Stop of 'ora.cssdmonitor' on 'tydic63' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'tydic63'
CRS-2677: Stop of 'ora.cssd' on 'tydic63' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'tydic63'
CRS-2677: Stop of 'ora.gpnpd' on 'tydic63' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'tydic63'
CRS-2677: Stop of 'ora.gipcd' on 'tydic63' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'tydic63'
CRS-2677: Stop of 'ora.mdnsd' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.mdnsd' on 'tydic63'
CRS-2676: Start of 'ora.mdnsd' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'tydic63'
CRS-2676: Start of 'ora.gipcd' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'tydic63'
CRS-2676: Start of 'ora.gpnpd' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'tydic63'
CRS-2676: Start of 'ora.cssdmonitor' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'tydic63'
CRS-2672: Attempting to start 'ora.diskmon' on 'tydic63'
CRS-2676: Start of 'ora.diskmon' on 'tydic63' succeeded
CRS-2676: Start of 'ora.cssd' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'tydic63'
CRS-2676: Start of 'ora.ctssd' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'tydic63'
CRS-2676: Start of 'ora.asm' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'tydic63'
CRS-2676: Start of 'ora.crsd' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'tydic63'
CRS-2676: Start of 'ora.evmd' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'tydic63'
CRS-2676: Start of 'ora.asm' on 'tydic63' succeeded
CRS-2672: Attempting to start 'ora.CRS.dg' on 'tydic63'
CRS-2676: Start of 'ora.CRS.dg' on 'tydic63' succeeded
 
tydic63     2010/02/08 15:43:23     /u09/app/11.2.0/grid/cdata/tydic63/backup_20100208_154323.olr
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Updating inventory properties for clusterware
Starting Oracle Universal Installer...
 
Checking swap space: must be greater than 500 MB.   Actual 18047 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u09/app/oraInventory
'UpdateNodeList' was successful.
 
 
 
 
 
 
 
Tydic64
# ./root.sh
Running Oracle 11g root.sh script...
 
The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u09/app/11.2.0/grid
 
Enter the full pathname of the local bin directory: : 
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n) 
: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
: y
   Copying coraenv to /usr/local/bin ...
 
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
2010-02-08 15:43:47: Parsing the host name
2010-02-08 15:43:47: Checking for super user privileges
2010-02-08 15:43:47: User has super user privileges
Using configuration parameter file: /u09/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
LOCAL ADD MODE 
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
ADVM/ACFS is not supported on centos-release-5-3.el5.centos.1
 
 
 
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node tydic63, number 1, and is terminating
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'tydic64'
CRS-2677: Stop of 'ora.cssdmonitor' on 'tydic64' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'tydic64'
CRS-2677: Stop of 'ora.gpnpd' on 'tydic64' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'tydic64'
CRS-2677: Stop of 'ora.gipcd' on 'tydic64' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'tydic64'
CRS-2677: Stop of 'ora.mdnsd' on 'tydic64' succeeded
An active cluster was found during exclusive startup, restarting to join the cluster
CRS-2672: Attempting to start 'ora.mdnsd' on 'tydic64'
CRS-2676: Start of 'ora.mdnsd' on 'tydic64' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'tydic64'
CRS-2676: Start of 'ora.gipcd' on 'tydic64' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'tydic64'
CRS-2676: Start of 'ora.gpnpd' on 'tydic64' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'tydic64'
CRS-2676: Start of 'ora.cssdmonitor' on 'tydic64' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'tydic64'
CRS-2672: Attempting to start 'ora.diskmon' on 'tydic64'
CRS-2676: Start of 'ora.diskmon' on 'tydic64' succeeded
CRS-2676: Start of 'ora.cssd' on 'tydic64' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'tydic64'
CRS-2676: Start of 'ora.ctssd' on 'tydic64' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'tydic64'
CRS-2676: Start of 'ora.asm' on 'tydic64' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'tydic64'
CRS-2676: Start of 'ora.crsd' on 'tydic64' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'tydic64'
CRS-2676: Start of 'ora.evmd' on 'tydic64' succeeded
 
tydic64     2010/02/08 15:46:08     /u09/app/11.2.0/grid/cdata/tydic64/backup_20100208_154608.olr
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Updating inventory properties for clusterware
Starting Oracle Universal Installer...
 
Checking swap space: must be greater than 500 MB.   Actual 19967 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u09/app/oraInventory
'UpdateNodeList' was successful.
 
 
 
 
 
 
 
执行完脚本，继续进行，最后会出现一个报错，不必管他，只是个dns的校验错误，不影响的。

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
8．4使用asmca建立数据与Fast Recovery Area用到的磁盘组
选择磁盘组，点Create，建立RACDB_DATA及FRA磁盘组
  
 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
9．安装数据库软件（oracle database）
使用xwindows软件进行安装
使用oracle用户登入系统
$export DISPLAY=IP:0.0
$cd /public/database  （该目录是oracle安装文件存在目录）
$./runInstaller
不选”I wish to receive security updates via My Oracle Support” Email也可不填

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
选Install database software only

选Real Application Clusters database installation，能看到两个节点已自动被选中（该处的ssh connectivity选项可以在线配置ssh）

 
 
选择语言  添加Simplified Chinese

选Enterprise Edition，缺省组件如图 

 
 
安装路径自动按环境变量填入 
数据库工作组选择，注意要有oper组，否则稍后用DBCA建库时可能发生不能识别出ASM磁盘组现象 
检查 
结果 
 
 
点Finish开始安装 

在两节点上用root用户执行脚本，完成Oracle软件安装 
 
 
执行root.sh的结果：
# ./root.sh
Running Oracle 11g root.sh script...
 
The following environment variables are set as:
    ORACLE_OWNER= ora11g
    ORACLE_HOME=  /u09/app/oracle/product/11.2.0/dbhome_1
 
Enter the full pathname of the local bin directory: : 
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n) 
: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
: y
   Copying coraenv to /usr/local/bin ...
 
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
 
10．建库
使用xwindows软件进行安装
使用oracle用户登入系统
$export DISPLAY=IP:0.0
$dbca
 
 
 
 
 
 
 
 
 
 
 
 
 
 
选Oracle Real Application Clusters database

选Create a Database 

 
 
 
 
选Custom Database 

填入oracle sid，选所有节点 
 
 
 
 
选Configure Enterprise Manager / Configure Database Control for local management

选Use the Same Administrative Password for All Accounts 

 
 
 
 
配置数据文件位置如下图，RACDB_DATA为前步建好的ASM磁盘组 

配置ASMSNMP密码（前面安装grid是设置的密码）

 
 
 
 
配置Fast Recovery Area，选取前步所建的FRA磁盘组，容量为该磁盘组容量的85% 
继续，用缺省配置 

 
 
 
配置SGA、字符集等（将sga调整小的时候会报错，可以忽略）

配置系统表空间等

 
 
 
 
生成建库脚本，开始


建库完成之后，可以用grid用户执行
$crs_stat –t
检查所有节点的资源组是否都启动。
目前发现11g的listener文件是在grid用户的$ORACLE_HOME/network/admin下
而tnsname文件则是在oracle用户下的$ORACLE_HOME/network/admin下，
其次oracle11g的alterlog文件的位置是可以配置的，不固定在$ORACLE_BASE/admin/sid/bdump下。
 
 
 
 
 
 
 </DIV>

ZRyan 发表于 2013-04-13 18:40

真实牛逼，崇拜至极

页: [1]

Chinaunix's Archiver

oracle11g grid asm centos53