oracle10grac - install - foraix - 图文

前言

本文档基于AIX5.3安装两个节点的oracle(10.2.0.1)RAC

RAC规划

主机的硬件和软件配置

主机名：db01/ db02 OS版本：AIX 5300-05 HA软件：HACMP 5.2

共享VG：datavg(位于共享存储)

网卡: En8 作为公网接口，En9 作为私网接口 Oracle版本: 10.2.0.1.0

IP地址规划

IP地址 10.201.2.102 172.16.100.1 10.201.2.104 10.201.2.103 172.16.100.2 10.201.2.105 域名 db01 db01_priv db01_vip db02 db02_priv db02_vip 说明 第一个节点的public ip 第一个节点的private ip 第一个节点的virtual ip 第二个节点的public ip 第二个节点的private ip 第二个节点的virtual ip NTP服务

在两个节点上配置指向同一个NTP Server的NTP Client或者两个节点互相做NTP Server和NTP Client.

选择存储类型

使用raw device 存储数据

安装RAC前的准备工作

安装需要的AIX补丁

安装fix 包所需补丁(到IBM 网站上下载补丁)：

本文档所使用的版本 AIX 5305，HACMP 5.2 只需要打一个hamcp 的补丁 IY60759 即可。

安装oracle、hacmp 支持包

# smitty installp 需要安装以下操作系统包： Bos.adt bos.cifs_fs Bos.clvm bos.compat bos.data Bos.perf rsct.basic rsct.compat.basic rsct.compat.clients rsct.core

rsct.exp.cimrm 2.4.2.0

（以下包在AIX Toolbox for Linux Applications 盘上，安装SSH 的前提包） openssl-0.9.7g openssl-devel-0.9.7g openssl-doc-0.9.7g （以下包在扩展盘上） openssh.base openssh.license openssh.man.en_US xlC.aix50.rte:8.*.*.* xlC.rte:8.*.*.*

配置AIX 修改hosts文件

# more /etc/hosts

127.0.0.1 loopback localhost # loopback (lo0) name/address 10.201.2.102 db01

172.16.100.1 db01_priv 10.201.2.104 db01_vip 10.201.2.103 db02 172.16.100.2 db02_priv 10.201.2.105 db02_vip 需要注意的是 ? ? ? ? ?

私有 IP 地址（必需与公网分离,两个节点可互相访问可以ping 通,必须在/etc/hosts 里有） 虚拟 IP 地址（同公网IP 地址是一个网段的，如果有DNS 就注册在DNS 中，如果没有DNS 就写在/etc/hosts 文件里）

公网 IP 地址（主机真正的IP 地址，主机管理员预先分配，如果有DNS 就注册在DNS 中，如果没 有DNS 就写在/etc/hosts 文件里），并且保证写入每个客户系统中的hosts 文件。

在各个节点的网卡配置必须相同，比如第一个节点公共 IP 是用en0，那么其他节点也得用en0 主机名称不允许出现大写字母，要求是小写字母和数字

?

调整swap

默认的 swap 为512M 修改pagesize，建议swap为物理内存大小：

Smitty->system storage management->logical volume manager->paging size->change/show characteristics of a paging size

调整AIX的相关系统参数

# smitty chgsys

Maximum number of PROCESSES allowed per user [4096] HIGH water mark for pending write I/Os per file [33] LOW water mark for pending write I/Os per file [24] Stack Execution Disable (SED) Mode off

调整AIX网络参数

修改文件/etc/rc.net，将如下几行加到文件的尾部： #chmod 755 /etc/rc.net #vi /etc/rc.net

if [ -f /usr/sbin/no ] ; then

/usr/sbin/no -o extendednetstats=0 >>/dev/null 2>&1 /usr/sbin/no -p -o udp_sendspace=65536 /usr/sbin/no -p -o udp_recvspace=655360 /usr/sbin/no -p -o tcp_sendspace=65536 /usr/sbin/no -p -o tcp_recvspace=65536 /usr/sbin/no -p -o rfc1323=1 /usr/sbin/no -p -o sb_max=1310720 /usr/sbin/no -r -o ipqmaxlen=512

Fi

#chmod 554 /etc/rc.net

设置异步I/O

# smitty chgaio [Entry Fields]

MINIMUM number of servers [30] # MAXIMUM number of servers [60] # maximum number of REQUESTS [4096] # server PRIORITY [39] #

