#!/bin/sh

# --------++-- oracle_installer.sh --++----------
# Installation for Orcale Database 9.2.0.4.0.
# Kreny <kreny[AT]hotmail.com>
# Copyright 2005. Last Updated 2005/10/15 22:18:39
#
# This installation runs pre-installation steps required for an Oracle9i
# software installation accrding the Oracle9i Official Installation Guide. 
# http://www.oracle.com/technology/documentation/oem92.html




#
# DEFINITION :  You may change any value for your convenience.
#

# IP address and Server Name for this machine.
LOCAL_IP=192.168.1.234
LOCAL_SERVERNAME=oracle234

# UNIX Group for the Oracle Universal Installer Inventory
ORACLE_UII_GID=501
ORACLE_UII_GNAME=oinstall

# OSDBA group.
ORACLE_OSDBA_GID=502
ORACLE_OSDBA_GNAME=dba

# OSOPER group. (Optional)
#ORACLE_OSOPER_GID=503
#ORACLE_OSOPER_GNAME=oper

# UNIX Account to Own Oracle Software
ORACLE_SOFTWARE_UID=501
ORACLE_SOFTWARE_UNAME=oracle
ORACLE_SOFTWARE_HOMEDIR=/home/oracle
ORACLE_SOFTWARE_BASH_PROFILE=$ORACLE_SOFTWARE_HOMEDIR/.bash_profile

# Oracle software environment parameters
ORACLE_SOFTWARE_BASE=/opt/oracle
ORACLE_SOFTWARE_VERSION=9.2.0.4.0
ORACLE_SOFTWARE_SID=orcl


#
# Check the system environment
#
echo "Checking the system environment..."


# Be sure run as root
if [ "`id |grep root`" = "" ]; then
    cat<<EOF

Sorry, but this must be run as root, as several operations require - well 
root access :-)

EOF
    exit
fi


# Be sure the group and user does not exist
# @under construction

if [ "`grep $ORACLE_UII_GID /etc/group`" != "" ]; then
    cat<<EOF
Group ID $ORACLE_UII_GID existed. Abord installation.
EOF
    exit

fi

if [ "`grep $ORACLE_OSDBA_GID /etc/group`" != "" ]; then
    cat<<EOF
Group ID $ORACLE_OSDBA_GID existed. Abord installation.
EOF
    exit
fi

# (Optional)
#if [ "`grep $ORACLE_OSOPER_GID /etc/group`" != "" ]; then
#    cat<<EOF
#Group ID $ORACLE_OSOPER_GID existed. Abord installation.
#EOF
#    exit
#fi

if [ "`grep $ORACLE_SOFTWARE_UID /etc/passwd`" != "" ]; then
    cat<<EOF
User ID $ORACLE_SOFTWARE_UID existed. Abord installation.
EOF
    exit
fi





#
# Setup Task to Perform as root User
#


#
# Create Mount Points
#

#
# Create UNIX Groups for Database Administrators
#
echo "Creating UNIX Groups for Database Administrators..."

# Create a UNIX Group for the Oracle Universal Installer Inventory
groupadd -g $ORACLE_UII_GID $ORACLE_UII_GNAME

# Create the OSDBA group.
groupadd -g $ORACLE_OSDBA_GID $ORACLE_OSDBA_GNAME

# You may choose to create the OSOPER group. (Optional)
#groupadd -g $ORACLE_OSOPER_GID $ORACLE_OSOPER_GNAME

# Create a UNIX Account to Own Oracle Software
useradd -u $ORACLE_SOFTWARE_UID -g $ORACLE_UII_GNAME -G $ORACLE_OSDBA_GNAME -d $ORACLE_SOFTWARE_HOMEDIR -m -s /bin/bash $ORACLE_SOFTWARE_UNAME
passwd $ORACLE_SOFTWARE_UNAME

# Create a UNIX Account to Own the Oracle HTTP Server
# We use nobody user here.

# Set Permissions for File Creation
umask 022



#
# Write the Oracle enviroment variables to /home/oracle/.bash_profile
# 
echo "Write the Oracle enviroment variables to $ORACLE_SOFTWARE_BASH_PROFILE ..."

if [ "`grep ORACLE_HOME $ORACLE_SOFTWARE_BASH_PROFILE`" = "" ]; then
	echo "

# Oracle Environment Variables
DISPLAY=$LOCAL_IP:0.0
ORACLE_BASE=$ORACLE_SOFTWARE_BASE
ORACLE_HOME=\$ORACLE_BASE/product/$ORACLE_SOFTWARE_VERSION
ORA_NLS33=\$ORACLE_HOME/ocommon/nls/admin/data 
ORACLE_SID=$ORACLE_SOFTWARE_SID
NLS_LANG=Japanese_Japan.JA16EUC
PATH=\$ORACLE_HOME/bin:/usr/bin:/bin:/usr/bin/X11/:/usr/local/bin:\$PATH 
LD_LIBRARY_PATH=/usr/lib:\$ORACLE_HOME/lib:\$LD_LIBRARY_PATH
LANG=ja_JP.eucJP

export DISPLAY
export ORACLE_BASE
export ORACLE_HOME
export ORA_NLS33
export ORACLE_SID
export NLS_LANG
export PATH
export LD_LIBRARY_PATH
export LANG

" >> $ORACLE_SOFTWARE_BASH_PROFILE;

else 

    cat<<EOF
The profile file $ORACLE_SOFTWARE_BASH_PROFILE seems contain Oracle enviroment variables.
Please add the enviroment variables below manually.


#################################################
# Oracle Environment Variables
DISPLAY=$LOCAL_IP:0.0
ORACLE_BASE=$ORACLE_SOFTWARE_BASE
ORACLE_HOME=\$ORACLE_BASE/product/$ORACLE_SOFTWARE_VERSION
ORA_NLS33=\$ORACLE_HOME/ocommon/nls/admin/data 
ORACLE_SID=$ORACLE_SOFTWARE_SID
NLS_LANG=Japanese_Japan.JA16EUC
PATH=\$ORACLE_HOME/bin:/usr/bin:/bin:/usr/bin/X11/:/usr/local/bin:\$PATH 
LD_LIBRARY_PATH=/usr/lib:\$ORACLE_HOME/lib:\$LD_LIBRARY_PATH
LANG=ja_JP.eucJP

export DISPLAY
export ORACLE_BASE
export ORACLE_HOME
export ORA_NLS33
export ORACLE_SID
export NLS_LANG
export PATH
export LD_LIBRARY_PATH
export LANG
#################################################

EOF

fi

# Make directories for Oracle software.
echo "Building the directory for Oracle product..."
mkdir -p $ORACLE_SOFTWARE_BASE/product/$ORACLE_SOFTWARE_VERSION >/dev/null 2>&1;

# Set the permition for directories.
echo "Setting the permition..."
chmod u-w $ORACLE_SOFTWARE_HOMEDIR/.bash_profile >/dev/null 2>&1;
chown -R $ORACLE_SOFTWARE_UNAME:$ORACLE_UII_GNAME $ORACLE_SOFTWARE_BASE >/dev/null 2>&1;
chmod 755 -R $ORACLE_SOFTWARE_BASE >/dev/null 2>&1;

# Set the hostname to xhost parameter.
echo "Setting the hostname to xhost..."
xhost +$LOCAL_SERVERNAME

cat<<EOF

Setup Task to Perform as root User Finished!
EOF