TNS-12522: TNS:listener could not find available instance with given INSTANCE_ROLE

TNS-12522: TNS:listener could not find available instance with given INSTANCE_ROLE
Cause: There are not any available and appropriate database instances registered with the listener, that are part of the service identified by SERVICE_NAME given in the connect descriptor and that have the specified INSTANCE_ROLE (and INSTANCE_NAME, if specified).
Action: Check to make sure that the INSTANCE_ROLE specified is correct. Run "lsnrctl services" to ensure that the instance(s) have registered with the listener and that they are ready to accept connections.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:01

TNS-12522：TNS：侦听器找不到具有给定INSTANCE_ROLE的可用实例,
.原因：没有任何可用和适当的数据库实例注册到侦听器，它们是由连接描述符中给出的SERVICE_NAME标识的服务的一部分，并且具有指定的INSTANCE_ROLE（如果指定了INSTANCE_NAME）。,
.操作：检查以确保指定的INSTANCE_ROLE正确。运行“lsnrctl services”以确保实例已向侦听器注册，并且它们已准备好接受连接。,
.

aiaiDBA

13718043309

010-86462881

TNS-12522: TNS:listener could not find available instance with given INSTANCE_ROLE

1 个回答

相似问题