Dicas rápidas que ajudam na hora de configurar um Data Guard RAC para RAC.

Servidores:

Produção RAC: exacc01db01, exacc01db02
Produção databases: DB01, DB02,DB03
Data Guard RAC:  exacc02db01, exacc02db02
Data Guard databases: DB01_DG, DB02_DG, DB03_DG
ShellScript

1 – Verificar LISTENER.

Da produção ao Data Guard em todos os nós:

[grid@exacc01db01 ~]$ cat linstener.ora
SID_LIST_LISTENER =
 (SID_LIST =
  (SID_DESC =
    (GLOBAL_DBNAME = DB01_DG_DGMGRL.lab.corp)
    (ORACLE_HOME = /u02/app/oracle/product/12.1.0/dbhome_1)
    (SID_NAME = DB01)
  )
  (SID_DESC =
    (GLOBAL_DBNAME = DB02_DG_DGMGRL.lab.corp)
    (ORACLE_HOME = /u02/app/oracle/product/19.0.0.0/dbhome_1)
    (SID_NAME = DB02)
  )
  (SID_DESC =
    (GLOBAL_DBNAME = DB03_DG_DGMGRL.lab.corp)
    (ORACLE_HOME = /u02/app/oracle/product/12.1.0/dbhome_1)
    (SID_NAME = DB03)
  )
 )
 
[grid@exacc01db02 ~]$ cat linstener.ora
SID_LIST_LISTENER =
 (SID_LIST =
  (SID_DESC =
    (GLOBAL_DBNAME = DB01_DG_DGMGRL.lab.corp)
    (ORACLE_HOME = /u02/app/oracle/product/12.1.0/dbhome_1)
    (SID_NAME = DB01)
  )
  (SID_DESC =
    (GLOBAL_DBNAME = DB02_DG_DGMGRL.lab.corp)
    (ORACLE_HOME = /u02/app/oracle/product/19.0.0.0/dbhome_1)
    (SID_NAME = DB02)
  )
  (SID_DESC =
    (GLOBAL_DBNAME = DB03_DG_DGMGRL.lab.corp)
    (ORACLE_HOME = /u02/app/oracle/product/12.1.0/dbhome_1)
    (SID_NAME = DB03)
  )
 )
ShellScript

Do Data Guard para produção, em todos os nós:

[grid@exacc02db01 ~]$ cat linstener.ora
SID_LIST_LISTENER =
 (SID_LIST =
  (SID_DESC =
    (GLOBAL_DBNAME = DB01_DG_DGMGRL.lab.corp)
    (ORACLE_HOME = /u02/app/oracle/product/12.1.0/dbhome_1)
    (SID_NAME = DB01)
  )
  (SID_DESC =
    (GLOBAL_DBNAME = DB02_DG_DGMGRL.lab.corp)
    (ORACLE_HOME = /u02/app/oracle/product/19.0.0.0/dbhome_1)
    (SID_NAME = DB02)
  )
  (SID_DESC =
    (GLOBAL_DBNAME = DB03_DG_DGMGRL.lab.corp)
    (ORACLE_HOME = /u02/app/oracle/product/12.1.0/dbhome_1)
    (SID_NAME = DB03)
  )
 )
 
[grid@exacc02db02 ~]$ cat linstener.ora
SID_LIST_LISTENER =
 (SID_LIST =
  (SID_DESC =
    (GLOBAL_DBNAME = DB01_DG_DGMGRL.lab.corp)
    (ORACLE_HOME = /u02/app/oracle/product/12.1.0/dbhome_1)
    (SID_NAME = DB01)
  )
  (SID_DESC =
    (GLOBAL_DBNAME = DB02_DG_DGMGRL.lab.corp)
    (ORACLE_HOME = /u02/app/oracle/product/19.0.0.0/dbhome_1)
    (SID_NAME = DB02)
  )
  (SID_DESC =
    (GLOBAL_DBNAME = DB03_DG_DGMGRL.lab.corp)
    (ORACLE_HOME = /u02/app/oracle/product/12.1.0/dbhome_1)
    (SID_NAME = DB03)
  )
 )
