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

发表评论
1,194

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

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

)

发表评论取消回复