Oracle DG修改hostname

最新推荐文章于 2024-08-09 14:57:37 发布
最新推荐文章于 2024-08-09 14:57:37 发布
阅读量488 收藏 1
点赞数
文章标签： 数据库 oracle apk safari cordova
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hbhe0316/article/details/122701535
版权

将dg01修改为dg001
将dg02修改为dg002
1.实验环境,dg01为Primary节点，dg02为Standby节点https://www.cndba.cn/hbhe0316/article/5042

[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.

备库:

https://www.cndba.cn/hbhe0316/article/5042
https://www.cndba.cn/hbhe0316/article/5042 
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/5042 
[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

备库

[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.修改主库和备库hostname
主库

[root@dg01 ~]# hostnamectl set-hostname dg001

备库

[root@dg02 ~]# hostnamectl set-hostname dg002

5.重新打开连接终端，并修改/etc/hosts文件
主库:

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

备库:

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

6.修改tnsnams.ora文件
主库:

[oracle@dg001 ~]$ cd $ORACLE_HOME/network/admin
[oracle@dg001 admin]$ cat tnsnames.ora 
LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = dg001)(PORT = 1521))


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

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

备库:

[oracle@dg002 ~]$ cd $ORACLE_HOME/network/admin
[oracle@dg002 admin]$ cat tnsnames.ora 
ORCL_P =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg001)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

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

7.修改listener.ora文件
主库:

https://www.cndba.cn/hbhe0316/article/5042 
[oracle@dg001 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 = dg001)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

备库:

[oracle@dg002 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 = dg002)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

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