ShellScript

2 – TNSNAMES em todos os nós do RAC produção e Data Guard:

##### PRODUCTION X9 ######
DB01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB01.lab.corp)
    )
  )
   
DB02 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB02.lab.corp)
    )
  )
   
DB03 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB03.lab.corp)
    )
  )
 
##### DATAGUARD X8 ######
DB01_DG =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB01_DG_DGMGRL.lab.corp)
    )
  )
   
DB02_DG =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB02_DG_DGMGRL.lab.corp)
    )
  )
   
DB03_DG =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB03_DG_DGMGRL.lab.corp)
    )
  )
ShellScript

3 – Após configurar o listener do standby e tnsnames realize os testes com tnsping e sqlplus:

De produção para o Data Guard em todos os nós:

[oracle@exacc01db01 ~]$ tnsping DB01_DG
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB01_DG_DGMGRL.teste.corp)))
OK (0 msec)
 
[oracle@exacc01db01 ~]$ tnsping DB02_DG
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB02_DG_DGMGRL.teste.corp)))
OK (0 msec)
 
[oracle@exacc01db01 ~]$ tnsping DB03_DG
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB03_DG_DGMGRL.teste.corp)))
OK (0 msec)
 
 
[oracle@exacc01db02 ~]$ tnsping DB01_DG
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB01_DG_DGMGRL.teste.corp)))
OK (0 msec)
 
[oracle@exacc01db02 ~]$ tnsping DB02_DG
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB02_DG_DGMGRL.teste.corp)))
OK (0 msec)
 
[oracle@exacc01db02 ~]$ tnsping DB03_DG
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB03_DG_DGMGRL.teste.corp)))
OK (0 msec)
ShellScript
[oracle@exacc01db01 ~]$ sqlplus sys@DB01_DG as sysdba
[oracle@exacc01db01 ~]$ sqlplus sys@DB02_DG as sysdba
[oracle@exacc01db01 ~]$ sqlplus sys@DB03_DG as sysdba
 
[oracle@exacc01db02 ~]$ sqlplus sys@DB01_DG as sysdba
[oracle@exacc01db02 ~]$ sqlplus sys@DB02_DG as sysdba
[oracle@exacc01db02 ~]$ sqlplus sys@DB03_DG as sysdba
ShellScript

Do Data Guard para produção, em todos os nós:

[oracle@exacc02db01 ~]$ tnsping DB01
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB01X9.teste.corp)))
OK (0 msec)
 
[oracle@exacc02db01 ~]$ tnsping DB02
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB02X9.teste.corp)))
OK (0 msec)
 
 
[oracle@exacc02db01 ~]$ tnsping DB03
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB03X9.teste.corp)))
OK (0 msec)
 
 
[oracle@exacc02db02 ~]$ tnsping DB01
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB01X9.teste.corp)))
OK (0 msec)
 
[oracle@exacc02db02 ~]$ tnsping DB02
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB02X9.teste.corp)))
OK (0 msec)
 
 
[oracle@exacc02db02 ~]$ tnsping DB03
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB03X9.teste.corp)))
OK (0 msec)
ShellScript
[oracle@exacc02db01 ~]$ sqlplus sys@DB01 as sysdba
[oracle@exacc02db01 ~]$ sqlplus sys@DB02 as sysdba
[oracle@exacc02db01 ~]$ sqlplus sys@DB03 as sysdba
 
[oracle@exacc02db02 ~]$ sqlplus sys@DB01 as sysdba
[oracle@exacc02db02 ~]$ sqlplus sys@DB02 as sysdba
[oracle@exacc02db02 ~]$ sqlplus sys@DB03 as sysdba
ShellScript

4 – Verifique em todos os servidores produtivos e do Data guard se a variável TNS_ADMIN está com o local correto de acordo com cada banco:

Produção:

[oracle@exacc01db01 ~]$ srvctl getenv database -d DB01X9 -t "TNS_ADMIN"
DB01X9:
TNS_ADMIN=/u02/app/oracle/product/19.0.0.0/dbhome_1/network/admin/DB01
 
[oracle@exacc01db01 ~]$ srvctl getenv database -d DB02X9 -t "TNS_ADMIN"
DB02X9:
TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB02
 
[oracle@exacc01db01 ~]$ srvctl getenv database -d DB03X9 -t "TNS_ADMIN"
DB03X9:
TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB03
 
 
[oracle@exacc01db02 ~]$ srvctl getenv database -d DB01X9 -t "TNS_ADMIN"
DB01X9:
TNS_ADMIN=/u02/app/oracle/product/19.0.0.0/dbhome_1/network/admin/DB01
 
[oracle@exacc01db02 ~]$ srvctl getenv database -d DB02X9 -t "TNS_ADMIN"
DB02X9:
TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB02
 
[oracle@exacc01db02 ~]$ srvctl getenv database -d DB03X9 -t "TNS_ADMIN"
DB03X9:
TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB03
ShellScript

Data Guard:

[oracle@exacc02db01 ~]$ srvctl getenv database -d DB01_DG -t "TNS_ADMIN"
DB01_DG:
TNS_ADMIN=/u02/app/oracle/product/19.0.0.0/dbhome_1/network/admin/DB01
 
[oracle@exacc02db01 ~]$ srvctl getenv database -d DB02_DG -t "TNS_ADMIN"
DB02_DG:
TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB02
 
 
[oracle@exacc02db01 ~]$ srvctl getenv database -d DB03_DG -t "TNS_ADMIN"
DB03_DG:
TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB03
 
 
 
[oracle@exacc02db02 ~]$ srvctl getenv database -d DB01_DG -t "TNS_ADMIN"
DB01_DG:
TNS_ADMIN=/u02/app/oracle/product/19.0.0.0/dbhome_1/network/admin/DB01
 
[oracle@exacc02db02 ~]$ srvctl getenv database -d DB02_DG -t "TNS_ADMIN"
DB02_DG:
TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB02
 
 
[oracle@exacc02db02 ~]$ srvctl getenv database -d DB03_DG -t "TNS_ADMIN"
DB03_DG:
TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB03
ShellScript

5 – Cada diretório da variável TNS_ADMIN deve conter os arquivos de tnsnames.ora e sqlnet.ora no Data Guard em todos os nós para cada database:

[oracle@exacc02db01 ~]$ ls -lat /u02/app/oracle/product/19.0.0.0/dbhome_1/network/admin/DB01
total 16
drwxr-xr-x 2 oracle oinstall 4096 Oct 14 10:30 .
-rw-r--r-- 1 oracle oinstall 1069 Oct 14 10:30 sqlnet.ora
drwxr-xr-x 4 oracle oinstall 4096 Oct  7 15:07 ..
-rw-r--r-- 1 oracle oinstall 1673 Oct  6 11:19 tnsnames.ora
 
[oracle@exacc02db01 ~]$ ls -lat /u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB02
total 16
-rw-r--r-- 1 oracle oinstall 1080 Oct  6 12:40 sqlnet.ora
drwxr-xr-x 2 oracle oinstall 4096 Oct  6 12:40 .
-rw-r--r-- 1 oracle oinstall 1673 Oct  5 09:02 tnsnames.ora
drwxr-xr-x 6 oracle oinstall 4096 Oct  5 09:00 ..
 
[oracle@exacc02db01 ~]$ ls -lat /u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB03
total 20
drwxr-xr-x 2 oracle oinstall 4096 Oct 14 11:02 .
-rw-r--r-- 1 oracle oinstall 1074 Oct 14 11:02 sqlnet.ora
-rw-r--r-- 1 oracle oinstall 1080 Oct 14 11:02 sqlnet.ora_bkp
-rw-r--r-- 1 oracle oinstall 1678 Oct  6 11:41 tnsnames.ora
drwxr-xr-x 6 oracle oinstall 4096 Oct  5 09:00 ..
ShellScript

