Java 侦听器的 Oracle11g 安装错误

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/9756344/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-16 07:13:54  来源:igfitidea点击:

Oracle11g installation error for Listener

javaoraclejdbc

提问by DM111

When installing Oracle11.2.0 g, I get database Configuration Assistant warning- Enterprise manager configuration failed due to foll. error:Listener is not up or database service is not registered with it.Start the Listener and register database service and run EM Configuration assistant again.Please guide me how to proceed.. Hence I am not able to connect JavaJDBC program with Oracle

安装Oracle11.2.0 g时,出现数据库配置助手警告-企业管理器配置失败,原因如下。错误:监听器未启动或数据库服务未注册。启动监听器并注册数据库服务并再次运行EM配置助手。请指导我如何继续..因此我无法将JavaJDBC程序与Oracle连接

回答by sachinrahulsourav

You need to check if the database Listener is running. You can check by typing 'servies.msc' in your Start>Run box and see if the database listener is running.

您需要检查数据库侦听器是否正在运行。您可以通过在“开始”>“运行”框中键入“servies.msc”来检查数据库侦听器是否正在运行。

回答by Gaurav Soni

First of all what is your Database Version and Operating System

首先你的数据库版本和操作系统是什么

Register your database with the listener

使用侦听器注册您的数据库

Add SID_LIST_LISTENERin your listener.ora file present in $ORACLE_HOME\network\admin

添加SID_LIST_LISTENER您的 listener.ora 文件$ORACLE_HOME\network\admin

Example

例子

LISTENER=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=sale-server)(PORT=1521))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
    (GLOBAL_DBNAME=sales.us.example.com)
      (ORACLE_HOME=/oracle11g)
      (SID_NAME=sales))
    (SID_DESC=
       (SID_NAME=plsextproc)
      (ORACLE_HOME=/oracle11g)
      (PROGRAM=extproc)))

Refer to this link

参考这个链接

http://docs.oracle.com/cd/B28359_01/network.111/b28317/listener.htm

http://docs.oracle.com/cd/B28359_01/network.111/b28317/listener.htm

After Editing listener.orarestart the listener with the help of following command....

编辑后在listener.ora以下命令的帮助下重新启动侦听器....

lsnrctl reload

Then try to start Enterprise Manager as follows

然后尝试启动企业管理器如下

emctl start dbconsole

Reference from the link

来自链接的参考

Reconfigure Oracle Enterprise Manager on windows

在 Windows 上重新配置 Oracle Enterprise Manager

ORACLE_UNAME

ORACLE_UNAME