当前位置:Gxlcms > 数据库问题 > Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle 11.2 之01(安装配置)

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle 11.2 之01(安装配置)

时间:2021-07-01 10:21:17 帮助过:2人阅读

1.假设条件

您有两台服务器,其中装有操作系统,并在其上安装了Oracle Linux 7 和Oracle Database 11.2.0.4。
主服务器XAG200上安装了实例。
备服务器XAG201上仅软件安装。

2.修改主机名(从克隆过来的vm)

[root@xag100 ~]# cat /etc/hostname
xag200

[oracle@xag100 ~]$ cat /etc/sysconfig/network
# Created by anaconda
NETWORKING=yes
HOSTNAME=xag200
# oracle-rdbms-server-11gR2-preinstall : Add NOZEROCONF=yes
NOZEROCONF=yes

vim /etc/hosts
#增加如下
192.168.40.200  xag200
192.168.40.201  xag201

3.網卡配置

[root@xag100 ~]# cd /etc/sysconfig/network-scripts/

[root@xag100 network-scripts]# cat ifcfg-ens33 
TYPE="Ethernet"
PROXY_METHOD="none"
BROWSER_ONLY="no"
BOOTPROTO="static"
DEFROUTE="yes"
IPV4_FAILURE_FATAL="no"
NAME="ens33"
UUID="0224e944-0b68-47d5-b327-71d0e5560845"
DEVICE="ens33"
ONBOOT="yes"
IPADDR="192.168.40.200"
GATEWAY="192.168.40.2"
NETMASK="255.255.255.0"
DNS1="8.8.8.8"

#重啟網卡
[root@xag100 network-scripts]# service network restart

4.修改监听

[oracle@xag100 ~]$ cd $ORACLE_HOME/network/admin

[oracle@xag100 admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0.4/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xag200)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@xag100 admin]$ cat tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0.4/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DB100 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xag200)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB100)
    )
  )

5.重启OS

6.重复上面步骤1到步骤5 配置备机xag201 后重启os

7.安装监听(xag201)

[oracle@xag200 ~]$ export DISPLAY=192.168.0.7:0.0

[oracle@xag200 ~]$ netca

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle 11.2 之01(安装配置)

标签:inux   mes   one   主机   created   linux   rip   安装   admin   

人气教程排行