6 – No Data Guard se a variável TNS_ADMIN não estiver configurada, ajuste de acordo com cada database:

[oracle@exacc02db01 ~]$ srvctl setenv database -db DB01_DG -T "TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB01"
[oracle@exacc02db01 ~]$ srvctl setenv database -db DB02_DG -T "TNS_ADMIN=/u02/app/oracle/product/19.0.0.0/dbhome_1/network/admin/DB02"
[oracle@exacc02db01 ~]$ srvctl setenv database -db DB03_DG -T "TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB03"
 
 
[oracle@exacc02db02 ~]$ srvctl setenv database -db DB01_DG -T "TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB01"
[oracle@exacc02db02 ~]$ srvctl setenv database -db DB02_DG -T "TNS_ADMIN=/u02/app/oracle/product/19.0.0.0/dbhome_1/network/admin/DB02"
[oracle@exacc02db02 ~]$ srvctl setenv database -db DB03_DG -T "TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB03"
ShellScript

7 – Em ambiente RAC, o ideal é utilizar um acfs compartilhando TDE e wallet entre os nós do RAC, cada database deve ter seu conjunto de TDE e wallet.

Produção:

[oracle@exacc01db01 ~]$ ls -lat /var/opt/oracle/dbaas_acfs/DB01/
total 316
drwxr-xr-x 19 oracle oinstall 20480 Oct 14 11:01 ..
drwxr-x---  6 oracle oinstall 20480 Jul 23 11:22 .
drwx------  2 oracle oinstall 20480 Jul 23 11:14 bkup
drwxrwx---  2 oracle oinstall 20480 Jul 23 11:14 db_wallet
drwxr-x---  2 oracle oinstall 20480 Jul 23 11:13 tde_wallet
 
[oracle@exacc01db01 ~]$ ls -lat /var/opt/oracle/dbaas_acfs/DB02/
total 312
drwxr-xr-x 19 oracle oinstall 20480 Oct 14 11:01 ..
drwxr-x---  6 oracle oinstall 20480 Jun 19 16:31 .
drwxrwx---  2 oracle oinstall 20480 Jun 19 16:22 db_wallet
drwxr-x---  3 oracle oinstall 20480 Jun 19 16:12 wallet_root
 
[oracle@exacc01db01 ~]$ ls -lat /var/opt/oracle/dbaas_acfs/DB03/
total 312
drwxr-xr-x 19 oracle oinstall 20480 Oct 14 11:01 ..
drwxr-x---  6 oracle oinstall 20480 Jun 19 17:20 .
drwxrwx---  2 oracle oinstall 20480 Jun 19 17:13 db_wallet
drwxr-x---  2 oracle oinstall 20480 Jun 19 17:12 tde_wallet
ShellScript

Data Guard:

[oracle@exacc02db01 ~]$ ls -lat /var/opt/oracle/dbaas_acfs/DB01_DG/
total 208
drwxr-xr-x 18 oracle oinstall 20480 Oct 14 10:41 ..
drwxr-xr-x  2 oracle oinstall 20480 Oct  3 08:58 db_wallet
drwxr-xr-x  2 oracle oinstall 20480 Oct  3 08:57 tde_wallet
drwxr-xr-x  4 oracle oinstall 20480 Oct  3 08:16 .
[oracle@exacc02db01 ~]$ ls -lat /var/opt/oracle/dbaas_acfs/DB02_DG/
total 208
drwxr-xr-x 18 oracle oinstall 20480 Oct 14 10:41 ..
drwxr-xr-x  2 oracle oinstall 20480 Oct  3 09:00 db_wallet
drwxr-xr-x  2 oracle oinstall 20480 Oct  3 08:59 tde_wallet
drwxr-xr-x  4 oracle oinstall 20480 Oct  3 08:17 .
[oracle@exacc02db01 ~]$ ls -lat /var/opt/oracle/dbaas_acfs/DB03_DG/
total 208
drwxr-xr-x 18 oracle oinstall 20480 Oct 14 10:41 ..
drwxr-xr-x  2 oracle oinstall 20480 Oct  3 09:03 db_wallet
drwxr-xr-x  3 oracle oinstall 20480 Oct  3 08:18 wallet_root
drwxr-xr-x  4 oracle oinstall 20480 Oct  3 08:18 .
ShellScript

