Oracle Database 10g (10.2.0.1) Installation On Red Hat Enterprise Linux 3 (RHEL3)

In this article I’ll describe the installation of Oracle Database 10g Release 2 (10.2.0.1) on Red Hat Enterprise Linux 3 (RHEL3). The article is based on a server installation with a minimum of 2G swap, secure Linux disabled and the following package groups installed:

• X Window System
• GNOME Desktop Environment
• Editors
• Graphical Internet
• Text-based Internet
• Server Configuration Tools
• Development Tools
• Administration Tools
• System Tools

The installation is certified against RHEL3 Update 3 or above, but it will work against the initial release with some minor adjustments. Alternative installations may require more packages to be loaded, in addition to the ones listed below.

• Download Software
• Unpack Files
• Hosts File
• Set Kernel Parameters
• Setup
• Installation
• Post Installation

Download Software

Download the following software:

• Oracle Database 10g Release 2(10.2.0.1) Software

Unpack Files

Unzip the files:

unzip 10201_database_linux32.zip

You should now have a single directory containing installation files. Depending on the age of the download this may either be named “db/Disk1″ or “database”.

Hosts File

The /etc/hosts file must contain a fully qualified name for the server:

<IP-address>  <fully-qualified-machine-name>  <machine-name>

Set Kernel Parameters

Add the following lines to the /etc/sysctl.conf file:

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144

Run the following command to change the current kernel parameters:

/sbin/sysctl -p

Add the following lines to the /etc/security/limits.conf file:

*               soft    nproc   2047
*               hard    nproc   16384
*               soft    nofile  1024
*               hard    nofile  65536

Add the following line to the /etc/pam.d/login file, if it does not already exist:

session    required     pam_limits.so

Note by Kent Anderson: In the event that pam_limits.so cannot set privileged limit settings see Bug 115442.

Setup

Install the following packages:

# From RedHat AS3 Disk 2
cd /mnt/cdrom/RedHat/RPMS
rpm -Uvh setarch-1*
rpm -Uvh openmotif-2*

# From RedHat AS3 Disk 3
cd /mnt/cdrom/RedHat/RPMS
rpm -Uvh compat-libstdc++-7*
rpm -Uvh compat-libstdc++-devel-7*
rpm -Uvh compat-db-4*
rpm -Uvh compat-gcc-7*
rpm -Uvh compat-gcc-c++-7*
rpm -Uvh libaio-0*

Create the new groups and users:

groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba oracle
passwd oracle

Create the directories in which the Oracle software will be installed:

mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01

Login as root and issue the following command:

xhost +<machine-name>

Login as the oracle user and add the following lines at the end of the .bash_profile file:

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=TSH1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi

Installation

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:

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

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory:

./runInstaller

During the installation enter the appropriate ORACLE_HOME and name then continue with the installation.

When using the first release of RHEL AS 3.0 the pre-requesite check will complain about the version of the glibc package. To continue simply tick this error to confirm you wish to proceed anyway. The installation will work correctly but you will not have a supported installation. This issue doesn’t occur with RHEL AS 3.0 Update 3 or above.

For a more detailed look at the installation process, click on the links below to see screen shots of each stage.

 

Post Installation

Finally edit the /etc/oratab file setting the restart flag for each instance to ‘Y’:

TSH1:/u01/app/oracle/product/10.2.0/db_1:Y

 

Oracle Database 10g Release 2 (10.2.0.1) Installation On Fedora 7 (F7)

In this article I’ll describe the installation of Oracle Database 10g Release 2 (10.2.0.1) on Fedora 7. The article is based on a Fedora 7(F7 x86) Server Installation with a minimum of 2G swap, secure Linux disabled and the following package groups installed:

• Editors
• Graphical Internet
• Administration Tools
• Base
• X Window System
• System Tools
• Server Configuration Tools
• GNOME Desktop Environment
• Development Libraries
• Development Tools
• Legacy Software Support
• Hardware Support

Alternative installations may require more packages to be loaded, in addition to the ones listed below.

Note. There are a number of Fedora Core 6 packages that are required to get Oracle installed, linked and running. I’m not suggesting this will result in a stable Linux platform, but it does work.

