Oracle 10gR2 RAC再实战

这几天又感觉经验值嗖嗖飙升，总算把AIX平台下的Oracle 10gR2 RAC安装了一溜遍，存储总共也就三种类型，ASM或者GPFS或者RAW Device，全部装过了。问题一个接一个，解决了一个接一个，都有些懒的总结了。

1. GSD进程启动失败

2. 进入sqlplus出现下面这个怪现象
$sqlplus / as sysdba
/usr/bin/procmap : no such process : 119472
/usr/bin/procmap : no such process : 119472
/usr/bin/procmap : no such process : 119472

SQL*Plus: Release 10.2.0.3.0 – Production on Wed Jul 18 15:56:21 2007

ERROR:
ORA-12547: TNS:lost contact

Enter user-name:

3. rawutl问题

4. Kernal参数设置问题

5. C编译器版本问题

# /oracle/crs/root.sh
WARNING: directory ‘/oracle’ is not owned by root
Checking to see if Oracle CRS stack is already configured
Checking to see if any 9i GSD is up
/etc/oracle does not exist. Creating it now.

Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory ‘/oracle’ is not owned by root
exec(): 0509-036 Cannot load program crsctl.bin because of the following errors:
0509-130 Symbol resolution failed for crsctl.bin because:
0509-136 Symbol _Getctype__FPCc (number 101) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-136 Symbol _Getnumpunct__FPCc (number 105) is not exported from
dependent module /usr/lib/libC.a[ansi_64.o].
0509-192 Examine .loader section symbols with the
‘dump -Tv’ command.

6. 裸设备损坏

*** 2007-07-19 18:52:06.473
*** SERVICE NAME:() 2007-07-19 18:52:06.470
*** SESSION ID:(2624.1) 2007-07-19 18:52:06.470
ORA-00320: cannot read file header from log 6 of thread 2
ORA-00312: online log 6 thread 2: ‘/dev/rzs_redo2_2_01’
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 7
Additional information: 1
Additional information: -1
ORA-00320: cannot read file header from log 6 of thread 2
ORA-00312: online log 6 thread 2: ‘/dev/rzs_redo2_2_01’
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 7
Additional information: 1
Additional information: -1

7. 内核参数maxuproc设置不足

0403-030 The fork function failed. Too many processes already exist.

6 Comments Add yours

木匠 says:

July 21, 2007 at 1:21 am

明年我们升级硬件, 从 Linux PC Server 到 IBM P 系列, 到时候会有好多问题向你请教.

你干脆把问题汇总成一个册子, 印成书出版.

kamus says:

July 21, 2007 at 4:05 pm

别客气，到时候有问题尽管问。
光总结问题就出书恐怕还是不够的，呵呵。但是预计9月份在OTN会发布一个ppt视频，其中一定会牵涉到RAC安装的问题解决方法。

lifekeeper says:

July 21, 2007 at 7:48 pm

kamus，你好，有个问题要请教一下。
我们这里买了4台P570的小机，准备4台做成一个oracle10g的rac，中间件会按照不同的请求功能号把请求发给不同的节点来处理。我的问题是如果我不使用HACMP（采购费用不菲），直接用CRS＋ASM，在性能上和稳定性上是否会比HACMP差？另外，我们这里是一个OLTP系统，数据量大约在100G，每天的归档日志不会超过10G

kamus says:

July 21, 2007 at 9:45 pm

to lifekeeper
已经给你回了邮件，放心的使用ASM吧。