https://www.cndba.cn/hbhe0316/article/5042 
[oracle@dg001 admin]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-NOV-2021 11:15:59

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/dg001/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg001)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg001)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                06-NOV-2021 11:15:59
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/dg001/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg001)(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

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

[oracle@dg002 admin]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-NOV-2021 11:16:27

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/dg002/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg002)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg002)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                06-NOV-2021 11:16:27
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/dg002/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg002)(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

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

[oracle@dg002 admin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 6 11:17:19 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.

主库:

[oracle@dg001 admin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Nov 6 11:18:13 2021
Version 19.12.0.0.0

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

Connected to an idle instance.

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.

10.验证主备库状态
主库:https://www.cndba.cn/hbhe0316/article/5042

https://www.cndba.cn/hbhe0316/article/5042 
SQL> set linesize 200
SQL> set pagesize 200
SQL> col open_mod for a30
SQL> col protection_mode for a30
SQL> col database_role for a20
SQL> col switchover_status for a20
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> col open_mod for a10
SQL> col protection_mode for a20
SQL> col database_role for a20
SQL> col switchover_status for a20
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
关注
ORACLE DG专题3--手把手部署DG 物理备库
本博客纯属个人学习记载，不对外负责，若有错误，请批评指正
09-17 2605
前言 笔者前文已介绍了ORACLE DG的成员身份与数据保护模式等相关理论知识，从本文开始，将进入ORACLE DG理论与实践相结合模式，深入理解ORACLE DG的内在原理与基本运维技能。本文讲述如何使用rman恢复方式搭建ORACLE DG物理备库—physical standby。 部署前规划 oracle DG要求主备数据库的DB_NAME相同，d...
Oracle 11gR2 DG部署（RMAN方式）
热门推荐
onlyshenmin的博客
07-16 1万+
Oracle DG部署（RMAN方式） Oracle DG部署（RMAN方式） 1.环境介绍 2.DG部署 2.1.建立主库orcl 2.2.主库开启归档 2.3.主库添加Standby Redo Log 2.4.从主库创建pfile文件 2.5.设置主库初始化参数 2.6.设置备库初始化参数 2.7.复制主库的密码文件到备库 2.8.创建备库相应的目录结构 2.9.配置主库和备库的监听 ...
oracle修改hostname
qq_52376111的博客
08-09 420
此时报错The listener supports no services，需要。parameter service_names 显示服务名。环境：centos6,oracle 11g。增加127.0.0.1 yforcl1。3、修改listener.ora文件。4、修改tnsnames.ora文件。之前的监听，默认localhost。register 强制注册服务。2、修改hostname。1、停止数据库以及监听。
Oracle单机修改hostname
hbhe0316的专栏
11-05 1075
1.实验环境 https://www.cndba.cn/hbhe0316/article/5038 [oracle@db01 ~]$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.9 (Maipo) [oracle@db01 ~]$ sqlplus -V SQL*Plus: ...
oracle linux sudo修改,Oracle Linux 7 修改 hostname
weixin_29332029的博客
04-03 307
Linux修改hostname的常用操作方法是——手工在/etc/sysconfig/network中追加"HOSTNAME=xxxxx"并重启系统，这个方法在Oracle Linux 7中是不生效的。那么在Oracle Linux 7中怎么配置hostname？来源于：How to Configure hostname in Oracle Linux 7 (Doc ID 2049221.1)解决...
oracle net listen 变慢的解决方法
lipps的专栏
10-25 719
具体操作步骤： 1）修改hostname为www.ixdba.net2）修改/etc/hosts,去掉原来的主机名的行，增加该行   192.168.60.253 www.ixdba.net3）重启数据库，查询instance信息   select * from v$instance;   得到新的HOST_NAME为www.ixdba.net4）修改listene
Oracle主机名改为IP地址
qq_41600330的博客
12-16 3872
前置条件： 虚拟机：win10、Oracle11g 1.初始主机名为本机电脑名称，改为IP地址 2.测试实例连接 3.第二天连接发现报“ora-12514的错误”错误； 百度后，修改 C:\Windows\System32\drivers\etc 下的hosts 文件，赋予当前用户修改hosts文件权限 4.监听文件添加一段 (SID_DESC = (SID_NAME = ORCL ) --实例名 (ORACLE_HOME = C:\oracle\product\
oracle 19c DG
12-20
1、环境说明 ...hostname dg1 dg2 SID orcl orcl DB_UNQUE_NAME orcl_p orcl_s 数据库文件路劲 /u01/app/oracle/oradata /u01/app/oracle/oradata 归档文件路劲 /u01/archivelog /u01/archivelog_s
Oracle11g搭建物理DG.docx|Oracle11g搭建物理DG.docx
11-11
- `HOSTNAME`: 主机名，例如dg1和dg2分别代表主库和备库的主机。 - `IP_ADDRESS`: 主备数据库的IP地址，如192.168.169.220和192.168.169.221。 - `DB_NAME`: 数据库名，如prod。 - `DB_UNIQUE_NAME`: 数据库唯一名称...
Ora_11g Rac R2 修改主机Hostname详解
xiaoxu oracle专栏
10-19 3591
1g RacR2 修改主机HOSTNAME详解
修改系统主机名
weixin_53389944的博客
03-30 8630
例如，要将主机名更改为 "mycomputer"，可以使用命令 hostnamectl set-hostname mycomputer。请注意，在Oracle Linux 7及更高版本中，建议使用hostnamectl命令来设置主机名。使用方法为： hostnamectl set-hostname [new_hostname]。hostnamectl set-hostname 命令用于设置主机名。注意：更改此文件后，请务必重新启动网络服务或重启系统以使更改生效。这将确保您的系统可以正常解析主机名。
oracle主机名修改
demonson的专栏
09-09 3014
oracle主机名修改   有的情况下，我们需要修改已经安装oracle数据库的主机名。以下是具体步骤 1.修改/etc/hosts    su -    vi /etc/hosts 2.修改network   vi /etc/sysconfig/network   注意以上两个文件必须全部修改，否则会错误，修改完毕后不会立即生效，如hostname看到还是旧的，需要rebo
oracle Linux 修改主机名
skv00d00的博客
01-29 251
nmcli general hostname overzeus nmcli general hostname overzeus systemctl restart systemd-hostnamed.service
『ORACLE』更改host主机名（11g）
OFF-LINE
05-18 3600
[root@Annie ~]# cd /etc/sysconfig/ [root@Annie sysconfig]# vi network NETWORKING=yes NETWORKING_IPV6=no HOSTNAME=EZreal GATEWAY=192.168.11.1 ~ ~ ~ ~ ~ ~ Type  :quit  to exit Vim [ro
在linux上安装完oracle数据库后，如何修改ORACLE_HOSTNAME
珑歆逸的专栏
04-07 5978
在linux上安装完oracle数据库后，如何修改ORACLE_HOSTNAME
修改oracle所在的linux主机名（hostname）
der322的博客
05-18 3287
测试环境：redhat 6.4, oracle 12c总共要修改3个地方1）[root@ora92 /]# vi /etc/hosts192.168.56.16 ora932）[root@ora92 /]# vi /etc/sysconfig/networkHOSTNAME=ora933）[oracle@ora93 ~]$vi /opt/oracle/product/12.2.0/dbhome/n...
oracle19c ORACLE_HOSTNAME
最新发布
09-06
`ORACLE_HOSTNAME` 是Oracle数据库环境中的一个环境变量。它用于指定数据库服务器的主机名。在Oracle的安装和配置过程中，这个变量可能被用于指定数据库的监听器（Listener）配置文件中的设置，确保客户端应用能够...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值