Oracle DG修改IP地址

最新推荐文章于 2023-09-17 11:09:19 发布
最新推荐文章于 2023-09-17 11:09:19 发布
阅读量1.4k 收藏 1
点赞数
文章标签： 数据库 safari dom cordova apk
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hbhe0316/article/details/122701533
版权
该篇博客详细记录了如何在Oracle环境中，将数据库节点IP地址从192.168.56.101和102更改为111和112，包括主机和备机的网络配置、监听器和tnsnames.ora文件的修改，以及数据库的启动、切换和验证过程。
摘要由CSDN通过智能技术生成

将192.168.56.101修改为192.168.56.111
将192.168.56.102修改为192.168.56.112
1.实验环境,dg01为Primary节点，dg02为Standby节点https://www.cndba.cn/hbhe0316/article/5041

[root@dg01 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.56.101 dg01
192.168.56.102 dg02
[root@dg01 ~]# su - oracle
Last login: Sat Nov  6 09:39:04 CST 2021 on pts/2
[oracle@dg01 ~]$ sqlplus -V

SQL*Plus: Release 19.0.0.0.0 - Production
Version 19.12.0.0.0

2.Primary节点和Standby节点停止数据库
主库:

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

备库:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Database altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

3.Primary节点和Standby节点停止监听
主库https://www.cndba.cn/hbhe0316/article/5041

https://www.cndba.cn/hbhe0316/article/5041 
[oracle@dg01 ~]$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-NOV-2021 10:08:24

Copyright (c) 1991, 2021, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg01)(PORT=1521)))
The command completed successfully

备库

https://www.cndba.cn/hbhe0316/article/5041 
[oracle@dg02 ~]$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-NOV-2021 10:08:50

Copyright (c) 1991, 2021, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg02)(PORT=1521)))
The command completed successfully

4.修改主库和备库IP地址
主库:

[root@dg01 ~]# cd /etc/sysconfig/network-scripts/
[root@dg01 network-scripts]# cat ifcfg-enp0s3 
TYPE=Ethernet
PROXY_METHOD=none
BROWSER_ONLY=no
BOOTPROTO=static
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6_ADDR_GEN_MODE=stable-privacy
NAME=enp0s3
DEVICE=enp0s3
ONBOOT=yes
IPADDR=192.168.56.111
NETMASK=255.255.255.0
GATEWAY=192.168.56.1

备库:

[root@dg02 ~]# cd /etc/sysconfig/network-scripts/
[root@dg02 network-scripts]# cat ifcfg-enp0s3 
TYPE=Ethernet
PROXY_METHOD=none
BROWSER_ONLY=no
BOOTPROTO=static
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6_ADDR_GEN_MODE=stable-privacy
NAME=enp0s3
DEVICE=enp0s3
ONBOOT=yes
IPADDR=192.168.56.112
NETMASK=255.255.255.0
GATEWAY=192.168.56.1

5.主库和备库重启网卡
主库:

[root@dg01 network-scripts]# systemctl restart network.service

备库:https://www.cndba.cn/hbhe0316/article/5041https://www.cndba.cn/hbhe0316/article/5041

[root@dg02 network-scripts]# systemctl restart network.service

6.使用新的IP登录主备机,并修改/etc/hosts文件
主库:

https://www.cndba.cn/hbhe0316/article/5041 
[root@dg01 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.56.111 dg01
192.168.56.112 dg02

备库:

[root@dg01 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.56.111 dg01
192.168.56.112 dg02

7.修改tnsnams.ora文件
主库:https://www.cndba.cn/hbhe0316/article/5041

[root@dg01 ~]# su - oracle
Last login: Sat Nov  6 09:57:19 CST 2021 on pts/2
[oracle@dg01 ~]$ cd $ORACLE_HOME/network/admin
[oracle@dg01 admin]$ cat tnsnames.ora 
LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = dg01)(PORT = 1521))


ORCL_P =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg01)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

ORCL_S =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg02)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

备库:

[root@dg02 ~]# su - oracle
Last login: Sat Nov  6 10:08:46 CST 2021 on pts/2
[oracle@dg02 ~]$ cd $ORACLE_HOME/network/admin
[oracle@dg02 admin]$ cat tnsnames.ora
ORCL_P =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg01)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

ORCL_S =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg02)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

8.修改listener.ora文件
主库:https://www.cndba.cn/hbhe0316/article/5041

https://www.cndba.cn/hbhe0316/article/5041 
[oracle@dg01 ~]$ cd $ORACLE_HOME/network/admin
[oracle@dg01 admin]$ cat listener.ora 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/19.3.0/dbhome_1)
      (SID_NAME = orcl)
    )
  )

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

ADR_BASE_LISTENER = /u01/app/oracle

备库:

[oracle@dg02 admin]$ cat listener.ora 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/19.3.0/dbhome_1)
      (SID_NAME = orcl)
    )
  )

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

ADR_BASE_LISTENER = /u01/app/oracle

9.启动主库和备库监听
主库:

[oracle@dg01 admin]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-NOV-2021 10:26:45

Copyright (c) 1991, 2021, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/19.3.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/dg01/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg01)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg01)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                06-NOV-2021 10:26:46
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/dg01/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg01)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

备库

[oracle@dg02 ~]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-NOV-2021 10:28:16

Copyright (c) 1991, 2021, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/19.3.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/dg02/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg02)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg02)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                06-NOV-2021 10:28:16
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/dg02/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg02)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

10.启动主库和备库数据库
备库:

[oracle@dg02 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 6 10:29:26 2021
Version 19.12.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 2516581448 bytes
Fixed Size                  9141320 bytes
Variable Size             654311424 bytes
Database Buffers         1845493760 bytes
Redo Buffers                7634944 bytes
SQL> alter database mount standby database;

Database altered.

SQL> alter database open read only;

Database altered.

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

主库:

SQL> STARTUP
ORACLE instance started.

Total System Global Area 2516581448 bytes
Fixed Size                  9141320 bytes
Variable Size            1157627904 bytes
Database Buffers         1342177280 bytes
Redo Buffers                7634944 bytes
Database mounted.
Database opened.

11.验证主备库状态
主库:

SQL> set linesize 200
SQL> set pagesize 200
SQL> select open_mode,protection_mode,database_role,switchover_status from v$database;

OPEN_MODE                                                    PROTECTION_MODE                                              DATABASE_ROLE
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------
SWITCHOVER_STATUS
------------------------------------------------------------
READ WRITE                                                   MAXIMUM PERFORMANCE                                          PRIMARY
TO STANDBY

备库:

SQL> set linesize 200
SQL> set pagesize 200
SQL> select open_mode,protection_mode,database_role,switchover_status from v$database;

OPEN_MODE                                                    PROTECTION_MODE                                              DATABASE_ROLE
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------
SWITCHOVER_STATUS
------------------------------------------------------------
READ ONLY WITH APPLY                                         MAXIMUM PERFORMANCE                                          PHYSICAL STANDBY
NOT ALLOWED

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle

hbhe0316
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle Active Dataguard 之更改服务器IP
种瓜得瓜，种豆得豆
04-08 578
背景 Oracle 数据库 + Active dataguard + DG Broker主备模式 需要更改主备数据库服务器的IP地址，因为不是RAC环境，只有Dataguard配置，只涉及到更改listener.ora和tnsnames.ora文件，重启监听即可，在此做个简单记录 测试环境 OS: CentOS 7.8 Oracle 12.1.0.2 原服务器ip: 新服务器ip 172.16.79.231 172.16.79.237 172.16.79...
Oracle DG实施
12-06
在开始实施Oracle DataGuard之前，首先需要了解主数据库和备数据库的环境配置，包括操作系统版本、IP地址、数据库版本、数据库名、SID、唯一数据库名和实例名。这些信息对于确保Oracle DataGuard配置正确至关重要。 ...
Oracle DG换IP.txt
06-10
oracle dataguard ，Oracle DG换IP.txt
oracle dg主备切换 更换ip,【DG】主备切换
weixin_33277215的博客
04-16 693
一：DG之主备切换(主切备、备切主)1)主切备：SYS@ORA11GR2>selectdatabase_role,switchover_status from v$database;DATABASE_ROLESWITCHOVER_STATUS---------------- --------------------PRIMARYSESSIONS ACTIVESYS@ORA11GR2>a...
Data Guard 环境修改主备库IP地址
David Dai -- Focus on Oracle
12-20 7753
<br /> <br />       公司机房搬迁，Data Guard 环境需要修改IP地址。提前整理顺便测试一下。虽然只有几步，但怕晚上头晕了出了纰漏。  整理好了，晚上直接按文档，一步一步操作就可以了。<br /> <br /> <br />一.  IP 及数据库信息<br />修改之前：<br />主库：192.168.2.242<br />备库：192.168.2.243<br /> <br />修改之后：<br />主库：192.168.2.22<br />备库：192.168.2.23<br
DG备库改IP和DB_UNIQUE_NAME
Baldwin的博客
07-22 362
主库和备库都是11g单实例 主库 alter system set log_archive_dest_state_2 = defer scope = both sid= '*'; 备库 alter database recover managed standby database cancel; shu immediate lsnrctl stop 创建pfile之后在pfile中把db_unique_name改成orcldg create pfile from spfile; 改好之后 creat
Oracle 12c RAC+DG安装配置
08-09
在进行Oracle 12c RAC+DG的安装前，必须对硬件配置、IP地址规划和存储布局有清晰的理解。 1. 硬件配置：确保每台虚拟机（VM）有足够的内存、CPU资源以及共享磁盘空间来运行Oracle数据库实例。通常，RAC节点至少需要...
Oracle 11g RAC+DG安装配置
08-09
2. **IP 地址规划**：每个节点（主机）需要有私有 IP 地址用于集群内部通信，公开 IP 地址用于客户端连接。此外，还需要浮动 IP 地址用于自动故障切换。 3. **本地磁盘分区规划**：为 ASM (Automatic Storage ...
ORACLE 12c DG实测-主从转换
09-30
- IP地址: 10.168.9.52 - SID: bbcdb - Unique Name: bbc ##### 从库配置: - IP地址: 10.168.9.53 - SID: bbcdb - Unique Name: abc **注意事项**: - 备库需要使用主库的密码文件。 #### 三、主从数据库状态查询 ...
oracle rac dg
最新发布
05-16
- **公网IP地址**：10.134.82.200 - **ORACLE SID**：dgtest #### 五、数据保护模式 Oracle Data Guard 提供了三种不同的数据保护级别，以适应不同的业务需求： 1. **最大保护模式(Maximum Protection)**：确保...
oracle dataguard 备库自动切换主为库,ORACLE DataGuard主备切换
weixin_39915171的博客
04-12 488
主库磁盘问题，导致主库宕机，因为归档还没有应用，导致备库无法转为主库先查看一下备库当前的信息：SQL>select*fromv$version;BANNER---------------------------------------------------------------------OracleDatabase11gEnterpriseEditionRelease...
Oracle data guard 主库备库切换演练
听雪楼主
05-10 1794
本实验做的是将primary主库和standby  步骤如下：  1 在主库端检查数据库可切换状态 SQL> select switchover_status from v$database;11 SWITCHOVER_STATUS–>TO STANDBY,表示可以正常切换.  SWITCHOVER_STATUS–>SESSIONS ACTIVE,表示当前有会话处于ACTIVE状
oracle dataguard 备库自动切换主为库,DataGuard切换(主库为Rac+备库为Rac)
weixin_39958911的博客
04-12 345
前段时间做了一次主备库的切换，大体写下操作步骤和记录，分享下。环境：db version:11.2.0.3主库：两节点的RAC备库：两节点的RAC是异地灾备，网络质量不太好。步骤：1.检查日志应用情况standby database(备库检查)：SQL> select thread#,SEQUENCE#,FIRST_TIME,next_time,applied from gv$archive...
RAC如何在不停止数据库实例和集群服务的情况下修改IP地址
千里足迹
02-28 1362
修改RAC的IP通常修改的是公共网络的IP地址（包括：公共IP，VIP，SCAN VIP），只要不修改私有网络的IP地址，Clusterware服务和RAC所有实例都不需要停止，这样可以更有效的保障数据安全和节约时间。 这篇文章将以Oracle 11gR2 RAC for Linux修改公共网络的网段来讨论如何在不停止数据库实例和集群服务的情况下完成。 >>这里还有三点需要说明一下：
oracle dataguard 自动故障转移及VIP漂移
xiaohan4536的专栏
09-17 537
oracle dataguard lvs keepalived vip adg dgmgrl
Oracle 11g RAC 修改服务器各类ip地址【转载】
qq_32838955的博客
04-25 2301
此文转载自“架构君” ，地址：https://javajgs.com/archives/72358 此文说明较为详细，所以留作参考，详细内容如下。 Oracle 11g RAC 修改各类IP地址 首先，我们都知道Oracle 11g RAC中的IP主要有：Public IP、VIP、SCAN VIP、Private IP这几种。 一般这类改IP地址或者网卡名称的需求主要场景有： 机房搬迁网络变更、系统上线由测试IP更改为生产IP、系统层面双网卡绑定或者解绑等。 我这里实验环境的需求是： 之前在Virtual
Oracle 12c Data Guard 环境修改主备库IP地址
leo__1990的博客
05-16 940
因为虚拟机IP 地址冲突，需要修改DG IP 地址，顺便测试一下 DG 修改IP的步骤。 一. IP 及数据库信息 修改之前： 主库：192.168.1.60 备库：192.168.1.61 修改之后： 主库：192.168.1.10 备库：192.168.1.11 数据库版本：12.2.0.1.0 操作系统版本： Redhat 7.3 二. Shut...
Oracle DG环境搭建手册：从零开始学习Oracle DG
* 删除 HWADDR，修改 IPADDR，保存退出 * 使用 secureCRT 创建新的网络连接 **第四章： Oracle DG 环境搭建** * 使用虚拟机模板搭建 DG 环境 * 配置网络设置，启动数据库 * 使用 Oracle 官方支持平台，获取解决...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值