Oracle DB 10.2g installation on Ubuntu Linux
Introduction –
Oracle Database is widely used commercial Database on Unix/Linux and Windows platform….
This article explain the step by step installation of Oracle 10g Release 2.0 on Ubuntu 8.04111!!
Please refer the Oracle installation guide for System requirement…
1] Hardware requirement –
RAM – minimum 1024 MB of physical memory
Disk space -1.5 GB to 3.5 GB of disk space, depends on the installation…
Minimum 400 MB of disk space in the /tmp directory
arunsb@arun:~$ free -m
arunsb@arun:~$ df -h
arunsb@arun:~$ df -h /tmp
2] Software dependency –
Make sure that following packages are installed on your system!!
make-3.8
gcc-4.2
libdb4.2
libdb4.2++-dev
libstdc++6
libstdc++6-4.2-dev
libmotif-dev
libmotif3
root@arun:~# apt-get install build-essential libc6-dev libmotif-dev libmotif3
root@arun:~# apt-get install xauth libxp6 libxt6 libxtst6 libaio1 glibc-source
root@arun:~# apt-get install rpm
root@arun:~# ln -s /usr/bin/awk /bin/awk
root@arun:~# ln -s /usr/bin/basename /bin/basename
root@arun:~# ln -s /usr/bin/rpm /bin/rpm
root@arun:~# dpkg -l
3] Operating System Groups and Users for Oracle –
* oinstall – Oracle Inventory group
* dba – The OS DBA group
* oracle – Oracle software owner (in mycase arunsb is oracle user)
root@arun:~# id oracle
id: oracle: No such user
root@arun:~#
root@arun:~# grep oinstall /etc/group
root@arun:~# grep dba /etc/group
NOTE – “oinstall” should be primary group of oracle user. It is not necessary to use “oracle” as username, you can name but make sure that the “oinstall” is primary group of that user!!
root@arun:~# addgroup oinstall
Adding group ‘oinstall’ (GID 1001) …
Done.
root@arun:~#
root@arun:~# addgroup dba
Adding group `dba’ (GID 1002) …
Done.
root@arun:~#
root@arun:~# addgroup nobody
Adding group `nobody’ (GID 1000) …
Done.
root@arun:~#
root@arun:~# useradd -g oinstall -G dba arunsb
root@arun:~#
root@arun:~# id arunsb
uid=1000(arunsb) gid=1001(oinstall) groups=1001(oinstall),1002(dba)
root@arun:~#
*** other setting –
root@arun:~# echo “Red Hat Linux release 3.0 (drupal)” > /etc/redhat-release
root@arun:~# cat /etc/redhat-release
Red Hat Linux release 3.0 (drupal)
root@arun:~#
4] Configure Kernel Parameters –
Add following kernel variable value as shown below in sysctl.conf file, then run command “sysctl -p” to update the setting…
root@arun:~# tail -n 16 /etc/sysctl.conf
###############################
## Adding setting for oracle 10g
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
##############################
root@arun:~#
* Use below command to set above kernel variables…
root@arun:~# sysctl -p
5] Oracle user profile and envirnoment –
Update /etc/security/limits.conf file as shown below….
root@arun:~# vi /etc/security/limits.conf
root@arun:~# tail /etc/security/limits.conf
#######################
## Added for arunsb (oracle user)
arunsb soft nproc 2047
arunsb hard nproc 16384
arunsb soft nofile 1024
arunsb hard nofile 65536
#######################
#
root@arun:~#
Add following setting in /etc/pam.d/login file
root@arun:~# vi /etc/pam.d/login
###################################
# oracle user –
session required pam_limits.so
###################################
** set envirnoment variables in user profile file “/home/arunsb/.bashrc” as shown below
arunsb@arun:~$ tail /home/arunsb/.bashrc
###########################
# Setting for Oracle 10g
export DISPLAY=”:0.0″
export ORACLE_OWNER=arunsb
export ORACLE_BASE=/u01/app
export ORACLE_HOME=/u01/app/product/10.2.0/db_1
export ORACLE_HOSTNAME=arun.mylaptop.com
PATH=$PATH:/u01/app/product/10.2.0/db_1/bin
##########################
#
arunsb@arun:~$
6] Oracle inventory and installation setting –
you need to create oralce Inventory director where Oracle stores all information about oralce software installed on your system. Also use same direcory
for oracle installation make sure to set proper path in user profile file ie .barshrc
root@arun:~# mkdir -p /u01/app/oraInventory
root@arun:~# ls -ld /u01/app/oraInventory
drwxr-xr-x 2 root root 4096 2008-11-23 22:57 /u01/app/oraInventory
root@arun:~# chown arunsb:oinstall -R /u01/app/oraInventory
root@arun:~# ls -ld /u01/app/oraInventory
drwxr-xr-x 2 arunsb oinstall 4096 2008-11-23 22:57 /u01/app/oraInventory
root@arun:~#
arunsb@arun:~$ mkdir -p /u01/app/product/10.2.0/db_1
7] It’s time to install Oracle –
arunsb@arun:/root/oracle-setup/oracle_server-10g$ ./runInstaller
Starting Oracle Universal Installer…
…
In between installation you need to run following shell scripts as root user…..
root@arun:~# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory to 770.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete
root@arun:~# /u01/app/product/10.2.0/db_1/root.sh
Running Oracle10 root.sh script…
The following environment variables are set as:
ORACLE_OWNER= arunsb
ORACLE_HOME= /u01/app/product/10.2.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin …
Copying oraenv to /usr/local/bin …
Copying coraenv to /usr/local/bin …
Creating /etc/oratab file…
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
root@arun:~#
8] Errors during installation –
NOTE – Installation failed many times with following ERRORs … please don’t forget to create soft link for awk , basename , rpm
Exception Name: MakefileException
Exception String: Error in invoking target ‘ntcontab.o’ of makefile
Exception Name: MakefileException
Exception String: Error in invoking target ‘utilities ctx_on’ of makefile
=================================================
The following J2EE Applications have been deployed and are accessible at the URLs listed below.
iSQL*Plus URL:
http://arun.mylaptop.com:5560/isqlplus
iSQL*Plus DBA URL:
http://arun.mylaptop.com:5560/isqlplus/dba
Oracle Enterprise manager URL
http://arun.mylaptop.com:5560/isqlplus/dba
=================================================
Thank you,
Arun Bagul
One Reply to “Oracle DB 10.2g installation on Ubuntu Linux”