Oracle 11gR2 Installation on Sun Solaris 10 Sparc

INSTALLATION OF 11gR2 DATABASE ON SUN SOLARIS 10 (SPARC -64 Bit)

Operating System pre-requistes:

Hardware Requirement:

Hardware	Description
RAM	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

bash-3.00#

To View Available Swap Space:

bash-3.00# swap -l
swapfile             dev  swaplo blocks   free
/dev/dsk/c1t2d0s1   32,9      16 32766704 32766704
bash-3.00#

Determine Disk Space size using command:

bash-3.00#df –h

Software Requirement:

Software	Description
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

bash-3.00#

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_SID=db1; export ORACLE_SID

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.