Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Log 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 Removed

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. Right click on the Network Manager icon on the top right hand corner, and click on "Edit Connections..."

Image Removed

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

Image Removed

6. 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 Removed

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)

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.

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

9. 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) 

10. 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!).

11. Restart the firewall (iptables).

No Format
service iptables restart

12. 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  ]

13. Restart the whole VM.

...

When the machine_setup script has been edited to accept the eula and the memory parameter adjusted, execute the script.

On Windows

In the ?? directory, execute the machine_setup.bat script by double clicking.

On Mac OS X

Open a Terminal window and change directory to where you downloaded the…

Execute the machine_setup.bash script.

No Format
bash-3.2$ ./machine_setup.bash

On Linux

TBD.