Linux 4 All: Installing Oracle Database 11g on Linux

Purpose

In this tutorial, you learn how to install Oracle Database 11g on Linux.

Note: This OBE was tested on production software however some of the screenshots may still refer to the beta software.

Using the Oracle Universal Installer, you install the Oracle Database 11g software and create a database.

Installing Oracle Database 11g on Linux

Set Kernel Parameters.

Edit /etc/sysctl.conf file to add these kernel parameters.The file should reflect this value

fs.aio-max-nr = 1048576  

fs.file-max = 6815744  

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128  

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default=262144  

net.core.rmem_max=4194304  

net.core.wmem_default=262144

net.core.wmem_max=104858

Execute the following command to update the parameters

# /sbin/sysctl -p

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

oracle      soft         nproc     2047  

oracle      hard        nproc     16384

oracle      soft         nofile     1024

oracle      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

For Fedora 13

Edit /etc/redhat-release file as follows:

redhat release 5

 

Some additional packages are required for succesful installation of Oracle software. To check whether required packages are installed on your operating system use following command:

rpm  -q binutils elfutils elfutils-libelf gcc gcc-c++ glibc glibc-common  glibc-devel compat-libstdc++-33 cpp make compat-db sysstat libaio  libaio-devel unixODBC unixODBC-devel| ksh sysstat make

Create new groups and users:

groupadd oinstall

groupadd dba

groupadd oper

groupadd asmadmin

useradd -g oinstall -G dba,oper,asmadmin oracle

passwd oracle

Create Directories in which Oracle software will be installed:

mkdir -p /u01/app/oracle/product/11.2.0/db_1

chown -R oracle:oinstall /u01

chmod -R 755 /u01

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

# Oracle Settings
ORACLE_HOSTNAME=localhost; export ORACLE_HOSTNAME
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; 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

 Login as root and enter the following command:

xhost +

Download Oracle Database 11g R2 from Oracle and place the two file into the same directory:

unzip linux_11gR2_database_1of2.zip

unzip linux_11gR2_database_2of2.zip

You should now have a single directory called database.

 Run the Oracle Universal Installer

cd database

./runInstaller

To install the Oracle software, you must use the Oracle Universal installer.

1.	For this installation, you need either the DVDs or a downloaded version of the DVDs. In this tutorial, you install from the downloaded version. From the directory where the DVD files were unzipped, open a terminal window and enter the following: ./runInstaller.sh
2.	The product you want to install is Oracle Database 11g. Make sure the product is selected and click Next.
2.	You will perform a basic installation with a starter database. Enter orcl for the Global Database Name and oracle for Database Password and Confirm Password. Then, click Next.
3.	You need to specify your Inventory directory. The location should be set to /u01/app/oracle/oraInventory. Accept the default Operating System group name, oinstall. Then, click Next.
4.	The installer now verifies that the system meets all the minimum requirements for installing and configuring the chosen product. Please correct any reported errors before continuing. When the check successfully completes, click Next.
5.	Oracle Configuration Manager allows you to associate your configuration information with your Metalink account. You can choose to enable it on this window. Then, click Next.
5.	Review the Summary window to verify what is to be installed. Then, click Install.
6.	The progress window appears.
7.	The Configuration Assistants window appears.
8.	Your database is now being created.
9.	When the database has been created, you can unlock the users you want to use. Click OK.
10.	You need to execute orainstRoot.sh and root.sh as the root user.
11.	Open a terminal window and enter the following commands. Follow the prompts as instructed. su - cd /u01/app/oracle/oraInventory ./orainstRoot.sh cd ../product/11.1.0/db_1 ./root.sh exit exit
12.	Switch back to the Universal Installer and click OK.
13.	Click Exit. Click Yes to confirm exit.

Back to Topic List

Testing Your Installation

To test that your installation completed successfully, perform the following steps:

1.	Open a browser and enter the following URL: https://:1158/em where <hostname> should be changed to your machine name, IP address, or localhost. Because Enterprise Manager Database Control is a secure site, you need a certificate. Select the Accept this certificate permanently option, and then click OK.
2.	Enter system as the User Name and oracle as the Password, and then click Login.
3.	The Database Control Home Page appears. Your installation was successful.