发布网友 发布时间:2022-04-07 16:47
共1个回答
热心网友 时间:2022-04-07 18:17
ORA-一二5二吧: TNS:listener: all appropriate instances are blocking new connections Cause: All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup. Action: Attempt the connection again. If error persists, then contact the administrator to check the status of the instances. ORA-一二5二吧问题是因为监听中的服务没有注册到监听。 你现在使用的是动态注册,实例是通过PMON进程注册到监听上的,而PMON进程需要在MOUNT状态下才会启动。所以造成了上面的错误。 解决方案: 一.设置为静态注册。 你现在没在listener.ora 文件中添加SID_LIST_LISTENER参数,所以现在是动态注册。 可以添加以下内容: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = [DBNAME]) (ORACLE_HOME = [$ORACLE_HOME]) (SID_NAME = [SID]) ) ) 二.启动实例。 sqlplus / as sysdba SQL> startup mount; 如果还不行,改完以后再重启下监听咯。lsnrctl reload