Setting up a Slackware Linux Oracle Server
This is a set of instructions (to myself (in case I need to do a similar install in the future, or make modifications) and anyone else who's interested) on a setting up a Slackware server running an Oracle database. This is the 2nd in a series of Roqet servers, the first was here.
If you are using this document to setup your own system, please note that some version numbers of files/applications may have changed since this was written.
The distribution of GNU/Linux I chose for this workstation was Slackware.
The version of Oracle I used was Oracle 10g.
The main reason I chose Linux were stability, security, affordability and usability. Linux gave me all of that. I also considered the various flavors of BSD, but found that I had become more comfortable with Linux over the last couple of years.
Simply put, my previous server was Slackware 7.1 and it hadn't given me any problems even after running for several years on obsolete hardware. So when I considered a new server Slackware was my first choice; Slackware Linux is the most robust operating system I've ever had (although I've seldom had any "stability" issues with any other Linux distribution).
The server is to be used as a fileserver, mail-collection server, database server and emergency workstation (if I can't use my other pc, then I would use this, which is why I have included a few installs like
NOTE: One of the important things to know is the power management of your BIOS; in my case it uses ACPI, this does make a difference, because if you want the machine to automatically power-down when you shutdown and you have ACPI, then you need to choose the
bareacpi.i kernel instead of the
acpi.i kernel (which is the default), if your BIOS uses APM, then you can just choose
For further reading: there are some more advanced setting options, taken from this book.
wget http://www.linuxiso.org/download.php/472/slackware-10.1-install-d1.iso wget http://www.linuxiso.org/download.php/595/slackware-10.1-install-d2.iso cdrecord dev=0,0,0 -dao -data slackware-10.1-install-d1.iso cdrecord dev=0,0,0 -dao -data slackware-10.1-install-d2.iso
2. insert the 1st CD and rebooted my PC. Follow partitioning advice using
cfdisk from here.
setup; unselect the GNOME and KDE disk-sets as the only desktop manager that will be used for this server is XFCE (xwindows is not required for the everyday opperation of the server, but it is necessary for the Oracle installation, and as I wanted to be able to use the server as an emergency workstation this is good to have anyway).
During the installation you can set your network connections, but if you want to modify your network settings later, use the
netconfig utility. Another thing to remember is to update your
/etc/resolv.conf file to add in any additional nameserver ip addresses (check your isp or your registrar for these - I use changeip.com to manage mine.)
For example these were my settings (changed for privacy):
hostname: myhost domain: mydomain.org static ip address: 192.168.1.21 netmask (local): 255.255.255.0 gateway address: 192.168.1.1 (that's where my router is) accessing a nameserver? yes nameserver ip: 188.8.131.52 after complete, edit /etc/resolv.conf,add a 2nd nameserver: 184.108.40.206
If you have other machines on your network with fixed IP Addresses, you can add their IP Adresses and names to your
/etc/hosts file, then you can access them by name. Here's an example of my
127.0.0.1 localhost 192.168.1.21 myhost.mydomain.org myhost 192.168.1.22 mydesktop.mydomain.org mydesktop
The default Slackware boot manager is
lilo, to reduce the amount of time it takes to boot Linux, modify the
timeout = 300
Advanced Power Management
If you want your pc to power-down when you tell it to shutdown like it does in Windows, you may (depending on if your machine's power-management is APM or ACPI, mine was ACPI, and I didn't need to do this) have to edit the
/etc/rc.d/rc.modules file, and uncomment the line:
After the installation, the pc boots to the command line, with root being the only account on the system. Use
adduser username to add new accounts as is shown here.
As an aside, if you want certain files to be placed in a new user accounts home directory, as root, add those files to the
CDRW and CD-burning
The quick method of burning a cd is to use this command (where the
.iso has been pre-created):
cdrecord -v -dao dev=ATAPI:0,0,0 /path-to-filename/filename.iso
On Slackware, the command
vi text editor clone. If like me, you prefer
vim(VIiMproved), then run this as root:
ln -sf /usr/bin/vim /usr/bin/vi
There is more on
There shouldn't be any need to change the defaults, but it's good to know that the configuration file is
/etc/apache/httpd.conf, the webserver's files should be in
To start the webserver (should automatically start on system startup), run:
/etc/rc.d/rc.httpd start and to stop it (also automatic during system shutdown):
A couple of things to note:
Files should be given 644 permissions
chmod 644 filename.html.
A personal note:I had to change the default port from 80 to 3332 as my cable company blocked port 80, the file to change if you need to do this is
/etc/apache/httpd.conf, look for the default port of 80 and change it, then also look for the line containing "Listen", un-comment this, and change it to 3332 (I arbitrarily chose 3332, but you can use any unused port - the higher the better).
To build your own 404 Error page (if someone types in a non-existant URL), simply edit your
/etc/apache/httpd.conf file; uncomment the line:
#ErrorDocument 404 /missing.html, and change
/missing.html to whatever you want your customized 404 error page to be, then create that page,
chmod 644 (change permissions to read) that file, and restart your apache server as mentioned above.
The fortune program automatically runs on each login, this wears a bit thin after a while, change the permissions of the
/etc/profile.d/bsdgames.sh file to get rid of it:
chmod -x /etc/profile.d/bsd-games-login-fortune.sh
A friendly Welcome
To display a friendly welcome message to those who login to the server, created a welcome file (all the .sh files in /etc/profile.d are run at login (provided they have the correct permissions):
cat > /etc/profile.d/welcome.sh #!/bin/sh # roqetman additions: serverdate=`date` echo Server: $serverdate :: Welcome to myhost.
chmod +x /etc/profile.d/welcome.sh
Mouse Wheel modifications
If for some reason, your mouse-wheel wasn't detected, here's what you can do to get it to work: edit
/etc/X11/xorg.conf, and add the following to the "Pointers" section:
Option "ZAxisMapping" "4 5" Option "Buttons" "5" Option "Protocol" "IMPS/2"
SSHD Secure Remote Access
This is documented here.
Keeping Slackware Secure
This is my general security document.
Keeping Slackware up-to-date with Swaret is documented here.
Perl and CPAN
The Perl language is installed by default, as is CPAN. CPAN (Comprehensive Perl Archive Network) is the source for Perl modules and extensions. Thousands of useful modules and libraries are available in this repository, all are free. To get CPAN configured, type:
cpan, then once
cpan has started, type:
o conf init. You should be able to accept the defaults from there, the important thing to find out is the correct URL's, which you can get from here; for example, I currently use:
ftp://ftp.rge.com/pub/languages/perl/ as I'm close to NY, USA.
VPN and Remote Desktop
This is documented here.
My preferred command-line email client is Pine.
I have a document on this that includes how to collect and send mail with an MS Exchange server, a VPN, fetchmail and Pine here.
pal is a very cool comand-line calendar and appointment reminder program, available here.
To allow users on your server to connect to a news server, add the following line to your
(where news-server.somewhere.com is the name of your own news server).
There are many command-line news readers you can use. One called Gnus comes with emacs. My personal favorite is
slrn; it is simple and quick to configure and use - I have created a document for it here.
XFCE and XWindows
XFCE is a lightweight desktop manager.
By default Slackware loads into the command-line, which is the way it should be for a server. To start up xwindows type:
startx. If you chose XFCE in the install, then that will be the manager that loads. If you want to change it at some time in the future, then go to the
/usr/X11R6/lib/X11/xinit folder, and copy your chosen desktop manager to the
xinitrc file, for example:
cp xinitrc.xfce xinitrc.
Firefox web Browser
There are several ways to install this, but I suggest the Slackware way; go to LinuxPackages and download it, then as root:
Unlike on my old server, I did not set this server to relay mail, or allow the sending of mail outside of my network. This is primarily due to SMTP Authentication restrictions that are now becoming commonplace. Instead, when I send mail, I send it using my ISP's SMTP server, or my registrar's permitted relay.
However, I still like to have sendmail active as I like to allow mail between accounts on the server. I also have an antivirus on my Windows machine that I set to email the server if it finds a virus. This required me to set up a relay just for that IP Address like so:
/etc/mail/access and put the following in the file:
#domain/ip address to accept mail from 192.168.1.111 RELAY
Once your changes are done, you need to recreate the access database:
makemap hash /etc/mail/access < /etc/mail/access
And then restart
sendmail by typing:
killall -HUP sendmail
If you want to add a few local email aliases, edit the
/etc/mail/aliases file, and then type
To allow other machines to collect mail from the server, enable POP access: modify the
/etc/inetd.conf file (uncomment the POP and imap lines).
If the install didn't autodetect your sound card...
From the command line (as root) type
alsaconf for sound configuration.
After the initial configuration, run
gamix to set volumes etc. and
alsactl store to save your settings, for example:
alsaconf alsamixer alsactl store
This is documented here.
Install of Oracle 10g
This is documented here.
On This document? Contact me here.
Where to find documentation on your system: in the
More on Slackware? - There is a great book online called Slackware Linux Essentials.
Oracle help can be found at the Oracle Technology Network.