Default

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

Read

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

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

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

)

SourceByrd's Weblog-https://note.t4x.org/error/ora-12560-tns/ SourceByrd's Weblog-https://note.t4x.org/error/ora-12560-tns/

Today in History

August

4

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

by Byrd Published on August 4, 2016
原文链接：https://note.t4x.org/error/ora-12560-tns/