SUSE All-in-one + Oracle 11g ADG Modify the main library IP entire process

One, the description database version 11g, single instance ADG. The operating system version is SuSE SP3. ip:192.168.1.11 Repository ip:192.168.1.12 Second, the requirements of the main library needs to modify the IP address, to ensure the normal operation of the ADG environment. The main library IP is changed to: 192.168.1.10, the standby IP is not changed. Third, the Operation step 1, check whether the main standby library is currently running [email protected]:~> DGMGRL/DGMGRL for linux:version 11.2.0.1.0-64bit Productioncopyright (c), Oracle. All rights reserved. Welcome to DGMGRL, type ' help ' for information. Connected.dgmgrl> show configuration; Configuration-dg_broker Protection mode:maxperformance databases:mmpt-primary database mmptdg-physical standby dat Abasefast-start failover:disabledconfiguration status:successdgmgrl> 2, shut down master, standby lsnrctl stop Listenershutdown Immediate;3, modifying the operating system IP address mmpt-srj:/etc/sysconfig/network # lsconfig DHCP if-down.d if-up.d ifcfg-eth0 Ifcfg-lo Ifcfg.template Ifroute-lo Providers Scriptsmmpt-srj:/etc/sysconfig/network # vi ifcfg-eth0 bootproto= ' static ' broadcast= ' ethtool_options= ' ipaddr= ' 192.168.1.10/24 ' mtu= ' name= ' 82540EM Gigabit Ethernet Controller ' network= ' Remote_ipaddr= ' startmode= ' auto ' usercontrol= ' no ' ~ ~ ' ifcfg-eth0 "10L, 188C written mmpt-srj:/etc/sysconfig/network #/etc/init.d/network restartshutting down network interfaces:e Th0 Device:intel Corporation 82540EM Gigabit Ethernet Co-Done ..... Re-use the new IP address to connect ..... ..... 4, the main library to modify the listening file Listener.ora[email protected]:/fantlam/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin > VI Listener.ora sid_list_listener = (Sid_list = (Sid_desc = (Global_dbname = mmpt) (Oracle_home =/fantlam/oracle/app) /oracle/product/11.2.0/dbhome_1) (sid_name = mmpt))) LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168 .1.10) (PORT = 1521)) 4, the main library modifies the listening file tnsnames.ora[email protected]:/fantlam/oracle/app/oracle/product/11.2.0/ Dbhome_1/network/admin> VI tnsnames.ora# Tnsnames.ora network Configuration File:/fantlam/oracle/app/oracle/ product/11.2.0/dbhome_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools. MMPT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.10) (PORT = 1521)) (Connect_data = (SERVER = Dedicated) (service_name = mmpt))) MMPTDG = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.12) (PORT = 1521) ) (Connect_data = (SERVER = dedicated) (service_name = MMPTDG))) 4, the main library modifies the Hosts file mmpt-srj:~ # vi/etc/hosts## hosts this fil E describes a number of hostname-to-address# mappings for the TCP/IP subsystem. It is mostly# used at boot time, when no name servers was running.# on small systems, this file can be used instead of a# "named" Name server.# syntax:# # ip-address full-qualified-hostname short-hostname# 127.0.0.1 localhost# Special IPV6 addr esses::1 localhost ipv6-localhost ipv6-loopback fe00::0 ipv6-localnetff00::0 ipv6-mcastprefixff02::1 Ipv6-allnodesff02::2 ipv6-allrouters ff02::3 ipv6-allhosts#192.168.1.11 suse11.site suse11192.168.1.10 Mmpt-SRJ mmpt-srj192.168.1.12 MMPT-SRJ-DG Mmpt-srj-dg5, the repository does not need to be modified listener.ora[email protected]:/fantlam/oracle/app/ Oracle/product/11.2.0/dbhome_1/network/admin> cat Listener.ora Sid_list_listener = (SID_LIST = (SID_DESC = (Global_dbname = MMPTDG) (Oracle_home =/fantlam/oracle/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = MMPTDG))) LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.12) (PORT = 1521))) 6. Prepare to modify the listening file Tnsnames.ora[email&nbs P;protected]:/fantlam/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin> VI tnsnames.ora# Tnsnames.ora Network Configuration File:/fantlam/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools. MMPT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.10) (PORT = 1521)) (Connect_data = (SERVER = dedicated) (service_name = mmpt)) ) MMPTDG = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.12) (PORT = 1521)) (Connect_data = (SERVER = Dedicate D) (service_name = MMPT-SRJ-DG))) "Tnsnames.ora" 21L, 529C written 7, prepare the library to modify the Hosts file mmpt-srj-dg:~ # vi/etc/hosts## hosts Thi S file describes a number of hostname-to-address# mappings for the TCP/IP subsystem. It is mostly# used at boot TimE, when no name servers is running.# on small systems, the This file can be used instead of a# "named" Name server.# syntax:# # ip-address Full-qualified-hostname short-hostname#127.0.0.1 localhost# special IPv6 addresses::1 localhost Ipv6-localhost ipv6-loopbackfe00::0 ipv6-localnetff00::0 ipv6-mcastprefixff02::1 ipv6-allnodesff02::2 Ipv6-allroutersff02::3 ipv6-allhosts192.168.1.12 mmpt-srj-dg mmpt-srj-dg192.168.1.10 mmpt-SRJ mmpt-SRJ~ "/etc/hosts" 24L, 721C Written8, start master standby monitoring, test lsnrctl start listener tnsping mmpttnsping MMPT-DG output as follows:[email protected]:~> Lsnrctl Startlsnrctl for linux:version 11.2.0.1.0-production on 17-may-2018 16:31:16copyright (c) 1991,----Oracle. All rights reserved. Starting/fantlam/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr:please wait ... Tnslsnr for linux:version 11.2.0.1.0-productionsystem parameter file is/fantlam/oracle/app/oracle/product/11.2.0/ Dbhome_1/network/admin/listener.oralog messages Written to/fantlam/oracle/app/oracle/diag/tNslsnr/mmpt-srj/listener/alert/log.xmllistening on: (Description= (Address= (protocol=tcp) (HOST=192.168.1.10) (PORT =1521)) Connecting to (Description= (address= (protocol=tcp) (host=192.168.1.10) (port=1521)) STATUS of the LISTENER------------------------Alias listenerversion Tnslsnr for linux:version 11.2.0.1.0-productionstart Date 17- MAY-2018 16:31:16uptime 0 days 0 hr. 0 min. 0 sectrace level offsecurity on:local OS authenticationsnmp offlistener Param Eter File/fantlam/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oralistener Log file/fantlam/ oracle/app/oracle/diag/tnslsnr/mmpt-srj/listener/alert/log.xmllistening Endpoints Summary ... (Description= (address= (protocol=tcp) (host=192.168.1.10) (port=1521))) Services Summary ... Service "Mmpt" has 1 instance (s). Instance "Mmpt", status UNKNOWN, have 1 handler (s) for the This service ... The command completed successfully[email protected]:~> tnsping mmpttns Ping Utility for Linux:version 11.2.0.1.0 -Production on 17-may-2016:31:26copyright (c) 1997, Oracle. All rights reserved. Used parameter files:used TNSNames adapter to resolve the aliasattempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.10) (PORT = 1521)) (Connect_data = (SERVER = dedicated) (service_name = mmpt)) OK (0 msec) [email&nbs p;protected]:~> tnsping mmptdgtns Ping Utility for linux:version 11.2.0.1.0-production on 17-may-2018 16:31:31Copyri Ght (c) 1997, Oracle. All rights reserved. Used parameter files:used TNSNames adapter to resolve the aliasattempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.12) (PORT = 1521)) (Connect_data = (SERVER = dedicated) (service_name = MMPTDG)) OK (0 msec) [email&n Bsp;protected]:~> 8, start the main repository start the standby library, and then start the main library [email protected]:~> Sqlplus/as sysdbasql*plus:release 11.2.0.1.0 Production on Thu 16:32:42 2018Copyright (c) 1982, Oracle. All rights reserved. Connected to an idle instance. Sql> Startuporacle instance started.Total System Global area 784998400 bytesfixed size 2217464 bytesvariable size 473958920 bytesdatabase buffers 306184192 by Tesredo buffers 2637824 bytesdatabase mounted. Database opened. Sql> 9, verify adgmmpt-srj-dg:~ # su-oracle[email protected]:~> DGMGRL/DGMGRL for Linux:version 11.2.0.1.0-64bi T Productioncopyright (c), Oracle. All rights reserved. Welcome to DGMGRL, type ' help ' for information. Connected.dgmgrl> show configuration; Configuration-dg_broker Protection mode:maxperformance databases:mmpt-primary database mmptdg-physical standby dat Abasefast-start failover:disabledconfiguration status:successdgmgrl> 10, original repository modified edit database Mmpt set Property Staticconnectidentifier = ' (description= (address= (protocol=tcp) (host=192.168.1.10) (port=1521)) (CONNECT_DATA= ( service_name=mmpt) (instance_name=mmpt) (server=dedicated))) '; 11. Switch Test [email protected]:~> DGMGRL/DGMGRL for linux:version 11.2.0.1.0-64bit Productioncopyright (c) 2000, 200 9, Oracle. All Rights reserved. Welcome to DGMGRL, type ' help ' for information. Connected.dgmgrl> show configuration; Configuration-dg_broker Protection mode:maxperformance databases:mmptdg-primary database mmpt-physical standby dat Abasefast-start failover:disabledconfiguration status:successdgmgrl> Connect sys/[email protected] Connected.dgmgrl> switchover to Mmpt; Performing switchover now, please wait ... New Primary Database "Mmpt" is opening ... Operation requires shutdown of instance "MMPTDG" on the Database "MMPTDG" shutting down instance "MMPTDG" ... Ora-01109:database not OpenDatabase dismounted. ORACLE instance shut down. Operation requires startup of instance "MMPTDG" on Database "MMPTDG" starting instance "MMPTDG" ... ORACLE instance started. Database mounted. Database opened. Switchover succeeded, new primary is "Mmpt" dgmgrl>

SUSE one + Oracle 11g ADG Modify the main library IP whole process