Installing Oracle Database 10g R2 Enterprise Editon on Kubuntu Dapper -- October 2006
------------------------------------------------------------------------------------
Oracle Database 10g R2 (10.2.0.1) on Kubuntu linux Dapper Drake 6.0.1

*** This guide is for test purposes only - not production ***

Boot from the Kubuntu desktop disc
this will install a live CD, if it recognizes your hardware 
you can then use the install icon to install Kubuntu onto your disk.
	** Need at least 512MB RAM / 2.5GB Space for Oracle Enterprise Edition **
+ Set language and time zone preferences

+ Set user password  (note: on kubuntu and ubuntu root password is not set)

+ Automaticaly or Manually partition your hard drive (default partioning works with Dapper)
	/tmp = 512MB ext3 fixed size
	/boot = 128MB ext3 fixed size
	swap = 1024MB fixed size
	/ = fill to maximum allowable size

+ When it gives you the option to continue using the live disk or to reboot, reboot to start
using the new system. If you are used to using root this is a good time to use set root's password
	$ sudo passwd root

+ Use 'System > Adept' and then search and install firefox

+ Use 'System > Adept' to make sure the packages the oracle installer needs are installed
	- gcc, libaio1, libc6, libstdc++5, make, rpm, lesstif2, lesstif2-dev
	(this can also be achieved by using apt-get)
	$ su -
	# apt-get install gcc libaio1 libc6 libstdc++5 make rpm lesstif2 lesstif2-dev
(notes: to install lesstif2 you will need to use 'Adept' to enable the universe repository or 
	edit /etc/apt/source.list .
	if you get this repository contention warning while using apt-get you will need to close
	'Adept' as they both access the same repository. )
	

For post-install configuration login as root
--------------------------------------------
+ create the following groups
via 'System Settings > Users & Groups' or
	$ su -
	# /usr/sbin/groupadd oinstall
	# /usr/sbin/groupadd dba
	# /usr/sbin/groupadd nobody

+ create OS user oracle with group 'oinstall', secondary group 'dba', home /opt/oracle and shell
/bin/bash and set the passwd (make sure you remember this password)
via "System Settings > Users & Groups' or
	# /usr/sbin/useradd -g oinstall -G dba,nobody -d /opt/oracle -s /bin/bash oracle

+ set user oracle's password
	# /usr/bin/passwd oracle

+ Append user oracle's bash profile with PATH and ORACLE:BASE,HOME and SID information
	# vi /opt/oracle/.bash_profile
		(append the following lines)
	export ORACLE_BASE=/opt/oracle
	export ORACLE_HOME=$ORACLE_BASE/product/10gR2
	export ORACLE_SID=orcl
	export PATH=$PATH:$ORACLE_HOME/bin

+ Create the directory for the software installation and assign ownership to oracle:oinstall
	# chown -R oracle:oinstall /opt
	# chmod -R 775 /opt

+ Make sure the correct kernel parmeters are appended to sysctl.conf
	# vi /etc/sysctl.conf (these can be easily copied from the Quick Installation Guide
                              for Linux x86 doc on the Oracle10g CD)
	kernel.shmall = 2097152
	kernel.shmmax = 2147483648
	kernel.shmmni = 4096
	kernel.sem = 250 32000 100 128
        net.core.rmem_default = 262144
	net.core.rmem_max = 262144
	net.core.wmem_default = 262144
	net.core.wmem_max = 262144
	fs.file-max = 65536
	net.ipv4.ip_local_port_range = 1024 65000

+ set the kernel parameters or reboot
	# /sbin/sysctl -p		(pic)

+ set security limits 
	# vi /etc/security/limits.conf   
		(and append the following values to the end of the file)
	* soft nproc 2047
	* hard nproc 16384
	* soft nofile 1024
	* hard nofile 65536

+ create symbolic links and camoflage Kubuntu to look more like an enterprise rpm based distro,
because the oracle installer is expecting rhel, sles or asianux based distros.
	# ln -s /usr/bin/awk /bin/awk
	# ln -s /usr/bin/rpm /bin/rpm
	# ln -s /lib/libgcc_s.so.1 /lib/libgcc_s.so
	# ln -s /usr/bin/basename /bin/basename		(pic)

Login in to xwindows session as user oracle
-------------------------------------------
+ Mount the Oracle10g CD and run the installer
copy the /media/cdrom/database contents to the hard disk
	$ cp -r /media/cdrom/database .
	$ cd /database
	$ ./runInstaller -ignoreSysPrereqs
	- follow the installer instructions 
	- (view sequential pics : 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18 )
	- use password mgmt to unlock DBuser scott & set password 'tiger'
+ open http://localhost.localdomain:1158/em in a browser or
	As root # vi /etc/oratab  change :N to :Y 
+ This enables the oracle user to dbshut, dbstart and lsnrctl start