Oracle11gR2 RAC添加节点

最新推荐文章于 2024-07-22 20:43:37 发布

cowdeowfq707347470

最新推荐文章于 2024-07-22 20:43:37 发布

阅读量121

点赞数

文章标签：运维数据库操作系统

RHEL5.5 ORACLE11gR2 RAC 2节点

安装操作系统并配置yum源安装oracle所需要的包

点击(此处)折叠或打开

[root@node3 ~]# cat /etc/yum.repos.d/oracle.repo
[server]
name=oracle
baseurl=file:///mnt/Server
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release

配置node3各种参数

修改每个节点的 /etc/hosts

点击(此处)折叠或打开

[root@node3 ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 node3.rac node3 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
#Public
192.168.0.231 node1
192.168.0.232 node2
192.168.0.233 node3
#Virtual
192.168.0.221 node1-vip
192.168.0.222 node2-vip
192.168.0.223 node3-vip
#Private
192.168.8.20 node1-priv
192.168.8.24 node2-priv
192.168.8.27 node3-priv

[root@node3 ~]# /sbin/service ntpd stop
Shutting down ntpd: [FAILED]
[root@node3 ~]# /sbin/service ntpd status
ntpd is stopped
[root@node3 ~]# chkconfig ntpd off
[root@node3 ~]# mv /etc/ntp.conf /etc/ntp.conf.bak

配置系统内核参数，以root用户登录，修改在/etc/sysctl.conf文件，在该文件中添加以下参数
#Install oracle setting
fs.aio-max-nr = 1048576
fs.file-max = 6815744
#kernel.shmall = 4294967296
#kernel.shmmax = 68719476736
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
完成后，运行以下命令激活更改：
[root@rac1 ~]# /sbin/sysctl -p

创建grid和oracle用户，在每一个节点操作
groupadd -g 1000 oinstall
groupadd -g 1020 asmadmin
groupadd -g 1021 asmdba
groupadd -g 1022 asmoper
useradd -u 1100 -g oinstall -G asmadmin,asmdba -c "Grid Infrastructure Owner" grid
groupadd -g 1300 dba
groupadd -g 1301 oper
useradd -u 1101 -g oinstall -G dba,asmdba -c "Oracle Software Owner" oracle
passwd oracle
passwd grid
--创建oracle和grid的Oracle Base目录
mkdir -p /u01/app/11.2.0/grid
mkdir -p /u01/app/grid
chown -R grid:oinstall /u01
mkdir -p /u01/app/oracle
chown oracle:oinstall /u01/app/oracle
chmod -R 775 /u01
--配置grid,oralce用户环境变量
[grid@rac1 ~]$ vi .bash_profile
export PATH
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0/grid
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=+ASM3
umask=022
stty erase ^H
# stty erase ^H 由于终端默认ctrl + backspace 为删除操作很不方便，这样设置后直接backspace就能删除了

[oracle@rac1 ~]$ vi .bash_profile
export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=rac3
umask=022
stty erase ^H

--设置用户资源限制
在文件 /etc/security/limits.conf 加以下参数:

#Install oracle setting
oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile 1024
oracle              hard    nofile 65536
oracle              soft    stack   10240
grid                soft    nproc   2047
grid                hard    nproc   16384
grid                soft    nofile 1024
grid                hard    nofile 65536
grid                soft    stack   10240

配置SSH互信（grid和oracle用户下）

点击(此处)折叠或打开

mkdir 755 .ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
cd .ssh
cat id_rsa.pub id_rsa2.pub id_rsa3.pub id_dsa.pub id_dsa2.pub id_dsa3.pub>>authorized_keys

将节点3关机，配置共享磁盘并安装ASM包

点击(此处)折叠或打开

[root@node3 yum.repos.d]# yum repolist
Loaded plugins: rhnplugin, security
This system is not registered with RHN.
RHN support will be disabled.
repo id repo name status
oracleasm Oracle ASMLib Kernel Drivers for Red Hat Enterprise enabled: 176
server oracle enabled: 3,116
repolist: 3,292
[root@node3 yum.repos.d]#

[root@node3 ~]# rpm -qa|grep oracleasm
oracleasm-2.6.18-194.el5-2.0.5-1.el5
oracleasm-support-2.1.8-1.el5
oracleasmlib-2.0.4-1.el5
[root@node3 ~]#

点击(此处)折叠或打开

[root@node3 ~]# /usr/sbin/oracleasm status
Checking if ASM is loaded: no
Checking if /dev/oracleasm is mounted: no
[root@node3 ~]# /usr/sbin/oracleasm configure -i
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting without typing an
answer will keep that current value. Ctrl-C will abort.
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) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
[root@node3 ~]# /usr/sbin/oracleasm init
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Mounting ASMlib driver filesystem: /dev/oracleasm
[root@node3 ~]# /usr/sbin/oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes
[root@node3 ~]# /usr/sbin/oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "VOL1"
Instantiating disk "VOL2"
Instantiating disk "VOL3"
[root@node3 ~]# /usr/sbin/oracleasm listdisks
VOL1
VOL2
VOL3
[root@node3 ~]#

参考： http://blog.itpub.net/29065182/viewspace-1071584/

已有节点rac1、rac2，下面做的是添加节点rac3

rac3先安装下cvuqdisk包，这个包在GI安装文件中有。
/home/grid/grid/rpm
[root@rac3 rpm]# rpm -ivh cvuqdisk-1.0.9-1.rpm

1.rac3节点添加集群软件GI
①检查rac3是否满足rac安装条件（在已经有节点下面用grid，oracle用户执行）
[root@rac1 ~]# su - grid
[grid@rac1 ~]$ cluvfy stage -pre nodeadd -n rac3 -fixup -verbose
[grid@rac1 ~]$ cluvfy stage -post hwos -n rac3

②添加新节点的软件
在已经有节点下面执行这个命令添加新节点的集群软件（grid用户执行）
[root@rac1 ~]# su - grid
[grid@rac1 ~]$ /app/grid/product/11.2.0/grid/oui/bin/addNode.sh -silent "CLUSTER_NEW_NODES={rac3}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac3-vip}" "CLUSTER_NEW_PRIVATE_NODE_NAMES={vrh3-priv}" #用grid用户执行
运行提示的root.sh脚本
/app/oraInventory/orainstRoot.sh #在新节点 rac3用root用户执行
/app/grid/product/11.2.0/grid/root.sh #在新节点rac3用root用户执行
#On nodes rac3#在节点 rac3用root用户执行#在节点 rac3用root用户执行

③验证集群软件是否添加成功
[grid@rac1 bin]$ cluvfy stage -post nodeadd -n rac3 -verbose

2.添加新节点数据库
①为新节点安装数据库软件（在已经有节点下用oracle用户执行）
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ /app/oracle/product/11.2.0/db_1/oui/bin/addNode.sh -silent "CLUSTER_NEW_NODES={rac3}"
运行提示的root.sh脚本
    #在新节点 rac3用root用户执行
  /app/oracle/product/11.2.0/db_1/root.sh

②添加实例
[oracle@rac1 ~]$ dbca
或用命令行直接添加实例（在已经有节点下面用oracle用户执行）
[oracle@rac1 ~]$ dbca -silent -addInstance -nodeList rac3 -gdbName orcl -instanceName orcl3 -sysDBAUserName sys -sysDBAPassword "***" 在oracle用户下面执行

3.验证已添加实例
查看活动的实例：
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL> select thread#,status,instance from gv$thread;

[root@rac1 ~]# crs_stat -t
[root@rac1 ~]# crsctl status resource -t

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30305095/viewspace-2121123/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30305095/viewspace-2121123/