Question

执行请求的操作时遇到错误: Listener refused the connection with the following error:

执行请求的操作时遇到错误:

Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

供应商代码 12505
无法连接
oracle数据库监听

Answer 1

ORA-12505:
TNS:listener does not currently know of SID given 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 a SID 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 <listener name>
- Check that the SID parameter in the connect descriptor specifies an instance known by the listener.
- Check for an event in the listener.log file.

1、服务器正在启动中，等等
2、用命令lsnrctl检查服务器端提供的服务名和sid
3、检查本地tnsnames.ora的配置是否错误
4、检查服务器端listener.log日志

Answer 2

重启一下SQL就好了