问题：oracle11g数据库处于nomount状态，动态注册的监听拒绝一切连接
oracle@node1:/oracle/app/oracle/product/11.2.0.4/dbhome_1/network/admin$ rman
Recovery Manager: Release 11.2.0.4.0 - Production on Sat May 24 18:06:39 2025
Copyright © 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target sys/******@主库连接串
connected to target database: orcl (DBID=729144632)
RMAN> connect auxiliary sys/******@备库连接串
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
RMAN> exit
解决办法：
方法一、配置静态监听
vi $GRID_HOME/network/admin/listener.ora
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=ip地址)(PORT=1521))))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=hddb)
(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/dbhome_1)
(SID_NAME=orcl1)))
然后，重启监听！
方法二、设置连接串
cd $ORACLE_HOME/network/admin/
vi tnsnames.ora
备库连接串 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192...*)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(UR=A) --加入这行
)
)
