ORA-12514:TNS listener错误

使用startup mount命令或者SqlPlus命令后提示ORA-12514:TNS:listener错误

 

1.确保Oracle 基本服务都已启动
OracleDBConsoleORCL
OracleOraDb11g_home1TNSListener
OracleServiceORCL

 2.在命令行中，执行lsnrctl status,查看监听程序参数文件

C:\Documents and Settings\Administrator>lsnrctl status

可以看到程序参数文件在D:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN

监听程序日志文件在D:\Oracle\diag\tnslsnr\FP-ATP\listener\alert

 

3.修改监听程序参数文件

初次打开内容如下

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

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )

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

ADR_BASE_LISTENER = D:\oracle

修改为如下

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

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = seineebs)
      (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
      #(PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

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

ADR_BASE_LISTENER = D:\oracle

SID_NAME，KEY 的值修改为要访问的oracle实例的名称，HOST 修为 oracle 服务器使用的地址

 

4.重启listener,在命令行中依次执行 lsnrctl stop，lsnrctl start

 

 

5.再次使用startup mount命令或者SqlPlus命令后没有提示ORA-12514:TNS:listener错误代表成功