关于Oracle的TNS

×才开始学Oracle，遇到点问题，记录一下。×

 

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

ORA-12514: TNS: 协议适配器错误

 

首先保证服务正常起来。

 

在次去看$Oracle_home/network/admin/listener.ora

 

如果只是在sqlplus 中出现这样的问题。

win

set ORACLE_ID=DBname

 

管理工具编辑listenr.org

# listener.ora Network Configuration File: e:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = e:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )

#add db name desc
     (SID_DESC =
       (GLOBAL_DBNAME = ebay)
       (ORACLE_HOME = e:\oracle\product\10.2.0\db_1)  
       (SID_NAME = ebay)
      )

#end
  )

#不同IP端口监听

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521))
    )
  )

#end
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
    )
  )