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

文档解释

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. 数据库实例刚刚安装，但未注册到监听程序中。

2. 在指定节点上运行了多个实例，但是客户端只知道一个实例，并尝试连接另一个实例。

3. 连接字符串中实例名（SID）的拼写错误。

正常处理方法及步骤

1、检查数据库连接字符串，确认实例名（SID）是否正确，SID应与数据库实例相匹配；

2、确认TNSNAMES.ORA文件中此实例是否存在；

3、检查数据库实例是否正确注册到监听程序中，请使用以下命令来检查：

（1）lsnrctl status

（2）lsnrctl services

（3）select instance_name from v$instance;

（1）如果用户是Windows操作系统环境：

a. 启动Oracle实例

b. 再次启动监听程序

（2）如果用户是Linux/Unix操作系统环境：

a. 关闭Oracle实例

b. 再次启动监听程序

c. 启动Oracle实例

5、重新启动和初始化客户端；

6、重新尝试连接实例。