错误：ORA-01034：ORACLE不可用ORA-27101：共享内存域不存在 [英] ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

问题描述

当我尝试连接到Oracle时，我收到此错误。



当我通过vb.net运行我的项目并尝试连接到oracle是：



创建表单时出错。有关详细信息，请参阅Exception.InnerException。错误是：ORA-12514：TNS：侦听器当前不存在知道连接描述符中要求的服务



我得到了这个错误次数。

任何人都可以告诉我完美的解决方案它？



请帮帮我...

谢谢，

I am getting this error when i am trying to connect to Oracle.

And Another error occurred when i am running my project through vb.net and trying to connect to oracle is :

"An error occurred creating the form. See Exception.InnerException for details. The error is: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"

I am getting this error number of times.
Can any one tell me the perfect solution of it ?

Please help me out ...
Thank you,

推荐答案

当数据库或侦听器进程处于启动过程中，或者数据库（在您的情况下为mysid）尚未向侦听器注册时，通常会发生这种形式的ORA-12541错误。



查看这些内容，了解何时以及为何会出现此类错误以及如何处理错误：

ORA-12514：TNS：监听器目前不知道服务 [ ^ ]

ORA-12514：TNS：侦听器当前不知道连接描述符中请求的服务 [ ^ ]





这里有更多细节： TNS：侦听器当前不知道连接描述符中请求的服务 [ ^ ]，它说：

原因：侦听器收到建立与数据库或其他服务的连接的请求。侦听器接收的连接描述符指定了服务（通常是数据库服务）的服务名称，该服务尚未向侦听器动态注册或尚未为侦听器静态配置。这可能是一个临时条件，例如在侦听器启动之后，但在数据库实例向侦听器注册之前。



动作：

- 等一下，再尝试连接第二次。

- 执行以下命令检查监听器当前已知的服务：lsnrctl services< listener name>

- 检查所使用的网络服务名称的连接描述符中的SERVICE_NAME参数是否指定了侦听器已知的服务。

- 如果使用了简单连接命名连接标识符，请检查指定的服务名称是侦听器已知的服务。

- 检查listener.log文件中的事件。

This form of the ORA-12541 error commonly happens when the database or the listener processes are in the middle of a startup, or when the database (mysid in your case) has not been registered with the listener.

Have a look at these to understand when and why such error occurs and how to handle it:
ORA-12514: TNS:listener does not currently know of service [^]
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [^]


More detail here:TNS:listener does not currently know of service requested in connect descriptor[^], it says:
Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.

Action:
- Wait a moment and try to connect a second time.
- Check which services are currently known by the listener by executing: lsnrctl services <listener name>
- Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.
- If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.
- Check for an event in the listener.log file.

这篇关于错误：ORA-01034：ORACLE不可用ORA-27101：共享内存域不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！