首页 新闻 会员 周边

oracle 连接不上

0
悬赏园豆:100 [已解决问题] 解决于 2010-11-17 13:12

11G R2,windows 2003 ,用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

 

 

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)
    )
  )

 

 

四神的主页 四神 | 初学一级 | 园豆:6
提问于:2010-11-14 20:04
< >
分享
最佳答案
0

把HOST改为计算机名或ip地址试一下

收获园豆:100
贪心狸猫 | 小虾三级 |园豆:872 | 2010-11-17 10:47
重装了,谢谢
四神 | 园豆:6 (初学一级) | 2010-11-17 13:12
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册