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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)