tnsnames动态和静态的区别

发布网友发布时间：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