Error: ORA-16532: Oracle Data Guard broker configuration does not exist

ajmoreti
(usa Suse)

Enviado em 06/06/2020 - 11:56h

Boa tarde Pessoal,

Tenho um Data Guard Configurado, e funcionando perfeitamente.

Nesse momento estou na tentativa de configurar o Data Broker, porem estou com um problema no momento de adicionar as configurações do STANDBY. Se tiverem alguma ideia do que pode estar ocorrendo fico agradecido.

O que esta me retornando é esse:

Error: ORA-16532: Oracle Data Guard broker configuration does not exist

DGMGRL> ADD DATABASE ’seniorstby' AS CONNECT IDENTIFIER IS seniorstby MAINTAINED AS PHYSICAL;
Error: ORA-16532: Oracle Data Guard broker configuration does not exist

Failed.

olhando o arquivo doc<DB_UNIQUE_NAME>.log ele me retorna somente o erro abaixo:

2020-06-05 12:09:45.809 00000000 24572709 DMON: ADD_DATABASE will be retired
2020-06-05 12:09:45.809 00000000 24572709 severity = ORA-16501, status = ORA-16532
2020-06-05 12:09:45.809 00000000 24572709 DMON: ADD_DATABASE operation completed

Abaixo estou postando algumas informações da minha configuração.

PRIMARIO

ORACLE_SID = SENIORPRD

DGMGRL> CREATE CONFIGURATION 'dg_config' AS PRIMARY DATABASE IS 'seniorprd' CONNECT IDENTIFIER IS seniorprd;
Configuration "dg_config" created with primary database "seniorprd"

Parametros

connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1))
dg_broker_config_file1 string /opt/oracle/product/12cR2/db/dbs/dr1seniorprd.dat
dg_broker_config_file2 string /opt/oracle/product/12cR2/db/dbs/dr2seniorprd.dat
dg_broker_start boolean TRUE
use_dedicated_broker boolean FALSE

Listener

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradb)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = seniorprd_DGMGRL)
(ORACLE_HOME = /opt/oracle/product/12cR2/db)
(SID_NAME = seniorprd)
)
)

ADR_BASE_LISTENER = /opt/oracle

TNSNAMES

SENIORPRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradb)(PORT = 1521))
)
(CONNECT_DATA =
(SID = seniorprd)
)
)

SENIORSTBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orarman)(PORT = 1521))
)
(CONNECT_DATA =
(SID = seniorprd)
)
)


STANDBY

ORACLE_SID = SENIORPRD

DGMGRL> ADD DATABASE ’seniorstby' AS CONNECT IDENTIFIER IS seniorstby MAINTAINED AS PHYSICAL;
Error: ORA-16532: Oracle Data Guard broker configuration does not exist

Parametros

connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1))
dg_broker_config_file1 string /opt/oracle/product/12cR2/db/dbs/dr1seniorstby.dat
dg_broker_config_file2 string /opt/oracle/product/12cR2/db/dbs/dr2seniorstby.dat
dg_broker_start boolean TRUE
use_dedicated_broker boolean FALSE

Listener

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orarman)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = SENIORSTBY_DGMGRL)
(ORACLE_HOME = /opt/oracle/product/12cR2/db)
(SID_NAME = seniorprd)
)
)

ADR_BASE_LISTENER = /opt/oracle

TNANAMES

SENIORPRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradb)(PORT = 1521))
)
(CONNECT_DATA =
(SID = seniorprd)
(UR = A)
)
)

SENIORSTBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orarman)(PORT = 1521))
)
(CONNECT_DATA =
(SID = seniorprd)
(UR = A)
)
)