在同一Windows机器上的Oracle 11g和12c，12c侦听器无法启动 [英] Oracle 11g and 12c on same windows machine, 12c listener fails to start

问题描述

我有一台Windows计算机，上面已经安装了Oracle 11g，并且ORACLE_HOME指向11g的家. 然后，我尝试安装12c.在安装过程中，安装程序要求我取消设置环境变量，然后重新运行安装程序.我做到了然后，安装工作正常.当安装程序继续进行网络配置时，唯一的麻烦是它失败了.我做了一个重试"，它成功完成了. 完成安装后，我发现12c的oracle数据库服务正在运行，但侦听器未运行.我尝试启动该服务，并收到一条消息，说它已启动和停止".然后，我在网上搜索了所有内容，并找到了各种建议.尝试了很多，但无法使监听器运行.

I have a windows machine with Oracle 11g already installed on it and ORACLE_HOME pointing to the home of 11g. I then tried installing 12c. While installing, the installer asked me to unset the environment variable and re-run the installer. I did that. Then the installation worked fine. Just one hiccup was when the installer went on for net configuarion, it failed. I did a 'retry' and it completed successfully. When the installation was completely done, I found that the oracle database service for 12c was running, but listener was not. I tried starting the service and got a message saying 'it started and stopped'. I then searched all around the net and found various advises. Tried lot of them but not able to get the listener running.

当前状态是，我的ORACLE_HOME设置为12c home.而lsnrctl何时启动，却出现此错误.

The current state is, my ORACLE_HOME is set to the 12c home. and when do lsnrctl start, I'm getting this error..

C:\Users\Administrator>lsnrctl start
LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 11-JUN-2014 02:00:42
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Starting tnslsnr: please wait...
Failed to start service, error 0.
TNS-12560: TNS:protocol adapter error

我做错了什么?

这里是listener.ora ...

Here's listener.ora...

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\Administrator\product\12.1.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\12.1.0\dbhome_1\bin\oraclr12.dll")
    )
  )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
      (ADDRESS = (PROTOCOL = TCP)(HOST = <hostname.domain.com>)(PORT = 1522))
    )
  )

这是tnsnames.ora ...

and here's tnsnames.ora...

MY12C =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <hostname.domain.com>)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MY12C)
    )
  )


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

推荐答案

请尝试检查是否正在运行oracle 11G的天气旧侦听器.

Please try to check weather old listener of oracle 11G is currently running or not.

或

从oracle 12C运行netca，然后使用与oralce 11G不同的名称和不同的端口创建侦听器.

run netca from oracle 12C and then create listener with different name and different port from oralce 11G.

这篇关于在同一Windows机器上的Oracle 11g和12c，12c侦听器无法启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！