{"id":51,"date":"2009-06-05T11:13:22","date_gmt":"2009-06-05T10:13:22","guid":{"rendered":"http:\/\/www.gadgetdude.co.uk\/blog\/?p=51"},"modified":"2009-06-05T11:14:24","modified_gmt":"2009-06-05T10:14:24","slug":"the-oracle-challenge","status":"publish","type":"post","link":"https:\/\/www.gadgetdude.co.uk\/blog\/?p=51","title":{"rendered":"The Oracle Challenge"},"content":{"rendered":"
\"Download<\/a><\/div>

<\/p>\n

<\/p>\n

As Oracle have now bought out Sun I thought it might be a good time to look at running an oracle database on linux. Especially as Sun have MySQL in their portfolio and that is one of if not the major database currently running on most linux systems.Now lucklily Oracle allow you to pull down a demo version and have a play. So I did. And what follows is the traps and pitfalls I found along the way.<\/span><\/p>\n

<\/span><\/p>\n

Now before I start I have to say I broke a few rules by installing this on Centos 5.3 instead of RedHat or any of the approved operating systems. But to be honest, I did not have a single problem with the OS. A lot of the issues are really to do with the linux environment unless all the tricks and traps are done then something will break lol<\/span><\/p>\n

<\/span><\/p>\n

So firstly register with oracle and pull down the database software. Due to me mucking about I ended up pulling down 10 and 11g versions. This document will be around the 10 version.<\/span><\/p>\n

<\/span><\/p>\n

Once pulled down you have to ensure a few things are done on your system. <\/span>Firstly ensure that the following RPM’s are installed<\/span><\/p>\n

<\/span><\/p>\n

libaio-devel<\/span><\/address>\n
elfutils-devel<\/span><\/address>\n
sysstat<\/span><\/address>\n
compat-libstdc++<\/span><\/address>\n
unixodbc<\/span><\/address>\n
unixodbc-devel<\/span><\/address>\n


\n<\/span><\/p>\n

Then you have to modify the \/etc\/sysctl.conf file. The additions\/modifiations I had to make were the following<\/span><\/p>\n

<\/span><\/p>\n

net.core.rmem_default = 4194304<\/span><\/address>\n
net.core.rmem_max <\/span>= 4194304<\/span><\/address>\n
net.core.wmem_default = 262144<\/span><\/address>\n
net.core.wmem_max <\/span>= 262144<\/span><\/address>\n
net.ipv4.ip_local_port_range = 1024 65000<\/span><\/address>\n
kernel.sem = 250 32000 100 128<\/span><\/address>\n

<\/span><\/p>\n

If you add these lines and then use the ‘sysctl -p’ command to load them, failing any typos it will be fine.<\/span><\/p>\n

<\/span><\/p>\n

Next you need to create a user accounts and groups for the database, this will make it easier for you in the future. For this i created an oracle user and a dba and oinstall groups.<\/span><\/p>\n

These are easy to add using the following commands<\/span><\/p>\n

<\/span><\/p>\n

groupadd oinstall<\/span><\/address>\n
groupadd dba<\/span><\/address>\n
useradd -m -g oinstall -G dba oracle<\/span><\/address>\n
passwd oracle<\/span><\/address>\n

<\/span><\/p>\n

That is the installation account ready then ( as oracle will not let you install as root ).<\/span><\/p>\n

<\/span><\/p>\n

Next create some directories for oracle. For this I just created a top level folder called oracle.<\/span><\/p>\n

Again , easy to do with the following commands :<\/span><\/p>\n

<\/span><\/p>\n

mkdir -p \/oracle<\/span><\/address>\n
chown -R oracle:oinstall \/oracle<\/span><\/address>\n
chmod -R 775 \/oracle<\/span><\/address>\n

<\/span><\/p>\n

Now oracle advise setting limits for the number of processes and open files for each account. This is done by adding the following lines to \/etc\/security\/limits.conf just before the “# End of file” marker.<\/span><\/p>\n

<\/span><\/p>\n

oracle soft nproc 2047<\/span><\/address>\n
oracle hard nproc 16384<\/span><\/address>\n
oracle soft nofile 1024<\/span><\/address>\n
oracle hard nofile 65536<\/span><\/address>\n

<\/span><\/p>\n

And also add the following for PAM security in “\/etc\/pam.d\/login”<\/span><\/p>\n

<\/span><\/p>\n

session required \/lib\/security\/pam_limits.so<\/span><\/address>\n

<\/span><\/p>\n

Ok now for the first gotcha I came across. In order to install oracle your system MUST have a fixed IP address. I couldn’t for the life of me get it working on DHCP. ONce you have your fixed IP done check to ensure your \/etc\/hosts file has your IP defined. If it hasn’t then oracle won’t install.<\/span><\/p>\n

Just one simple line can muck up a whole installation, grrrrr.<\/span><\/p>\n

<\/span><\/p>\n

Right you’ll be glad thats all the system tuning done. If you want to you can reboot here to ensure everything is set, but it should be all ok.<\/span><\/p>\n

<\/span><\/p>\n

Now log into the oracle account you just created and unzip the oracle installation kit into it. ( Linux does have the unzip command so don’t worry it’s a zip file you got for the linux installation).<\/span><\/p>\n

<\/span><\/p>\n

Start the Oracle Universal Installer.<\/span><\/p>\n

<\/span><\/p>\n

$ .\/runInstaller<\/span><\/p>\n

<\/span><\/p>\n

<\/span>1. Select Installation Method<\/span><\/p>\n

<\/span>* Select Basic Installation<\/span><\/p>\n

<\/span>* Oracle Home Location: \/oracle\/product\/10.2.0\/db_1<\/span><\/p>\n

<\/span>* Installation Type: Enterprise Edition (1.3GB)<\/span><\/p>\n

<\/span>* UNIX DBA Group: <\/span>oinstall<\/span><\/p>\n

<\/span>* Make sure Create Starter Database is checked<\/span><\/p>\n

<\/span>* Global Database Name: demo1<\/span><\/p>\n

<\/span>* Enter the Database Password and Confirm Password<\/span><\/p>\n

<\/span>* Click on Next<\/span><\/p>\n

<\/span>2. Specify Inventory Directory and Credentials<\/span><\/p>\n

<\/span>* Inventory Directory: \/oracle\/oraInventory<\/span><\/p>\n

<\/span> <\/span>* Operating System group name: <\/span>oinstall<\/span><\/p>\n

<\/span>* Click on Next<\/span><\/p>\n

<\/span>3. Product-specific Prerequisite Checks<\/span><\/p>\n

<\/span>* If you’ve been following the steps in this guide, all the checks should pass without difficulty. If one or more checks fail, correct the problem before proceeding. <\/span><\/p>\n

<\/span>* Click on Next<\/span><\/p>\n

<\/span>4. Summary<\/span><\/p>\n

<\/span>* A summary of the products being installed is presented.<\/span><\/p>\n

<\/span>* Click on Install.<\/span><\/p>\n

<\/span>5. Configuration Assistants<\/span><\/p>\n

<\/span>* The Oracle Net, Oracle Database, and iSQL*Plus configuration assistants will run automatically<\/span><\/p>\n

<\/span>6. Execute Configuration Scripts<\/span><\/p>\n

<\/span>* At the end of the installation, a pop up window will appear indicating scripts that need to be run as root. <\/span>Login as root and run the indicated scripts.<\/span><\/p>\n

<\/span>* Click on OK when finished.<\/span><\/p>\n

<\/span>7. End of Installation<\/span><\/p>\n

<\/span>* Make note of the URLs presented in the summary, and click on Exit when ready.<\/span><\/p>\n

<\/span>8. Congratulations! Your new Oracle Database 10g Release 2 database is up and ready for use.<\/span><\/p>\n

<\/span><\/p>\n

You should now have an up and running Oracle installation. But, if you reboot the system it won’t be up and running. For some reason they don’t install any automatic startup script ??<\/span><\/p>\n

<\/span><\/p>\n

The first thing to do is add some environment variables to the oracel user account. This is done by editing the .bashrc file in the account and add the following lines<\/span><\/p>\n

<\/span><\/p>\n

ORACLE_OWNER=oracle; export ORACLE_OWNER<\/span><\/address>\n
ORACLE_HOME=\/home\/oracle\/oracle\/product\/10.2.0\/db_1<\/span><\/address>\n
ORACLE_SID=demo1<\/span><\/address>\n
PATH=$PATH:$ORACLE_HOME\/bin<\/span><\/address>\n
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME\/lib:$ORACLE_HOME\/network\/lib<\/span><\/address>\n
<\/span><\/address>\n
export PATH ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH<\/span><\/address>\n

<\/span><\/p>\n

So I surfed around and eventually came across a simple script I built up. This is my finished script that is located in \/etc\/rc.d\/init.d\/oracle<\/span><\/p>\n

<\/span><\/p>\n

#!\/bin\/bash<\/span><\/address>\n
#<\/span><\/address>\n
# Run-level Startup script for the Oracle Instance and Listener<\/span><\/address>\n
#<\/span><\/address>\n
# chkconfig: 345 91 19<\/span><\/address>\n
# description: Startup\/Shutdown Oracle listener and instance<\/span><\/address>\n
<\/span><\/address>\n
ORA_HOME=”\/oracle\/product\/10.2.0\/db_1″<\/span><\/address>\n
ORA_OWNR=”oracle”<\/span><\/address>\n
<\/span><\/address>\n
# if the executables do not exist — display error<\/span><\/address>\n
<\/span><\/address>\n
if [ ! -f $ORA_HOME\/bin\/dbstart -o ! -d $ORA_HOME ]<\/span><\/address>\n
then<\/span><\/address>\n
<\/span>echo “Oracle startup: cannot start”<\/span><\/address>\n
<\/span>exit 1<\/span><\/address>\n
fi<\/span><\/address>\n
<\/span><\/address>\n
# depending on parameter — startup, shutdown, restart<\/span><\/address>\n
# of the instance and listener or usage display<\/span><\/address>\n
<\/span><\/address>\n
case “$1” in<\/span><\/address>\n
<\/span>start)<\/span><\/address>\n
<\/span># Oracle listener and instance startup<\/span><\/address>\n
<\/span>echo -n “Starting Oracle: “<\/span><\/address>\n
<\/span>su – $ORA_OWNR -c “$ORA_HOME\/bin\/lsnrctl start”<\/span><\/address>\n
<\/span>su – $ORA_OWNR -c “$ORA_HOME\/bin\/dbstart”<\/span><\/address>\n
<\/span> <\/span>su – $ORA_OWNR -c “emctl start dbconsole”<\/span><\/address>\n
<\/span>su – $ORA_OWNR -c “isqlplusctl start”<\/span><\/address>\n
<\/span>touch \/var\/lock\/subsys\/oracle<\/span><\/address>\n
<\/span>echo “OK”<\/span><\/address>\n
<\/span>;;<\/span><\/address>\n
<\/span>stop)<\/span><\/address>\n
<\/span># Oracle listener and instance shutdown<\/span><\/address>\n
<\/span>echo -n “Shutdown Oracle: “<\/span><\/address>\n
<\/span>su – $ORA_OWNR -c “isqlplusctl stop”<\/span><\/address>\n
<\/span>su – $ORA_OWNR -c “emctl stop dbconsole”<\/span><\/address>\n
<\/span>su – $ORA_OWNR -c “$ORA_HOME\/bin\/lsnrctl stop”<\/span><\/address>\n
<\/span>su – $ORA_OWNR -c $ORA_HOME\/bin\/dbshut<\/span><\/address>\n
<\/span>rm -f \/var\/lock\/subsys\/oracle<\/span><\/address>\n
<\/span>echo “OK”<\/span><\/address>\n
<\/span> <\/span>;;<\/span><\/address>\n
<\/span>reload|restart)<\/span><\/address>\n
<\/span>$0 stop<\/span><\/address>\n
<\/span>$0 start<\/span><\/address>\n
<\/span>;;<\/span><\/address>\n
<\/span>*)<\/span><\/address>\n
<\/span>echo “Usage: $0 start|stop|restart|reload”<\/span><\/address>\n
<\/span>exit 1<\/span><\/address>\n
esac<\/span><\/address>\n
exit 0<\/span><\/address>\n

<\/span><\/p>\n

There was one last gotcha that I came across, something that is left over from Oracle themselves.<\/span><\/p>\n

During the startup of the database it comes back with the following error<\/span><\/p>\n

<\/span><\/p>\n

<\/span>Failed to auto-start Oracle Net Listene using \/ade\/vikrkuma_new\/oracle\/bin\/tnslsnr<\/span><\/p>\n

<\/span><\/p>\n

If you edit the file “\/oracle\/product\/10.2.0\/db_1\/bin\/dbstart” and look for the line containing that text and change it to the location for your oracel database. In my case it is “\/oracle\/product\/10.2.0\/db_1”.<\/span><\/p>\n

<\/span><\/p>\n

Problems and my <\/span>solutions.<\/span><\/p>\n

<\/span><\/p>\n

When the “lsnrctl start” command is sent you get a the following errors<\/span><\/p>\n

<\/span><\/p>\n

<\/span># \/app\/oracle\/oracle\/product\/10.2.0\/db_1\/bin\/lsnrctl start<\/span><\/p>\n

LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 19-APR-2008 22:24:04<\/span><\/p>\n

Copyright (c) 1991, 2005, Oracle. <\/span>All rights reserved.<\/span><\/p>\n

Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 not found; No message file for product=network, facility=TNS<\/span><\/p>\n

<\/span>TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS<\/span><\/p>\n

<\/span>TNS-00515: Message 515 not found; No message file for product=network, facility=TNS<\/span><\/p>\n

<\/span>Linux Error: 2: No such file or directory<\/span><\/p>\n

<\/span><\/p>\n

This is because the oracle user account does not have “$ORACLE_HOME\/network\/lib” in its LD_LIBRARY_PATH. Check the modifications in .bashrc.<\/span><\/p>\n

<\/span><\/p>\n

When you execute .\/runInstaller and it shows an error on the first line of checks and then gives messages about DHCP, check the hostname and ip is defined in \/etc\/hosts.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

As Oracle have now bought out Sun I thought it might be a good time to look at running an oracle database on linux. Especially as Sun have MySQL in their portfolio and that is one of if not the major database currently running on most linux systems.Now lucklily Oracle allow you to pull down […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8,10],"tags":[],"_links":{"self":[{"href":"https:\/\/www.gadgetdude.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/51"}],"collection":[{"href":"https:\/\/www.gadgetdude.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gadgetdude.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gadgetdude.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gadgetdude.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=51"}],"version-history":[{"count":4,"href":"https:\/\/www.gadgetdude.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/51\/revisions"}],"predecessor-version":[{"id":54,"href":"https:\/\/www.gadgetdude.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/51\/revisions\/54"}],"wp:attachment":[{"href":"https:\/\/www.gadgetdude.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=51"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gadgetdude.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=51"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gadgetdude.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=51"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}