首页 > 数据库 > Oracle > oracle 11g rac安装
1.安装验证:
./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -fixup –verbose
2.修改主机名:
/etc/sysconfig/network文件中:
hostname=red5-2
/etc/hosts中:
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.1.105 red5-1
192.168.1.117 red5-2
192.168.1.115 red5-1-vip
192.168.1.116 red5-2-vip
10.10.1.5 red5-1-priv
10.10.1.6 red5-2-priv
192.168.1.234 rac-scan.lzf.com rac-scan
3.修改IP(eth0 为bridge,eth1为host only)
/etc/sysconfig/network-scripts/ifcfg-eth0 中修改为:
DEVICE=eth0
BOOTPROTO=static
ONBOOT=yes
HWADDR=08:00:27:12:bb:45
IPADDR=192.168.1.117
/etc/sysconfig/network-scripts/ifcfg-eth1 中修改为:
DEVICE=eth1
BOOTPROTO=static
ONBOOT=yes
HWADDR=08:00:27:b8:7f:ca
IPADDR=10.10.1.6
4 ./etc/sysconfig/iptables中最前面添加(最好关闭):
-A RH-Firewall-1-INPUT -p tcp -m multiport --dport 22,53,1521 -j ACCEPT
5.创建oinstall、dba组,oracle用户,设置oracle用户密码:
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
6. /etc/sysctl.conf中添加:
kernel.shmall = 4294967296
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 1048576
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
fs.file-max = 6815744
添加后执行命令sysctl -p 生效。
/etc/security/limits.conf中添加:
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
/etc/pam.d/login中添加:
session required /lib64/security/pam_limits.so
session required pam_limits.so
/etc/profile中添加:
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
7.
mkdir /u01
chown oracle:oinstall /u01
8.
mkdir ~/.ssh
chmod 700 ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
cat id_rsa.pub >>authorized_keys
cat id_dsa.pub >>authorized_keys
scp authorized_keys red5-2:/home/oracle/.ssh
9.分区
fdisk /dev/sdb
fdisk /dev/sdc
fdisk /dev/sdd
10. 两个节点分别执行:
/etc/init.d/oracleasm configure
节点1执行:/etc/init.d/oracleasm createdisk 11 /dev/sdb1
节点2执行: /etc/init.d/oracleasm scandisks
11 安装 grid 选install and configure grid infrastructure for a cluster
选custom
oracle base 不是真正的ORACLEBASE,指定oracle base/grid/11.2
software location 不是真正ORACLE软件路径:是GRID路径指定oracle base/crs不能与前一个路径相同
12 执行asmca 创建ASM
13 安装数据库软件 选 install database software only
14 dbca 创建集群数据库:选oracle real application clusters database
选create a database
选custom database
dbca创建数据库时报节点2以下错误:
出现ORA-01034和ORA-27101的原因是多方面的:主要是oracle当前的服务不可用,shared memory realm does not exist,是因为oracle没有启动或没有正常启动,共享内存并没有分配给当前实例.所以,通过设置实例名,再用操作系统身份验证的方式,启动数据库。这样数据库就正常启动了,就不会报ORA-01034和ORA-27101两个启动异常了。
解决方法(在节点2启动数据库):
节点2执行:set ORACLE_SID=RAC
sqlplus / as sysdba
startup;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9569516/viewspace-2060771/ ,如需转载,请注明出处,否则将追究法律责任。