当前位置: 代码迷 >> Oracle技术 >> ORA 12505 异常信息
  详细解决方案

ORA 12505 异常信息

热度:1091   发布时间:2016-04-24 08:43:39.0
ORA 12505 错误信息
各位先辈们,帮下小弟!
我的Oracle 11g用CMD下的sqlplus可以连接成功,但是用Oracle官网的SQL Developer连接时出现如下错误提示:
  ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
将SQL Developer中的连接删除都再次配置连接出现提示:
  状态:失败-测试失败:IO错误:Socket read timed out

监听文件如下(listener.ora):
# listener.ora Network Configuration File: C:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

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

(SID_DESC = 
(GLOBAL_DBNAME = orcl ) 
(ORACLE_HOME = C:\Oracle\product\11.2.0\dbhome_1) 
(SID_NAME = orcl ) 


LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.92.103)(PORT = 1522))
  )
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.92.103)(PORT = 1521))
  )
  )

ADR_BASE_LISTENER = C:\Oracle


这个是tnsnames.ora文件中的内容
------------------
# tnsnames.ora Network Configuration File: C:\Oracle\product

\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

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

1.ORCL =  
2. (DESCRIPTION =  
3. (ADDRESS_LIST =  
4. (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 

1521))  
5. )  
6. (CONNECT_DATA =  
7. (SERVICE_NAME = orcl)  
8. )  
9. ) 

恳求解决

------解决方案--------------------
你看看这个链接上的图,是不是这样配置的:
http://hi.csdn.net/space-4884479-do-album-picid-984644.html
  相关解决方案