Installing Oracle Database 11g on Linux

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.
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
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.

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.
In this tutorial, you learned how to install and test the Oracle Database 11g installation on Linux.



1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete