1. 为内部部署 Oracle Exadata 部署混合 DR 拓扑
  2. 配置监听程序和 SQLNet.ora

配置监听程序和 SQLNet.ora

配置 Oracle Database Exadata Cloud Service 和内部部署 Oracle Exadata Database Machine 的所有节点上的监听程序。

将静态监听程序添加到备用实例

将静态监听程序添加到 Oracle Database Exadata Cloud Service 实例上的网格主目录。

  1. 在 Oracle Database Exadata Cloud Service 实例的节点 1 上创建监听程序文件。
    以下是示例文件。更改环境的 GLOBAL_DBNAME 和 SID_NAME。 
    [grid@exacs82-vm3sv1 admin]$ cat listener.ora
    LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))
# line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3))
))
# line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))
))
# line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))
))
# line added by Agent
ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM
))))
# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON
# line added by Agent
VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET
# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON
# line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF
# line added by Agent - 
Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON
# line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN2=OFF
# line added by Agent - 
Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON
# line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN3=OFF
# line added by Agent - 
Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON
# line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET
# line added by Agent
SSL_CLIENT_AUTHENTICATION = FALSE
WALLET_LOCATION=(SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = 
/var/opt/oracle/dbaas_acfs/grid/tcps_wallets)))
SID_LIST_LISTENER =
(SID_LIST =
  (SID_DESC =
   (GLOBAL_DBNAME = DB1_phx3g7)
   (ORACLE_HOME = /u02/app/oracle/product/19.0.0.0/dbhome_5)
   (SID_NAME = DB11)
  )
)
  2. 以 opc 用户身份登录节点。
    ssh -i cluster.key opc@10.255.195.131
  3. Sudo to grid user。
    sudo su - grid
  4. 更新环境。
    $ . oraenv
ORACLE_SID = [DB11] ? +ASM1
    输出将类似于以下内容：
    The Oracle base has been changed from /u02/app/oracle to /u01/app/grid
  5. 确认监听程序文件位于$ORACLE_HOME/network/admin 目录中。
    cd $ORACLE_HOME/network/admin
ls -lrt
  6. 重新加载监听程序。
    [grid@exacs82-vm3sv1 admin]$ lsnrctl reload
  7. 检查监听程序的状态。
    [grid@exacs82-vm3sv1 admin]$ lsnrctl status
    输出将类似于以下内容：
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                18-JAN-2021 03:42:09
Uptime                    10 days 8 hr. 47 min. 53 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/19.0.0.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/exacs82-
vm3sv1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
Services Summary...
Service "DB1_phx3g7" has 1 instance(s).
  Instance "DB11", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
  8. 搜索节点以验证监听程序。
    lsnrctl services | grep DB1
    输出将与以下内容类似：
    Service "DB1_phx3g7" has 1 instance(s).
  Instance "DB11", status UNKNOWN, has 1 handler(s) for this service...
Service "DB1_phx3g7.datasubnetactiv.oscphevcn.oraclevcn.com" has 1 instance(s).
  Instance "DB11", status BLOCKED, has 1 handler(s) for this service...
[oracle@exacs82-vm3sv1 DB1]$ Connection to 10.255.195.131 closed by remote host.
  9. 启动 Oracle Database Exadata Cloud Service 实例。
    [oracle@exacs82-vm3sv1 ~]$ sqlplus / as sysdba
SQL> startup mount;

配置 SQL Net.Ora

配置 sqlnet.ora 文件并将其复制到主 Exadata 实例和备用 Exadata 实例的所有节点，包括网格主目录。SQLNET.ora 配置必须存在于内部部署 Oracle Exadata Database Machine 和 Oracle Database Exadata Cloud Service 上。

以下是节点间值的快照。

Wallet 文件位置必须存在于主 Exadata 实例和备用 Exadata 实例上的 SQLNet.ora 文件中。确保 SQLNET.ora 文件中没有换行符或空格。

  1. 登录到主内部部署 Exadata 的 Oracle 主目录节点 1，然后设置 sqlnet.ora。
    [oracle@exa11db01 admin]$ cat sqlnet.ora
    下面是输出示例。
    # sqlnet.ora.exa11db01 Network Configuration File: 
/u01/app/19.0.0.0/grid/network/admin/sqlnet.ora.exa11db01
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.EXPIRE_TIME=10
SQLNET.ENCRYPTION_SERVER=REQUIRED 
SQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED 
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128) 
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1) 
SQLNET.ENCRYPTION_CLIENT=REQUIRED 
SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIRED 
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128) 
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1)
ENCRYPTION_WALLET_LOCATION = 
 (SOURCE=
  (METHOD=FILE)
   (METHOD_DATA=
    (DIRECTORY=/u01/app/oracle/admin/db1/wallet/)))
  2. 登录到主内部部署 Exadata 的 Oracle 主目录节点 2，然后设置 sqlnet.ora。
    [oracle@exa11db02 admin]$ cat sqlnet.ora
    下面是输出示例。
    # sqlnet.ora.exa11db01 Network Configuration File: 
/u01/app/19.0.0.0/grid/network/admin/sqlnet.ora.exa11db01
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.EXPIRE_TIME=10
SQLNET.ENCRYPTION_SERVER=REQUIRED 
SQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED 
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128) 
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1) 
SQLNET.ENCRYPTION_CLIENT=REQUIRED 
SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIRED 
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128) 
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1)
ENCRYPTION_WALLET_LOCATION = 
 (SOURCE=
  (METHOD=FILE)
   (METHOD_DATA=
    (DIRECTORY=/u01/app/oracle/admin/db1/wallet/)))
  3. 登录到主内部部署 Exadata 的网格主目录节点 1，然后设置 sqlnet.ora。
    [oracle@exa11db01 admin]$ cat sqlnet.ora
    下面是输出示例。
    # sqlnet.ora.exa11db02 Network Configuration File: 
/u01/app/19.0.0.0/grid/network/admin/sqlnet.ora.exa11db01
# Generated by Oracle configuration tools.
#(Default Values)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.EXPIRE_TIME=10
  4. 登录到主内部部署 Exadata 的网格主目录节点 2，然后设置 sqlnet.ora。
    [oracle@exa11db02 admin]$ cat sqlnet.ora
    下面是输出示例。
    # sqlnet.ora.exa11db02 Network Configuration File: 
/u01/app/19.0.0.0/grid/network/admin/sqlnet.ora.exa11db02
# Generated by Oracle configuration tools.
#(Default Values)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.EXPIRE_TIME=10
  5. 登录备用 Oracle Database Exadata Cloud Service 的节点 1，然后设置 sqlnet.ora。
    [oracle@exacs82-vm3sv1 DB1]$ cat sqlnet.ora
    下面是输出示例。
    # sqlnet.ora.exa11db01 Network Configuration File: 
/u01/app/19.0.0.0/grid/network/admin/sqlnet.ora.exa11db01
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.EXPIRE_TIME=10
SQLNET.ENCRYPTION_SERVER=REQUIRED 
SQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED 
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128) 
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1) 
SQLNET.ENCRYPTION_CLIENT=REQUIRED 
SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIRED 
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128) 
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1)
ENCRYPTION_WALLET_LOCATION = 
 (SOURCE=
  (METHOD=FILE)
   (METHOD_DATA=
    (DIRECTORY=/var/opt/oracle/dbaas_acfs/DB1/wallet_root/tde)))
  6. 登录备用 Oracle Database Exadata Cloud Service 的节点 2，然后设置 sqlnet.ora。
    [oracle@exacs82-vm3sv2 DB1]$ cat sqlnet.ora
    下面是输出示例。
    SQLNET.ENCRYPTION_TYPES_CLIENT = (AES256, AES192, AES128)
SQLNET.ENCRYPTION_SERVER = requested
SSL_CLIENT_AUTHENTICATION = FALSE
SQLNET.ENCRYPTION_CLIENT = requested
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)
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (SHA256, SHA384, SHA512, SHA1)
HTTPS_SSL_VERSION = 1.2
SQLNET.WALLET_OVERRIDE = FALSE
SQLNET.EXPIRE_TIME = 10
WALLET_LOCATION = 
(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/var/opt/oracle/dbaas_acfs/grid/tcps_wall
ets)))
SQLNET.CRYPTO_CHECKSUM_CLIENT = accepted
SQLNET.CRYPTO_CHECKSUM_SERVER = accepted
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA256, SHA384, SHA512)
ENCRYPTION_WALLET_LOCATION = 
 (SOURCE=
  (METHOD=FILE)
   (METHOD_DATA=
    (DIRECTORY=/var/opt/oracle/dbaas_acfs/DB1/wallet_root/tde)))
SQLNET.ENCRYPTION_TYPES_SERVER = (AES256, AES192, AES128)
SQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS = TRUE
SSL_VERSION = 1.2
  7. 登录备用 Oracle Database Exadata Cloud Service 的网格主目录节点 1，然后设置 sqlnet.ora。
    [grid@exacs82-vm3sv1 admin]$ cat sqlnet.ora
    下面是输出示例。
    #SQLNET.ENCRYPTION_SERVER = requested
#SQLNET.ENCRYPTION_TYPES_CLIENT = (AES256, AES192, AES128)
#SSL_CLIENT_AUTHENTICATION = FALSE
#SQLNET.ENCRYPTION_CLIENT = requested
#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)
#SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (SHA256, SHA384, SHA512, SHA1)
#HTTPS_SSL_VERSION = 1.2
#NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
#SQLNET.EXPIRE_TIME = 10
#SQLNET.WALLET_OVERRIDE = FALSE
WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = 
/u02/app/oracle/admin/grid/grid_wallet)))
#SQLNET.CRYPTO_CHECKSUM_CLIENT = accepted
#SQLNET.CRYPTO_CHECKSUM_SERVER = accepted
#SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA256, SHA384, SHA512, SHA1)
#SQLNET.ENCRYPTION_TYPES_SERVER = (AES256, AES192, AES128)
#SQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS = TRUE
#SSL_VERSION = 1.2
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.EXPIRE_TIME=10
SQLNET.ENCRYPTION_SERVER=REQUIRED 
SQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED 
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128) 
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1) 
SQLNET.ENCRYPTION_CLIENT=REQUIRED 
SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIRED 
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128) 
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1)
  8. 登录备用 Oracle Database Exadata Cloud Service 的网格主目录节点 2，然后设置 sqlnet.ora。
    [grid@exacs82-vm3sv2 admin]$ cat sqlnet.ora
    下面是输出示例。
    SQLNET.ENCRYPTION_SERVER = requested
SQLNET.ENCRYPTION_TYPES_CLIENT = (AES256, AES192, AES128)
SSL_CLIENT_AUTHENTICATION = FALSE
SQLNET.ENCRYPTION_CLIENT = requested
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)
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (SHA256, SHA384, SHA512, SHA1)
HTTPS_SSL_VERSION = 1.2
NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
SQLNET.EXPIRE_TIME = 10
SQLNET.WALLET_OVERRIDE = FALSE
WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = 
/u02/app/oracle/admin/grid/grid_wallet)))
SQLNET.CRYPTO_CHECKSUM_CLIENT = accepted
SQLNET.CRYPTO_CHECKSUM_SERVER = accepted
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA256, SHA384, SHA512, SHA1)
SQLNET.ENCRYPTION_TYPES_SERVER = (AES256, AES192, AES128)
SQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS = TRUE
SSL_VERSION = 1.2

更新所有节点上的实例和数据库名称

Change the instance and database names in the tnsnames.ora file on all nodes of the primary on-premises Exadata and the standby Oracle Database Exadata Cloud Service. Entries for each database are needed in both primary and standby tnsnames.ora files for proper redo transport.

在此示例中。

  • DB1：主要内部部署 Oracle Exadata Database Machine 数据库名称
  • db11：节点 1 上的数据库实例名
  • db12：节点 2 上的数据库实例名
  • DB1_phx3g7：唯一 Oracle Database Exadata Cloud Service 实例名。
  • DB11：节点 1 上的 Oracle Database Exadata Cloud Service 实例名称 1
  • DB12：节点 2 上的 Oracle Database Exadata Cloud Service 实例名称 2

如果主数据库在本地 tnsnames.ora 文件中具有 TNS 条目，其中包含 HOST 的服务器名称，则将该条目中的服务器名称更改为使用主机的 IP 地址。由于内部部署环境和云环境之间没有用于将服务器名称解析为 IP 地址的 DNS，因此将使用 IP 地址。

Oracle Real Application Clusters (Oracle RAC ) 配置无法解析扫描监听程序名称；因此，必须使用列出所有节点的地址列表。稍后将添加这些内容，初始实例只应在 TNS 条目中列出一个 IP，以确保 Oracle Recovery Manager (RMAN ) 始终连接到相同的节点

使用以下示例替换与配置相关的值。

  1. 在主内部部署 Exadata 的节点 1 上，更新 tnsnames.ora 文件中的服务名和实例名。
    [oracle@exa11db01 admin]$ cat tnsnames.ora
    下面是输出示例。
    # tnsnames.ora Network Configuration File: 
/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
DB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.136.74.2)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
     #(SERVICE_NAME = db1.service_name)
     (SERVICE_NAME = DB1)
      (INSTANCE_NAME = db11)
    )
  )
DB1_phx3g7 =
  (DESCRIPTION =
    (SDU = 65536)
    (RECV_BUF_SIZE = 134217728)
    (SEND_BUF_SIZE = 134217728)
    (ADDRESS_LIST =
      (CONNECT_TIMEOUT = 3)
      (RETRY_COUNT = 3)
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.255.195.136)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB1_phx3g7.service_name)
      (UR = A)
    )
  )
  2. 在主内部部署 Exadata 的节点 2 上，更新 tnsnames.ora 文件中的服务名和实例名。
    [oracle@exa11db02 admin]$ cat tnsnames.ora
    下面是输出示例。
    # tnsnames.ora.exa11db02 Network Configuration File: 
/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/tnsnames.ora.exa11db02
# Generated by Oracle configuration tools.
DB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = exa11-scan1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db1.service_name)
      (INSTANCE_NAME = db12)
    )
  )
DB1_phx3g7 =
  (DESCRIPTION =
    (SDU = 65536)
    (RECV_BUF_SIZE = 134217728)
    (SEND_BUF_SIZE = 134217728)
    (ADDRESS_LIST =
      (CONNECT_TIMEOUT = 3)
      (RETRY_COUNT = 3)
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.255.195.136)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB1_phx3g7.service_name)
      (UR = A)
    )
  )
  3. 在主内部部署 Exadata 的网格主目录节点 1 上，更新 tnsnames.ora 文件中的服务名和实例名。
    [oracle@exa11db01 admin]$ cat tnsnames.ora
    下面是输出示例。
    DB1_phx3g7 = 
(DESCRIPTION = 
(SDU=65536) (RECV_BUF_SIZE=134217728) 
(SEND_BUF_SIZE=134217728) 
(ADDRESS_LIST = 
(CONNECT_TIMEOUT=3)(RETRY_COUNT=3)
(ADDRESS = (PROTOCOL = TCP)(HOST =10.255.195.131)(PORT = 1521)) 
) 
(CONNECT_DATA = 
(SERVER = DEDICATED) 
(SERVICE_NAME = DB1_phx3g7)
(INSTANCE_NAME=DB11) 
(UR=A) 
)) 
db1 = 
(DESCRIPTION = 
(SDU=65536) (RECV_BUF_SIZE=134217728) 
(SEND_BUF_SIZE=134217728) 
(ADDRESS_LIST = 
(FAILOVER=on)
(CONNECT_TIMEOUT=3)(RETRY_COUNT=3)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.136.74.18)(PORT = 1521)) 
) 
(CONNECT_DATA = 
(SERVER = DEDICATED) 
(SERVICE_NAME = db1) 
(UR=A) 
))
  4. 登录备用 Oracle Database Exadata Cloud Service 的节点 1，然后更新 tnsnames.ora 文件中的服务名和实例名。
    [oracle@exacs82-vm3sv1 DB1]$ cat tnsnames.ora
    下面是输出示例。
    DB1_phx3g7 =
  (DESCRIPTION =
    (SDU = 65536)
    (RECV_BUF_SIZE = 134217728)
    (SEND_BUF_SIZE = 134217728)
    (ADDRESS_LIST =
      (CONNECT_TIMEOUT = 3)
      (RETRY_COUNT = 3)
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.255.195.136)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB1_phx3g7.service_name)
      (INSTANCE_NAME = DB11)
      (UR = A)
    )
  )
db1 = 
(DESCRIPTION = 
(SDU=65536) (RECV_BUF_SIZE=134217728) 
(SEND_BUF_SIZE=134217728) 
(ADDRESS_LIST = 
(FAILOVER=on)
(CONNECT_TIMEOUT=3)(RETRY_COUNT=3)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.136.74.18)(PORT = 1521))  
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db1.service_name)
      (INSTANCE_NAME = DB11)
      (UR = A)
    )
  )
  5. 在备用 Oracle Database Exadata Cloud Service 的节点 2 中，更新 tnsnames.ora 文件中的服务名和实例名。
    [oracle@exacs82-vm3sv2 DB1]$ cat tnsnames.ora
    下面是输出示例。
    db1 = 
(DESCRIPTION = 
(SDU=65536) (RECV_BUF_SIZE=134217728) 
(SEND_BUF_SIZE=134217728) 
(ADDRESS_LIST = 
(CONNECT_TIMEOUT=3)(RETRY_COUNT=3)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.136.74.18)(PORT = 1521)) 
) 
(CONNECT_DATA = 
(SERVER = DEDICATED) 
(SERVICE_NAME = db1.service_name) 
(UR=A) 
)
         ) 
DB1_phx3g7 =
  (DESCRIPTION =
    (SDU = 65536)
    (RECV_BUF_SIZE = 134217728)
    (SEND_BUF_SIZE = 134217728)
    (ADDRESS_LIST =
      (CONNECT_TIMEOUT = 3)
      (RETRY_COUNT = 3)
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.255.195.136)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB1_phx3g7.service_name)
      (INSTANCE_NAME = DB12)
      (UR = A)
    )
  )
  6. 登录备用 Oracle Database Exadata Cloud Service 的网格主目录节点 1，然后设置 sqlnet.ora。
    [grid@exacs82-vm3sv1 admin]$ cat tnsnames.ora
    下面是输出示例。
    DB1_phx3g7 = 
(DESCRIPTION = 
(SDU=65536) (RECV_BUF_SIZE=134217728) 
(SEND_BUF_SIZE=134217728) 
(ADDRESS_LIST = 
(CONNECT_TIMEOUT=3)(RETRY_COUNT=3)
(ADDRESS = (PROTOCOL = TCP)(HOST =10.255.195.131)(PORT = 1521)) 
) 
(CONNECT_DATA = 
(SERVER = DEDICATED) 
(SERVICE_NAME = DB1_phx3g7)
(INSTANCE_NAME=DB11) 
(UR=A) 
)) 
db1 = 
(DESCRIPTION = 
(SDU=65536) (RECV_BUF_SIZE=134217728) 
(SEND_BUF_SIZE=134217728) 
(ADDRESS_LIST = 
(FAILOVER=on)
(CONNECT_TIMEOUT=3)(RETRY_COUNT=3)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.136.74.18)(PORT = 1521)) 
) 
(CONNECT_DATA = 
(SERVER = DEDICATED) 
(SERVICE_NAME = db1.service_name) 
(UR=A) 
))

设置 TCP 套接字大小

对于内部部署系统和云实例，将 TCP 套接字大小设置为最大 128MB，以获得最佳传输性能。如果内部部署和云实例之间的值不匹配，网络协议将协商两个值中的较低值。

  1. 以 root 用户身份，检查内部部署系统的 TCP 套接字大小。
    /sbin/sysctl -a | egrep net.core.[w,r]mem_max
    输出将类似于以下内容：
    net.core.rmem_max = 4194304 
net.core.wmem_max = 2097152
  2. 以 root 用户身份，检查云实例的 TCP 套接字大小。
    /sbin/sysctl -a | egrep net.core.[w,r]mem_max
    输出将类似于以下内容：
    net.core.rmem_max = 134217728
net.core.wmem_max = 134217728
  3. 如果云实例的 TCP 套接字大小不是 128MB 或 134217728，则编辑 net.core.wmem_max 和 net.core.rmem_max 的/etc/sysctl.conf 文件设置到 134217728。