oracle进程都启来了，sqlplus 显示是idle instance

今天碰到一个比较郁闷的问题，通过第三方备份软件恢复数据库后，查看进程显示oracle是起来的：

oracle    6661     1  0 17:09 ?        00:00:00 ora_pmon_orcl

oracle    6663     1  0 17:09 ?        00:00:00 ora_psp0_orcl

oracle    6665     1  0 17:09 ?        00:00:00 ora_mman_orcl

oracle    6667     1  0 17:09 ?        00:00:00 ora_dbw0_orcl

oracle    6669     1  0 17:09 ?        00:00:00 ora_lgwr_orcl

oracle    6671     1  0 17:09 ?        00:00:00 ora_ckpt_orcl

oracle    6673     1  0 17:09 ?        00:00:00 ora_smon_orcl

oracle    6675     1  0 17:09 ?        00:00:00 ora_reco_orcl

oracle    6677     1  0 17:09 ?        00:00:00 ora_cjq0_orcl

oracle    6679     1  0 17:09 ?        00:00:00 ora_mmon_orcl

oracle    6681     1  0 17:09 ?        00:00:00 ora_mmnl_orcl

oracle    6683     1  0 17:09 ?        00:00:00 ora_d000_orcl

oracle    6685     1  0 17:09 ?        00:00:00 ora_s000_orcl

oracle    6693     1  0 17:09 ?        00:00:00 ora_p000_orcl

oracle    6695     1  0 17:09 ?        00:00:00 ora_p001_orcl

oracle    6697     1  0 17:09 ?        00:00:00 ora_qmnc_orcl

oracle    6699     1  0 17:09 ?        00:00:00 ora_j000_orcl

oracle    6701     1  0 17:09 ?        00:00:00 ora_j001_orcl

oracle    6703     1  0 17:09 ?        00:00:00 ora_j002_orcl

oracle    6705     1  0 17:09 ?        00:00:00 ora_j003_orcl

oracle    6711     1  0 17:09 ?        00:00:00 ora_q000_orcl

oracle    6713     1  0 17:09 ?        00:00:00 ora_q001_orcl

oracle    6719  6599  0 17:10 pts/2    00:00:00 ps -ef

oracle    6720  6599  0 17:10 pts/2    00:00:00 grep ora

然后通过sqlplus / as sysdba进去，显示是idle instance

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 11 17:10:31 2012

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

Connected to an idle instance.

SQL> conn sys/123 as sysdba

Connected to an idle instance.

SQL> conn / as sysdba

Connected to an idle instance.

但是使用下面一种方式可以：

SQL> conn sys/123@orcl as sysdba

Connected.

这就比较郁闷了：

后面有人说是环境变量的问题，我仔细检查。没检查出什么问题：

PATH=$PATH:$HOME/bin

export PATH

unset USERNAME

ORACLE_BASE=/app/oracle/

ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

ORACLE_SID=orcl

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

LD_LIBARY_PATH=$ORACLE_HOME/lib:/usr/lib

export PATH

export ORACLE_BASE ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBARY_PATH

最后和其他主机数据库环境变量做比较，发现ORACLE_BASE后面多了一条斜线。

去掉之后，重新连接，OK了，比较不解，记录一下。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22418990/viewspace-723381/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22418990/viewspace-723381/