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

Saturday, 22 May 2010

Oracle 11gR2 Installation on Sun Solaris 10 Sparc


Operating System pre-requistes:

Hardware Requirement:




1 GB (Min)

SWAP Space

For RAM Between 1 and 2 GB, Swap = 1.5 times the size of RAM

For RAM Between 2 GB and 16 GB, Swap= Equal to the size of RAM

For RAM More than 16 GB, Swap Space= More than 16 GB

Disk Space Requirement

Minimum 1 GB free space should be in /tmp directory

Enterprise Edition = 4.68

Standard Edition= 4.62

Standard Edition One=4.62

Custom (Enterprise Edition + custom install options)= 4.71

To view available RAM : -

bash-3.00# prtconf | grep "Memory size"
Memory size: 16384 Megabytes
To View Available Swap Space:
bash-3.00# swap -l
swapfile dev swaplo blocks free
/dev/dsk/c1t2d0s1 32,9 16 32766704 32766704
Determine Disk Space size using command:
bash-3.00#df –h

Software Requirement:



Operating System version

Solaris 10 U6 (5.10-2008.10)

OS Package Requirement

· SUNWarc

· SUNWbtool

· SUNWhea

· SUNWlibC

· SUNWlibm

· SUNWlibms

· SUNWsprot

· SUNWtoo

· SUNWi1of

· SUNWi1cs (ISO8859-1)

· SUNWi15cs (ISO8859-15)

· SUNWxwfnt

· SUNWcsl

OS Patch Requirement

· 120753-06: SunOS 5.10: Microtasking libraries (libmtsk) patch

· 139574-03: SunOS 5.10

· 119963-14: SunOS 5.10: Shared library patch for C++

· 124861-15: SunOS 5.10 Compiler Common patch for Sun C C++ (optional)

· All mentioned below patches are required if you are using Database Smart Flash Cache (An Enterprise Edition only feature.)

· 125555-03

· 140796-01

· 140899-01

· 141016-01

· 139555-08

· 141414-10

· 141736-05

Command to check instllated packages:

bash-3.00# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibms SUNWsprot \

> SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt

system SUNWarc Lint Libraries (usr)

system SUNWbtool CCS tools bundled with SunOS

system SUNWhea SunOS Header Files

system SUNWi15cs X11 ISO8859-15 Codeset Support

system SUNWi1cs X11 ISO8859-1 Codeset Support

system SUNWi1of ISO-8859-1 (Latin-1) Optional Fonts

system SUNWlibC Sun Workshop Compilers Bundled libC

system SUNWlibms Math & Microtasking Libraries (Usr)

system SUNWsprot Solaris Bundled tools

system SUNWtoo Programming Tools

system SUNWxwfnt X Window System platform required fonts


Command to check Installed patches:

bash-3.00# showrev -p | grep 139574-03

Patch: 139574-03 Obsoletes: Requires: 118833-36, 120011-14, 127127-11, 137137-09 Incompatibles: Packages: SUNWcsu, SUNWcslr, SUNWtoo, SUNWbtool, SUNWxcu4

Creating required OS group and Users:

groupadd dbaprod

useradd –g dbaprod –d /home/ora11g –m ora11g

Change Privileges on installation Directories:

#chmod –R 774 /appl/11.2.0

#chown –R ora11g:dbaprod /appl/11.2.0

Set the Environment variables as below:


ORACLE_HOME=/appl/11.2.0/dbhome_1/; export ORACLE_HOME

PATH=/appl/11.2.0/dbhome_1/bin/:/usr/ccs/bin:$PATH; export PATH

Configuring Kernel Parameters on Solaris 10:

1) edit /etc/system as follows:

set shmsys:shminfo_shmmax=12025908428

set shmsys:shminfo_shmmni=100

set shmsys:shminfo_shmseg=10

set semsys:seminfo_semmni=100

set semsys:seminfo_semmns=1024

set shmsys:shminfo_shmmin=1

set max_nprocs=30000

set maxuprc=16384

2) setup project for oracle user (if it’s already setup then just ignore the duplicate error while running projadd command):

#projadd -U oracle user.ora11g

#projmod -s -K "project.max-sem-ids=(priv,100,deny)" user.ora11g

#projmod -s -K "process.max-sem-nsems=(priv,256,deny)" user.ora11g

#projmod -s -K "project.max-shm-memory=(priv,12025908428,deny)" user.ora11g

#projmod -s -K "project.max-shm-ids=(priv,100,deny)" user.ora11g

#projmod -s -K "process.max-file-descriptor=(priv,65536,deny)" user.ora11g

3) bounce the box:

init 6

Note: All these kernel parameters are configured as per 16 GB of RAM

Installing Oracle Software and creating default database:

· Configure the proper XDISPLAY

· Copy the media to a Stage Area

· Then runInstaller from Stage Area

Clcik "close" to exit Installation.

No comments: