oracle小问题

[我就是个打字的]

Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:orcl
连接的时候,提示这个错误,今天刚学的oracle,坐等大神求解

[huangdh12]

监听重新配置一下。

[我就是个打字的]

昨天刚装的oracle.应该没问题吧

[huangdh12]

你是用java连接? 试试把 localhost 换成127.0.0.1

或者 参考一下
http://zhidao.baidu.com/question/139871368.html

[我就是个打字的]

刚刚试了试,还是连接不上.
那个网页里也不行,我的是`11g的

[我就是个打字的]

问题解决了,谢谢了
修改listener.ora文件,然后重启服务就ok了

# listener.ora Network Configuration File: D:\app\Administrator\product

\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)
      (PROGRAM = extproc)
    )
 (SID_DESC =
       (GLOBAL_DBNAME = orcl)
       (ORACLE_HOME =  D:\app\Administrator\product\11.1.0\db_1)  
       (SID_NAME = orcl)
      )
   )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )
    )
  )

[Edam]

# listener.ora Network Configuration File: D:\app\Administrator\product

\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)