Oracle ORA-12514: TNS:listener does not currently know of service requested in conn解决方案

# listener.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
      (PROGRAM = extproc)
    )
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = cust-e44050fe71)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

 如果你listener.ora配置文件是这样的 说明少了一些配置信息应指出监听那个数据库应加上

(SID_DESC =
      (GLOBAL_DBNAME = GKBM2015) //为数据库服务名
      (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
      (SID_NAME = GKBM2015) //为数据库服务名
     )
    (SID_DESC =
      (GLOBAL_DBNAME = ZYXX2015) //为数据库服务名
      (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
      (SID_NAME = ZYXX2015) //为数据库服务名
    )

 之后的文件是这样的

# listener.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = GKBM2015)
      (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
      (SID_NAME = GKBM2015)
     )
    (SID_DESC =
      (GLOBAL_DBNAME = ZYXX2015)
      (ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
      (SID_NAME = ZYXX2015)
    )
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = cust-e44050fe71)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

 之后重启监听程序

cmd命令中输入 lsnrctl

stop

start

 

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。