ORA-12560: TNS: 协议适配器错误解决

发表评论
1,651

A+

所属分类：Error

遇到ORA-12560: TNS: 协议适配器错误这样的问题：

解决方法：

\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
    )
    (SID_DESC = 
      (GLOBAL_DBNAME = tztorcl) 
      (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1) 
      (SID_NAME = orcl) 
    )
  )

LISTENER =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.251.9.112)(PORT = 1521))
     )