oracle18C (多租户模式) ADG部署流程

最新推荐文章于 2025-10-13 14:00:22 发布

原创

最新推荐文章于 2025-10-13 14:00:22 发布 · 1.1k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库

系列文章目录

第一章 ADG基本知识
第二章 oracle18C ADG部署流程
第三章 oracle18c OGG级联模式（ADG模式级联 Downstream库+OGG18）

文章目录

系列文章目录
前言
一、环境说明
二、使用步骤
总结

前言

oracle18c ADG

提示：以下是本篇文章正文内容，下面案例可供参考

一、环境说明

oracle版本：Version 18.3.0.0.0

角色	IP	主机名	sid	global_names	service_names	db_unique_name
主库	192.168.103.31	pri	orcl	pri	pri	pri
备库	192.168.103.32	adg	orcl	adg	adg	pri

二、使用步骤

1.检查数据库各个参数

要保证每个实例的db_unique_name和global_name不同

SQL> show parameter db_unique_name;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_unique_name			     string	 pri
SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
pri

2.配置网络，添加tnsnames字符串

cd $ORACLE_HOME/network/admin
vim tnsnames.ora 
##添加以下内容

PRI =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.103.31)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pri)
    )
  )

ADG =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.103.32)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = adg)
    )
  )

检查是否可达

[oracle@adg admin]$ tnsping pri

TNS Ping Utility for Linux: Version 18.0.0.0.0 - Production on 06-APR-2022 22:15:55

Copyright (c) 1997, 2018, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/18.3.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.103.31)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pri)))
OK (10 msec)
[oracle@adg admin]$ tnsping adg

TNS Ping Utility for Linux: Version 18.0.0.0.0 - Production on 06-APR-2022 22:15:57

Copyright (c) 1997, 2018, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/18.3.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.103.32)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = adg)))
OK (10 msec)