• Download Software
• Unpack Files
• Hosts File
• Set Kernel Parameters
• Setup
• Installation
• Post Installation

Download Software

Download the following software:

• Oracle Database 10g Release 2 (10.2.0.1) Software

Unpack Files

Unzip the files:

unzip 10201_database_linux32.zip

You should now have a single directory containing installation files. Depending on the age of the download this may either be named “db/Disk1″ or “database”.

Hosts File

The /etc/hosts file must contain a fully qualified name for the server:

<IP-address>  <fully-qualified-machine-name>  <machine-name>

Set Kernel Parameters

Add the following lines to the /etc/sysctl.conf file:

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144

Run the following command to change the current kernel parameters:

/sbin/sysctl -p

Add the following lines to the /etc/security/limits.conf file:

*               soft    nproc   2047
*               hard    nproc   16384
*               soft    nofile  1024
*               hard    nofile  65536

Add the following line to the /etc/pam.d/login file, if it does not already exist:

session    required     pam_limits.so

Disable secure linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows:

SELINUX=disabled

Alternatively, this alteration can be done using the GUI tool (Desktop > System Settings > Security Level). Click on the SELinux tab and disable the feature.

Setup

Install the following packages:

# From Fedora 7 DVD
cd /media/dvd/Fedora
rpm -Uvh setarch-*
rpm -Uvh --force tcl-*
rpm -Uvh compat-db-*
rpm -Uvh --force libXau-devel-*

# Not available on Fedora 7 DVD, but available from standard yum repository.
yum install libXp libaio
yum install compat-libstdc++* compat-libf2c* compat-gcc* compat-libgcc*

Create the new groups and users:

groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba oracle
passwd oracle

Create the directories in which the Oracle software will be installed:

mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01

Login as root and issue the following command:

xhost +<machine-name>

Edit the /etc/redhat-release file replacing the current release information (Fedora release 7 (Moonshine)) with the following:

redhat-4

Login as the oracle user and add the following lines at the end of the .bash_profile file:

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=TSH1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi

Installation

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:

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

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory:

./runInstaller

Enter the appropriate ORACLE_HOME and name then continue with the installation.

For a more detailed look at the installation process, click on the links below to see screen shots of each stage.

 

Post Installation

Edit the /etc/redhat-release file restoring the original release information:

Fedora release 7 (Moonshine)

Finally edit the /etc/oratab file setting the restart flag for each instance to ‘Y’:

TSH1:/u01/app/oracle/product/10.2.0/db_1:Y

 

In this article I’ll describe the installation of Oracle Database 10g Release 2 (10.2.0.1) on Fedora Core 3. The article is based on a Fedora Core 3 Server Installation with a minimum of 2G swap, secure Linux disabled and the following package groups installed:

• X Window System
• GNOME Desktop Environment
• Editors
• Graphical Internet
• Text-based Internet
• Server Configuration Tools
• Development Tools
• Administration Tools
• System Tools

Alternative installations may require more packages to be loaded, in addition to the ones listed below.

• Download Software
• Unpack Files
• Hosts File
• Set Kernel Parameters
• Setup
• Installation
• Post Installation

Download Software

Download the following software:

• Oracle Database 10g Release 2(10.2.0.1) Software

Unpack Files

Unzip the files:

unzip 10201_database_linux32.zip

You should now have a single directory containing installation files. Depending on the age of the download this may either be named “db/Disk1″ or “database”.

Hosts File

The /etc/hosts file must contain a fully qualified name for the server:

<IP-address>  <fully-qualified-machine-name>  <machine-name>

Set Kernel Parameters

Add the following lines to the /etc/sysctl.conf file:

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144

Run the following command to change the current kernel parameters:

/sbin/sysctl -p

Add the following lines to the /etc/security/limits.conf file:

*               soft    nproc   2047
*               hard    nproc   16384
*               soft    nofile  1024
*               hard    nofile  65536

Add the following line to the /etc/pam.d/login file, if it does not already exist:

session    required     pam_limits.so

Note by Kent Anderson: In the event that pam_limits.so cannot set privilidged limit settings see Bug 115442.

Disable secure linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows:

SELINUX=disabled

Alternatively, this alteration can be done using the GUI tool (Desktop > System Settings > Security Level). Click on the SELinux tab and disable the feature.

Setup

Install the following packages:

# From Fedora Core 3 Disk 1
cd /media/cdrom/Fedora/RPMS
rpm -Uvh setarch-1*
rpm -Uvh tcl-8*
rpm -Uvh compat-libstdc++-8*

# From Fedora Core 3 Disk 2
cd /media/cdrom/Fedora/RPMS
rpm -Uvh xorg-x11-deprecated-libs-6*
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*

# From Fedora Core 3 Disk 3
cd /media/cdrom/Fedora/RPMS
rpm -Uvh compat-libstdc++-devel-8*
rpm -Uvh compat-gcc-8*
rpm -Uvh compat-gcc-c++-8*
rpm -Uvh libaio-0*

Create the new groups and users:

groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba oracle
passwd oracle

Create the directories in which the Oracle software will be installed:

mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01

Login as root and issue the following command:

xhost +<machine-name>

Edit the /etc/redhat-release file replacing the current release information (Fedora Core release 3 (Heidelberg)) with the following:

redhat-3

Login as the oracle user and add the following lines at the end of the .bash_profile file:

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=TSH1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi

Installation

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:

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

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory:

./runInstaller

During the installation enter the appropriate ORACLE_HOME and name then continue with a “software only” installation. For a more detailed look at the installation process, click on the links below to see screen shots of each stage.

 

Post Installation

Create a new instance using the DBCA. If you get the “ORA-27125: unable to create shared memory segment” error when using the DBCA issue the following commands as the oracle user then try again:

cd $ORACLE_HOME/bin

mv oracle oracle.bin

cat >oracle <<"EOF"
#!/bin/bash

export DISABLE_HUGETLBFS=1
exec $ORACLE_HOME/bin/oracle.bin $@
EOF

chmod +x oracle

Edit the /etc/redhat-release file restoring the original release information:

Fedora Core release 3 (Heidelberg)

Finally edit the /etc/oratab file setting the restart flag for each instance to ‘Y’:

TSH1:/u01/app/oracle/product/10.2.0/db_1:Y

 

Oracle Database 10g Release 2 (10.2.0.1) Installation On Fedora Core 4 (FC4)

In this article I’ll describe the installation of Oracle Database 10g Release 2 (10.2.0.1) on Fedora Core 4. The article is based on a Fedora Core 4 Server Installation with a minimum of 2G swap, secure Linux disabled and the following package groups installed:

• X Window System
• GNOME Desktop Environment
• Editors
• Graphical Internet
• Text-based Internet
• Server Configuration Tools
• Development Tools
• Administration Tools
• System Tools

Alternative installations may require more packages to be loaded, in addition to the ones listed below.

• Download Software
• Unpack Files
• Hosts File
• Set Kernel Parameters
• Setup
• Installation
• Post Installation

Download Software

Download the following software:

• Oracle Database 10g Release 2 (10.2.0.1) Software

Unpack Files

Unzip the files:

unzip 10201_database_linux32.zip

You should now have a single directory containing installation files. Depending on the age of the download this may either be named “db/Disk1″ or “database”.

Hosts File

The /etc/hosts file must contain a fully qualified name for the server:

<IP-address>  <fully-qualified-machine-name>  <machine-name>

Set Kernel Parameters

Add the following lines to the /etc/sysctl.conf file:

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144

Run the following command to change the current kernel parameters:

/sbin/sysctl -p

Add the following lines to the /etc/security/limits.conf file:

*               soft    nproc   2047
*               hard    nproc   16384
*               soft    nofile  1024
*               hard    nofile  65536

Add the following line to the /etc/pam.d/login file, if it does not already exist:

session    required     pam_limits.so

Note by Kent Anderson: In the event that pam_limits.so cannot set privilidged limit settings see Bug 115442.

Disable secure linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows:

SELINUX=disabled

Alternatively, this alteration can be done using the GUI tool (Desktop > System Settings > Security Level). Click on the SELinux tab and disable the feature.

Setup

Install the following packages:

# From Fedora Core 4 Disk 1
cd /media/cdrom/Fedora/RPMS
rpm -Uvh setarch-1*
rpm -Uvh tcl-8*

# From Fedora Core 4 Disk 2
cd /media/cdrom/Fedora/RPMS
rpm -Uvh xorg-x11-deprecated-libs-6*
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*

# From Fedora Core 4 Disk 3
cd /media/cdrom/Fedora/RPMS
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh compat-gcc-32-3*
rpm -Uvh libaio-0*

# From Fedora Core 4 Disk 4
cd /media/cdrom/Fedora/RPMS
rpm -Uvh compat-gcc-32-c++-3*

Create the new groups and users:

groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba oracle
passwd oracle

Create the directories in which the Oracle software will be installed:

mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01

Login as root and issue the following command:

xhost +<machine-name>

Edit the /etc/redhat-release file replacing the current release information (Fedora Core release 4 (Stentz)) with the following:

redhat-4

Login as the oracle user and add the following lines at the end of the .bash_profile file:

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=TSH1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi

Installation

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:

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

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory:

./runInstaller

During the installation enter the appropriate ORACLE_HOME and name then continue with the installation. For a more detailed look at the installation process, click on the links below to see screen shots of each stage.

Post Installation

Edit the /etc/redhat-release file restoring the original release information:

Fedora Core release 4 (Stentz)

Finally edit the /etc/oratab file setting the restart flag for each instance to ‘Y’:

TSH1:/u01/app/oracle/product/10.2.0/db_1:Y

 

Oracle Database 10g Release 2 (10.2.0.1) Installation On Fedora Core 5 (FC5)

In this article I’ll describe the installation of Oracle Database 10g Release 2 (10.2.0.1) on Fedora Core 5. The article is based on a Fedora Core 5 (FC5 X86) Server Installation with a minimum of 2G swap, secure Linux disabled and the following package groups installed:

• Editors
• Graphical Internet
• Administration Tools
• Base
• X Window System
• System Tools
• Server Configuration Tools
• GNOME Desktop Environment
• Development Libraries
• Development Tools
• Legacy Development Support
• Legacy Server Support

Alternative installations may require more packages to be loaded, in addition to the ones listed below.

• Download Software
• Unpack Files
• Hosts File
• Set Kernel Parameters
• Setup
• Installation
• Post Installation

Download Software

Download the following software:

• Oracle Database 10g Release 2 (10.2.0.1) Software
• openmotif21-2.1.30-14.i386.rpm

Unpack Files

Unzip the files:

unzip 10201_database_linux32.zip

You should now have a single directory containing installation files. Depending on the age of the download this may either be named “db/Disk1″ or “database”.

Hosts File

The /etc/hosts file must contain a fully qualified name for the server:

<IP-address>  <fully-qualified-machine-name>  <machine-name>

Set Kernel Parameters

Add the following lines to the /etc/sysctl.conf file:

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144

Run the following command to change the current kernel parameters:

/sbin/sysctl -p

Add the following lines to the /etc/security/limits.conf file:

*               soft    nproc   2047
*               hard    nproc   16384
*               soft    nofile  1024
*               hard    nofile  65536

Add the following line to the /etc/pam.d/login file, if it does not already exist:

session    required     pam_limits.so

Disable secure linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows:

SELINUX=disabled

Alternatively, this alteration can be done using the GUI tool (Desktop > System Settings > Security Level). Click on the SELinux tab and disable the feature.

Setup

Install the following packages:

# From Fedora Core 5 DVD
cd /media/dvd/Fedora/RPMS
rpm -Uvh setarch-*
rpm -Uvh --force tcl-*
rpm -Uvh libXp-*
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-*
rpm -Uvh compat-libstdc++-33*
rpm -Uvh compat-libf2c-32-*
rpm -Uvh compat-gcc-32-*
rpm -Uvh libaio-*
rpm -Uvh compat-gcc-32-c++-*
rpm -Uvh compat-libstdc++-296*
rpm -Uvh compat-libgcc-296*

# From download
rpm -Uvh openmotif21-2.1.30-14.i386.rpm

Create the new groups and users:

groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba oracle
passwd oracle