oracle 监听器不支持任何服务
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12564623/
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
oracle listener supports no service
提问by G.S
I am having trouble with my Oracle instance.
我的 Oracle 实例有问题。
I get the following error when I run lsnrctl stat in command prompt. I even confirmed Oracle services running.
在命令提示符下运行 lsnrctl stat 时出现以下错误。我什至确认 Oracle 服务正在运行。
The listener supports no services.
侦听器不支持任何服务。
回答by ik_zelf
I assume the platform is Windows and the Oracle version is 11g. When an Oracle database instance starts, it tries to register itself to the default listener or to the listener registered in the init parameters as the local_listener. What you can do is
我假设平台是 Windows，Oracle 版本是 11g。当 Oracle 数据库实例启动时，它会尝试将自己注册到默认侦听器或注册到在 init 参数中注册为 local_listener 的侦听器。你能做的是
- make sure that your local_listener parameter points to your listener
- make sure that your listener runs on localhost port 1521 (using the listener.ora file)
- 确保您的 local_listener 参数指向您的侦听器
- 确保您的侦听器在 localhost 端口 1521 上运行（使用 listener.ora 文件）
This is when the database is using a dynamic listener. You could also make the listener a static one by entering the instance details in the listener.ora file. Docu about the listener.ora is found here Oracle Net Listener Parameters (listener.ora)
这是数据库使用动态侦听器的时候。您还可以通过在 listener.ora 文件中输入实例详细信息来使侦听器成为静态侦听器。关于 listener.ora 的文档可以在这里找到Oracle Net Listener Parameters (listener.ora)
回答by Priyadarshini
when the listener is created after creation of database,we need to explicitly register our instance.
在创建数据库后创建侦听器时，我们需要显式注册我们的实例。
try:
尝试：
starting database by doing startup and check the listerner status by lsnrctl status and it your instance is running it means pmon has done registering your instance with the listener itself.
通过执行启动来启动数据库并通过 lsnrctl status 检查侦听器状态，并且您的实例正在运行，这意味着 pmon 已完成向侦听器本身注册您的实例。
回答by Rajesh Chaudhary
A solution is very simple for this error, first, let's understand why this error occurs. It basically has two reasons which are:
这个错误的解决方法很简单，首先我们来了解一下为什么会出现这个错误。基本上有两个原因，分别是：
1) Your database and service name is not properly set in Oracle environment it should be same everywhere check below parameter values
1) 您的数据库和服务名称在 Oracle 环境中设置不正确它应该是相同的，请检查以下参数值
-ORACLE_SID in oracle environment.
-Check Database Instance name.
-SID_NAME in tnsnames.ora file.
-SERVICE_NAME in listener.ora file.
2) Host name/IP address is missing, not correct or spelling mistake, so please check the below.
2) 主机名/IP 地址缺失、不正确或拼写错误，请检查以下内容。
-Check the IP ADDRESS in /etc/hosts file.
-It should be same in listener.ora and tnsnames.ora file
-And it should be able to ping from the local and remote server.
Now see I've also faced the same problem and resolved:
现在看到我也遇到了同样的问题并解决了：
please visit this StackOverflow link: https://stackoverflow.com/a/45065640/6332029
请访问此 StackOverflow 链接：https://stackoverflow.com/a/45065640/6332029
I hope it will help, thanks!
我希望它会有所帮助，谢谢！
回答by Olga T
In my case it was easy - for some reason, after restarting my laptop, services stopped working. So, Run > services > start OracleService helped to start the listener
就我而言，这很容易 - 出于某种原因，在重新启动笔记本电脑后，服务停止工作。所以，Run > services > start OracleService 帮助启动了监听器
回答by G.S
I did check all the things but could not find the cause. So I re-installed the Oracle and using that now.
我确实检查了所有的东西，但找不到原因。所以我重新安装了 Oracle 并使用它。
