In my previous posts I installed Debian as a virtual server and installed Oracle XE on it. In this post some minor improvements are being described. The first is to make use of a fixed IP address for the Debian instance (in my default setup I made use of DHCP to obtain an IP address). This is done in Debian by editing the file ‘/etc/network/interfaces’.
Originally I had this in the file:

# This file describes the network interfaces available on your system
# and how to activate them. For more information, see interfaces(5).

# The loopback network interface
auto lo
iface lo inet loopback

# The primary network interfaces
allow-hotplug eth0

iface eth0 inet dhcp

And I changed it into:

# This file describes the network interfaces available on your system
# and how to activate them. For more information, see interfaces(5).

# The loopback network interface
auto lo
iface lo inet loopback

# The primary network interfaces
allow-hotplug eth0

iface eth0 inet static
address 192.168.2.16
netmask 255.255.255.0
network 192.168.2.1
broadcast 192.168.2.255
gateway 192.168.2.1

Now when you restart the virtual server the Debian server will have the IP address 192.168.2.16. You can test this first by performing the ‘ifconfig’ command in Debian. And the real test is to open up a terminal in Mac OS and ping there the set IP:

Next step is to match the name ‘xe-server’ to this IP address in Mac OS. You can do this by editing the hosts file with:
sudo nano /private/etc/hosts
In my case I added the line:
192.168.2.16 xe-server
Now you can access the Debian server with ‘http://xe-server:8080/apex’ or ‘system@//xe-server:1521/xe’ in SQLDeveloper.
This was the last post about this issue. I hope it helps you in some way. Otherwise it was fun to do anyway :-)