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)
)
)
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)