Oracle Database 10g R2 on Kubuntu 8.04 32bit

Download here: http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201linuxsoft.html

1. Install additional packages
   # apt-get install gcc libaio1 libc6 libstdc++5 make lesstif2 lesstif2-dev rpm

   Attention! Be sure to install exactly “libstdc++5″. If you install a newer version you may encounter the following error during installation:

   INFO: Creating /opt/oracle/product/10gR2/lib/liborasdkbase.so.10.2</p>
   INFO: gcc:
   INFO: /usr/lib/libstdc++.so.5: No such file or directory
   INFO:</p>
   INFO: /opt/oracle/product/10gR2/bin/genorasdksh: Failed to link liborasdkbase.so.10.2</p>
   INFO: make: *** [liborasdkbase] Error 1</p>
   INFO: End output from spawned process.
   INFO: ———————————-
   INFO: Exception thrown from action: make
   Exception Name: MakefileException
   Exception String: Error in invoking target ‘all_no_orcl ihsodbc’ of makefile ‘/opt/oracle/product/10gR2/rdbms/lib/ins_rdbms.mk’. See ‘/opt/oracle/oraInventory/logs/installActions2008-06-09_10-10-35PM.log’ for details.

2. Create groups
   # groupadd oinstall
# groupadd dba
# groupadd oper
# groupadd nobody
3. Create user ‘oracle’ with group ‘oinstall’, secondary group ‘dba’, ‘oper’ and ‘admin’ for sudo, home /opt/oracle and shell
   /bin/bash and set the passwd
   # useradd -g oinstall -G dba,oper,admin,nobody -d /opt/oracle -s /bin/bash oracle
# passwd oracle
4. Create oracle home directory and set permissions
   # mkdir /opt/oracle
# chown -R oracle:oinstall /opt/oracle
# chmod -R 775 /opt/oracle
5. Edit /opt/oracle/.bash_profile for user ‘oracle’. Append PATH and ORACLE:BASE,HOME and SID information
   export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10gR2
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
6. Append kernel parameters int /etc/sysctl.conf
   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
7. Set kernel parameters or reboot# sysctl -p
8. set security limits in /etc/security/limits.conf
   soft nproc 2047
hard nproc 16384
soft nofile 1024
hard nofile 65536
9. 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
10. Relogin to X-Session as user ‘oracle’
11. Download and unzip 10201_database_linux32.zip
    $ unzip 10201_database_linux32.zip
12. Run the installer
    $ cd /database
$ ./runInstaller -ignoreSysPrereqs
13. Follow the installer.
14. Open Oracle Enterprise Manager 10g Database Control “http://localhost.localdomain:1158/em” in a browser to administrate your oracle 10g installation.
15. To start/stop the Oracle Enterprise Manager 10g Database Control use the following commands:
    # emctl start| stop| status| setpasswd dbconsole

16. To start/stop listener use the following commands:
    # lsnrctl start| stop| status|

Done.