Installing Oracle 10G on Red Hat Enterprise Linux

Preparing the operating system for installation. Software packages that are required while installing Linux (first check to see whether the server's BIOS has the latest firmware).

Preparing the operating system for installation. Software packages that are required while installing Linux (first check to see whether the server’s BIOS has the latest firmware).

 

Desktop Environment
  • GNOME Desktop Environment
Applications
  • Graphical Internet
Development
  • Development Libraries
  • Development Tools
Servers
  • Server Configuration Tools
Base System
  • Administration Tools
  • Base
  • Java
  • Legacy Software Support
  • System Tools
  • X Window System
Gerekli RPM’ ler
  • compat-db-4.2.52-5.1.i386.rpm
  • sysstat-7.0.2-1.el5.i386.rpm
  • libaio-devel-0.3.106-3.2.i386.rpm
  • libXp-1.0.0-8.1.el5.i386.rpm

 

Once the CD/DVD has been inserted into the drive, the command shown below starts installation

Both x86 and 64bit versions of libXp need to be loaded on 64bit systems.

 

The “yum” tool on licensed versions of RHEL can be used to install any missing packages.

 

If using an unlicensed version if the (open source) yum package manager has been installed, required packages can be accessed by adding this repository

 

 

Various Settings

The commands below: Checks to see whether the default Linux firewall is active. If it is active we shut it down and stop it automatically starting upon system boot-up. (“systemctl” command should be used on RHEL 7)

 

 

To send the Oracle setup files from a Windows environment to a Linux system we can use the freely available WinSCP (www.winscp.net) utility.

 

In order to use WinSCP, the SSH service needs to be running and iptables needs to be configured to accept requests from TCP port 22. However an easier, and less safe way, to transfer the files would be to shutdown iptables as shown in the above syntax.

 

Alternatively, connect to the server using PuTTY or any other SSH client.

 

To connect as a root user, in the /etc/ssh/sshd_config directory.

 

Creating the groups that are required for Oracle:

 

First, create an Oracle user and change their password using oinstall

 

After entering the command, the dbms will prompt you to enter a password twice. (On a Unix system the passwords are masked.)

 

Enter the following values or change the current ones in the /etc/sysctl.conf file.

 

# Controls the maximum number of shared memory segments, in pages

The changes get activated by the command on line 15.

 

Enter the lines in the code show below into the /etc/security/limits.conf file.

There are 2 ways of doing this: By opening and manually changing the limits.conf file, alternatively by using the ‘cat’ syntax as a root user in the terminal.

 

Making directories to install Oracle

It is recommended that Oracle and Datafiles are kept in separate physical disks, in fact for optimal performance keep datafiles, archivelogs, redo logs in separate physical disks. If there aren’t enough physical disks available, prioritizing the storage of the index tablespace’s datafiles would increase performance.

The disk count and RAID architecture varies according to the volume of data and service life of the database.

 

In our example, the disk architecture and mountable directories are as shown in this diagram.

Installing Oracle 10G on Red Hat Enterprise Linux

 

Data Mount Point
OS /
Oracle /u01
Datafile /u01/app/oracle/ < The enclosed oradata directory
Index Datafile /u02 (creates the IndexData/SID_Name folders)

 

 

 

 

We configure the system after having added 8 disks, 2 x RAID 1 and 1 x RAID 10.

(As this is a test environment 2 x 5Gb disks have been used for RAID 1, a single 10Gb disk was used for RAID 10).

 

To check:

 

Once its clear that the disks have been recognized by the system; We create partitions and mount them on to the system & check to see if they have been mounted permanently by restarting.

m : « Loads the help menu

n : « Used to start a new partition

p : « Configures the new partition as a primary partition. Enter “1” as the partition number, “1” for the cylinder (it is “1” by default anyway). The default last cylinder value is the last cylinder number, just press Enter.

P : « Checks to see whether the operations have been successful.

w : « Once confirmed “w” or write saves the changes to disk.

 

 

 

To mount.

The previous commant mounts the disk, however we would need to run the same command whenever the system starts.

 

By configuring /etc/fstab as shown below, the system would automatically mount the disk upon boot up.

 

 

To check.

 

 

The -R option operates recursively on file systems. It allows ownership over the directories and files shown below.

The -p parameter creates the folder if there isn’t one.

 

The following lines should be entered into /home/oracle/.bash_profile to automatically enter Oracle directory paths and user environment variables.

 

The previous syntax activates the environment variables. Logging in as an Oracle user validates the settings.

Change paths to the directory that contains the installation files and open the zipped file.

 

As required by the type of archive containing the source code:

 

Logging off as the root user and the logging back on as an Oracle user.

 

This example describes the steps in making a database. The recommended sequence of installation would first be to install Oracle, followed by its patches and creating the database last.

(The options circled in red in the images below, would only setup Oracle DBMS. The database itself could be created afterwards.)

 

Installing Oracle 10G on Red Hat Enterprise Linux

Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux

 

In this example we have created the database during the installation process, however it is recommended that creating the database is left until the final stage.

 

Assuming that only the application was installed, we can continue by first creating a Listener. The netca command loads the “network configuration assistant”.

 

Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux

 

At this stage the Listener is running.

 

Entering the dbca command loads the Database Configuration Assistant, that creates the database. (Alternatively the database can be created using the command prompt, for further details please read the creating a database manually article.)

 

Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux  Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux Installing Oracle 10G on Red Hat Enterprise Linux  Installing Oracle 10G on Red Hat Enterprise Linux