Oracle 10g RAC sqlplus / as sysdba Connected to an idle instance

刚搭建的rac环境在用sqlplus 连接数据库是报如下情况：

[oracle@rac2 ~]$ export ORACLE_SID=RAC2
[oracle@rac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 4 00:55:19 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

没有连接到数据库，实际上数据库是启动的。

用以下方式就可以连接：
[oracle@rac2 ~]$ sqlplus sys@rac2 as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 4 00:57:24 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

经过一番波折发现原来是安装的rac环境的oracle sid 是小写的

SQL> select instance_name from gv_$instance;

INSTANCE_NAME
----------------
rac1
rac2

当oracle sid换成小写之后问题解决：

[oracle@rac2 ~]$ export ORACLE_SID=rac2
[oracle@rac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 4 00:59:13 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL>

玩了这么多年的oracle，此次居然被其愚弄了一把。哈哈