Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Wednesday, 20 October 2010

Installation of on Oracle Solaris 10u9

This article will be useful for Installation of Oracle on Latest available Oracle Soalris Update 9

Note: (10098816) patchset comes with complete Installation. For this release we need not have to Install base release software. The base release software is already included in software.

Steps for Installation:

1) Donwload patchset 10098816 from

File Size 1.4G (1424340471 bytes) Download 1.0G (1069940891 bytes) Download 918M (963322837 bytes) Download 674M (707499195 bytes) Download 621M (651345204 bytes) Download 483M (506870319 bytes) Download 138M (144770887 bytes) Download

The first two files contains RDBMS Software.

2) Unzip the files in a stage area.

3) Perform all pre-requisite steps

In Oracle Solaris 10 9/10 s10s_u9wos_14a SPARC u need not have to Install any additional patches and packages.

Need to configure shmmax variable, this can be done with the following commnad:

bash-3.00#projadd -U ora11g -K "project.max-shm-memory=(priv,8192MB,deny)" user.ora11g

Bounce the Server (init 6)

Some other new kernel parameters are added for patchset Instalaltion. For setting these kernel parameter use below commands:

bash-3.00# ndd -set /dev/udp udp_smallest_anon_port 9000
bash-3.00# ndd -set /dev/udp udp_largest_anon_port 65500
bash-3.00# ndd -set /dev/tcp tcp_smallest_anon_port 9000
bash-3.00# ndd -set /dev/tcp tcp_largest_anon_port 65500

For more Information on setting these parameters please refer:

add oracle user and group:

bash-3.00#groupadd dba
bash-3.00#useradd -g dba -d /home/ora11g -m ora11g

change directory privileges and ownership:

bash-3.00#chmod -R 775 /u01/11g_Home
bash-3.00#chown -R ora11g:dba /u01/11g_Home

Set environment variables in bash profile or any other .env file:

ORACLE_BASE=/u01/11g_home; export ORACLE_BASE

Login to sever with xwindow software and set the proper display.

4) Install the Oracle software:

-> Run Installer from stage area

Follow one by one Installation steps.

No comments: