If you are doing a duplicate (except an Active duplication) to create a Standby database and received the following error below:
Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (DBID = 1451288836) 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
You should add the entry “(UR = A)” in tnsnames.ora for the target and source database. (Feature of Oracle 10g).
As the example below in the tnsnames.ora:
DBTECH = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = dbtech.techdata.com) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DBTECH) (UR = A) ) )
Se você estiver fazendo um duplicate (exceto um Active duplication) para criar um banco de dados do tipo Standby e recebeu o seguinte erro abaixo:
Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (DBID=1451288836) 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
Você deverá adicionar a entrada “(UR = A)” no tnsnames.ora para o aliás dos bancos de dados de target e source . (Feature do Oracle 10g).
Conforme o exemplo abaixo no tnsnames.ora:
DBTECH =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbtech.techdata.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBTECH)(UR=A)
)
)
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.