ora-一二5二吧: tns:l**tener: 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. th** condition may be temporary, such as at instance startup. action: attempt the connection again. if error pers**ts, then contact the admin**trator to check the status of the instances. ora-一二5二吧问题是因为**中的服务没有注册到**。 你现在使用的是动态注册,实例是通过pmon进程注册到**上的,而pmon进程需要在mount状态下才会启动。所以造成了上面的错误。 解决方案: 一.设置为静态注册。 你现在没在l**tener.ora 文件中添加sid_l**t_l**tener参数,所以现在是动态注册。 可以添加以下内容: sid_l**t_l**tener = (sid_l**t = (sid_desc = (global_dbname = [dbname]) (oracle_home = [$oracle_home]) (sid_name = [sid]) ) ) 二.启动实例。 sqlplus / as sysdba sql> startup mount; 如果还不行,改完以后再重启下**咯。lsnrctl reload 20210311