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
这是因为 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
但如果我不加这个 / 则不会出错
[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