Oracle 10gR2 RAC再实战

on

这几天又感觉经验值嗖嗖飙升,总算把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

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

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

  1. 木匠 says:

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

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

  2. kamus says:

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

  3. lifekeeper says:

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

  4. kamus says:

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

  5. Joyce says:

    Informative site. Best wishes from California!0

  6. ggf says:

    gsd问题如何解决的,请教下

Leave a Reply

Your email address will not be published. Required fields are marked *