STATE to be configured at system restart available + ORACLE 10G RAC 参考手册 7

State of fast path enable + # mkdev –l aio0 使异步I/O 可用

Oracle相关配置

创建oracle账号和组

创建oinstall、dba、hagsuser 组

建议使用 smitty 添加组(设置三个组的id，如2.2.2 的步骤所示) 或者如下命令

# mkgroup -'A' id='203' oinstall # mkgroup -'A' id='204'dba # mkgroup -'A' id='205'hagsuser

创建oracle 用户

1、使用 smit 来创建用户

Smit -> Security & Users -> Users -> Add a User 或者快速路径 # smitty mkuser Add a User

Type or select values in entry fields. Press Enter AFTER making all desired changes. * User NAME [oracle] User ID [440]

Primary GROUP [oinstall] Group SET [dba,hagsuser]

Soft FILE size [-1] Soft CPU time [-1] Soft DATA segment [-1] Soft STACK size [-1]

PS:保证两台主机的组号要一致！ # more /etc/group oinstall203: dba204: hagsuser205: # id oracle

uid=440(oracle) gid=203(oinstall) groups=204(dba),205(hagsuser)

创建LV

创建lv的工作由系统管理员完成,我们只要列出每个lv的大小和名称就可以了. 创建datavg: # hostname db01

ORACLE 10G RAC 参考手册 10

#

# smitty mkvg

",Add a Big Volume Group

Type or select values in entry fields. Press Enter AFTER making all desired changes. [Entry Fields]

VOLUME GROUP name [datavg] +

Physical partition SIZE in megabytes 512 * PHYSICAL VOLUME names [hdisk2,hdisk3] + Force the creation of a volume group yes + Activate volume group AUTOMATICALLY no + at system restart?

Volume Group MAJOR NUMBER [60]

Create VG Concurrent Capable? enhanced concurrent +

PS：确认所有卷组必须以 concurrent 模式被激活，两个节点可以同时对磁盘进行操作. # varyonvg datavg

创建 oracle 使用的并行卷

使用下面命令。或者将如下命令便写成一个脚本然后执行。后面的partition size 的个数请参 考自己系统的情况。

mklv -y'rac_crs1024m' -w'n' -s'n' -r'n' datavg 2 hdisk2 mklv -y'rac_vote1024m' -w'n' -s'n' -r'n' datavg 2 hdisk2 mklv -y'rac_system_1024m' -w'n' -s'n' -r'n' datavg 4 hdisk2 mklv -y'rac_pwdfile_100m' -w'n' -s'n' -r'n' datavg 1 hdisk2

mklv -y'rac_sysaux_800m' -w'n' -s'n' -r'n' datavg 4 hdisk2 mklv -y'rac_undo1_4096m' -w'n' -s'n' -r'n' datavg 16 hdisk2 mklv -y'rac_undo2_4096m' -w'n' -s'n' -r'n' datavg 16 hdisk2 mklv -y'rac_temp_4096m' -w'n' -s'n' -r'n' datavg 16 hdisk2 mklv -y'rac_users_800m' -w'n' -s'n' -r'n' datavg 4 hdisk2 mklv -y'rac_redo1_1_120m' -w'n' -s'n' -r'n' datavg 2 hdisk2 mklv -y'rac_redo1_2_120m' -w'n' -s'n' -r'n' datavg 2 hdisk2 mklv -y'rac_redo1_3_120m' -w'n' -s'n' -r'n' datavg 2 hdisk2 mklv -y'rac_redo2_1_120m' -w'n' -s'n' -r'n' datavg 2 hdisk2 mklv -y'rac_redo2_2_120m' -w'n' -s'n' -r'n' datavg 2 hdisk2 mklv -y'rac_redo2_3_120m' -w'n' -s'n' -r'n' datavg 2 hdisk2 mklv -y'rac_ctl1_100m' -w'n' -s'n' -r'n' datavg 1 hdisk2 mklv -y'rac_ctl2_100m' -w'n' -s'n' -r'n' datavg 1 hdisk2 mklv -y'rac_ctl3_100m' -w'n' -s'n' -r'n' datavg 1 hdisk2 mklv -y'rac_spfile_100m' -w'n' -s'n' -r'n' datavg 1 hdisk2 ORACLE 10G RAC 参考手册 11

