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

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