ASM instance正常启动,但是用sqlplus 连不上的问题

首先,这是oracle 11g 11.0.2.3 版本。这是一个神奇的问题.

asm instance启动正常,但是用sqlplus 去连接的时候会显示如下:

[oracle@racnode1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 6 12:59:28 2013

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

Connected to an idle instance.

SQL> quit
View Code

这是因为 ORACLE_HOME设置错了,只是多加了一个 /

如下所示,如果我设置ORACLE_HOME=/u01/app/11.2.0/grid/ 就会出错

[oracle@racnode1 ~]$ export ORACLE_HOME=/u01/app/11.2.0/grid/
[oracle@racnode1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 6 12:59:28 2013

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

Connected to an idle instance.

SQL> quit
View Code

但如果我不加这个 / 则不会出错

[oracle@racnode1 ~]$ export ORACLE_HOME=/u01/app/11.2.0/grid
[oracle@racnode1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 6 12:59:35 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Real Application Clusters and Automatic Storage Management options

SQL> quit
View Code

 

posted on 2013-09-06 13:07  kramer  阅读(622)  评论(0编辑  收藏  举报

导航