8 – Verifique o checksum após a copia dos arquivos tde e wallet da origem e no destino do Data Guard.

Produção:

[oracle@exacc01db01 tde_wallet]$ md5sum *
d8d7fd69019c96e8e2f2e9106dcdbc61  cdb_ocids.json
25c501d45f632bd971b2b70099d72890  cwallet.sso
940abbf6becc952755ba0dfdffd05f8f  ewallet_2022072314092872.p12
4167705f20fc6bcfb33b7aad459a8b93  ewallet_2022072314130785.p12
aa36a5ce31323d2254ac187d4ba42234  ewallet.p12
ShellScript

Data Guard:

[oracle@exacc02db01 tde_wallet]$ md5sum *
d8d7fd69019c96e8e2f2e9106dcdbc61  cdb_ocids.json
25c501d45f632bd971b2b70099d72890  cwallet.sso
940abbf6becc952755ba0dfdffd05f8f  ewallet_2022072314092872.p12
4167705f20fc6bcfb33b7aad459a8b93  ewallet_2022072314130785.p12
aa36a5ce31323d2254ac187d4ba42234  ewallet.p12
ShellScript

9 – Verifique se o diretório da wallet e tde foram criados com o UNIQUE_NAME correto, cada banco irá ter seu diretório com UNIQUE_NAME contendo wallet e tde em todos os nós do RAC.

Data Guard:

[oracle@exacc02db01 ~]$ cat /u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB01/sqlnet.ora
HTTPS_SSL_VERSION=1.2
SQLNET.CRYPTO_CHECKSUM_CLIENT=ACCEPTED
SQLNET.CRYPTO_CHECKSUM_SERVER=ACCEPTED
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA256,SHA384,SHA512,SHA1)
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA256,SHA384,SHA512)
SQLNET.ENCRYPTION_CLIENT=REQUESTED
SQLNET.ENCRYPTION_SERVER=REQUESTED
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128)
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128)
SQLNET.EXPIRE_TIME=10
SQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS=TRUE
SQLNET.WALLET_OVERRIDE=FALSE
SSL_CIPHER_SUITES=(SSL_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256,SSL_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384,SSL_ECDHE_RSA_WITH_AES_128_GCM_SHA256,SSL_ECDHE_RSA_WITH_AES_256_GCM_SHA384)
SSL_CLIENT_AUTHENTICATION=FALSE
SSL_VERSION=1.2
WALLET_LOCATION=
    (SOURCE=
      (METHOD=FILE)
      (METHOD_DATA=(DIRECTORY=/var/opt/oracle/dbaas_acfs/DB01_DG/db_wallet))) <======================== UNIQUE_NAME = DB01_DG
