Nov 29, 2016 Home Oracle Database 11g Release 2 (11.2.0.4) RAC Installation On Solaris 10 Oracle Database 11g Release 2 (11.2.0.4) RAC Installation On Solaris 10 November 29, 2016 November 30, 2016 rizidba Uncategorized.
This article describes the installation of Oracle Database 11g Release 2 (11.2) (64-bit) on Oracle Linux 6 (64-bit). The article is based on a server installation with a minimum of 2G swap, with SELinux set to permissive and the firewall disabled. The following package groups were included for this installation.
Base System > Base
Base System > Client management tools
Base System > Compatibility libraries
Base System > Hardware monitoring utilities
Base System > Large Systems Performance
Base System > Network file system client
Base System > Performance Tools
Base System > Perl Support
Servers > Server Platform
Servers > System administration tools
Desktops > Desktop
Desktops > Desktop Platform
Desktops > Fonts
Desktops > General Purpose Desktop
Desktops > Graphical Administration Tools
Desktops > Input Methods
Desktops > X Window System
Development > Additional Development
Development > Development Tools
Applications > Internet Browser
An example of this type of Linux installations can be seen here. Alternative installations may require more packages to be loaded, in addition to the ones listed below.
Oracle Installation Prerequisites
Download Software
Download the Oracle software from OTN or MOS depending on your support status.
Unpack Files
Unzip the files.
You should now have a single directory called 'database' containing installation files.
Hosts File
The '/etc/hosts' file must contain a fully qualified name for the server.
For example.
Oracle Installation Prerequisites
Perform either the Automatic Setup or the Manual Setup to complete the basic prerequisites. The Additional Setup is required for all installations.
Automatic Setup
If you plan to use the 'oracle-rdbms-server-11gR2-preinstall' package to perform all your prerequisite setup, follow the instructions at http://public-yum.oracle.com to setup the yum repository for OL, then perform the following command.
All necessary prerequisites will be performed automatically.
It is probably worth doing a full update as well, but this is not strictly speaking necessary.
Manual Setup
If you have not used the 'oracle-rdbms-server-11gR2-preinstall' package to perform all prerequisites, you will need to manually perform the following setup tasks.
Oracle recommend the following minimum parameter settings.
The current values can be tested using the following command.
Add or amend the following lines in the '/etc/sysctl.conf' file.
Run the following command to change the current kernel parameters.
Add the following lines to the '/etc/security/limits.conf' file.
Install the following packages if they are not already present.
This will install all the necessary 32-bit packages for 11.2.0.1. From 11.2.0.2 onwards many of these are unnecessary, but having them present does not cause a problem.
Create the new groups and users.
We are not going to use the 'asm' groups, since this installation will not use ASM.
Additional Setup
Set the password for the 'oracle' user.
Amend the '/etc/security/limits.d/90-nproc.conf' file as described below. See MOS Note [ID 1487773.1]
Set secure Linux to permissive by editing the '/etc/selinux/config' file, making sure the SELINUX flag is set as follows.
Once the change is complete, restart the server.
If you have the Linux firewall enabled, you will need to disable or configure it, as shown here or here.
Create the directories in which the Oracle software will be installed.
Login as root and issue the following command.
Login as the oracle user and add the following lines at the end of the '.bash_profile' file.
Installation
Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.
Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.
Proceed with the installation of your choice. The prerequisites checks will fail for the following version-dependent reasons:
11.2.0.1: The installer shows multiple 'missing package' failures because it does not recognize several of the newer version packages that were installed. These 'missing package' failures can be ignored as the packages are present. The failure for the 'pdksh' package can be ignored because we installed the 'ksh' package in its place.
11.2.0.2: The installer should only show a single 'missing package' failure for the 'pdksh' package. It can be ignored because we installed the 'ksh' package in its place.
11.2.0.3: The installer shows no failures and continues normally.
You can see the type of installation I performed by clicking on the links below to see screen shots of each stage.
If you are doing an installation for an Enterprise Manager repository, remember to do an advanced installation and pick the ALT32UTF8 character set.
Post Installation
Edit the '/etc/oratab' file setting the restart flag for each instance to 'Y'.
Common Errors
'error code 35' : The machine name in the '/etc/hosts' file is not correct. It needs an entry for the loopback adapter (localhost) and the machine name. If you are using DNS for name resolution, you still need the loopback adapter reference in this file.
'error code 37' : The DNS not working properly. You may also get this error is the '/etc/hosts' file is not configured correctly.
'sqlplus: error while loading shared libraries: libclntsh.so.11.1' : The prerequisites have not been met. Work through them again. Specifically, make sure the 'gcc' package has been installed.
Listener fails to start - Typically this is due to incorrect name resolution. Make sure the '/etc/hosts' and/or DNS is configured correctly.
Linking errors - Almost always due to missing prerequisites. Review the setup sections.