aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor

ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor
Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified in addition to the service name an instance name for an instance (usually a database instance) 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 instances are currently known by the listener by executing: lsnrctl services

- Check that the INSTANCE_NAME parameter in the connect descriptor specifies an instance name known by the listener.

- Check for an event in the listener.log file.

请先 登录 后评论

1 个回答

小智
ORA-12521:TNS:侦听器当前不知道连接描述符中请求的实例,
.原因:侦听器收到建立到数据库或其他服务的连接的请求。由监听器接收的连接描述符除了服务名称之外还指定一个实例(通常是数据库实例)的实例名称,该实例尚未动态地向监听器注册或尚未静态配置为侦听器。这可能是临时条件,例如侦听器启动后,但在数据库实例向侦听器注册之前。,
.行动:,
.- 稍等片刻,再次尝试连接。,
.,
.- 通过执行以下命令检查侦听器当前已知的实例:lsnrctl services ,
.,
.- 检查连接描述符中的INSTANCE_NAME参数是否指定侦听器已知的实例名称。,
.,
.- 检查listener.log文件中的事件。,
.,
.
请先 登录 后评论