1. Oracle 10g Preinstallation (Sun Solaris)

Overview
Few actions will have a greater impact on the stability of your database than a sound software installation. We want to install software to meet these criteria:

* Secure.
* Standardized.
* Able to store a daunting amount of data.
* Able to manage connections effectively.
* Scalable.

This calls for markedly different mentality than installing home PC software.

If the installation of Oracle in your environment is not standardized, then it will be harder to duplicate success, and harder for new DBAs to get up to speed. The same is true with any piece of Enterprise software.

Modify the OS Kernel to Support Oracle
Add the following settings to the to your /etc/system file. The system must be rebooted before these settings will take effect. The below works in Solaris versions 8, 9 and 10. See your UNIX System Administrator as required.

set noexec_user_stack=1
set semsys:seminfo_semmni=300
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=300
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=300
set shmsys:shminfo_shmseg=20


The default kernel values for the Solaris 10 operating system now account for many of the traditional ones that used to be required. Any entries regarding shared memory or semaphores (shm & sem) in /etc/system will be ignored if prctl is used. Furthermore, the following parameters have been removed in Solaris 10. If these parameters are included in the /etc/system file on a Solaris 10 system, they will be ignored:

semsys:seminfo_semmns
semsys:seminfo_semvmx
shmsys:shminfo_shmseg
shmsys:shminfo_shmmin


Create Oracle UNIX Groups and User Account

1. Create Groups
/usr/sbin/groupadd dba
/usr/sbin/groupadd oinstall

2. Create Oracle UNIX User Account
For a new install:
/usr/sbin/useradd -u -g oinstall -G dba -d /home/oracle -c "Oracle" -s /bin/csh oracle

For an upgrade from 9i:
/usr/sbin/usermod -g oinstall -G dba oracle

3. Set oracle Account password.
passwd -r files oracle

4. Set permission for HOME directory.
chown oracleinstall /home/oracle
chmod 755 /home/oracle

Create Oracle Data Directories and Set Permissions

1. Create directories.
mkdir /oradata/<SID>/dbf
mkdir /oradata/<SID>/recovery1
mkdir /oradata/<SID>/recovery2
mkdir /oradata/<SID>/rman
mkdir /oradata/<SID>/exports

2. Set UNIX Privileges for Data Directories
chown -R oracleinstall /oradata*
chmod -R 755 /ora0*

Create Application Directory Structure and Initialize Environment

1. Login into your UNIX system as the oracle user.

2. Create common directory structure.

There is no need to change the permissions as you are logged in as the oracle user account.

mkdir /home/oracle/software
mkdir /home/oracle/software/10.2/db
mkdir /home/oracle/software/10.2/companion
mkdir /home/oracle/software/10.2/client
mkdir /home/oracle/software/patches

mkdir /home/oracle/product
mkdir /home/oracle/product/10.2
mkdir /home/oracle/product/10.2/db

mkdir /home/oracle/cron

mkdir /home/oracle/scripts

3. Download and copy the zipped Oracle database installation file to the directory /home/oracle/software/10.2/db.

Then unzip the file which will leave you with a standard UNIX cpio file. Using the commands shown expand the cpio file. This will build the required directory structure to perform the installation.

oracle> cd /home/oracle/software/10.2/db
oracle> gunzip 10gr2_db_sol.cpio.gz
oracle> cpio -idmv < 10gr2_db_sol.cpio

Repeat the above for the companion and client 10.2 zip files in the corresponding directory (.../10.2/companion, .../10.2/client).

4. Set environment to perform installation. It is very important to unset any Oracle environments variables not being used so as to not adversely affect existing Oracle software installations.

xhost +
setenv DISPLAY yourhostname:0
umask 022
setenv TEMP /tmp
setenv TMPDIR /tmp
setenv ORACLE_BASE /home/oracle
setenv PATH /usr/bin:/usr/sbin:/usr/dt/bin:/usr/openwin/bin:/usr/ucb:/usr/local/bin:/bin

unsetenv ORACLE_HOME
unsetenv LD_LIBRARY_PATH
unsetenv TNS_ADMIN
unsetenv ORACLE_SID

After performing these steps you are now ready to perform the installation.