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

August 4, 2016Comments

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

)

文章源自 note.t4x.orgByrd's Blog-https://note.t4x.org/error/ora-12560-tns/ 文章源自 note.t4x.orgByrd's Blog-https://note.t4x.org/error/ora-12560-tns/

申明：除非注明Byrd's Blog内容均为原创,未经许可禁止转载!详情请阅读版权申明!

On this day in past years

August

Hot search

On this day in past years

Comment