oracle无法检索环境变量path,RAC环境下oracle用户环境变量问题引起数据库无法启动...

Oracle 10g RAC+ASM

启动node1正常，启动node2发现ASM实例已经启动，但node2的数据库没有启动，

在node2上sqlplus / as sysdba登录数据库

[oracle@rac2 ~]$sqlplus / as sysdba

SQL>startup

ORACLE instance started.

Total System Global Area 184549376 bytes

Fixed Size 1218412 bytes

Variable Size 96471188 bytes

Database Buffers 83886080 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.

数据库可以正常启动，但为什么在启动系统的时候不能自动启动了。

检查node2的alter_+ASM2日志和alter_db2的日志

[@more@]

alter_+ASM2.log错误内容如下：

SQL> ALTER DISKGROUP ALL MOUNT

Wed Jan 20 16:42:35 2010

NOTE: cache registered group DG1 number=1 incarn=0x08e8936f

NOTE: cache registered group RECOVERYDEST number=2 incarn=0x08f89370

Wed Jan 20 16:42:35 2010

Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm2_rbal_9852.trc:

ORA-15183: ASMLIB initialization error [driver/agent not installed]

Wed Jan 20 16:42:35 2010

Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm2_rbal_9852.trc:

ORA-15183: ASMLIB initialization error [/opt/oracle/extapi/32/asm/orcl/1/libasm.so]

ORA-15183: ASMLIB initialization error [driver/agent not installed]

Wed Jan 20 16:42:35 2010

NOTE: Hbeat: instance not first (grp 1)

alter_db2.log错误内容如下：

Starting ORACLE instance (normal)

Cannot determine all dependent dynamic libraries for /proc/self/exe

Unable to find dynamic library libocr10.so in search paths

RPATH = /ade/aime1_build2101/oracle/has/lib/:/ade/aime1_build2101/oracle/lib/:/ade/aime1_build2101/oracle/has/lib/:

LD_LIBRARY_PATH is not set!

The default library directories are /lib and /usr/lib

Unable to find dynamic library libocrb10.so in search paths

Unable to find dynamic library libocrutl10.so in search paths

Unable to find dynamic library libocrutl10.so in search paths

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

日志中提示LD_LIBRARY_PATH未设置，检查node2节点的oracle用户环境变量。

原来是export LD_LIBRARY_PATH写成了LD_LIBARY_PATH，更改过来，重启node2恢复正常。

粗心大意的结果，提醒一下。