ORA-12528: TNS:listener: all appropriate instances are blocking new connection
利用rman做auxiliary恢复的时候出现了
ORA-12528: TNS:listener: all appropriate instances are blocking new connection
$lsnrctl status
Instance "ora10", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
The command completed successfully
mdslinuxoracle:/home/oracle>rman target / auxiliary sys/oracle@ora147
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Sep 25 09:46:51 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA10 (DBID=776229932)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
因为database 启动到nomount状态 远程连接不上
可是在tnsname.ora中加上
ora147 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.0.7)(PORT = 1521))
(CONNECT_DATA =
(SERVER = dedicated)
(SERVICE_NAME = ora10)
(UR = A)
)
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24849178/viewspace-744974/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- ORA-39213: Metadata processing is not available
- RAC oracle 权限更改导致 实力启动失败
- ORA-08102: 未找到索引关键字
- CBO的运行模式first_rows,all_rows
- ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052
- SP2-0611: Error enabling STATISTICS report
- 11gr2 RAC注册database，listener 到CRS
- tns listner 监听连接很慢
- ORA-06512: at "PERFSTAT.STATSPACK", line 2134
- asm工具asmcmd
