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

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

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

Post by andreribas »

-------------------------------------------
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>

portilho
Site Admin
Posts: 497
Joined: Wed May 29, 2013 8:51 am

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

Post by portilho »

Teste se o mesmo acontece com diferentes loginfs do dgmgrl:

Code: Select all

$ dgmgrl sys/senha@TnsDaProdução
$ dgmgrl sys/senha@TnsDoDr


E coloque aqui os seguintes testes de conexão:

A partir do Nó 1:

Code: Select all

$ 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:

Code: Select all

$ 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:

Code: Select all

$ 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
Posts: 497
Joined: Wed May 29, 2013 8:51 am

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

Post by portilho »

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

Post Reply