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