 |
| 文件: |
李守亮：Oracle RAC环境部署文档（实际案例）.rar |
| 大小: |
3474KB |
| 下载: |
下载 | |
某报社Oracle RAC环境部署文档
李守亮 2006-09-15
概要：
oracle 10g for Sun Solaris 9，采用ASM方式的部署过程。
目录
一、硬件
二、操作系统
三、网络配置
四、配置系统内核
五、配置oracle环境
六、共享磁盘分区
七、安装oracle cluster
八、安装配置ASM+
九、配置vipca
十、配置ASM（如果增加ASM设备也从该处配置）
十一、建库
十二、最后检查
十三、客户端管理
十四、参考
一、硬件
Sun V490X2，共享阵列，每台2块以上网卡（rac需要两块），接同一交换机
二、操作系统
1、基本环境
SunOS 5.9 + 推荐补丁
2、必需包
# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibm SUNWlibms SUNWsprot SUNWsprox SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt
3、必需补丁
All installations Patches for Solaris 9 (SPARC):
Patches for Solaris 9 (SPARC):
112233-11, SunOS 5.9: Kernel Patch
111722-04, SunOS 5.9: Math Library (libm) patch
4、特殊补丁（不必需）
PL/SQL native compilation, Pro*C/C++, Oracle Call Interface, Oracle C++ Call Interface, Oracle XML Developer's Kit (XDK) :
Patches for Solaris 8 and Solaris 9 (SPARC):
112758-02, dbx 7.1: Patch for S1S8CC Debugger
112760-05, C 5.5: Patch for S1S8CC C compiler
112763-06, Compiler Common S1S8CC: Patch for S1S8CC C C++ F77 F95
113817-03, C++ 5.5: Patch for S1S8CC C++ compiler
113820-02, Compiler Common 7.1: Patch for S1S8CC Math Libraries
113823-03, ILD 4.1: Patch for S1S8CC Incremental Linker
三、网络配置
1、列出系统网卡信息和已经激活的网卡信息
1）列出系统网卡信息
# grep network /etc/path_inst
2）激活的网卡信息
# ifconfig –a
2、激活尚未活动的第二块网卡
db1:
# ifconfig ce1 plumb
# ifconfig ce1 inet 10.10.10.1 netmask 255.255.255.0 up
================================
db2:
# ifconfig ce1 plumb
# ifconfig ce1 inet 10.10.10.2 netmask 255.255.255.0 up
3、配置网络参数文件
db1：
# cat /etc/hosts
#127.0.0.1 localhost
192.168.11.61 db2
192.168.11.60 db1
10.10.10.1 db1_pri
10.10.10.2 db2_pri
192.168.11.58 db1_vip
192.168.11.59 db2_vip
# cat /etc/hostname.ce1
db1_pri
==================================
db2:
# cat /etc/hosts
#127.0.0.1 localhost
192.168.11.61 db2
192.168.11.60 db1
10.10.10.1 db1_pri
10.10.10.2 db2_pri
192.168.11.58 db1_vip
192.168.11.59 db2_vip
# cat /etc/hostname.ce1
db2_pri
注意：
1）ce0为公用网卡，ce1为私有网卡，私有网卡不能和公用网卡在同一网段，vip是oracle rac自动分配，必须和公用网卡在同一网段。
2）oracle 的一个bug。
如果设置的外网的ip地址是10开始或者172.16-172.31或者192.168开始, oracle将会提示这个错误。解决办法：运行完毕root.sh脚本后，手工运行vipca(需要图形界面)
四、配置系统内核
db1:
# cat /etc/system
set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
# sync;sync;reboot
==================================
db2:
做以上同样的操作。
五、配置oracle环境
db1:
1、创建dba组，oracle用户
# groupadd –g 100 dba
# useradd –u 1000 –g dba –d /oracle –m oracle
# passwd oracle
# su - oracle
$ id -a
uid=1000(oracle) gid=100(dba) groups=100(dba)
说明：
因为做rac，两台机器需指定同样的uid和gid
2、配置环境参数
$ cat .profile
umask 022
ORACLE_BASE=/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/app/oracle/product/10.2.0
export ORACLE_HOME
ORACLE_SID=cddb1
export ORACLE_SID
PATH=$ORACLE_HOME/bin:/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/openwin/bin:/usr/dt/bin:/usr/platform/SUNW,Sun-Fire-V490/sbin:/opt/sun/bin:/opt/SUNWexplo/bin:/opt/SUNWsneep/bin:/opt/CTEact/bin
export PATH
说明：
公用的ORACLE_SID为cddb，而rac的每一台的单独ORACLE_SID分别为cddb1和cddb2，后面的数字在dbca建库时程序自动加上，而配置文件里需手工添加。
$ cat .rhosts
+
说明：
用于安装和运行中oracle rac通过rcp rsh等进行同步，设置后需测试r操作是否正常。
=============================
db2:
做以上同样的操作。
六、共享磁盘分区
说明：
由于c4t50060E80004450A1d0, c4t50060E80004450A1d1是共享磁盘，所以只在一台上做就可，做完重启，同步磁盘初始化。
Db1:
1、分区
# format
Searching for disks...done
AVAILABLE DISK SELECTIONS:
0. c1t0d0
1. c1t1d0
2. c4t50060E80004450A1d0
3. c4t50060E80004450A1d1
Specify disk (enter its number): 2
selecting c4t50060E80004450A1d0
[disk formatted]
FORMAT MENU:
disk - select a disk
type - select (define) a disk type
partition - select (define) a partition table
current - describe the current disk
format - format and analyze the disk
repair - repair a defective sector
label - write label to the disk
analyze - surface analysis
defect - defect list management
backup - search for backup labels
verify - read and display labels
save - save new disk/partition definitions
inquiry - show vendor, product and revision
volname - set 8-character volume name
! - execute , then return
quit
format> p
PARTITION MENU:
0 - change `0' partition
1 - change `1' partition
2 - change `2' partition
3 - change `3' partition
4 - change `4' partition
5 - change `5' partition
6 - change `6' partition
7 - change `7' partition
select - select a predefined table
modify - modify a predefined partition table
name - name the current table
print - display the current table
label - write partition map and label to the disk
! - execute , then return
quit
partition> p
Current partition table (original):
Total disk cylinders available: 10920 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 root wm 0 - 5 112.50MB (6/0/0) 230400
1 swap wu 6 - 11 112.50MB (6/0/0) 230400
2 backup wu 0 - 10919 199.95GB (10920/0/0) 419328000
3 unassigned wm 0 0 (0/0/0) 0
4 unassigned wm 0 0 (0/0/0) 0
5 unassigned wm 12 - 17 112.50MB (6/0/0) 230400
6 usr wm 18 - 23 112.50MB (6/0/0) 230400
7 unassigned wm 24 - 10892 199.02GB (10869/0/0) 417369600
db1# init 6
db2#init 6
注意：
1）起始柱面0不要使用；
2）slice 5给ocr用
3）slice 5给vote用
4）slice 7 分配给ASM用。
2、设置权限
db1:
# ls –lL /de/rdsk/ dev/rdsk/c4t50060E80004450A1d0*
# chown oracle:dba /dev/rdsk/c4t50060E80004450A1d0s5
# chown oracle:dba /dev/rdsk/c4t50060E80004450A1d0s6
# chown oracle:dba /dev/rdsk/c4t50060E80004450A1d0s7
# ls –lL /de/rdsk/ dev/rdsk/c4t50060E80004450A1d0*
===================================
db2:
# ls –lL /de/rdsk/ dev/rdsk/c4t50060E80004450A1d0*
# chown oracle:dba /dev/rdsk/c4t50060E80004450A1d0s5
# chown oracle:dba /dev/rdsk/c4t50060E80004450A1d0s6
# chown oracle:dba /dev/rdsk/c4t50060E80004450A1d0s7
# ls –lL /de/rdsk/ dev/rdsk/c4t50060E80004450A1d0*
七、安装oracle cluster
说明：
只在一台机器上做，系统会自动同步到另外一台机器上。假设在db1上。
1、展开介质
# cpio –ivcd <10gr2_cluster_sol.cpio
2、安装cluster
通过xmanger和本地控制台，以oracle用户登陆，进入安装目录，运行
$ ./runInstaller
1）安装程序欢迎界面:
2）指定inventory目录和组:
3）指定HOME路径：
4）安装要求检查：
5）指定Cluster配置：
6）增加另一个节点：
7）再次检查Cluster配置：
8）指定网络接口的使用：
9）指定OCR配置：
10）指定VOTING配置：
11）设定好了所有的信息，准备开始安装：
14. 安装进行中：
15）执行配置脚本：
db1:
# /oracle/oraInventory/orainstRoot.sh
Changing permissions of /oracle/oraInventory to 770.
Changing groupname of /oracle/oraInventory to dba.
The execution of the script is complete
#/oracle/app/oracle/product/crs/root.sh
Checking to see if Oracle CRS stack is already configured
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node
:
node 1: db1 db1-priv db1
node 2: db1 db2-priv db2
Creating OCR keys for user 'root', privgrp 'other'..
Operation successful.
Now formatting voting device: /app/oracle/VOTE/c2t4d0s5
Format of 1 voting devices complete.
Startup will be queued to init within 30 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
db1
CSS is inactive on these nodes.
db2
Local node checking complete.
Run root.sh on remaining nodes to start CRS daemons.
==============================
db2:
# /oracle/oraInventory/orainstRoot.sh
Changing permissions of /oracle/oraInventory to 770.
Changing groupname of /oracle/oraInventory to dba.
The execution of the script is complete#/oracle/app/oracle/product/crs/root.sh
Checking to see if Oracle CRS stack is already configured
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node
:
node 1: db1 db1-priv db1
node 2: db2 db2-priv db2
clscfg: Arguments check out successfully.NO KEYS WERE WRITTEN. Supply -force parameter to override.
-force is destructive and will destroy any previous cluster
configuration.
Oracle Cluster Registry for cluster has already been initialized
Startup will be queued to init within 30 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
Db1
Db2
CSS is active on all nodes.
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
Running vipca(silent) for configuring nodeapps
Creating VIP application resource on (2) nodes...
Creating GSD application resource on (2) nodes...
Creating ONS application resource on (2) nodes...
Starting VIP application resource on (2) nodes...
Starting GSD application resource on (2) nodes...
Starting ONS application resource on (2) nodes...
注意：
如果不是第一次安装，将受到历史配置的影响。解决办法：
#mv /etc/init.d/init.c* /
#mv /var/opt/oracle /var/opt/oracle.init
#ps –ef|grep css
#ps –ef|grep crs
#kill –9 pid
# ps -ef|grep crs
oracle 17601 27479 0 15:43:38 pts/1 0:00 grep crs
oracle 946 945 0 Sep 12 ? 1:08 /oracle/app/oracle/product/crs/bin/ocssd.bin
root 853 777 0 Sep 12 ? 0:00
/oracle/app/oracle/product/crs/bin/oprocd run -t 1000 -m 500 -f
root 603 1 0 Sep 12 ? 2:13 /oracle/app/oracle/product/crs/bin/crsd.bin reboot
oracle 601 1 0 Sep 12 ? 0:00 sh -c sh -c 'ulimit -c unlimited; cd /oracle/app/oracle/product/crs/log/db1/evm oracle 945 944 0 Sep 12 ? 0:00 /bin/sh -c ulimit -c unlimited; cd /oracle/app/oracle/product/crs/log/db1/cssd;
oracle 944 778 0 Sep 12 ? 0:00 sh -c /bin/sh -c 'ulimit -c unlimited; cd /oracle/app/oracle/product/crs/log/db
oracle 810 601 0 Sep 12 ? 0:02 /oracle/app/oracle/product/crs/bin/evmd.bin
oracle 1321 810 0 Sep 12 ? 0:00 /oracle/app/oracle/product/crs/bin/evmlogger.bin -o /oracle/app/oracle/product/oracle 1676 1 0 Sep 12 ? 0:00 /oracle/app/oracle/product/crs/opmn/bin/ons -d
oracle 1677 1676 0 Sep 12 ? 0:00 /oracle/app/oracle/product/crs/opmn/bin/ons -d
# ps -ef|grep css
oracle 946 945 0 Sep 12 ? 1:08 /oracle/app/oracle/product/crs/bin/ocssd.bin
root 602 1 0 Sep 12 ? 3:43 /bin/sh /etc/init.d/init.cssd fatal
root 777 602 0 Sep 12 ? 0:00 /bin/sh /etc/init.d/init.cssd oprocd
oracle 945 944 0 Sep 12 ? 0:00 /bin/sh -c ulimit -c unlimited; cd /oracle/app/oracle/product/crs/log/db1/cssd;
root 778 602 0 Sep 12 ? 0:00 /bin/sh /etc/init.d/init.cssd daemon
oracle 18112 27479 0 15:43:55 pts/1 0:00 grep css
# ls /etc/init.d/init.c*
/etc/init.d/init.crs /etc/init.d/init.cssd /etc/init.d/init.crsd
# ls /var/opt/oracle
ocr.loc oprocd oraInst.loc oratab scls_scr
16）上一步完成之后点击确定之后进行配置：
17）安装完成：
18）最后检查：
db1:
$crs_stat
NAME=ora.db1.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db1
NAME=ora.db1.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db1
NAME=ora.db1.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db1
NAME=ora.db2.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db2
NAME=ora.db2.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db2
NAME=ora.db2.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db2
============================
db2同样。
注意：
成功安装后crs_stat所有状态都是online的。
八、安装配置ASM+
1、解开软件包
cpio –ivcd < 10gr2_db_sol.cpio
2、进入安装目录，运行
$./runInstaller
1）欢迎界面
2）选择企业版
3）选择安装路径
4）选择所有的节点
5）选择ASM方式，输入口令（oracle）
6）选择normal，disk group输入oracle_diskgroup，名字可以自定义
7）输入ASM管理的裸设备路径
8）选择ASM管理的裸设备
前面分区时分给他的/dev/rdsk/c4t50060E80004450A1d07
9）准备安装
10）安装进行并逐项配置
11）分别在db1和db2上以root身份运行root.sh
db1:
# /oracle/app/oracle/product/10.2/root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/oracle/product/10.2
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Creating /usr/local/bin directory...
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /var/opt/oracle/oratab file...
Entries will be added to the /var/opt/oracle/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.
#
===================================
db2:
# /oracle/app/oracle/product/10.2/root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/oracle/product/10.2
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Creating /usr/local/bin directory...
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /var/opt/oracle/oratab file...
Entries will be added to the /var/opt/oracle/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.
12）安装结束
最后检查crs_stat状态：
$ crs_stat
NAME=ora.db1.ASM1.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db1
NAME=ora.db1.LISTENER_DB1.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db1
NAME=ora.db1.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db1
NAME=ora.db1.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db1
NAME=ora.db1.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db1
NAME=ora.db2.ASM2.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db2
NAME=ora.db2.LISTENER_DB2.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db2
NAME=ora.db2.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db2
NAME=ora.db2.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db2
NAME=ora.db2.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on db2
安装全部完成，然后就可以在这个基础上建立数据库了。
注意：
要检查crs_stat所有state均为online状态。
九、配置vipca
注意：
这一步非常重要！这里存在oracle 的一个bug。如果设置的外网的ip地址是10开始或者172.16-172.31或者192.168开始, oracle将会提示这个错误。解决办法：运行完毕root.sh脚本后，手工运行vipca(需要图形界面)
1）以root身份登陆控制台，进入crs/bin目录，运行
# ./vipca
2）欢迎界面
3）选择公网网卡
4）确认vip
5）确认
6）确认
7）确认
十、配置ASM（如果增加ASM设备也从该处配置）
1）以oracle登陆控制台，运行
$ dbca
选择clusters
2）选择config ASM
3）选择所有节点
4）输入ASM认证口令（前面配置过的oracle）
5）配置disk group
6）配置完成，返回或退出
十一、建库
注意：
如果此时前面已配置成功，则每个节点上都有ASM进程存在。
# ps –ef|grep asm
oracle 12425 1 0 12:58:06 ? 0:01 asm_rbal_+ASM1
oracle 12421 1 0 12:58:06 ? 0:00 asm_ckpt_+ASM1
oracle 12419 1 0 12:58:05 ? 0:00 asm_lgwr_+ASM1
oracle 12372 1 0 12:58:05 ? 0:00 asm_pmon_+ASM1
oracle 12427 1 0 12:58:06 ? 0:00 asm_gmon_+ASM1
oracle 12423 1 0 12:58:06 ? 0:00 asm_smon_+ASM1
oracle 12409 1 0 12:58:05 ? 0:01 asm_lmd0_+ASM1
oracle 12407 1 0 12:58:05 ? 0:01 asm_lmon_+ASM1
……
1）以oracle登陆控制台，运行
$ dbca
选择clusters
2）选择建库
3）选择所有节点
4）选择gernal purpose
5）输入oracle_sid
注意：这儿输入cddb，而程序在两个节点上分别自动建为cddb1和cddb2
6）下一步
7）输入口令，下一步
8）选择ASM方式，下一步
9）输入ASM验证口令
10）选择disk group
11）确认
12）确认
13）确认
14）设置taf service_name
15）输入公用servicename
16）选择preferred
17）调整性能，字符集等
18）存储信息确认
19）准备建库
20）最后确认
21）开始建库
22）确认口令书否修改
23）clone到另一节点
十二、最后检查
db1:
1、vip
# ifconfig -a
lo0: flags=1000849 mtu 8232 index 1 inet 127.0.0.1 netmask ff000000
ce0: flags=1000843 mtu 1500 index 2 inet 192.168.11.60 netmask ffffff00 broadcast 192.168.11.255 ether 0:14:4f:1e:88:51
ce0:1: flags=1040843 mtu 1500 index 2 inet 192.168.11.58 netmask ffffff00 broadcast 192.168.11.255
ce1: flags=1000843 mtu 1500 index 3 inet 10.10.10.1 netmask ff000000 broadcast 10.255.255.255 ether 0:14:4f:1e:88:51
红色标注为oracle cluster自动分配的vip
2、ora进程
# ps -ef|grep ora_
oracle 623 1 0 13:45:10 ? 0:00 ora_dbw0_cddb1
oracle 621 1 0 13:45:10 ? 0:04 ora_mman_cddb1
oracle 2630 1 0 14:41:11 ? 0:09 ora_pz96_cddb1
oracle 4661 1 0 14:42:26 ? 0:14 ora_pz95_cddb1
oracle 568 1 0 13:45:09 ? 0:00 ora_pmon_cddb1
oracle 571 1 0 13:45:10 ? 0:00 ora_diag_cddb1
oracle 6075 1 0 14:06:40 ? 0:16 ora_pz97_cddb1
oracle 611 1 0 13:45:10 ? 0:08 ora_lmd0_cddb1
……
3、asm进程
#ps -ef|grep asm
oracle 12425 1 0 12:58:06 ? 0:01 asm_rbal_+ASM1
oracle 12421 1 0 12:58:06 ? 0:00 asm_ckpt_+ASM1
oracle 12419 1 0 12:58:05 ? 0:00 asm_lgwr_+ASM1
oracle 12372 1 0 12:58:05 ? 0:00 asm_pmon_+ASM1
oracle 12427 1 0 12:58:06 ? 0:00 asm_gmon_+ASM1
oracle 12423 1 0 12:58:06 ? 0:00 asm_smon_+ASM1
oracle 12409 1 0 12:58:05 ? 0:01 asm_lmd0_+ASM1
……
4、tnsnames.ora
# cat tnsnames.ora
CDDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db2_vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cddb)
(INSTANCE_NAME = cddb2)
)
)
CDDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1_vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cddb)
(INSTANCE_NAME = cddb1)
)
)
LISTENERS_CDDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1_vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db2_vip)(PORT = 1521))
)
CDDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1_vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db2_vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cddb)
)
)
TAFCDDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1_vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db2_vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tafcddb)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
5、crs_stat全部online
====================================
db2:
1、vip
# ifconfig -a
lo0: flags=1000849 mtu 8232 index 1 inet 127.0.0.1 netmask ff000000
ce0: flags=1000843 mtu 1500 index 2 inet 192.168.11.61 netmask ffffff00 broadcast 192.168.11.255 ether 0:14:4f:1e:4f:77
ce0:1: flags=1040843 mtu 1500 index 2 inet 192.168.11.59 netmask ffffff00 broadcast 192.168.11.255
ce1: flags=1000843 mtu 1500 index 3 inet 10.10.10.2 netmask ff000000 broadcast 10.255.255.255 ether 0:14:4f:1e:4f:77
红色标注为oracle cluster自动分配的vip
2、oracle进程
# ps -ef|grep ora_
oracle 6510 1 0 14:44:46 ? 0:14 ora_pz95_cddb2
oracle 2808 1 0 13:47:33 ? 0:00 ora_psp0_cddb2
oracle 4177 1 0 13:48:20 ? 0:00 ora_q001_cddb2
oracle 4017 1 0 13:48:15 ? 0:00 ora_q000_cddb2
oracle 2818 1 0 13:47:34 ? 0:07 ora_lms1_cddb2
oracle 4454 1 0 14:43:31 ? 0:09 ora_pz96_cddb2
oracle 2806 1 0 13:47:33 ? 0:00 ora_diag_cddb2
oracle 2804 1 0 13:47:33 ? 0:00 ora_pmon_cddb2
……
3、asm进程
#ps -ef|grep asm
oracle 12425 1 0 12:58:06 ? 0:01 asm_rbal_+ASM1
oracle 12421 1 0 12:58:06 ? 0:00 asm_ckpt_+ASM1
oracle 12419 1 0 12:58:05 ? 0:00 asm_lgwr_+ASM1
oracle 12372 1 0 12:58:05 ? 0:00 asm_pmon_+ASM1
oracle 12427 1 0 12:58:06 ? 0:00 asm_gmon_+ASM1
oracle 12423 1 0 12:58:06 ? 0:00 asm_smon_+ASM1
oracle 12409 1 0 12:58:05 ? 0:01 asm_lmd0_+ASM1
……
4、tnsnames.ora
同db1。
5、crs_stat全部online
十三、客户端管理
1、IE管理：
2、oracle 10g client管理：
增加cddb或tafcddb的servicename。
十四：参考
参考oracle 10g rac官方文档：
