关闭防火墙:
Service iptables status
Service iptables stop
chkconfig iptables off
chkconfig iptables –list
修改hosts
127.0.0.1 localhost
192.168.128.2 rac1 rac1-public
192.168.128.3 rac1-priv
192.168.128.8 rac1-vip
192.168.128.4 rac2 rac2-public
192.168.128.5 rac2-priv
192.168.128.9 rac2-vip
192.168.128.7 rac-scan
打补丁包
安装 yum(可选)
[root@vmac6 ~]# cd /etc/yum.repos.d
[root@vmac6 yum.repos.d]# mv public-yum-ol6.repo public-yum-ol6.repo.bak
[root@vmac6 yum.repos.d]# touch public-yum-ol6.repo
[root@vmac6 yum.repos.d]# vi public-yum-ol6.repo
[oel6]
name = Enterprise Linux 6.2 DVD
baseurl=file:///media/"OL6.2 x86_64 Disc 1 20111212"/Server
gpgcheck=0
enabled=1
binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.97-5
elfutils-libelf-devel-0.125
glibc-2.5-12
glibc-common-2.5-12
glibc-devel-2.5-12
gcc-4.10.1-52
gcc-c++-4.10.1-52
libaio-0.30.106
libaio-devel-0.3.106
libgcc-4.10.1-52
libstdc++-4.1.1
libstdc++-devel-4.10.1-52
make-3.81-1.1
sysstat-7.0.0
unixODBC-2.2.11
unixODBC-devel-2.2.11
libcap这个包也要装
创建用户和组
groupadd -g 1000 oinstall
groupadd -g 1200 asmadmin
groupadd -g 1201 asmdba
groupadd -g 1202 asmoper
groupadd -g 1300 dba
groupadd -g 1301 oper
useradd -m -u 1100 -g oinstall -Gasmadmin,asmdba,asmoper -d /home/grid -s /bin/bash grid
useradd -m -u 1101 -g oinstall -Gdba,oper,asmdba -d /home/oracle -s /bin/bash oracle
确认用户创建成功
id oracle
id grid
创建密码
passwd oracle
passwd grid
创建用户目录并赋权
mkdir -p /u01/app/grid/11.2.0
chown -R grid:oinstall /u01
mkdir -p /u01/app/oracle/11.2.0/db_1
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01
cat >> /etc/security/limits.conf <<EOF
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF
修改/etc/pam.d/login
cat >> /etc/pam.d/login <<EOF
session required pam_limits.so
EOF
(1)对于 Bourne、Bash 或 Korn shell,通过运行以下命令将以下行添加到 /etc/profile 文件:
[root@rac1 ~]# cat >> /etc/profile <<EOF
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
if [ $USER = "root" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
EOF
(2)对于 C shell(csh 或 tcsh),通过运行以下命令将以下行添加到 /etc/csh.login 文件:
[root@racnode1 ~]# cat >> /etc/csh.login <<EOF
if ( /$USER == "oracle" || /$USER =="grid" ) then
limit maxproc 16384
limit descriptors 65536
endif
EOF
配置内核参数
cat >> /etc/sysctl.conf <<EOF
kernel.shmmax = 4294967295
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
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.aio-max-nr=1048576
EOF
sysctl -p
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
配置用户环境变量
grid 节点不同
export ORACLE_SID=+ASM1
#export ORACLE_SID=+ASM2
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/grid/11.2.0
exportPATH=$ORACLE_HOME/bin:$PATH:/usr/local/bin/:
export TEMP=/tmp
export TMP=/tmp
export TMPDIR=/tmpsu
umask 022
oracle
ORACLE_SID=racdb1;export ORACLE_SID
#ORACLE_SID=racdb2;export ORACLE_SID
ORACLE_UNQNAME=racdb;export ORACLE_UNQNAME
JAVA_HOME=/usr/local/java; export JAVA_HOME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1;export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="YYYY:MM:DD HH24:MI:SS";export NLS_DATE_FORMAT
#NLS_LANG=american_america.ZHS16GBK; exportNLS_LANG
#TNS_ADMIN=$ORACLE_HOME/network/admin; exportTNS_ADMIN
#ORA_NLS11=$ORACLE_HOME/nls/data; exportORA_NLS11
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/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
#---------------------------------------------------
# Set the default file mode creation mask
# (umask) to 022 to ensure that the userperforming
# the Oracle software installation createsfiles
# with 644 permissions.
#---------------------------------------------------
umask 022
发现设备
iscsiadm -m discovery -t sendtargets -p 192.168.128.6
手动登陆iscsi
iscsiadm -m node -T hui.asm.com -p 192.168.128.6 -l
配置自动登录iscsi
iscsiadm -m node -Thui.asm.com -p 192.168.128.6 --op update -n node.startup -v automatic
配置自动启动
chkconfig iscsid on
chkconfig iscsi on
格式化分区
fdisk /dev/sdq
Device contains neither a valid DOSpartition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with diskidentifier 0xd5a3f562.
Changes will remain in memory only, untilyou decide to write them.
After that, of course, the previous contentwon't be recoverable.
Warning: invalid flag 0x0000 of partitiontable 4 will be corrected by w(rite)
WARNING: DOS-compatible mode is deprecated.It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-1018, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G}(1-1018, default 1018):
Using default value 1018
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
只需要在一个机器上格式化磁盘
Openfiler iscsiadm: No portals found 解决方法
http://blog.csdn.net/tianlesoftware/article/details/8007658
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
启动UDEV
/sbin/start_udev
搭建ntp时间同步
编辑/etc/ntp.conf
server 192.168.1.10 prefer
driftfile /var/lib/ntp/drift
broadcastdelay 0.008
(3)要架设本机为时间服务器,在 /etc/ntp.conf文件下添加配置:
server 127.127.1.0
fudge 127.127.1.0 stratum 11
driftfile /var/lib/ntp/drift
broadcastdelay 0.008
编辑另一个节点:
server 192.168.128.2 prefer
driftfile /var/lib/ntp/drift
broadcastdelay 0.008
为了使NTP服务可以在系统引导的时候自动启动,执行:
# chkconfig ntpd on 启动/关闭/重启NTP的命令是:
# service ntpd start # service ntpd stop # service ntpd restart
将同步好的时间写到CMOS里
vi /etc/sysconfig/ntpd SYNC_HWCLOCK=yes 每次修改了配置文件后都需要重新启动服务来使配置生效。可以使用下面的命令来检查NTP服务是否启动,你应该可以得到一个进程ID号:
# pgrep ntpd 使用下面的命令检查时间服务器同步的状态:
# ntpq -p 用ntpstat 也可以查看一些同步状态
用netstat -ntlup查看端口使用情况!
安装grid
Service iptables status
Service iptables stop
chkconfig iptables off
chkconfig iptables –list
设置/etc/selinux/config 文件,将SELINUX设置为disabled。
vi /etc/selinux/config
修改hosts
127.0.0.1 localhost
192.168.128.2 rac1 rac1-public
192.168.128.3 rac1-priv
192.168.128.8 rac1-vip
192.168.128.4 rac2 rac2-public
192.168.128.5 rac2-priv
192.168.128.9 rac2-vip
192.168.128.7 rac-scan
打补丁包
安装 yum(可选)
[root@vmac6 ~]# cd /etc/yum.repos.d
[root@vmac6 yum.repos.d]# mv public-yum-ol6.repo public-yum-ol6.repo.bak
[root@vmac6 yum.repos.d]# touch public-yum-ol6.repo
[root@vmac6 yum.repos.d]# vi public-yum-ol6.repo
[oel6]
name = Enterprise Linux 6.2 DVD
baseurl=file:///media/"OL6.2 x86_64 Disc 1 20111212"/Server
gpgcheck=0
enabled=1
binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.97-5
elfutils-libelf-devel-0.125
glibc-2.5-12
glibc-common-2.5-12
glibc-devel-2.5-12
gcc-4.10.1-52
gcc-c++-4.10.1-52
libaio-0.30.106
libaio-devel-0.3.106
libgcc-4.10.1-52
libstdc++-4.1.1
libstdc++-devel-4.10.1-52
make-3.81-1.1
sysstat-7.0.0
unixODBC-2.2.11
unixODBC-devel-2.2.11
libcap这个包也要装
创建用户和组
groupadd -g 1000 oinstall
groupadd -g 1200 asmadmin
groupadd -g 1201 asmdba
groupadd -g 1202 asmoper
groupadd -g 1300 dba
groupadd -g 1301 oper
useradd -m -u 1100 -g oinstall -Gasmadmin,asmdba,asmoper -d /home/grid -s /bin/bash grid
useradd -m -u 1101 -g oinstall -Gdba,oper,asmdba -d /home/oracle -s /bin/bash oracle
确认用户创建成功
id oracle
id grid
创建密码
passwd oracle
passwd grid
创建用户目录并赋权
mkdir -p /u01/app/grid/11.2.0
chown -R grid:oinstall /u01
mkdir -p /u01/app/oracle/11.2.0/db_1
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01
注:红色部分一起执行
cat >> /etc/security/limits.conf <<EOF
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF
修改/etc/pam.d/login
cat >> /etc/pam.d/login <<EOF
session required pam_limits.so
EOF
(1)对于 Bourne、Bash 或 Korn shell,通过运行以下命令将以下行添加到 /etc/profile 文件:
[root@rac1 ~]# cat >> /etc/profile <<EOF
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
if [ $USER = "root" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
EOF
(2)对于 C shell(csh 或 tcsh),通过运行以下命令将以下行添加到 /etc/csh.login 文件:
[root@racnode1 ~]# cat >> /etc/csh.login <<EOF
if ( /$USER == "oracle" || /$USER =="grid" ) then
limit maxproc 16384
limit descriptors 65536
endif
EOF
配置内核参数
cat >> /etc/sysctl.conf <<EOF
kernel.shmmax = 4294967295
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
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.aio-max-nr=1048576
EOF
sysctl -p
如果是用的rdbms安装包需要配置limits.conf文件,添加如下内容
vi /etc/security/limits.conf
# grid-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024grid 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
配置用户环境变量
grid 节点不同
export ORACLE_SID=+ASM1
#export ORACLE_SID=+ASM2
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/grid/11.2.0
exportPATH=$ORACLE_HOME/bin:$PATH:/usr/local/bin/:
export TEMP=/tmp
export TMP=/tmp
export TMPDIR=/tmpsu
umask 022
oracle
ORACLE_SID=racdb1;export ORACLE_SID
#ORACLE_SID=racdb2;export ORACLE_SID
ORACLE_UNQNAME=racdb;export ORACLE_UNQNAME
JAVA_HOME=/usr/local/java; export JAVA_HOME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1;export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="YYYY:MM:DD HH24:MI:SS";export NLS_DATE_FORMAT
#NLS_LANG=american_america.ZHS16GBK; exportNLS_LANG
#TNS_ADMIN=$ORACLE_HOME/network/admin; exportTNS_ADMIN
#ORA_NLS11=$ORACLE_HOME/nls/data; exportORA_NLS11
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/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
#---------------------------------------------------
# Set the default file mode creation mask
# (umask) to 022 to ensure that the userperforming
# the Oracle software installation createsfiles
# with 644 permissions.
#---------------------------------------------------
umask 022
获取存储
安装 iscsi服务包
从安装光盘里找到iscsi安装包并进行安装
启动iscsi
service iscsid start发现设备
iscsiadm -m discovery -t sendtargets -p 192.168.128.6
手动登陆iscsi
iscsiadm -m node -T hui.asm.com -p 192.168.128.6 -l
配置自动登录iscsi
iscsiadm -m node -Thui.asm.com -p 192.168.128.6 --op update -n node.startup -v automatic
配置自动启动
chkconfig iscsid on
chkconfig iscsi on
格式化分区
fdisk /dev/sdq
Device contains neither a valid DOSpartition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with diskidentifier 0xd5a3f562.
Changes will remain in memory only, untilyou decide to write them.
After that, of course, the previous contentwon't be recoverable.
Warning: invalid flag 0x0000 of partitiontable 4 will be corrected by w(rite)
WARNING: DOS-compatible mode is deprecated.It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-1018, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G}(1-1018, default 1018):
Using default value 1018
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
只需要在一个机器上格式化磁盘
Openfiler iscsiadm: No portals found 解决方法
http://blog.csdn.net/tianlesoftware/article/details/8007658
使用UDEV配置共享存储
根据磁盘数量添加
for i in b c d;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
启动UDEV
/sbin/start_udev
搭建ntp时间同步
编辑/etc/ntp.conf
server 192.168.1.10 prefer
driftfile /var/lib/ntp/drift
broadcastdelay 0.008
(3)要架设本机为时间服务器,在 /etc/ntp.conf文件下添加配置:
server 127.127.1.0
fudge 127.127.1.0 stratum 11
driftfile /var/lib/ntp/drift
broadcastdelay 0.008
编辑另一个节点:
server 192.168.128.2 prefer
driftfile /var/lib/ntp/drift
broadcastdelay 0.008
为了使NTP服务可以在系统引导的时候自动启动,执行:
# chkconfig ntpd on 启动/关闭/重启NTP的命令是:
# service ntpd start # service ntpd stop # service ntpd restart
将同步好的时间写到CMOS里
vi /etc/sysconfig/ntpd SYNC_HWCLOCK=yes 每次修改了配置文件后都需要重新启动服务来使配置生效。可以使用下面的命令来检查NTP服务是否启动,你应该可以得到一个进程ID号:
# pgrep ntpd 使用下面的命令检查时间服务器同步的状态:
# ntpq -p 用ntpstat 也可以查看一些同步状态
用netstat -ntlup查看端口使用情况!
安装grid
ins-06002 setup报错
ssh-keygen -t rsa
ssh-keygen -t dsa
cd /home/grid/.ssh/
ssh rac1 cat /home/grid/.ssh/id_rsa.pub >>authorized_keys
ssh rac1 cat /home/grid/.ssh/id_dsa.pub >>authorized_keys
ssh rac2 cat /home/grid/.ssh/id_rsa.pub >>authorized_keys
ssh rac2 cat /home/grid/.ssh/id_dsa.pub >>authorized_keys
ins-06006 test报错
删除root oracle grid 下ssh文件重新启动
安装oracle软件