Page Comparison

...

2. In the terminal edit /etc/sysconfig/network

No Format
vi /etc/sysconfig/network

and change to:

No Format
NETWORKING=yes HOSTNAME=source

3. Edit /etc/hosts and add the following two hosts entries

No Format

# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1		localhost
::1				localhost
10.0.2.4       source-int source dbv01
10.0.2.5       target-int target dbv02

4. Network settings - this step is divided between sub points "a" and "b". "a" i for Linux 7 onward and "b" is prior to LInux 7. It's based on new features which comes with Linux 7 version - the NetworkManager interface. Settings was changed a little bit.

a) Linux 7 onward

Right click on Network Manager icon on the top right hand corner, and click on "Wired ON", then Network Settings.

Image Added

Click on icon marked by red circle:

Image Added

Check your current gateway:

No Format
[root@localhost ~]# route -ne Kernel IP routing table Destination Gateway Genmask Flags MSS Window irtt Iface 0.0.0.0 10.0.2.2 0.0.0.0 UG 0 0 0 enp0s3 10.0.2.0 0.0.0.0 255.255.255.0 U 0 0 0 enp0s3

Select the IPV4 tab, change method from automatic (DHCP) to manual and set below values:

Image Added

Address: 10.0.2.4

Netmask: 24

Gateway: 10.0.2.1

DNS Servers: 8.8.8.8

Check new ip settings by command ip ad (Changes will take effect after the VM restarts):

No Format

[root@localhost ~]# ip ad
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN 
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
    inet6 ::1/128 scope host 
       valid_lft forever preferred_lft forever
2: enp0s3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
    link/ether 08:00:27:eb:3b:9c brd ff:ff:ff:ff:ff:ff
    inet 10.0.2.4/24 brd 10.0.2.255 scope global enp0s3
    inet6 fe80::a00:27ff:feeb:3b9c/64 scope link 
       valid_lft forever preferred_lft forever

b) prior to Linux 7

Right click on the Network Manager icon on the top right hand corner, and click on "Edit Connections..."

Image Added

Click on Auto eth1 and click on "Edit..."

Image Added

Select the "IPv4 Settings" tab. Set the Method to "Manual" and add following details (click on "Add" to add the details):

Address: 10.0.2.4

Netmask: 24

Gateway: 10.0.2.1

DNS Servers: 8.8.8.8

Then click on Apply

Image Added

View the network interface

No Format

ifconfig
eth1      Link encap:Ethernet  HWaddr 08:00:27:5B:82:6E  
          inet addr:10.0.2.4  Bcast:10.0.2.255  Mask:255.255.255.0
          inet6 addr: fe80::a00:27ff:fe5b:826e/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:12 errors:0 dropped:0 overruns:0 frame:0
          TX packets:24 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:9201 (8.9 KiB)  TX bytes:1775 (1.7 KiB)
lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:65536  Metric:1
          RX packets:282 errors:0 dropped:0 overruns:0 frame:0
          TX packets:282 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:17588 (17.1 KiB)  TX bytes:17588 (17.1 KiB)

There is only one network interface:

eth1 which is a fixed IP address. This is used to connect between the source and target servers and also to the Internet. This IP is 10.0.2.4.

5. Test if the network connection is working. Use Control-C to stop the ping.

No Format

ping www.dbvisit.com
PING dbvisit.com (67.222.54.241) 56(84) bytes of data.
64 bytes from 67-222-54-241.unifiedlayer.com (67.222.54.241): icmp_seq=1 ttl=47 time=190 ms
64 bytes from 67-222-54-241.unifiedlayer.com (67.222.54.241): icmp_seq=2 ttl=47 time=189 ms
64 bytes from 67-222-54-241.unifiedlayer.com (67.222.54.241): icmp_seq=3 ttl=47 time=192 ms
64 bytes from 67-222-54-241.unifiedlayer.com (67.222.54.241): icmp_seq=4 ttl=47 time=193 ms
^C

6. scp (secure copy) does not work because there is display output in ~oracle/.bashrc file. To fix this:

a. Edit .bashrc in the home directory of oracle

No Format
cd ~oracle

No Format
vi .bashrc

Put a # in front of the following line:

No Format
#cat /u01/oracle/Desktop/readme.txt

Save the .bashrc file and exit (:wq)

7. Firewall exception - this step is divided between sub points "a" and "b". "a" i for Linux 7 onward and "b" is prior to LInux 7. It's based on new features which comes with Linux 7 version - the Dynamic firewall.

