B.1 Installing Oracle 11g

B.1.1 Oracle 11g Installation on SLES 11

  1. Follow the installation instructions provided in the SUSE Linux Enterprise Server (SLES) 11 installation manual. Install SLES 11 and the default packages along with the Oracle Server Base and the C/C++ Compiler and Tools.

  2. Log in as root.

  3. The account for the oracle user is disabled. Enable the account by changing the shell for the oracle user from /bin/false to /bin/bash by using YaST or by editing the /etc/passwd file.

    If the oracle user account does not exist, create an account by using the following commands:

    To add a dba group:

    groupadd -G dba

    To add an oracle user:

    useradd -G dba -d <home_directory> -m oracle -p <passwd>

  4. Set a new password for the oracle user by using YaST or by using the following command:

    /usr/bin/passwd oracle

  5. Change the default Oracle environment settings set by orarun, if required:

    1. Change the Oracle home directory by editing the ORACLE_HOME variable in /etc/profile.d/oracle.sh file.

    2. The default ORACLE_SID value is set to orcl. Change it to ESEC in the /etc/profile.d/oracle.sh file.

  6. Set the kernel parameters by using the following command:

    /usr/sbin/rcoracle start

    Required kernel parameter settings:

    fs.file-max = 512 * PROCESSES
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

  7. Ensure that the packages are installed correctly by using the following command:

    rpm -q <package_name>

    List of packages:

    binutils-2.19
gcc-4.3
gcc-32bit-4.3
gcc-c++-4.3
glibc-2.9
glibc-32bit-2.9
glibc-devel-2.9
glibc-devel-32bit-2.9
ksh-93t
libaio-0.3.104
libaio-32bit-0.3.104
libaio-devel-0.3.104
libaio-devel-32bit-0.3.104
libstdc++33-3.3.3
libstdc++33-32bit-3.3.3
libstdc++43-4.3.3_20081022
libstdc++43-32bit-4.3.3_20081022
libstdc++43-devel-4.3.3_20081022
libstdc++43-devel-32bit-4.3.3_20081022
libgcc43-4.3.3_20081022
libstdc++-devel-4.3
make-3.81
sysstat-8.1.5

  8. Change to the oracle user:

    su -oracle

  9. Change to database directory, then run ./runinstaller.

    The Oracle Universal Installer screen is displayed.

  10. From the Configuration options, select Install Database Software only, then click Next.

  11. Accept the default inventory directory or browse and select a new directory, then click Next.

  12. From the Installation types, select Enterprise Edition, then click Next.

  13. Review your selections, then click Install.

  14. Execute the specified scripts as the root user and click OK on completion.

  15. After the installation is complete, click Exit.

B.1.2 Oracle 11g Installation on SLES 10

  1. Follow the installation instructions provided in the SLES 10 installation manual. Install SLES 10 with the ext3 filesystem and the default packages along with Oracle Server Base, C/C++ Compiler and Tools.

  2. Log in as root.

  3. Install SLES 10 Service pack. Verify the service pack information by using the following command:

    SPident

    or

    cat /etc/SuSE-release

  4. The account for the oracle user is disabled. Enable the account by changing the shell for the oracle user from /bin/false to /bin/bash by using YaST or by editing the /etc/passwd file.

    If the oracle user account does not exist, create an account by using the following commands:

    To add a dba group:

    groupadd -G dba

    To add an oracle user:

    useradd -G dba -d <home_directory> -m oracle -p <passwd>

  5. Set a new password for the oracle user by using YaST or by using the following command:

    /usr/bin/passwd oracle

  6. Change the default Oracle environment settings set by orarun, if required:

    1. Change the Oracle home directory by editing the ORACLE_HOME variable in /etc/profile.d/oracle.sh file.

    2. The default ORACLE_SID value is set to orcl. Change it to ESEC in /etc/profile.d/oracle.sh file.

  7. Set the kernel parameters by using the following command:

    /usr/sbin/rcoracle start

    Required kernel parameter settings:

    fs.file-max = 512 * PROCESSES
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

  8. Ensure that the packages are installed correctly by using the following command:

    rpm -q <package_name>

    List of packages:

    binutils-2.16.91.0.5
compat-libstdc++-5.0.7
glibc-2.4-31.2
glibc-devel-2.4-31.2
gcc-4.1.0
ksh-93r-12.9
libaio-0.3.104
libaio-devel-0.3.104
libelf-0.8.5
libgcc-4.1.0
libstdc++-4.1.0
libstdc++-devel-4.1.0
make-3.80
sysstat-6.0.2
unixODBC-2.2.11
unixODBC-devel-2.2.11

  9. Change to the oracle user:

    su - oracle

  10. Change to database directory, then run ./runinstaller.

    The Oracle Universal Installer screen is displayed.

  11. From the Configuration options, select Install Database Software only, then click Next.

  12. Accept the default inventory directory or browse and select a new directory, then click Next.

  13. From the Installation types, select Enterprise Edition, then click Next.

    The Installation summary is displayed.

  14. Review the settings, then click Install.

  15. Execute the specified scripts as the root user and click OK on completion.

  16. After the installation is complete, click Exit.

B.1.3 Oracle 11g Installation on Red Hat Linux 4

  1. Log in as root.

  2. Set the kernel parameters as follows:

    fs.file-max = 512 * PROCESSES
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

  3. Run the following command to ensure that the required packages are installed on your server.

    rpm –q <package name>

    List of packages:

    binutils-2.15.92.0.2-18
compat-libstdc++-33.2.3-47.3
elfutils-libelf-0.97-5
elfutils-libelf-devel-0.97-5
glibc-2.3.9.4-2.19
glibc-common-2.3.9.4-2.19
glibc-devel-2.3.9.4-2.19
gcc-3.4.5-2
gcc-c++-3.4.5-2
libaio-devel-0.3.105-2
libaio-0.3.105-2
libgcc-3.4.5
libstdc++-3.4.5-2
libstdc++-devel-3.4.5-2
make-3.80-5
sysstat-5.0.5
unixODBC-2.2.11
unixODBC-devel-2.2.11

  4. Create a UNIX group and UNIX user account for the Oracle database owner by using the following commands:

    Add dba group (as root):

    groupadd oinstall
groupadd dba

  5. Add an Oracle user (as root):

    useradd –g oinstall –G dba –d /opt/oracle/product/<10.2.0.3>/db_1 –m oracle
passwd oracle

  6. Change to the oracle user:

    su - oracle

  7. Create directories for ORACLE_HOME and ORACLE_BASE.

  8. Open the .bash_profile file (in the oracle user’s home directory) for editing, and append the following:

    # User specific environment and startup programs
ORACLE_BASE=/opt/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=$ORACLE_HOME/bin:$PATH; export PATH
ORACLE_SID=oracle; export ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib; export CLASSPATH
LD_ASSUME_KERNEl=2.4.19; export LD_ASSUME_KERNEL
TMP=/tmp; export TMP
TMPDIR=$TMP;export TMPDIR
PATH=$PATH:$HOME/bin
export PATH

unset USERNAME

    IMPORTANT:This set of environment variables must only be used for the oracle user. These variables should not be set in the system environment or in the Sentinel Administrator User environment.

  9. Run the .bash_profile to set the environment variables, and check the values by using the following command:

    set | more

  10. If you are using X emulation, set the DISPLAY environmental variable:

    DISPLAY=<machine-name>:0.0; export DISPLAY

  11. Change to database directory, then run the following script: 

    ./runInstaller

  12. When you proceed through the installation, leave all the prompts with their default values except the ones specified below:

    1. In the Welcome window, click Next.

    2. In the File Locations window, select ORACLE_BASE and ORACLE_HOME from the drop-down list for the Destination Name, then click Next.

    3. Install only the Oracle software, and deselect the Default Database Creation option.

    4. In the Installation Types window, select Enterprise Edition, then click Next.

    5. In the Summary window, review the installation summary, then click Install.

    6. In the End of Installation window, click Exit.

B.1.4 Oracle 11g Installation on Solaris 10

  1. Log in as root.

  2. Set the kernel parameters according to the following standards:

    set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967296
set shmsys:shminfo_shmmni=100

  3. Run the following command to ensure that the required packages are installed on your server.

    rpm –q <package name>

    List of packages:

    SUNWarc
SUNWbtool
SUNWhea
SUNWlibC
SUNWlibm
SUNWlibms
SUNWsprot
SUNWtoo
SUNWi1of
SUNWi1cs
SUNWi15cs
SUNWxwfnt
SUNWsprox

  4. Create a UNIX group and UNIX user account for the Oracle database owner by using the following commands:

    Add dba group (as root):

    groupadd oinstall
groupadd dba

  5. Add an Oracle user (as root):

    useradd –g oinstall –G dba –d /opt/oracle/product/<10.2.0.3>/db_1 –m oracle
passwd oracle

  6. Change to the oracle user:

    su - oracle

  7. Create directories for ORACLE_HOME and ORACLE_BASE.

  8. Open the .bash_profile file (in the oracle user home directory) for editing, and append the following:

    # User specific environment and startup programs
ORACLE_BASE=/opt/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=$ORACLE_HOME/bin:$PATH; export PATH
ORACLE_SID=oracle; export ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib; export CLASSPATH
LD_ASSUME_KERNEl=2.4.19; export LD_ASSUME_KERNEL
TMP=/tmp; export TMP
TMPDIR=$TMP;export TMPDIR
PATH=$PATH:$HOME/bin
export PATH

unset USERNAME

    IMPORTANT:This set of environment variables must only be used for the oracle user. These variables should not be set in the system environment or in the Sentinel Administrator User environment.

  9. Run the .bash_profile to set the environment variables, and check the values by using the following command:

    set | more

  10. If you are using X emulation, set the DISPLAY environmental variable byu sing the following command:

    DISPLAY=<machine-name>:0.0; export DISPLAY

  11. Change to database directory, then run the following script: 

    ./runInstaller

  12. Whenyou proceed through the installation, leave all the prompts with their default values except the ones specified below:

    1. In the Welcome window, click Next.

    2. In the File Locations window, select ORACLE_BASE and ORACLE_HOME from the drop-down list for the Destination Name , then click Next.

    3. Install only the Oracle software, and deselect the Default Database Creation option.

    4. In the Installation Types window, select Enterprise Edition, then click Next.

    5. In the Summary window, review the install summary, then click Install.

    6. In the End of Installation window, click Exit.