ENCRYPTION_WALLET_LOCATION=
    (SOURCE=
      (METHOD=FILE)
      (METHOD_DATA=(/var/opt/oracle/dbaas_acfs/DB01_DG/wallet_root/tde)))  <======================== UNIQUE_NAME = DB01_DG
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
 
 
 
 
[oracle@exacc02db01 ~]$ cat /u02/app/oracle/product/12.1.0/dbhome_1/network/admin/DB02/sqlnet.ora
HTTPS_SSL_VERSION=1.2
SQLNET.CRYPTO_CHECKSUM_CLIENT=ACCEPTED
SQLNET.CRYPTO_CHECKSUM_SERVER=ACCEPTED
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA256,SHA384,SHA512,SHA1)
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA256,SHA384,SHA512)
SQLNET.ENCRYPTION_CLIENT=REQUESTED
SQLNET.ENCRYPTION_SERVER=REQUESTED
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128)
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128)
SQLNET.EXPIRE_TIME=10
SQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS=TRUE
SQLNET.WALLET_OVERRIDE=FALSE
SSL_CIPHER_SUITES=(SSL_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256,SSL_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384,SSL_ECDHE_RSA_WITH_AES_128_GCM_SHA256,SSL_ECDHE_RSA_WITH_AES_256_GCM_SHA384)
SSL_CLIENT_AUTHENTICATION=FALSE
SSL_VERSION=1.2
WALLET_LOCATION=
    (SOURCE=
      (METHOD=FILE)
      (METHOD_DATA=(DIRECTORY=/var/opt/oracle/dbaas_acfs/DB02_DG/db_wallet))) <======================== UNIQUE_NAME = DB02_DG
ENCRYPTION_WALLET_LOCATION=
    (SOURCE=
      (METHOD=FILE)
      (METHOD_DATA=(/var/opt/oracle/dbaas_acfs/DB02_DG/wallet_root/tde)))  <======================== UNIQUE_NAME = DB02_DG
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
 
 
 
[oracle@exacc02db01 ~]$ cat /u02/app/oracle/product/19.0.0.0/dbhome_1/network/admin/DB03/sqlnet.ora
HTTPS_SSL_VERSION=1.2
SQLNET.CRYPTO_CHECKSUM_CLIENT=ACCEPTED
SQLNET.CRYPTO_CHECKSUM_SERVER=ACCEPTED
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA256,SHA384,SHA512,SHA1)
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA256,SHA384,SHA512)
SQLNET.ENCRYPTION_CLIENT=REQUESTED
SQLNET.ENCRYPTION_SERVER=REQUESTED
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128)
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128)
SQLNET.EXPIRE_TIME=10
SQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS=TRUE
SQLNET.WALLET_OVERRIDE=FALSE
SSL_CIPHER_SUITES=(SSL_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256,SSL_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384,SSL_ECDHE_RSA_WITH_AES_128_GCM_SHA256,SSL_ECDHE_RSA_WITH_AES_256_GCM_SHA384)
SSL_CLIENT_AUTHENTICATION=FALSE
SSL_VERSION=1.2
WALLET_LOCATION=
    (SOURCE=
      (METHOD=FILE)
      (METHOD_DATA=(DIRECTORY=/var/opt/oracle/dbaas_acfs/DB03_DG/db_wallet))) <======================== UNIQUE_NAME = DB03_DG
ENCRYPTION_WALLET_LOCATION=
    (SOURCE=
      (METHOD=FILE)
      (METHOD_DATA=(/var/opt/oracle/dbaas_acfs/DB03_DG/wallet_root/tde)))  <======================== UNIQUE_NAME = DB03_DG
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
ShellScript

10 – Verificar INTERCONNECTS:

su - grid
[grid@exacc02db01 ~]$ sqlplus / as sysdba
SQL> select INST_ID, IP_ADDRESS from GV$CLUSTER_INTERCONNECTS;
 
   INST_ID IP_ADDRESS
---------- ----------------------------------------------
         1 10.1.2.1
         1 10.1.2.2
         2 10.1.2.3
         2 10.1.2.4
ShellScript

11 – Verificar SCAN:

[grid@exacc02db01 ~]$ srvctl config scan
SCAN name: exacc02-scan, Network: 1
Subnet IPv4: 10.1.1.0/255.255.255.0/bondeth0, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 10.1.1.36
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 10.1.1.34
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 10.1.1.35
SCAN VIP is enabled.
ShellScript

Leave a Reply

Your email address will not be published. Required fields are marked *

search previous next tag category expand menu location phone mail time cart zoom edit close