a) Linux 7 onward:

IPtables and Firewalld are disabled by default in downloaded VM, therefore this step could be skipped. However if you'd like to setup:

Download latest binaries:

No Format
yum install -y firewalld firewall-config

Check the IPtables are inactive, enable and start the firewalld feature:

No Format

[root@localhost ~]# systemctl status iptables
iptables.service - IPv4 firewall with iptables
   Loaded: loaded (/usr/lib/systemd/system/iptables.service; disabled)
   Active: inactive (dead)
[root@localhost ~]# systemctl status firewalld
firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled)
   Active: inactive (dead)
[root@localhost ~]# systemctl start firewalld
[root@localhost ~]# systemctl status firewalld
firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled)
   Active: active (running) since Sun 2015-06-07 22:38:07 CEST; 3s ago
 Main PID: 3700 (firewalld)
   CGroup: /system.slice/firewalld.service
           └─3700 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid
[root@localhost ~]# systemctl enable firewalld
ln -s '/usr/lib/systemd/system/firewalld.service' '/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service'
ln -s '/usr/lib/systemd/system/firewalld.service' '/etc/systemd/system/basic.target.wants/firewalld.service'

add new ports' exceptions to firewalld and reload:

No Format

[root@localhost ~]# firewall-cmd --zone=public --add-port=1521/tcp --permanent
success
[root@localhost ~]# firewall-cmd --zone=public --add-port=7901/tcp --permanent
success
[root@localhost ~]# firewall-cmd --zone=public --add-port=7902/tcp --permanent
success
[root@localhost ~]# firewall-cmd --reload
success

b) prior to LInux 7:

Setup the firewall rules (iptables) and open up the ports for SQL*Net (1521) and for Dbvisit Replicate (7901, 7902).

No Format
vi /etc/sysconfig/iptables

a. Add the following entries.

No Format
-A INPUT -m state --state NEW -m tcp -p tcp --dport 1521 -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 7901 -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 7902 -j ACCEPT

The whole file should look like.

No Format

# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 1521 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 7901 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 7902 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT

b. Save and quit the file (:wq!).

8. Restart the firewall (iptables).

No Format
service iptables restart

9. The output is.

No Format
iptables: Setting chains to policy ACCEPT: filter [ OK ] iptables: Flushing firewall rules: [ OK ] iptables: Unloading modules: [ OK ] iptables: Applying firewall rules: [ OK ]

10. Restart the whole VM.

No Format
shutdown -r now

8Log onto the VM through the VirtualBox console which will be shown when the VM has started.

The username is root and the password is oracle

1. When logged onto the desktop, right click and click on "Open Terminal" to bring up the terminal.

Image Added

2. In the terminal edit /etc/sysconfig/network

No Format
vi /etc/sysconfig/network

and change to:

No Format
NETWORKING=yes HOSTNAME=source

...

No Format

# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1		localhost
::1				localhost
10.0.2.4       source-int source dbv01
10.0.2.5       target-int target dbv02

4. Network settings - this step is divided between sub points "a" and "b". "a" i for Linux 7 onward and "b" is prior to LInux 7. It's based on new features which comes with Linux 7 version - the NetworkManager interface. Settings was changed a little bit.

a) Linux 7 onward

Right click on Network Manager icon on the top right hand corner, and click on "Wired ON", then Network Settings.

Image Added

Click on icon marked by red circle:

Image Added

Check your current gateway:

No Format
[root@localhost ~]# route -ne Kernel IP routing table Destination Gateway Genmask Flags MSS Window irtt Iface 0.0.0.0 10.0.2.2 0.0.0.0 UG 0 0 0 enp0s3 10.0.2.0 0.0.0.0 255.255.255.0 U 0 0 0 enp0s3

Select the IPV4 tab, change method from automatic (DHCP) to manual and set below values:

Image Added

Address: 10.0.2.4

Netmask: 24

Gateway: 10.0.2.1

DNS Servers: 8.8.8.8

Check new ip settings by command ip ad:

No Format

[root@localhost ~]# ip ad
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN 
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
    inet6 ::1/128 scope host 
       valid_lft forever preferred_lft forever
2: enp0s3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
    link/ether 08:00:27:eb:3b:9c brd ff:ff:ff:ff:ff:ff
    inet 10.0.2.4/24 brd 10.0.2.255 scope global enp0s3
    inet6 fe80::a00:27ff:feeb:3b9c/64 scope link 
       valid_lft forever preferred_lft forever

b) prior to Linux 7

