Shulou(Shulou.com)05/31 Report--

This article mainly explains "how Linux virtual machines copy Oracle databases by copying". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let Xiaobian take you to learn "How to copy Oracle database by Linux virtual machine"!

Oracle database is replicated by virtual machine copy method. Here, it is assumed that the database is Single Instance and the operating system is RedHat Linux. The processing flow is as follows:

1. Virtual machine copy via tools such as WorkStation or VCenter

2. Open a new copy of the virtual machine, modify the IP and hostname, RedHat modify the IP and hostname process is as follows:

(1) Start the virtual machine

CTRL+ALT+F6 to enter command line mode

Delete/etc/udev/rules.d/70-persistent-net.rules

(4) Modify the IP of/etc/sysconfig/network-scripts/ifcfg-eth0

(5) Modify the/etc/hosts file to configure the domain name resolution (IP hostname) of the host name.

(6) Modify the/etc/sysconfig/network file to the actual host name

（6）chkconfig NetworkManager off

（7）reboot

(8) Check the MAC address of the NIC, cat /etc/udev/rules.d/70-persistent-net.rules, and obtain the MAC address of the virtual NIC.

(9) Modify HWADDR parameter value in ifcfg-eth0 file to MAC address of NIC

（10）reboot

Note: If the system is suse, you need to modify the/etc/hosts and/etc/HOSTNAME files.

suse11 Set hostname command: /etc/rc.d/boot.localnet start

suse12 Set hostname command: /etc/rc.d/boot.local start

Dynamic hostname modification command: sysctl -w kernel.hostname= hostname

3. Modify listening files

(1) Switch to oracle user:$ su - oracle

（2）cd $ORACLE_HOME/network/admin

(3) Open the listener.ora file and modify the listening HOST to the current host name.

4. Execute lsnrctl start command under oracle user to start listening

5. Execute sqlplus / as sysdba command and then execute startup command to start database

At this point, I believe that everyone has a deeper understanding of "how Linux virtual machines copy Oracle databases by copying," so let's actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.