×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Oracle: All versions FAQ

Foundation

1. Oracle 10g Preinstallation (Sun Solaris) by Michael42
Posted: 17 Oct 06 (Edited 18 Oct 06)

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 oracle:oinstall /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 oracle:oinstall /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.

Back to Oracle: All versions FAQ Index
Back to Oracle: All versions Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close