关于Oracle的TNS

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

【责编:Ken】