Right click on the Network Manager icon on the top right hand corner, and click on "Edit Connections..."

5. Click on Auto eth1 and click on "Edit..."

6. Select the "IPv4 Settings" tab. Set the Method to "Manual" and add following details (click on "Add" to add the details):

...

DNS Servers: 8.8.8.8

Then click on Apply

7. View the network interface

No Format

# ifconfig
eth1      Link encap:Ethernet  HWaddr 08:00:27:5B:82:6E  
          inet addr:10.0.2.4  Bcast:10.0.2.255  Mask:255.255.255.0
          inet6 addr: fe80::a00:27ff:fe5b:826e/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:12 errors:0 dropped:0 overruns:0 frame:0
          TX packets:24 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:9201 (8.9 KiB)  TX bytes:1775 (1.7 KiB)
lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:65536  Metric:1
          RX packets:282 errors:0 dropped:0 overruns:0 frame:0
          TX packets:282 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:17588 (17.1 KiB)  TX bytes:17588 (17.1 KiB)

...

eth1 which is a fixed IP address. This is used to connect between the source and target servers and also to the Internet. This IP is 10.0.2.4.

85. Test if the network connection is working. Use Control-C to stop the ping.

No Format

# ping www.dbvisit.com
PING dbvisit.com (67.222.54.241) 56(84) bytes of data.
64 bytes from 67-222-54-241.unifiedlayer.com (67.222.54.241): icmp_seq=1 ttl=47 time=190 ms
64 bytes from 67-222-54-241.unifiedlayer.com (67.222.54.241): icmp_seq=2 ttl=47 time=189 ms
64 bytes from 67-222-54-241.unifiedlayer.com (67.222.54.241): icmp_seq=3 ttl=47 time=192 ms
64 bytes from 67-222-54-241.unifiedlayer.com (67.222.54.241): icmp_seq=4 ttl=47 time=193 ms
^C

96. scp (secure copy) does not work because there is display output in ~oracle/.bashrc file. To fix this:

...

Save the .bashrc file and exit out of the file with vi command - :wq!(:wq)

7. Firewall exception - this step is divided between sub points "a" and "b". "a" i for Linux 7 onward and "b" is prior to LInux 7. It's based on new features which comes with Linux 7 version - the Dynamic firewall.

a) Linux 7 onward:

IPtables and Firewalld are disabled by default in downloaded VM, therefore this step could be skipped. However if you'd like to setup firewalld:

yum install -y

[root@localhost ~]# systemctl enable firewalld
ln -s '/usr/lib/systemd/system/firewalld.service' '/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service'
ln -s '/usr/lib/systemd/system/firewalld.service' '/etc/systemd/system/basic.target.wants/firewalld.service'

No Format

[root@localhost ~]# systemctl status iptables
iptables.service - IPv4 firewall with iptables
   Loaded: loaded (/usr/lib/systemd/system/iptables.service; disabled)
   Active: inactive (dead)
[root@localhost ~]# systemctl status firewalld
firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled)
   Active: inactive (dead)
[root@localhost ~]# systemctl start firewalld
[root@localhost ~]# systemctl status firewalld
firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled)
   Active: active (running) since Sun 2015-06-07 22:38:07 CEST; 3s ago
 Main PID: 3700 (firewalld)
   CGroup: /system.slice/firewalld.service
           └─3700 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid
[root@localhost ~]# systemctl enable firewalld
ln -s '/usr/lib/systemd/system/firewalld.service' '/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service'
ln -s '/usr/lib/systemd/system/firewalld.service' '/etc/systemd/system/basic.target.wants/firewalld.service'

b) prior to LInux 7:

Setup the firewall rules (iptables) and open up the ports for SQL*Net (1521) and for Dbvisit Replicate (7901, 7902).

No Format
vi /etc/sysconfig/iptables

a. Add the following entries.

No Format
-A INPUT -m state --state NEW -m tcp -p tcp --dport 1521 -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 7901 -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 7902 -j ACCEPT

The whole file should look like.

No Format

# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 1521 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 7901 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 7902 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT

b. Save and quit the file (:wq!).

8. Restart the firewall (iptables).

No Format
service iptables restart

9. The output is.

No Format
iptables: Setting chains to policy ACCEPT: filter [ OK ] iptables: Flushing firewall rules: [ OK ] iptables: Unloading modules: [ OK ] iptables: Applying firewall rules: [ OK ]

10. Restart the whole VM.

No Format
shutdown -r now

Versions Compared

Old Version 28

New Version Current

Key