Home  >  Article  >  Database  >  Oracle错误- ORA-12514:TNS:无监听程序

Oracle错误- ORA-12514:TNS:无监听程序

WBOY
WBOYOriginal
2016-06-07 17:29:392495browse

OracleServiceORACLE: 若该服务未启动,将会导致Oracle错误- Ora-12514:TNS:监听程序当前无法识别链接描述符中请求的服务。

OracleOraDb10g_home1TNSListener:
该服务对应 %Oracle_Hoem\bin\TNSLSNR.EXE
若该服务未启动,,将会导致Oracle错误- Ora-12514:TNS:无监听程序。

OracleServiceORACLE:
若该服务未启动,将会导致Oracle错误- Ora-12514:TNS:监听程序当前无法识别链接描述符中请求的服务。
但是,启动了该服务也有可能导致该错误。解决方法如下:

打开:%Oracle_Home%/network/admin/listener.ora文件

  SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Oracle\Oracle10g)
      (PROGRAM = extproc)
    )
后面添加:
    (SID_DESC =
      (GLOBAL_DBNAME = ORACLE)
      (ORACLE_HOME = D:\Oracle\Oracle10g)
      (SID_NAME = ORACLE)
      )
/******ORACLE 指当前数据库中需要开启哪个SID**************/
  最后变成:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Oracle\Oracle10g)
      (PROGRAM = extproc)
    ) (SID_DESC =
        (GLOBAL_DBNAME = ORACLE)
        (ORACLE_HOME = D:\Oracle\Oracle10g)
        (SID_NAME = ORACLE)
      )
  )

linux

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn