oracle 连接不上

[斯赛]

用SqlPlus可以登陆，

PL/SQL登陆不了，Net Configuration Assistant测试连接的时候，像死了一样，不再有任何反应。

tnsping localhost 正常

telnet localhost 1521 正常

昨天还正常的，今天开机就这样了。。。

----------------------
listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = E:\Oracle\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\Oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = E:\Oracle

sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

tnsnames.ora

YFEBKF =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

[斯赛]

补充一下，是11G R2

[tangren]

直接在命令行连接，有何错误提示？

[真的不知道取什么名]

把服务重启下看看

[斯赛]

在命令行连接

出现 Copyright (c)1982,2010,Oracle,All right reserved.
后光标就在那里闪着。

服务重启过了。。

[斯赛]

再补充，命令是不是这样的？
sqlplus username/pwd

这样是可以登录的，前面说不能登录，可能是加了服务名 @servicename

[iihero_]

ORCL没有出现在listener.ora文件的SID_LIST里头啊。所以，你加上服务名肯定不能用
先把它添加进去再说。