通过 mklv 命令创建完lv 后，会在/dev/下生成两个文件，比如：

# mklv -y'rac_spfile_100m' -w'n' -s'n' -r'n' datavg 1 hdisk2

那么在/dev/下会生成两个文件

/dev/rac_spfile_100m /dev/rrac_spfile_100m

前面多了一个r 的文件就是我们要使用的character devices。 也就是我们通常所说的裸设备。 ", 在另外一个节点上 import 共享卷 # hostname db02 # smitty vg

Volume Groups

Move cursor to desired item and press Enter. ", Import a Volume Group Import a Volume Group

Type or select values in entry fields. Press Enter AFTER making all desired changes. [Entry Fields]

VOLUME GROUP name [datavg]

* PHYSICAL VOLUME name [hdisk2,hdisk3] + Volume Group MAJOR NUMBER [60] +#

修改共享卷的属性（建议两台主机都要做） # varyonvg datavg

# chown oracle:dba /dev/rrac_* # varyoffvg datavg

配置ssh

在所有节点配置SSH 的对等性

在安装 Oracle Real Application clusters 之前,必须先配置所有节点的SSH 对等性。因为在安装

过程种Oracle Universal Installer 使用ssh 和scp 命令执行远程命令执行及copy 的工作。 下面是具体的步骤：

以下步骤在所有节点上执行： 1.以oracle 用户登陆

# su – oracle

2.在两个节点的oracle 主目录分别创建.ssh 目录，并赋予权限。

# mkdir ~/.ssh

# chmod 755 ~/.ssh

3. 在两个节点分别生成RSA key # /usr/bin/ssh-keygen -t rsa 会出现如下提示:

■ Accept the default location for the key file.

■ Enter and confirm a pass phrase that is different from the oracle user’s password. phrase

密码处直接回车即可

4. 生成DSA key

# /usr/bin/ssh-keygen -t dsa 出现如下提示:

■ Accept the default location for the key file.

■ Enter and confirm a pass phrase that is different from the oracle user’s password. phrase

密码处直接回车即可

5. 以oracle 用户身份，在所有节点创建authorized_keys 文件，并赋予权限 # touch ~/.ssh/authorized_keys # cd ~/.ssh

# ls

你应该可以看到你所创建的id_dsa.pub 和id_rsa.pub 和authorized_keys 6.在两个节点分别将id_dsa.pub 和id_rsa.pub 加入到authorized_keys 节点 1：

$ ssh db01 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys $ ssh db01 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys $ ssh db02 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys $ ssh db02 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys 节点2：

$ ssh db02 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys $ ssh db02 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys $ ssh db01 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys $ ssh db01 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys

PS：如果提示是否连接选择yes，密码输入oracle 用户的密码 7.在每个节点上分别设置authorized_keys 文件的权限

# chmod 644 ~/.ssh/authorized_keys

8.防止X11 转发造成的安装失败,创建~ /.ssh/config，并加入如下内容。 Host *

ForwardX11 no

9.以oracle 用户身份，运行Oracle Universal Installer 的节点上执行如下命令，然后测试ssh 的对等性。

# exec /usr/bin/ssh-agent $SHELL 节点1

# ssh db01 date # ssh db02 date 节点2

# ssh db02 date

# ssh db01 date

如果都不需要密码，得到时间后。就说明ssh 对等性配置成功。

安装oracle软件

安装crs

1.执行rootpre.sh

# cd clusterware/rootpre # ./rootpre.sh

./rootpre.sh output will be logged in /tmp/rootpre.out_07-03-15.11:01:09 Saving the original files in /etc/ora_save_07-03-15.11:01:09.... Copying new kernel extension to /etc.... Loading the kernel extension from /etc Oracle Kernel Extension Loader for AIX Copyright (c) 1998,1999 Oracle Corporation

Successfully loaded /etc/pw-syscall.64bit_kernel with kmid: 0x3f14e00 Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x3f14e00 The kernel extension was successfuly loaded. Configuring Asynchronous I/O.... Asynchronous I/O is already defined Configuring POSIX Asynchronous I/O....

Checking if group services should be configured....

Please confirm your Oracle userid is a member of the group: hagsuser Configuring HACMP group services socket for possible use by Oracle.

PS:注意rootpre.sh 需要在两个节点都运行。

