Oracle DBA Tips Corner
Return to the Oracle DBA Tips Corner.
|
Oracle DBA Tips Corner
|
Installing Oracle Database 10g Release 2 on Linux - (RHEL 5)
by Jeff Hunter, Sr. Database Administrator
Contents
Overview
Please keep in mind
that this article should not be considered
a substitution for completely reading and understanding the official
installation guide and release notes from Oracle. The following links can be used to
download the official installation guides for Oracle10g Release 2 (10.2.0):
Hardware Overview
The Pentium 4 server is configured as follows:
After discussing the hardware being utilized for this article, I end this
section by describing how each of the disks will be used
for the database software installation and database:
Install the Linux Operating System
Downloading CentOS
After downloading and burning the CentOS images (ISO files) to CD,
insert CentOS Disk #1 into the database server (vmlinux1 in this example), power it on,
and answer the installation screen prompts as noted below.
Boot Screen
Note: When the installer detects
multiple initialized drives, it will check all of them to be used for the
Linux installation. For this installation, I only want to install the Linux
software on the first hard disk (/dev/sda) so I will keep it selected (checked).
Uncheck all other drives that the installer selected which for my installation was
/dev/sdb and /dev/sdc. I will manually partition and create a file system
for /dev/sdb and /dev/sdc later in this article.
Click [Next] to continue.
You will then be prompted with a
dialog window asking if you really want to remove all partitions. Click
[Yes] to acknowledge this warning.
For most automatic layouts, the
installer will choose 100MB for /boot, double the amount of RAM (systems with < 2GB RAM)
or an amount equal to RAM (systems with > 2GB RAM) for swap, and the rest going to the
root (/) partition. Starting with EL 4, the installer
will create the same disk configuration as just noted but will create
them using the Logical Volume Manager (LVM). For example, it will
partition the first hard drive (/dev/sda for my configuration) into two
partitions — one for the /boot partition (/dev/sda1) and the
remainder of the disk dedicate to a LVM named VolGroup00 (/dev/sda2).
The LVM Volume Group (VolGroup00) is then partitioned into two LVM
partitions - one for the root filesystem (/) and another for swap.
The main concern during
the partitioning phase is to ensure enough swap space is allocated as
required by Oracle (which is a multiple of the available RAM).
The following is Oracle's requirement for swap space:
For the purpose of this install, I will accept
all automatically preferred sizes. (Including 2GB for swap since I have
2GB of RAM installed.)
If for any reason, the automatic layout does not
configure an adequate amount of swap space, you can easily change that from this screen.
To increase the size of the swap partition, [Edit] the volume group VolGroup00.
This will bring up the "Edit LVM Volume Group: VolGroup00" dialog.
First, [Edit] and decrease the size of the root file system (/) by the amount you
want to add to the swap partition. For example, to add another 512MB to swap, you would
decrease the size of the root file system by 512MB (i.e. 36,032MB - 512MB = 35,520MB).
Now add the space you decreased from the root file system (512MB) to the swap
partition. When completed, click [OK] on the "Edit LVM Volume Group: VolGroup00"
dialog.
Finally, verify that no partitions or file systems exist for /dev/sdb and /dev/sdc.
If any do exist, click on the partition and [Delete] it so that the entire
disk has a single free entry with all "Free space" available. When all complete, the
only partitions that should be created are the two partitions on the first SCSI disk
(/dev/sda1 and /dev/sda2) described earlier in this section.
Once you are satisfied with the disk layout, click [Next] to continue.
First, make sure that the network device is checked
to [Active on boot].
(This should already be checked by the installer.)
Second, [Edit] eth0 as follows. Verify that the option "Enable IPv4 support"
is selected. Click off the option for "Use dynamic IP configuration (DHCP)"
and configure a static IP address and Netmask for your environment.
Click off the option to "Enable IPv6 support".
You may choose to use a different IP address for eth0 that I have documented
in this guide and that is OK. Ensure eth0 is configured for your public network:
eth0:
Continue by manually setting your hostname. I used
"vmlinux1" for the node.
Finish this dialog off by supplying your gateway and
DNS servers.
This is where you pick the packages to install. Most of the
packages required for the Oracle software are grouped into "Package Groups" (i.e. Application -> Editors).
Since this node will be hosting the Oracle Database software,
verify that at least the following package groups are selected for install. Note that for many of the
Linux package groups, not all of the packages associated with that group get selected
for installation. (Note the "Optional packages" button after selecting a package group.)
So although the package group gets selected for install, some of
the packages required by Oracle do not get installed. In fact, there are some packages
that are required by Oracle that do not belong to any of the available package groups
(i.e. libaio-devel).
Not to worry. A complete list of required packages for Oracle Database 10g will be provided at the end of
this section. These packages will need to be manually installed from the CentOS CDs after the operating system
install. For now, install the following package groups:
In addition to the above packages, select any
additional packages you wish to install for this node. After selecting the
packages to install click [Next] to continue.
You will be prompted with a warning dialog about not setting the firewall.
When this occurs, click [Yes] to continue.
You will be prompted with a warning dialog warning that changing the SELinux setting
will require rebooting the system so the entire file system can be relabeled.
When this occurs, click [Yes] to acknowledge a reboot of the system will occur after
firstboot (Post Installation Wizard) is completed.
If you chose not to define any additional operating system
user accounts, click [Continue] to acknowledge the warning dialog.
Install Required Linux Packages for Oracle
Although many of the required packages for Oracle were
installed during the
CentOS installation,
several will be missing either because they were considered optional within the package group
or simply didn't exist in any package group!
The packages listed in this section (or later versions) are required for
Oracle Database 10g Release 2 running on the x86 (32-bit) CentOS 5.1 platform.
Each of the packages listed above can be found on
CD #1, CD #2, or CD #3 on the CentOS 5.1 CDs. While it is possible to query each
individual package to determine which ones are missing and need to be installed, an
easier method is to run the
rpm -Uvh PackageName command from the
three CDs as follows. For packages that already exist and are up to date,
the RPM command will simply ignore the install and print a warning message to the console that
the package is already installed.
Disk Configuration
Before using the second and third SCSI hard disk, we need to first
partition the disks and then create a file system (ext3) on them.
After partitioning and creating the file system, each of the disks will
need to be mounted.
The Linux operating system was installed on the first disk /dev/sda.
The second hard disk (/dev/sdb) will be used to store the
Oracle Database 10g Software and mounted to the directory /u01.
The third internal SCSI disk (/dev/sdc) will be used to store the
physical database files and mounted to the directory /u02.
In a production environment, these directories would be created on a separate file system.
The following steps require use of the root user account:
Operating System Configuration
Login as root
To check the amount of memory you have installed, type:
(An inadequate amount of swap during the installation
will cause the Oracle Universal Installer
to either "hang" or "die")
To check the amount of memory you have, type:
To check the amount of swap you have allocated, type:
As root, make a file that will act as additional swap space, let's say about 500MB:
Now we should change the file permissions:
Finally we format the "partition" as swap and add it to the swap space:
To check the amount of free disk available in the /tmp directory, type:
The kernel parameters and shell limits presented in this section
are recommended values only as documented by Oracle. For production database
systems, Oracle recommends that you tune these values to optimize the performance
of the system.
Verify that the kernel parameters shown in this
section are set to values greater than or equal to the recommended values. Also note
that when setting the four semaphore values that all four values need to be
entered on one line.
Shared Memory
Oracle makes use of shared memory for its Shared Global Area (SGA) which is an area of
memory that is shared by all Oracle backup and foreground processes. Adequate sizing of
the SGA is critical to Oracle performance since it is responsible for holding the database
buffer cache, shared SQL, access paths, and so much more.
To determine all current shared memory limits, use the following:
The following list describes the kernel parameters that can be used to
change the shared memory configuration for the server:
You can determine the value of shmmax by performing the following:
You can determine the value of shmmni by performing
the following:
ceil(SHMMAX/PAGE_SIZE)
You can determine the value of shmall by performing
the following:
You can determine the value of shmmin by performing
the following:
To determine all current semaphore limits, use the following:
The following list describes the kernel parameters that can be used to
change the semaphore configuration for the server:
Use the following command to determine the maximum number of file handles
for the entire system:
Oracle recommends that the file handles for the entire system be set to at least 65536.
The default value for ip_local_port_range is ports 32768 through 61000
which is inadequate for a successful Oracle configuration.
Use the following command to determine the value of ip_local_port_range:
Oracle strongly suggests to adjust the default and maximum receive buffer size
(SO_RCVBUF socket option) to 1MB and the default and maximum send
buffer size (SO_SNDBUF socket option) to 256KB.
The receive buffers are used by TCP and UDP to hold received data until it
is read by the application. The receive buffer cannot overflow because the
peer is not allowed to send data beyond the buffer size window. This means that
datagrams will be discarded if they don't fit in the socket receive buffer,
potentially causing the sender to overwhelm the receiver.
Use the following commands to determine the current buffer size (in bytes) of each of
the IPC networking parameters:
Please note that prior to adding the following kernel parameter
values to /etc/sysctl.conf, I removed the two shared memory
kernel parameters (kernel.shmmax and kernel.shmall)
put in by CentOS 5.
After adding the above lines to the /etc/sysctl.conf file, they persist each
time the system reboots. If you would like to make these kernel parameter value changes to the
current system without having to first reboot, enter the following command:
To make these changes, run the following as root:
Network Configuration
Note that the Oracle database server should have a static IP address configured for the
public network (eth0 for this article). Do not use DHCP naming for the
public IP address; you need a static IP address!
Confirm the Node Name is Not Listed in Loopback Address
Create "oracle" User and Directories
Note that members of the UNIX group oinstall are considered the "owners" of
the Oracle software.
Members of the dba group can administer Oracle databases, for example starting up and shutting
down databases. In this article, we are creating the oracle user account to have both
responsibilities!
The UNIX group oinstall is used
by organizations that have separate teams responsible for maintaining the Oracle software
and the database(s). In situations like this, the group membership prevents unauthorized
access to the database by personal who only maintain the Oracle software. At the same
time, it also prevents database administrators from making modifications to the
database software and the installation's Inventory directory.
The Oracle documentation uses the following definitions when describing the UNIX groups:
If you intend to use the oinstall group during the installation process, then you
must set the default group to the one that will be maintaining the database before
creating the database or permission problems will arise. In this article, we will be taking care of
this issue when we install the database software.
The thing to keep in mind is that the UNIX oinstall group is completely optional and is not required
if the same individuals will be maintaining the software and the database. Some consider it
unnecessary work which adds another layer of complexity
to the maintenance of the installation. In this type of scenario, all that would be required is
the UNIX group dba (and assigning dba as the primary UNIX group for the
"oracle" user account).
This article (along with other Oracle installation guides on this site)
adhere to the Optimal Flexible Architecture (OFA) and create both the
oinstall and dba UNIX groups.
After the directory is created, you must then specify the correct
owner, group, and permissions for it.
At the end of this procedure, you will have the following:
Login to the database server as the oracle user account:
Download the Oracle Database 10g Release 2 Software
Oracle offers a development and testing license free of charge. No support, however,
is provided and the license does not permit production use.
A full description of the license agreement is available on OTN.
In this section, we will be downloading and extracting the required software from Oracle
to the database server. Login to the database server as the
"oracle" user account.
In this article, I will be downloading the required Oracle software to vmlinux1 and
saving it to "~oracle/orainstall".
Oracle Database 10g Release 2 (10.2.0.1.0) for Linux x86
As the "oracle" user account, extract the two packages you downloaded to
a temporary directory. In this example, I will use "~oracle/orainstall".
Extract the Oracle Database 10g Software:
Extract the Oracle Database 10g Companion CD Software:
Pre-Installation Tasks
Modify the Red Hat Release File
Install the Oracle Database 10g Release 2 Software
X Windows Server Requirements
Before starting the Oracle Universal Installer, you should first verify
you are logged onto the server you will be running the installer from
(i.e. vmlinux1) then run the xhost + command as
root from the console to allow X Server connections.
Next, login as the oracle user account.
If you are using a remote client to connect to the node performing the
installation (SSH or Telnet to vmlinux1 from a workstation configured with
an X Server), you will need to set the DISPLAY variable to point to your
local workstation:
For my installation, all checks passed with no problems.
It is possible to receive an error about the available swap space not meeting its minimum requirements:
Checking available swap space requirements...
In most cases, you will have the minimum required swap space (as shown above) and this can be safely ignored.
Simply click the check-box for "Checking available swap space requirements..." and
click Next to continue.
Database Administrator (OSDBA) Group: dba
Remember that we will create the database
as a separate step using DBCA.
Navigate to the /u01/app/oracle/oraInventory directory
and run orainstRoot.sh.
NOTE: After executing the orainstRoot.sh
script, verify the permissions of the file "/etc/oraInst.loc" are 644 (-rw-r--r--)
and owned by root:root. Problems can occur during the installation
of Oracle if the oracle user account does not have read permissions to this file -
(the location of the oraInventory directory cannot be determined).
If the permissions to
/etc/oraInst.loc are not set correctly, it is possible you didn't run orainstRoot.sh
before running root.sh. Also, the umask setting may be off - it should be
0022.
Navigate to the /u01/app/oracle/product/10.2.0/db_1 directory
and run root.sh accepting all default values.
After running the root.sh script go back to the OUI and acknowledge
the "Execute Configuration scripts" dialog window.
The last screen of a successful Oracle Database 10g Release 2 installation
is the "End of Installation" screen. The OUI provides you with several URLs that will be
activated by the OUI:
Install the Oracle Database 10g Companion CD Release 2 Software
Please keep in mind that this is an optional step. For the purpose of this article,
my testing database will often make use of the
Java Virtual Machine (Java VM) and Oracle interMedia and therefore will require
the installation of the Oracle Database 10g Companion CD. The type of
installation to perform will be the Oracle Database 10g Products installation type.
This installation type includes the Natively Compiled Java Libraries (NCOMP) files to
improve Java performance. If you do not install the NCOMP files,
the "ORA-29558:JAccelerator (NCOMP) not installed" error occurs when a database
that uses Java VM is upgraded to the patch release.
Login as the oracle User Account and Set DISPLAY (if necessary)
Click Next to continue.
The last screen of a successful Oracle Database 10g Companion CD Release 2 installation
is the "End of Installation" screen. The OUI provides you with several URLs that will be
activated by the OUI:
Apply the 10.2.0.3 Database Patchset
Downloading the Patchset
After logging in to the Oracle Metalink website,
click on the "Patches & Updates" tab on the top menu and use the following
to download the correct database patchset:
Navigate to the /u01/app/oracle/product/10.2.0/db_1 directory
and run root.sh accepting all default values.
After running the root.sh script go back to the OUI and acknowledge
the "Execute Configuration scripts" dialog window.
The Oracle Database 10g Release 2 Patch Set 2 has now been successfully applied!
This article is a comprehensive guide for installing
Oracle Database 10g Release 2 on the Red Hat Enterprise Linux 5 (RHEL5) operating environment.
Here is a short introduction to some of the configuration parameters that will
be used for installing the Oracle Database Software and creating a fully functional Oracle10g database:
Oracle Database Installation Guide 10g Release 2 (10.2) for Linux x86 - (B15660-02)
Oracle Database Quick Installation Guide 10g Release 2 (10.2) for Linux x86 - (B28052-01)
By the time you finish this article, the following will be
installed and configured:
The following is a list of items NOT covered in this article:
Although this article is titled and introduced to work with Red Hat Enterprise Linux 5.1, I will
actually be using a Red Hat Linux clone named CentOS. To read more about about
CentOS, please visit their website at
www.centos.org. I will also provide additional
details about CentOS along with installation instructions later in this article.
For the purpose of this document, I will be utilizing a Pentium 4 (32-bit Clone) running CentOS Release 5.1.
The Pentium 4 server will consist of three 36GB internal disks and 1GB of RAM. The first hard disk
(/dev/sda) will be used to store the Linux operating system while the second hard disk
(/dev/sdb) will be used to store the Oracle Database software.
Finally, the third hard disk (/dev/sdc) will be used for all physical database files
(data files, control files, online redo log files, flash recovery area)
Oracle Database Server
Machine Name:
vmlinux1.idevelopment.info
IP Address:
192.168.1.111
Processor:
Pentium 4 - (1.8 GHz.)
Operation Environment:
CentOS Release 5.1 - (32-bit)
Memory:
1 GB
Network:
Intel 10/100/1000Mbps PCI Desktop Adapter - (PWLA8391GT)
Internal Disks:
3 x 36GB SCSI hard drives identified as follows:
Software and Database Storage
Device
Type
Size - (GB)
Usage
Mount Point
/dev/sda
Internal
36
CentOS Release 5.1 Operating System
/
/dev/sdb
Internal
36
Oracle Database 10g Software.
/u01
/dev/sdc
Internal
36
Physical Database and Backup Files.
/u02
This section provides a summary of the screens used to install
the Linux operating system. As already mentioned,
this article will use CentOS 5.1.
Although I have used Red Hat Fedora and Red Hat Enterprise Linux in the past, I wanted to switch
to a Linux environment that would guarantee all of the functionality
contained with Oracle. This is where CentOS comes in.
The CentOS Project takes the Red Hat Enterprise Linux 5 source RPMs, and compiles
them into a free clone of the Red Hat Enterprise Server 5 product. This provides
a free and stable version of the Red Hat Enterprise Linux 5 (AS/ES) operating environment that
I can now use for
testing different Oracle configurations. I have moved away from Fedora as I need a
stable environment that is not only
free, but as close to the actual Oracle supported operating system as possible.
While CentOS is not the only project performing the same functionality, I
tend to stick with it as it is stable and reacts fast with regards to updates by Red Hat.
Use the links (below) to download CentOS 5.1. After
downloading CentOS, you will then want to burn each of the ISO images
to CD.
If you are downloading the above ISO files to a MS Windows machine,
there are many options for burning these images (ISO files) to a CD. You
may already be familiar with and have the proper software
to burn images to CD. If you are not familiar with this process
and do not have the required software to burn images to CD, here are just
two (of many) software packages that can be used:
Installing CentOS
This section provides a summary of the screens used to install
CentOS. For more detailed installation instructions, it
is possible to use the manuals from Red Hat Linux
http://www.redhat.com/docs/manuals/.
I would suggest, however, that the instructions I have provided
below be used for this Oracle 10g configuration.
The first screen is the CentOS boot screen.
At the boot: prompt, hit [Enter] to start the installation process.
Media Test
When asked to test the CD media, tab over to [Skip] and hit
[Enter]. If there
were any errors, the media burning software would have warned us. After several
seconds, the installer should then detect the video card, monitor, and mouse.
The installer then goes into GUI mode.
Welcome to CentOS
At the welcome screen, click [Next] to continue.
Language / Keyboard Selection
The next two screens prompt you for the Language and Keyboard
settings. Make the appropriate selection for your configuration
and click [Next] to continue.
Detect Previous Installation
Note that if the installer detects a previous version of CentOS,
it will ask if you would like to "Install CentOS" or "Upgrade an
existing Installation". Always select to "Install CentOS".
Disk Partitioning Setup
If prompted to initialize any of the drives (i.e. the partition
table on device /dev/sdX was unreadable), click [Yes] to
acknowledge the warning.
Keep the default selection to
[Remove linux partitions on selected drives and create default layout]
and check the option to [Review and modify partitioning layout].
Partitioning
The installer will then allow you to view (and modify if needed) the
disk partitions it automatically selected.
Boot Loader Configuration
Available RAM
Swap Space Required
Between 1 GB and 2 GB
1.5 times the size of RAM
Between 2 GB and 8 GB
Equal to the size of RAM
More than 8 GB
.75 times the size of RAM
The installer will use the GRUB boot loader by default.
To use the GRUB boot loader, accept all default values and click [Next] to continue.
Network Configuration
Before starting the Linux installation, I verified the NIC interface (card)
was installed. This screen
should have successfully detected the network device. Since we
will be using this machine to host an Oracle database, there will
be several changes that need to be made to the network configuration.
The settings you make here will, of course, depend on your network
configuration. The key point to make is that the machine should never be
configured with DHCP since it will be used to host the Oracle database
server. You will need to configure the machine with a static IP address.
You will also need to configure the server with a real host name.
Time Zone Selection
- Check ON the option to [Enable IPv4 support]
- Check OFF the option to [Use dynamic IP configuration (DHCP)] - (select Manual configuration)
IPv4 Address: 192.168.1.111
Prefix (Netmask): 255.255.255.0
- Check OFF the option to [Enable IPv6 support]
Select the appropriate time zone for your environment and click [Next] to continue.
Set Root Password
Select a root password and click [Next] to continue.
Package Installation Defaults
By default, CentOS installs most of the software required
for a typical server. There are several other packages (RPMs), however, that
are required to successfully install the Oracle Database software.
For the purpose of this article, select the radio button [Customize now]
and click [Next] to continue.
About to Install
This screen is basically a confirmation screen. Click [Continue] to start
the installation. During the installation process, you will be asked to
switch CDs depending on which packages you selected to install.
Congratulations
And that's it. You have successfully installed CentOS
on the database server. The installer will eject the CD from the
CD-ROM drive. Take out the CD and click [Reboot] to reboot the system.
Post Installation Wizard Welcome Screen
When the system boots into CentOS for
the first time, it will prompt you with another Welcome screen for the
"Post Installation Wizard". The
post installation wizard allows you to make final O/S configuration
settings. On the "Welcome" screen, click [Forward] to continue.
Firewall
On this screen, make sure to select the [Disabled] option and click [Forward] to continue.
SELinux
On the SELinux screen, choose the [Disabled] option if you plan to use
the Oracle Cluster File System (OCFS2). For Oracle installations, I typically opt
to disable SELinux. Click [Forward] to continue.
Kdump
Accept the default setting on the Kdump screen (disabled) and click [Forward] to continue.
Date and Time Settings
Adjust the date and time settings if necessary and click [Forward] to continue.
Create User
Create any additional (non-oracle) operating system user accounts if desired and click [Forward] to
continue. For the purpose of this article, I will not be creating any additional
operating system accounts. I will be creating the "oracle" user account during the
Oracle database installation later in this guide.
Sound Card
This screen will only appear if the wizard detects a sound card.
On the sound card screen click [Forward] to continue.
Additional CDs
On the "Additional CDs" screen click [Finish] to continue.
Reboot System
Given I changed the SELinux option (to disabled), I am prompted to
reboot the system. Click [OK] to reboot the system for normal use.
Login Screen
After rebooting the machine, you are presented with the login screen.
Login using the "root" user account and the password you provided during the
installation.
After installing CentOS, the next step is
to verify and install all packages (RPMs) required by Oracle Database 10g.
The Oracle Universal Installer (OUI) performs checks on your
machine during installation to verify that it meets the appropriate operating system package
requirements. To ensure that these checks complete successfully, verify the
software requirements documented in this section before starting the Oracle installs.
# From CentOS 5.1 - [CD #1]
mkdir -p /media/cdrom
mount -r /dev/cdrom /media/cdrom
cd /media/cdrom/CentOS
rpm -Uvh binutils-2.*
rpm -Uvh glibc-2*
rpm -Uvh glibc-common-2.*
rpm -Uvh libaio-0*
rpm -Uvh libgcc-4.*
rpm -Uvh libstdc++-4.*
rpm -Uvh make-3*
rpm -Uvh setarch-2*
cd /
eject
# From CentOS 5.1 - [CD #2]
mount -r /dev/cdrom /media/cdrom
cd /media/cdrom/CentOS
rpm -Uvh glibc-devel-2.*
rpm -Uvh gcc-4*
rpm -Uvh gcc-c++-4.*
rpm -Uvh libstdc++-devel-4.*
cd /
eject
# From CentOS 5.1 - [CD #3]
mount -r /dev/cdrom /media/cdrom
cd /media/cdrom/CentOS
rpm -Uvh compat-db-4*
rpm -Uvh compat-gcc-34-3*
rpm -Uvh compat-gcc-34-c++-3*
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh libaio-devel-0.*
rpm -Uvh libXp-1*
rpm -Uvh openmotif-2*
rpm -Uvh sysstat-7.*
cd /
eject
As noted in the section "Hardware Overview",
I discussed the disks that will be used for the Linux operating system, the
Oracle Database 10g Software installation, and the physical database files.
This section discusses the steps required to partition (and mount)
the two internal SCSI hard drives to be used by the Oracle software and database files.
The steps in this section are completely optional as it is possible
to simply create the directories required for installing the
Oracle Database 10g software and database files
off of the root directory (i.e. mkdir /u01 /u02).
For the sake of simplicity, this is often done in test environments but however
is not recommended as a general practice.
# [ LOGIN AS ROOT ]
# su -
# [ CREATE SINGLE PARTITION ON SECOND INTERNAL SCSI HARD DISK ]
# fdisk /dev/sdb
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-4699, default 1): 1
Last cylinder or +size or +sizeM or +sizeK (1-4699, default 4699): 4699
Command (m for help): p
Disk /dev/sdb: 38.6 GB, 38654705664 bytes
255 heads, 63 sectors/track, 4699 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 4699 37744686 83 Linux
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
# [ CREATE SINGLE PARTITION ON THIRD INTERNAL SCSI HARD DISK ]
# fdisk /dev/sdc
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-4699, default 1): 1
Last cylinder or +size or +sizeM or +sizeK (1-4699, default 4699): 4699
Command (m for help): p
Disk /dev/sdc: 38.6 GB, 38654705664 bytes
255 heads, 63 sectors/track, 4699 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdc1 1 4699 37744686 83 Linux
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
# [ CREATE NEW EXT3 FILE SYSTEM ON SECOND INTERNAL SCSI HARD DISK ]
# mkfs.ext3 -b 4096 /dev/sdb1
mke2fs 1.39 (29-May-2006)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
4718592 inodes, 9436171 blocks
471808 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=0
288 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000, 7962624
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done
This filesystem will be automatically checked every 38 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.
# [ CREATE NEW EXT3 FILE SYSTEM ON THIRD INTERNAL SCSI HARD DISK ]
# mkfs.ext3 -b 4096 /dev/sdc1
mke2fs 1.39 (29-May-2006)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
4718592 inodes, 9436171 blocks
471808 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=0
288 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000, 7962624
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done
This filesystem will be automatically checked every 35 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.
# [ CREATE MOUNT POINT DIRECTORIES ]
# mkdir /u01
# mkdir /u02
# [ INSERT THE FOLLOWING ENTRIES INTO /etc/vfstab ]
# echo "/dev/sdb1 /u01 ext3 defaults 1 1" >> /etc/fstab
# echo "/dev/sdc1 /u02 ext3 defaults 1 1" >> /etc/fstab
# [ MOUNT THE NEW FILE SYSTEMS ]
# mount /u01
# mount /u02
# [ CHECK FOR NEW FILE SYSTEMS ]
# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
34470656 2787292 29904064 9% /
/dev/sda1 101086 11784 84083 13% /boot
tmpfs 517660 0 517660 0% /dev/shm
/dev/sdb1 37152364 180240 35084892 1% /u01
/dev/sdc1 37152364 180240 35084892 1% /u02
This section describes hardware/software requirements and
the steps that should be performed
by the DBA as it relates to the Linux operating
system before performing the Oracle Database 10g software installation.
The following steps need to be performed as the root user account.
% su -
RAM Memory
Installing Oracle Database 10g on Linux requires a minimum of 512MB of memory.
I highly recommend installing at least 1GB of memory when
running Oracle 10g. Although 512MB will work, it is extremely tight.
# cat /proc/meminfo | grep MemTotal
MemTotal: 1035324 kB
Swap Space
The following is Oracle's requirement for swap space:
Available RAM
Swap Space Required
Between 1 GB and 2 GB
1.5 times the size of RAM
Between 2 GB and 8 GB
Equal to the size of RAM
More than 8 GB
.75 times the size of RAM
# cat /proc/meminfo | grep MemTotal
MemTotal: 1035324 kB
# cat /proc/meminfo | grep SwapTotal
SwapTotal: 2031608 kB
If you have less than 1GB of memory (between your RAM and SWAP), you can add temporary
swap space by creating a temporary swap file.
This way you do not have to use a raw device or even more drastic, rebuild your system.
# dd if=/dev/zero of=tempswap bs=1k count=500000
# chmod 600 tempswap
# mke2fs tempswap
# mkswap tempswap
# swapon tempswap
Checking /tmp Directory
Ensure enough disk space in the /tmp directory. An amount
of disk space equal to 400 MB (or greater) needs to be available
for the Oracle Database installation.
# df -h /tmp
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
33G 2.7G 29G 9% /
If 1 GB or more is not available in /tmp, you can create
a "tmp" directory in another file system, then set the environment
variables TMP (used by Oracle) and TMPDIR (used by operating
system programs like the linker "ld" and library archiver
"ar") to point to this location. For example:
# mkdir /u01/app/oracle/tmp
# TEMP=/u01/app/oracle/tmp; export TEMP
# TMPDIR=/u01/app/oracle/tmp; export TMPDIR
Configuring Kernel Parameters
This section documents the checks and modifications to the Linux kernel
that should be made by the DBA to support Oracle Database 10g. Before
detailing these individual kernel parameters, it is important to fully understand
the key kernel components that are used to support the Oracle Database environment.
Shared memory allows processes to access common structures and data by placing
them in a shared memory segment. This is the fastest form of Inter-Process Communications
(IPC) available - mainly due to the fact that no kernel involvement occurs when data is
being passed between the processes. Data does not need to be copied between processes.
Semaphores
# ipcs -lm
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 4194303
max total shared memory (kbytes) = 1073741824
min seg size (bytes) = 1
ORA-27123: unable to attach to shared memory segment
# cat /proc/sys/kernel/shmmax
4294967295
For most Linux systems, the default
value for shmmax is 32MB. This size is often too small to configure
the Oracle SGA. The default value for shmmax
in CentOS 5 is 4GB which is more than enough for the Oracle configuration
described in this article. Note that this value of 4GB is not the "normal" default
value for shmmax in a Linux environment — CentOS 5 inserts
the following two entries in the file /etc/sysctl.conf:
# Controls the maximum shared segment size, in bytes
kernel.shmmax = 4294967295
# cat /proc/sys/kernel/shmmni
4096
# cat /proc/sys/kernel/shmall
268435456
For most Linux systems, the default value for shmall
is 2097152 and is adequate for most configurations.
The default value for shmall
in CentOS 5 is 268435456 (see above) which is more than enough for the Oracle configuration
described in this article. Note that this value
of 268435456 is not the "normal" default value for shmall
in a Linux environment — CentOS 5 inserts
the following two entries in the file /etc/sysctl.conf:
# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 268435456
# ipcs -lm | grep "min seg size"
min seg size (bytes) = 1
After the DBA has configured the shared memory settings, it is time to take
care of configuring the semaphores. The best way to describe a semaphore is as
a counter that is used to provide synchronization between processes (or threads within a process)
for shared resources like shared memory. Semaphore sets are supported in System V where each
one is a counting semaphore. When an application requests semaphores, it does so using "sets".
File Handles
# ipcs -ls
------ Semaphore Limits --------
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 32
semaphore max value = 32767
You can also use the following command:
# cat /proc/sys/kernel/sem
250 32000 32 128
SEMMNS -or- (SEMMSL * SEMMNI)
When configuring the Linux server, it is critical to ensure that the
maximum number of file handles is large enough. The setting for file
handles denotes the number of open files that you can have on the
Linux system.
IP Local Port Range
# cat /proc/sys/fs/file-max
102312
You can query the current usage of file handles by using the following:
# cat /proc/sys/fs/file-nr
3072 0 102312
The file-nr file displays three parameters:
If you need to increase the value in
/proc/sys/fs/file-max,
then make sure that the ulimit is set properly. Usually for Linux 2.4 and 2.6 it is set to
unlimited. Verify the ulimit setting my issuing the ulimit command:
# ulimit
unlimited
Oracle strongly recommends to set the
local port range ip_local_port_range for outgoing messages
to "1024 65000" which is needed for systems with high-usage. This kernel parameter
defines the local port range for TCP and UDP traffic to choose from.
Networking Settings
# cat /proc/sys/net/ipv4/ip_local_port_range
32768 61000
With Oracle 9.2.0.1 and later, Oracle makes use of UDP as the default protocol
on Linux for inter-process communication (IPC), such as Cache Fusion and Cluster
Manager buffer transfers between instances within the RAC cluster.
Oracle 10g Required Kernel Parameter Settings
# cat /proc/sys/net/core/rmem_default
109568
# cat /proc/sys/net/core/rmem_max
131071
# cat /proc/sys/net/core/wmem_default
109568
# cat /proc/sys/net/core/wmem_max
131071
Now let's review what has been covered thus far.
The Oracle Database 10g documentation defines the following parameters and limits
that should be validated before creating an Oracle database.
Setting Kernel Parameters for Oracle
Parameter
Recommended Value
Default Value
How to Check
shmmax
2147483648
33554432
cat /proc/sys/kernel/shmmax
shmmni
4096
4096
cat /proc/sys/kernel/shmmni
shmall
2097152
2097152
cat /proc/sys/kernel/shmall
shmmin
1
1
ipcs -lm | grep "min seg size"
semmsl
250
250
cat /proc/sys/kernel/sem | awk '{print $1}'
semmns
32000
32000
cat /proc/sys/kernel/sem | awk '{print $2}'
semopm
100
32
cat /proc/sys/kernel/sem | awk '{print $3}'
semmni
128
128
cat /proc/sys/kernel/sem | awk '{print $4}'
file-max
65536
102696
cat /proc/sys/fs/file-max
ip_local_port_range
1024 65000
32768 61000
cat /proc/sys/net/ipv4/ip_local_port_range
rmem_default
1048576
109568
cat /proc/sys/net/core/rmem_default
rmem_max
1048576
131071
cat /proc/sys/net/core/rmem_max
wmem_default
262144
109568
cat /proc/sys/net/core/wmem_default
wmem_max
262144
131071
cat /proc/sys/net/core/wmem_max
If the current value for any parameter is higher
than the value listed in this table, do not change the value
of that parameter.
If the value of any kernel parameter is different to the recommended
value, they will need to be modified. For this article, I identified and
provide the following values that will need to be added to the
/etc/sysctl.conf file which is used during the boot process.
# +---------------------------------------------------------+
# | KERNEL PARAMETERS FOR ORACLE 10g |
# +---------------------------------------------------------+
# | Configure the kernel parameters for all Oracle Linux |
# | servers by setting shared memory and semaphores, |
# | setting the maximum amount of file handles, setting the |
# | networking parameters, and finally setting the IP local |
# | port range. |
# +---------------------------------------------------------+
# +---------------------------------------------------------+
# | SHARED MEMORY |
# +---------------------------------------------------------+
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.shmall = 2097152
# +---------------------------------------------------------+
# | SEMAPHORES |
# | ---------- |
# | |
# | SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value |
# | |
# +---------------------------------------------------------+
kernel.sem = 250 32000 100 128
# +---------------------------------------------------------+
# | FILE HANDLES |
# ----------------------------------------------------------+
fs.file-max = 65536
# +---------------------------------------------------------+
# | LOCAL IP RANGE |
# ----------------------------------------------------------+
net.ipv4.ip_local_port_range = 1024 65000
# +---------------------------------------------------------+
# | NETWORKING |
# ----------------------------------------------------------+
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
# /sbin/sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
Review the output from the above command and verify that the values are
correct. If the values are not correct, edit the /etc/sysctl.conf to correct the values,
re-run the sysctl -p command and verify the values.
Configuring Shell Limits for the oracle User
To improve the performance of the software on Linux systems, Oracle recommends you increase the
following shell limits for the oracle user:
Shell Limit
Item in limits.conf
Hard Limit
Maximum number of open file descriptors
nofile
65536
Maximum number of processes available to a single user
nproc
16384
cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF
cat >> /etc/pam.d/login <<EOF
session required /lib/security/pam_limits.so
EOF
Update the default shell startup file for the "oracle" UNIX account.
cat >> /etc/profile <<EOF
if [ \$USER = "oracle" ]; then
if [ \$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
EOF
cat >> /etc/csh.login <<EOF
if ( \$USER == "oracle" ) then
limit maxproc 16384
limit descriptors 65536
endif
EOF
Check and Turn off UDP ICMP Rejections
During the Linux installation process, I indicated to
not configure the firewall option.
(By default the option to configure a firewall is selected by the installer.)
I like to do a double-check that the
firewall option is not configured and to ensure udp ICMP filtering is
turned off.
# /etc/rc.d/init.d/iptables status
Firewall is stopped.
# /etc/rc.d/init.d/iptables stop
Flushing firewall rules: [ OK ]
Setting chains to policy ACCEPT: filter [ OK ]
Unloading iptables modules: [ OK ]
# chkconfig iptables off
During the Linux operating system install we already configured the IP address and
host name for the database node.
We now need to configure the /etc/hosts file.
Ensure that the node name (vmlinux1) is
not included for the loopback address in the /etc/hosts file.
If the machine name is listed in the in the loopback address entry as below:
127.0.0.1 vmlinux1 localhost.localdomain localhost
it should be removed as shown below:
127.0.0.1 localhost.localdomain localhost
Remove IPv6 Entries
Remove any entry that has to do with IPv6
(for example, ::1 localhost6.localdomain6 localhost6).
Sample /etc/hosts File
The following is an example /etc/hosts file I used for this article:
Sample /etc/hosts File # Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
#
192.168.1.102 alex alex.idevelopment.info
192.168.1.105 bartman bartman.idevelopment.info
192.168.1.120 cartman cartman.idevelopment.info
192.168.1.106 melody melody.idevelopment.info
192.168.1.190 george george.idevelopment.info
#
192.168.1.1 router router.idevelopment.info
192.168.1.245 accesspoint accesspoint.idevelopment.info
#
# ------------- [ LINUX ] -------------------------------------
192.168.1.111 vmlinux1 vmlinux1.idevelopment.info
192.168.1.112 vmlinux2 vmlinux2.idevelopment.info
192.168.1.131 vmlinux3 vmlinux3.idevelopment.info
192.168.1.132 vmlinux4 vmlinux4.idevelopment.info
This section covers the steps required to create
the UNIX groups (oinstall, dba, and oper) and user (oracle) that will be used
to install the Oracle Database 10g software.
This guide adheres
to the Optimal Flexible Architecture (OFA) for naming conventions used
in creating the directory structure.
Create Group and User for Oracle
Lets start this section by creating the UNIX
oinstall and dba group
and oracle user account:
# groupadd -g 501 oinstall
# groupadd -g 502 dba
# groupadd -g 503 oper
# useradd -m -u 501 -g oinstall -G dba,oper -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle
# id oracle
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper)
Set the password for the oracle account:
# passwd oracle
Changing password for user oracle.
New UNIX password: xxxxxxxxxxx
Retype new UNIX password: xxxxxxxxxxx
passwd: all authentication tokens updated successfully.
Verify That the User nobody Exists
Before installing the Oracle software, complete the following procedure to verify that the user
nobody exists on the system:
# id nobody
uid=99(nobody) gid=99(nobody) groups=99(nobody)
If this command displays information about the nobody user, then you do not
have to create that user.
# /usr/sbin/useradd nobody
Create the Oracle Base Directory
The next step is to create a new directory that will be used to store
the Oracle Database software. When configuring the
oracle user's environment (later in this section) we will be assigning
the location of this directory to the $ORACLE_BASE environment variable.
# mkdir -p /u01/app/oracle
# chown -R oracle:oinstall /u01/app/oracle
# chmod -R 775 /u01/app/oracle
Create Directory for Database Files
Let's now create the directory that will be used to store the
Oracle database files and backup files (on the /u02 file system):
# mkdir -p /u02/oradata
# chown oracle:oinstall /u02/oradata
# chmod 775 /u02/oradata
# mkdir -p /u02/flash_recovery_area
# chown oracle:oinstall /u02/flash_recovery_area
# chmod 775 /u02/flash_recovery_area
Create Login Script for oracle User Account
To ensure that the environment is setup correctly for the "oracle" UNIX
user account, use the following .bash_profile:
# su - oracle
.bash_profile for Oracle User # .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
alias ls="ls -FA"
export JAVA_HOME=/usr/local/java
# User specific environment and startup programs
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_PATH=$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin
export ORACLE_SID=TESTDB
export PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
The next logical step is to install Oracle Database 10g Release 2 (10.2.0.1.0)
and optionally the Companion CD Release 2 (10.2.0.1.0) for Linux x86 software. However,
we must first download and extract the required Oracle software packages from the
Oracle Technology Network (OTN).
If you do not currently have an account with Oracle OTN, you
will need to create one. This is a FREE account!
Download the Oracle Database 10g Release 2 (10.2.0.1.0) Software for Linux x86.
Oracle Database 10g Release 2 (10.2.0.1.0)
Oracle Database 10g Companion CD Release 2 (10.2.0.1.0) for Linux x86
Next, download the Oracle Database 10g Companion CD for Linux x86.
This can be downloaded from the same page used to download the
Oracle Database software:
Oracle Database 10g Companion CD Release 2 (10.2.0.1.0)
# su - oracle
$ mkdir -p ~oracle/orainstall
$ cd ~oracle/orainstall
$ unzip 10201_database_linux32.zip
$ cd ~oracle/orainstall
$ unzip 10201_companion_linux32.zip
This section contains the mandatory tasks that need to be
completed before install the Oracle Database 10g
software.
One of the first checks performed by the Oracle Universal Installer (OUI)
is to determine if the host platform is supported. The OUI uses the
file /etc/redhat-release to determine the platform.
For the case of Red Hat Enterprise Linux,
Oracle Database 10g Release 2 expects either RHEL 3 or RHEL/OEL 4.
The OUI will immediately fail if it doesn't recognize either of these
two platforms:
$ /home/oracle/orainstall/database/runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version:
must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Failed <<<<
Exiting Oracle Universal Installer, log for this session can be found at
/tmp/OraInstall2008-01-08_06-06-36PM/installActions2008-01-08_06-06-36PM.log
The easiest way to get around this error is to modify the
/etc/redhat-release file replacing the current release
information (CentOS release 5 (Final)) with the following:
Before modifying /etc/redhat-release, make a backup copy
of the file and ensure to replace the original one after the
Oracle installation and patch process has been completed.
redhat-4
$ su -
# cp /etc/redhat-release /etc/redhat-release.original
# echo "redhat-4" > /etc/redhat-release
We are now ready to install the Oracle Database 10g Release 2 software. This section
will provide the steps necessary to configure the database server to successfully
run the Oracle Universal Installer (OUI).
For the purpose of this example, we will forgo
the "Create Database" option when installing the Oracle Database software. We will,
instead, create the database using the Database Configuration Assistant (DBCA) after
all of the software and patches have been installed.
Beginning with Oracle version 8i, the Oracle Universal Installer (OUI)
is a Java application and uses a JRE (Java runtime Environment) shipped on the media.
Other Java applications that utilize the JRE are the Database Configuration Assistant
and the Oracle Net Assistant. The JRE shipped by Oracle is the only one supported to run
with these applications. Installations can no longer be performed using character mode.
You must install the Oracle database software from an X windows workstation, an
X terminal, or a PC or other system with X server software installed.
# hostname
vmlinux1
# xhost +
access control disabled, clients can connect from any host
# su - oracle
$ # IF YOU ARE USING A REMOTE CLIENT TO CONNECT TO THE
$ # NODE PERFORMING THE INSTALL
$ DISPLAY=<your local workstation>:0.0
$ export DISPLAY
If you are using Hummingbird's Exceed X-Windows emulator while installing
and using Oracle10g, set the window manager to run in "Native"
mode so that Microsoft windows functions as the window manager. See your
Exceed documentation for instructions on configuring the window manager.
Install the Oracle Database 10g Release 2 Software
Install the Oracle Database 10g Release 2 software as follows:
$ cd ~oracle
$ /home/oracle/orainstall/database/runInstaller
Oracle Database 10g Software Installation Screen Responses
Screen Name
Response
Select Installation Method
Select the Advanced Method option and click
Next to start the installation process.
Specify Inventory directory
and credentials
Accept the default values:
Inventory directory: /u01/app/oracle/oraInventory
Operating System group name: oinstall
Select Installation Type
Select the type of installation to perform
(Enterprise Edition, Standard Edition, or Custom).
I selected the Custom option for this example
given I wanted to install Oracle Label Security and other components not
available with the Enterprise or Standard Edition installation option.
Specify Home Details
Set the Name and Path for the ORACLE_HOME as follows:
Name: OraDb10g_home1
Location: /u01/app/oracle/product/10.2.0/db_1
Available Product Components
If you selected the Custom installation type, the next screen
(Available Product Components)
allows you to select from all available components. Select the appropriate
components for your environment and click Next to continue.
Product-Specific
Prerequisite Checks
The installer will run through a series of checks to determine
if the node meets the minimum requirements for installing
and configuring the Oracle database software. If any of the
checks fail, you will need to manually verify the check that
failed by clicking on the checkbox.
Expected result: 3036MB
Actual Result: 1983MB
Privileged Operating
System Groups
Select the UNIX groups that will be used for
each of the Oracle group names as follows:
Database Operator (OSOPER) Group: oper
Create Database
Select the option to Install database Software only.
Summary
Click Install to start the installation!
Root Script Window - Run root.sh
After the installation has completed, you will be prompted to run the
orainstRoot.sh and root.sh script. Open a new console window as the
"root" user account.
End of installation
At the end of the installation, exit from the OUI.
The following J2EE Applications have been deployed and are accessible
at the URLs listed below.
iSQL*Plus URL:
http://vmlinux1:5560/isqlplus
iSQL*Plus DBA URL:
http://vmlinux1:5560/isqlplus/dba
After successfully installing the Oracle Database software, the next
step is to install the Oracle Database 10g Companion CD Release 2 software (10.2.0.1.0).
As discussed in the previous section, (Install Oracle Database 10g Software),
the terminal shell environment needs to run an X Windows application as
the "oracle" user account.
Note that you can utilize the same terminal shell session used in the previous section
which in this case, you do not have to take any of the actions described below
with regards to setting the DISPLAY variable:
# su - oracle
$ # IF YOU ARE USING A REMOTE CLIENT TO CONNECT TO THE
$ # NODE PERFORMING THE INSTALL
$ DISPLAY=<your local workstation>:0.0
$ export DISPLAY
Install Oracle10g Companion CD Software
Install the Oracle 10g Companion CD Software as follows:
$ cd ~oracle
$ /home/oracle/orainstall/companion/runInstaller
Oracle Database 10g Companion CD Installation Screen Responses
Screen Name
Response
Welcome Screen
Click Next
Select a Product to Install
Select the Oracle Database 10g Products 10.2.0.1.0 option.
Specify Home Details
Set the destination for the ORACLE_HOME Name and Path to that of the previous
Oracle10g Database software install as follows:
Name: OraDb10g_home1
Path: /u01/app/oracle/product/10.2.0/db_1
Product-Specific
Prerequisite Checks
The installer will run through a series of checks to determine
if the node meets the minimum requirements for installing
and configuring the Oracle10g Companion CD Software. If any of the
checks fail, you will need to manually verify the check that
failed by clicking on the checkbox. For my installation, all checks passed with no problems.
Summary
On the Summary screen, click Install to start the installation!
End of installation
At the end of the installation, exit from the OUI.
Ultra Search URL:
http://vmlinux1:5620/ultrasearch
Ultra Search Administration Tool URL:
http://vmlinux1:5620/ultrasearch/admin
It has been reported that for users who installed the 10g Apache server standalone
from the Companion CD on CentOS 5 (which is not discussed in this article), elicits
the following error from the configuration assistant:
libdb.so.2: cannot open shared object file
A workaround was posted on an
Oracle forum
and consists of the following tasks:
ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
chmod 755 /usr/lib/libgdbm.so.2.0.0
chmod 755 /usr/lib/libdb.so.2
At the time of this writing, the latest patchset
for Oracle Database 10g Release 2 running on Linux x86 (32-bit)
is 10.2.0.3 (also known as patch 5337014).
The Oracle 10.2.0.3 patchset will need to be downloaded from the
Oracle Metalink website
(http://metalink.oracle.com).
Access to Oracle Metalink requires a valid login and CSI number.
The file name of the patchset to download is p5337014_10203_LINUX.zip
(last updated 21-FEB-2007)
and is 900MB in size. This may take some time to download.
Extract the Patch File
As the oracle user account, extract the patch file to a temporary directory:
$ id -a
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper)
$ mkdir -p /home/oracle/orainstall/patches/database_10.2.0.3
$ mv p5337014_10203_LINUX.zip /home/oracle/orainstall/patches/database_10.2.0.3
$ cd /home/oracle/orainstall/patches/database_10.2.0.3
$ unzip p5337014_10203_LINUX.zip
Login as the oracle User Account and Set DISPLAY (if necessary)
As discussed in the previous section,
(Install the Oracle Database 10g Companion CD Release 2 Software),
the terminal shell environment needs to run an X Windows application as
the "oracle" user account.
Note that you can utilize the same terminal shell session used in the previous section
which in this case, you do not have to take any of the actions described below
with regards to setting the DISPLAY variable:
# su - oracle
$ # IF YOU ARE USING A REMOTE CLIENT TO CONNECT TO THE
$ # NODE PERFORMING THE INSTALL
$ DISPLAY=<your local workstation>:0.0
$ export DISPLAY
Stop All Oracle Processes
Before starting the OUI to install the patch set, we need to stop all listeners and other
processes running in the Oracle home directory. If you have been following the instructions
in this article, there should be no Oracle processes running:
$ ps -ef | grep ora
Applying the Patchset
Once all processes running in the Oracle home directory have been stopped, we can now
start the patch installation process. To do this, run the OUI installer
(runInstaller) out of the directory where you extracted the patch set to
as the oracle
UNIX user account:
$ id -a
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper)
$ cd ~oracle
$ /home/oracle/orainstall/patches/database_10.2.0.3/Disk1/runInstaller
Oracle 10.2.0.3 Patchset Installation Screen Responses
Screen Name
Response
Welcome Screen
Click Next
Specify Home Details
Set the destination for the ORACLE_HOME Name and Path to that of the previous
Oracle10g Database software install as follows:
Name: OraDb10g_home1
Path: /u01/app/oracle/product/10.2.0/db_1
Summary
On the Summary screen, click Install to start the installation!
Root Script Window - Run root.sh
After the patch installation has completed, you will be prompted to run the
root.sh script. Open a new console window as the
"root" user account.
End of installation
At the end of the installation, exit from the OUI.
Running changePerm.sh Script on an Oracle Database Server Home
During patch set installation, all new files and directories are created with restricted
access, by default. Users or third party applications with a different group identifier
from that of the database owner (dba and oper for example), which try
to access client-side utilities or libraries in the database home, will see permission
errors when trying to access these files or directories.
Perform the following steps to change the permissions so that groups other then just
the database owner (for this example, the database owner is oracle:oinstall)
can access client-side utilities and libraries.
$ cd $ORACLE_HOME/install
$ ./changePerm.sh
-------------------------------------------------------------------------------
Disclaimer: The purpose of this script is to relax permissions on some of the
files in the database Oracle Home so that all clients can access them.
Please note that Oracle Corporation recommends using the most restrictive file
permissions as possible for your given implementation. Running this script
should be done only after considering all security ramifications.
-------------------------------------------------------------------------------
Do you wish to continue (y/n) [n]: y
Finished running the script successfully
Please see /tmp/changePerm_err.log for errors and /tmp/changePerm.log for the log of events
