Wednesday, June 9, 2010

Oracle 10g Quick Installation

Oracle Prerequisites and Install Requirements

Login to Solaris 10 server as root and open a terminal window
# /usr/sbin/prtconf | grep Memory - Check RAM (Recommended 1GB)
# /usr/sbin/swap –s - Check Swap (Free Space on swap)
# df -h /tmp - Check /tmp (Recommended 750MB)
# uname –r - Check Solaris Version
# hostname - Check host name

Check for Required installed Solaris Packages
# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWsprot SUNWtoo SUNWi1of
SUNWi1cs SUNWi15cs SUNWxwfnt

If any package is missing (not installed), install them using Solaris 10 CD pack as below example
#pkgadd -d . SUNWi1cs

Create User Groups, Oracle Users & .profile
To create user groups related to oracle, edit group file using vi editor and add 2 user groups
(oracle, oinstall) as per below
# vi /etc/group

To create oracle user refer the below sequence
# mkdir /export/home/oracle
# vi /etc/passwd
oracle:x:101:101:Oracle Super User:/export/home/oracle:/sbin/sh

# pwconv
# chown –R oracle:dba /export/home/oracle
# passwd –r files oracle
To check the oracle user ID, group use below command
(if output doesn’t match with example correct live machine according to example)

# id -a oracle
uid=101(oracle) gid=101(dba) groups=100(oinstall)
To change primary (-g) and supplementary (-G) groups

# usermod –g 101 –G 100 oracle
To create oracle user .profile follow the instructions below

#vi /export/home/oracle/.profile
umask 022 -> default permission
TMP=/tmp -> TMP to directory /tmp
TMPDIR=$TMP -> TMPDIR to same directory /tmp
DISPLAY=localhost:0.0 -> Display to local host
export TMP TMPDIR DISPLAY -> export to make available as env.
ORACLE_BASE=/oracle/app/oracle -> oracle products to installing dir.
ORACLE_HOME=/oracle/app/oracle/10.2.0/db1 -> oracle home dir. for executables
ORACLE_SID=orcl -> oracle instance (orcl is default)
PATH=$ORACLE_HOME/bin:$PATH -> dir. to search commands & prgs.
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH -> export to make available as env.

Configure Solaris 10 System Parameters Using
Resource Control Projects
#projadd oracle - Create a new resource project
Add new line to “/etc/user_attr" file
#su – oracle
$ id –p - Check oracle user
uid=101(oracle) gid=101(dba) projid=100(oracle)
(if output doesn’t match with example correct live machine according to example)

$ prctl -n project.max-shm-memory -i project oracle - Check shared memory
project: 100: oracle
privileged 254MB – deny - To be increased for better performance
system 16.0EB max deny
To set the kernel system value for the shared memory parameter, open another root shell and
perform the following two commands, make sure at least one terminal session is still logged in as
the oracle user. Then from root user shell issue these commands to set shared memory to 4GB.

# prctl -n project.max-shm-memory -v 4gb -r -i project oracle
# projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" oracle

The first dynamically resets the value, while the second makes changes to the "/etc/project" file
so the value is persistent between reboots. To see changes to /etc/project perform the following
# cat /etc/project

Now to go back to the oracle shell command terminal and type the following again to see that
the project information has been update to 4GB for the shared memory kernel system
$ prctl -n project.max-shm-memory -i project oracle
project: 100: oracle
privileged 4.00GB – deny - New value of Shared Memory
system 16.0EB max deny
If performed a new default Solaris installation, it is likely that this is the only system kernel
parameter you need to set is "max-shm-memory" for Oracle 10g.

Install Oracle® 10g
Logout from root and Login as user oracle
To install oracle on Solaris 10 first you have to transfer the zip (compressed) file to server
Insert CDROM containing oracle 10g ‘zip’ file (ex:
NOTE : Recommended minimum free space required
Mount Total Free
--------- --------- ----------------------------------------------------
/ 6GB 3GB -> root
/oracle 6GB 6GB -> Oracle installing directory
/export/home 1GB -> Users home directories
/u01 3GB 2GB -> to transfer & unzip compressed file
/archive 8GB 8GB -> if only archiving is enabled

#cd /cdrom
#cp –R /u01
#cd /u01
#cd database

Basic installation will be enough for the requirement
Insert & confirm ‘database password’ here
Keep system group name ad ‘dba’

If warning displays on below checks ‘check’ to ‘user verified’
Confirm to Install

Wait for installation completes,…..
Another screen you will see

Change if required a last minute password change,…

Installation seems to be successful
Once you see this pop-up window open a new terminal windows, log in as root and run the
specified scripts,…. Once complete come back to this window and press ‘ok’

Example screen dumps of above
CONGRATULATIONS !!! you have installed the Oracle 10g successfully.
Refer the web link on below window to “Enterprise Manager Control”
Ie,.. http://:1158/em

Press ‘Installed Products’ to check installed components

Install Oracle® 10g Web Administration
Logout from root and Login as user oracle to check and start listener control
# su – oracle
$ lsnrctl start
$ emctl start dbconsole
To Log into Enterprise Manager start your ‘web browser’