2.确保HACMP 集群已经在db01 和db02 上已经启动。 在两个节点执行 # smitty clstart # lssrc -g cluster 3.创建目录：

mkdir -p /opt/app/oracle

chown oracle:oinstall /opt/app/oracle

4.在两个节点分别设置oracle 用户的环境变量 # su - oracle $ vi ~oracle/.profile

ORACLE_BASE=/opt/app/oracle export ORACLE_BASE

5.执行ssh 对等命令

$ exec /usr/bin/ssh-agent $SHELL 6.设置display

$ export DISPLAY=10.201.2.110:0 7.运行runInstaller

$ /mnt/clusterware/runInstaller

**************************************************************************

Your platform requires the root user to perform certain pre-installation OS preparation. The root user should run the shell script 'rootpre.sh' before you proceed with Oracle installation. rootpre.sh can be found at the top level of the CD or the stage area. Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle installation.

Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.

************************************************************************** Has 'rootpre.sh' been run by root? [y/n] (n) y

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed. Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-03-15_03-21-44PM. Please wait ...

Oracle Universal Installer, Version 10.2.0.1.0 Production Copyright (C) 1999, 2005, Oracle. All rights reserved. 进入安装界面，点击下一步

设置 inventory 目录及信任组，点击下一步

设置crs 的主目录，点击下一步

检查安装环境

指定cluster 的配置。点击Edit 修改VIP 的配置。保证和/etc/hosts 中一致

修改网络接口的设置。点击 Edit 编辑

指定OCR 的位置。如下图

指定 Voting Disk，如下图：

显示综合信息，点击install 开始安装

最后执行下面两个脚本。

先执行/opt/app/oracle/oraInventory/orainstRoot.sh 然后执行root.sh

Node 1:

# /opt/app/oracle/oraInventory/orainstRoot.sh

Changing permissions of /opt/app/oracle/oraInventory to 775. Changing groupname of /opt/app/oracle/oraInventory to oinstall. The execution of the script is complete

Node 2:

# /opt/app/oracle/oraInventory/orainstRoot.sh

Changing permissions of /opt/app/oracle/oraInventory to 775. Changing groupname of /opt/app/oracle/oraInventory to oinstall. The execution of the script is complete

Node 1:

# /opt/app/oracle/crs/root.sh

WARNING: directory '/opt/app/oracle/crs' is not owned by root WARNING: directory '/opt/app/oracle/crs' is not owned by root WARNING: directory '/opt/app/oracle' is not owned by root WARNING: directory '/opt/app' 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 '/opt/app/oracle/crs' is not owned by root WARNING: directory '/opt/app/oracle/product' is not owned by root WARNING: directory '/opt/app/oracle' is not owned by root WARNING: directory '/opt/app' is not owned by root Successfully accumulated necessary OCR keys.

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

node : node 3: db01 db01_priv db01 node 4: db02 db02_priv db02

Creating OCR keys for user 'root', privgrp 'system'.. Operation successful.

Now formatting voting device: /dev/rrac_vote1024m Format of 1 voting devices complete.

Startup will be queued to init within 30 seconds. Adding daemons to inittab Adding daemons to inittab

Expecting the CRS daemons to be up within 600 seconds. CSS is active on these nodes. db01

CSS is inactive on these nodes. db02

Local node checking complete.

Run root.sh on remaining nodes to start CRS daemons.

Node 2:

# /opt/app/oracle/crs/root.sh

WARNING: directory '/opt/app/oracle/crs' is not owned by root WARNING: directory '/opt/app/oracle/product' is not owned by root WARNING: directory '/opt/app/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

Setting the permissions on OCR backup directory Setting up NS directories

Oracle Cluster Registry configuration upgraded successfully WARNING: directory '/opt/app/oracle/crs' is not owned by root WARNING: directory '/opt/app/oracle/product' is not owned by root WARNING: directory '/opt/app/oracle' is not owned by root 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 3: db01 db01_priv db01

node 4: db02 db02_priv db02

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 Adding daemons to inittab

Expecting the CRS daemons to be up within 600 seconds. CSS is active on these nodes. db01 db02

CSS is active on all nodes.

Waiting for the Oracle CRSD and EVMD to start

Oracle CRS stack installed and running under init(1M) Running vipca(silent) for configuring nodeapps

The given interface(s), \is not public. Public interfaces should be used to configure virtual IPs.

此时，在运行OUI 的节点上以root 身份在/opt/app/oracle/crs/bin 下运行vipca

# ./vipca

选择你运行VIP 的网络接口

然后设置 VIP

启动VIP

启动成功以后出现统计信息。点击完成

然后回到这个界面点击OK

然后点击next 安装完成

CRS 安装完毕。检查crs状态 # su - oracle

$ /opt/app/oracle/crs/bin/crs_stat -t Name Type Target State Host

------------------------------------------------------------ ora.db01.gsd application ONLINE ONLINE db01 ora.db01.ons application ONLINE ONLINE db01 ora.db01.vip application ONLINE ONLINE db01 ora.db02.gsd application ONLINE ONLINE db02 ora.db02.ons application ONLINE ONLINE db02 ora.db02.vip application ONLINE ONLINE db02

安装rdbms

1.在两个节点设置环境变量 # su - oracle # vi .profile

export ORACLE_BASE=/opt/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

$./database/runInstaller

**************************************************************************

Your platform requires the root user to perform certain pre-installation OS preparation. The root user should run the shell script 'rootpre.sh' before you proceed with Oracle installation. rootpre.sh can be found at the top level of the CD or the stage area. Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle installation.

Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.

************************************************************************** Has 'rootpre.sh' been run by root? [y/n] (n) y

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed. Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-03-15_04-54-25PM. Please wait ...

启动安装界面，点击下一步

选择安装类型，选择企业版，另外在 product languages，可以将中文加入

设置 oracle 主目录，按默认即可

选择 cluster installation，选择所有的节点。

进行先决条件检查

选择只安装数据库软件，然后我们单独建库。

现实统计信息

安装过程

在两个节点执行 root.sh

Node 1：

# /opt/app/oracle/product/10.2.0/db_1/root.sh

Running Oracle10 root.sh script...

The following environment variables are set as: ORACLE_OWNER= oracle

ORACLE_HOME= /opt/app/oracle/product/10.2.0/db

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 /etc/oratab file...

Entries will be added to the /etc/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.

Node 2：

# /opt/app/oracle/product/10.2.0/db_1/root.sh

Running Oracle10 root.sh script...

The following environment variables are set as: ORACLE_OWNER= oracle

ORACLE_HOME= /opt/app/oracle/product/10.2.0/db

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 /etc/oratab file...

Entries will be added to the /etc/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.. 执行完root.sh 后回到上一个界面点击OK

安装结束。点击退出

建数据库

1.分别在每个节点设置环境变量 # su – oracle # vi .profile

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:. export PATH

if [ -s \then echo \fi # periodically.

export ORACLE_BASE=/opt/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export ORA_CRS_HOME=$ORACLE_BASE/crs

# 每个节点要有自己的实例名（比如在第一个节点上racdb1，第二个节点上racdb2） export ORACLE_SID=racdb1

export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin export TNS_ADMIN=$ORACLE_HOME/network/admin export NLS_LANG=\

2.规划数据库建在raw 卷上

使用 find 命令得到裸设备的名称。

# find /dev -user oracle -name 'r*' -print > db_raw.conf 然后编辑文件 db_raw.conf

system=/dev/rrac_system_1024m sysaux=/dev/rrac_sysaux_800m users=/dev/rrac_users_800m temp=/dev/rrac_temp_4096m undotbs1=/dev/rrac_undo1_4096m undotbs2=/dev/rrac_undo2_4096m redo1_1=/dev/rrac_redo1_1_120m redo1_2=/dev/rrac_redo1_2_120m redo2_1=/dev/rrac_redo2_1_120m redo2_2=/dev/rrac_redo2_2_120m control1=/dev/rrac_ctl1_100m control2=/dev/rrac_ctl2_100m spfile=/dev/rrac_spfile_100m pwdfile=/dev/rrac_pwdfile_100m

$ export DISPLAY=10.201.2.110:0 $ exec /usr/bin/ssh-agent $SHELL

$ export DBCA_RAW_CONFIG=db_raw.conf $ dbca

进入到建库的界面

选择创建一个数据库

选择在两个结点上创建

选择一个模板。我们这次选择通用的模板

键入全局数据库名和 SID Prefix。

启用EM

设置密码

选择存储部分，我们选择裸设备，会自动选择到 db_raw.conf 文件

启动归档，同时设置归档路径。

创建 sample schema。默认即可。

配置数据库的 services，选择add 添加一个services，我们选择racdb 其他选项如图

配置初始化参数。如下：

字符集要注意选择。 我们选择ZHS16GBK

选择数据库存储，点击 next （RAC 默认的redolog 组为4 组，每个thread 两组，通常我们 会在创建RAC 后再添加redolog。）

选择 finish

安装完毕，点击 exit，启动cluster 服务

有时在启动cluster 服务过程中可能会报两个错误。

这个原因可能是因为

SRVCTL fails to startup instance, due to connection to racgimon killed by NS after 10s

具体可查看metalink Note:402437.1

我们需要做的是在sqlnet.ora 中加入如下参数：

sqlnet.inbound_connect_timeout = 600

然后，我们在使用如下命令来查看现有的服务。 $ crs_stat -t

Name Type Target State Host

------------------------------------------------------------ ora.oradb.db application ONLINE ONLINE db01 ora....radb.cs application ONLINE ONLINE db01 ora....db1.srv application ONLINE ONLINE db01 ora....db2.srv application ONLINE ONLINE db02 ora....b1.inst application ONLINE ONLINE db01 ora....b2.inst application ONLINE ONLINE db02 ora....C1.lsnr application ONLINE ONLINE db01 ora.db01.gsd application ONLINE ONLINE db01 ora.db01.ons application ONLINE ONLINE db01 ora.db01.vip application ONLINE ONLINE db01 ora....C2.lsnr application ONLINE ONLINE db02 ora.db02.gsd application ONLINE ONLINE db02 ora.db02.ons application ONLINE ONLINE db02 ora.db02.vip application ONLINE ONLINE db02

至此，我们的oracle 10G RAC 安装成功。

安装过程中意外处理

安装crs失败后如何彻底删除crs

第一种方法，通过CRS 提供的脚本来删除。

首先，运行$ORA_CRS_HOME/install 目录下的 rootdelete.sh 运行完毕后，再运行 rootdeinstall.sh 这执行完这两个脚本之后，就可以干净的删除安装失败的CRS。

第二种方法，我们手工去删除CRS。因为有些情况这两个脚本可能会没有，或者有问题。 那么我们手工删除的步骤如下： 1、停止所有节点上的Nodeapps：

$ srvctl stop nodeapps -n

2、防止CRS 自动跟随着节点的启动。我们需要以root 身份来执行如下的操作来去掉CRS 相关的自动启动的文件

# rm /etc/init.cssd # rm /etc/init.crs # rm /etc/init.crsd # rm /etc/init.evmd

# rm /etc/rc.d/rc2.d/K96init.crs # rm /etc/rc.d/rc2.d/S96init.crs # rm -Rf /etc/oracle/scls_scr

# rm -Rf /etc/oracle/oprocd # rm /etc/inittab.crs

# cp /etc/inittab.orig /etc/inittab

3、再一次确认crs 相关的三个进程是否还存在，如果存在就将他们kill 掉或者reboot 节点。

# ps -ef | grep crs # kill # ps -ef | grep evm # kill # ps -ef | grep css # kill

PS：不要kill 任何OS 的进程比如icssvr_daemon。

4、如果在节点上没有其他的oracle 软件运行，如果listener、DB 等。你可以删除/var/tmp/.oracle 和 /tmp/.oracle.

# rm -f /var/tmp/.oracle # rm -f /tmp/.oracle

5、然后删除/etc/oracle 目录下的ocr.loc

# rm -f /etc/oracle/ocr.loc

6、使用OUI 删除CRS Home。 7、删除CRS 安装目录。

# rm -Rf /*

8、如果你使用的是裸设备，那么使用dd 命令清空OCR 和Voting：

# dd if=/dev/zero of=/dev/rrac_vote1024m bs=8192 count=2560 # dd if=/dev/zero of=/dev/rrac_crs1024m bs=8192 count=12800

如果你的将OCR 和voting disk 放置在shared filesystem 上，那么将他们删除。 如果你使用ASM，那么在你删除数据库的安装的时候，你也必须清空ASM 的disks 9、这个时候就可以安装RAC 的安装手册来重新安装了 PS：该方法参考Metalink Note:239998.1

本文来源：https://www.bwwdw.com/article/cyoo.html