Índice do fórum Treinamentos Avançados Treinamento Oracle Maximum Availability Architecture Problemas com a configuração do Broker no 12c

Problemas com a configuração do Broker no 12c

Dúvidas, dicas e atualizações sobre o Treinamento Oracle Maximum Availability Architecture.


Mensagens: 0
Localização: Germany

-------------------------------------------
LISTENER:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = foedwh12) #RAC Production
(GLOBAL_DBNAME = foedwh12) #RAC Production
(ORACLE_HOME = /u01/app/12.1.0.2/grid)
)
(SID_DESC =
(SID_NAME = foeodi12) #RAC Production
(GLOBAL_DBNAME = foeodi12) #RAC Production
(ORACLE_HOME = /u01/app/12.1.0.2/grid)
)
(SID_DESC =
(SID_NAME = foedwh12) #DataGuard Single
(GLOBAL_DBNAME = foedwh12_DGMGRL) #DataGuard Single
(ORACLE_HOME = /u01/app/12.1.0.2/grid)
)
(SID_DESC =
(SID_NAME = foeodi12) #DataGuard Single
(GLOBAL_DBNAME = foeodi12_DGMGRL) #DataGuard Single
(ORACLE_HOME = /u01/app/12.1.0.2/grid)
)
)
-------------------------------------------
TNSNAMES:
FOEDWH12 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rdslinux220-scan)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760)))
(SDU = 32767)
(CONNECT_DATA =
(SERVICE_NAME = foedwh12) #RAC Production
(UR = A)
)
)

FOEODI12 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rdslinux220-scan)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760)))
(SDU = 32767)
(CONNECT_DATA =
(SERVICE_NAME = foeodi12) #RAC Production
(UR = A)
)
)

FOEDWH12_DR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rdslinux220c)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760)))
(SDU = 32767)
(CONNECT_DATA =
(SERVICE_NAME = foedwh12_dr) #DataGuard Single
(UR = A)
)
)

FOEODI12_DR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rdslinux220c)(PORT = 1521)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760)))
(SDU = 32767)
(CONNECT_DATA =
(SERVICE_NAME = foeodi12_dr) #DataGuard Single
(UR = A)
)
)

-------
DGMGRL> show configuration

Configuration - DRSolution

Protection Mode: MaxPerformance
Members:
foeodi12 - Primary database
foeodi12_dr - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 8 seconds ago)

DGMGRL>

DGMGRL> show database foeodi12_dr

Database - foeodi12_dr

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
foeodi12

Database Status:
DGM-17016: failed to retrieve status for database "foeodi12_dr"
ORA-16664: unable to receive the result from a database

DGMGRL>
--
Mit Freundlichen Grüßen / Saludos / Best Regards / Saudações
IT Expert, DBA Oracle, DBA RAC Oracle, DMA Oracle, Solaris, Linux, OS X.

André Augusto Ribas
andre.ribas@icloud.com
dba.ribas@gmail.com
DE: +49 (0)151 660 76921

portilho Site Admin

Mensagens: 482
Teste se o mesmo acontece com diferentes loginfs do dgmgrl:
$ dgmgrl sys/senha@TnsDaProdução
$ dgmgrl sys/senha@TnsDoDr


E coloque aqui os seguintes testes de conexão:

A partir do Nó 1:
$ sqlplus SYSTEM/senha@TnsDaProdução
SQL> SELECT HOST_NAME FROM V$INSTANCE;
$ sqlplus SYSTEM/senha@TnsDoDR
SQL> SELECT HOST_NAME FROM V$INSTANCE;


A partir do Nó 2:
$ sqlplus SYSTEM/senha@TnsDaProdução
SQL> SELECT HOST_NAME FROM V$INSTANCE;
$ sqlplus SYSTEM/senha@TnsDoDR
SQL> SELECT HOST_NAME FROM V$INSTANCE;


A partir do dr:
$ sqlplus SYSTEM/senha@TnsDaProdução
SQL> SELECT HOST_NAME FROM V$INSTANCE;
$ sqlplus SYSTEM/senha@TnsDoDR
SQL> SELECT HOST_NAME FROM V$INSTANCE;

portilho Site Admin

Mensagens: 482
No 12c, siga o material de OMAA para criação de RAC + DG Single diretamente com o Broker:
http://nervinformatica.com.br/Downloads ... estado.pdf


Voltar para Treinamento Oracle Maximum Availability Architecture

cron