For part two of the network I have used pfSense as a router (all firewall and NAT serveices have been disabled) and installed Oracle XE on Ubuntu 12.04. I have also installed Oracle SQL Developer on the XP Clients to connect to the Oracle db on a new subnet.
Steps to install each are as follows:
Install and Configure pfSense
1. Download pfSense
2. As I mentioned previously I’m using Oracle Virtual Box to create my virtual machines. You will need to create a virtual machine of type BSD, FreeBSD(64 bit) to install pfSense
3. You will need to enable two Network Adapters of ‘Internal Network’ type on your pfSense virtual machine
4. One should be the internal network that your Windows Domain sits on. the other Should be the network you intend to place your Unbuntu and Oracle db on
5. Kick off the install by referencing the pfSense iso through the virtual machine you have just created.
6. Select ‘1. Boot pfSense [default]’ from the boot menu
7. Select the ‘(I)nstaller’ option
8. Accept all defaults that follow. Screen shots of the installation process are here on the pfSense website
9. After installation pfSense reboots and you are asked to configure the device
10. when you are asked ‘Do you want to set up VLANs now?’ type ‘n’
11. Type ’em0′ for the WAN interface name
12. Type ’em1′ for the LAN interface name
13. Simply hit enter when prompted for the ‘Optional 1’ interface
14. Hit ‘y’ when you are asked to proceed with the names you have assigned to the LAN and WAN interfaces.
15. pfSense now applies your configuration and displays its interface menu. The device is up and running
16. All that remains is to apply the correct IP addresses to your LAN and WAN interfaces
17. Select ‘2) Set interface(s) IP Address’ from the console menu
18. For the LAN and WAN interfaces enter a valid IP address for the Windows Domain network and one for the Ubuntu machine you will create later in this part of the network creation. It’s a matter of choice what private IP address you set at this stage.
19. The IP address you set in the router will act as the default gateway for the XP machines and Ubuntu machine respectively
20. Now configure the pfSense device as a router only. This step disables the firewall functionality of pfSense. I will use pfSense as an actual firewall in a later section but for now I only need it to act as a router.
21. pfSense is now configured
22. If that didn’t make sense here’s a video link from pcaddicts explaining the installation
Install Ubuntu 12.04
1. Get the Ubuntu installation here
2. Create a Ubuntu 64bit (need this to install 64bit version of Oracle XE 11.2) virtual machine
3. The installation is quite simple, but here’s a how-to link from the Ubuntu website
Install Oracle XE 11.2 on Ubuntu 12.04
1. Get the Oracle installation here
2. Installing Oracle XE on Ubuntu can be a tricky but here’s an excellent guide on how to do it
3. Just two points on this installation, section ‘C.5. Setup Oracle environment variables’ did not work for me and I had to explicitly set the variables. I did so in the terminal window with the commands below:
4. If you want to start Oracle automatically each time your Ubuntu machine starts carry out the steps listed here in Manish Raj’s blog. Thanks Manish!
5. Finally load a sample db which you can connect to. Here’s a simple db script from the Oracle XE tutorial series. Open the tutorial and select the attachments tab to download the db script.
Install Oracle SQL Developer
1. Finally install Oracle SQL Developer on your XP Client machines
2. Set up a connection through SQL Developer and connect to your Oracle DB. Just one point here, you will need to turn off the windows Firewall to allow SQL Developer connect to the Oracle db on the Ubuntu machine.