ORACLE 11G INSTALLATION ON ENTERPRISE LINUX

ORACLE 11G INSTALLATION ON ENTERPRISE LINUX

Hi, this is your step by step installation of oracle 11G on enterprise linux 4.5 and 5.0. Firstly ensure the proper installation of all the packages needed for oracle 11g database. Download linux_x86_11gR1_database.zip software or any other release from oracle website.

A:  CONFIGURATION

Boot the linux operating system to display the login screen.

And

1. LOG IN AS ROOT , open a new terminal and issue the following commands to create the various user’s groups: ( press enter key after each command to execute )

groupadd oinstall

groupadd oper

groupadd dba

2. CREATING A USER ‘ORACLE’ AND ADD USER ‘ORACLE’ TO GROUPS

useradd –g oinstall –G dba,oper oracle (press enter to execute)

3. GIVE PASSWORD TO ORACLE

passwd oracle

(Supply the password of your choice twice, press enter after each entry. Note: The password will not show while typing it)

4. Next CREATE DIRECTORIES AND GRANTING PERMISSIONS TO USER ‘ORACLE’

 (run each as a separate command, press enter after each)

mkdir  –p  /u01/app/oracle

chown  –R oracle:oinstall  /u01/app

chmod  –R 775  /u01/app

5. EDIT THE SYSTEM CONTROL FILE  PARAMETERS

gedit  /etc/sysctl.conf     ( this command  displays the content of sysctl.conf file ( a non empty file) in a editable gedit fomat, scroll down to  the end of the file and append  the kernel parameters  below)

kernel.shmmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 262144

( save and quit)

6.      Next  edit the /etc/security/limits.conf file

gedit /etc/security/limits.conf   (add the following lines to the end of the file)

oracle                                    soft                         nproc                     2047

oracle                                    hard                       nproc                     16384

oracle                                    soft                         nofile                     1024

oracle                                    hard                       nofile                     65536

(save and quit)

7.      Edit the /etc/pam.d/login

gedit  /etc/pam.d/login   ( add the following lines to the end of the file)

session                  required                                /lib/security/pam_limits.so

session                  required                                pam_limits.so

(save and quit)

8.      Edit the /etc/selinux/config

gedit  /etc/selinux/config  (change the  SELINUX setting from enabled to disabled i.e if it was not disabled during operating system configuration)

SELINUX=disabled

(save and quit)

9.       Execute the following command to add operating system’s hostname to the access control list.

xhost  +hostname (e.g  xhost +fred.oracleserver.com)

LOGOUT AS ROOT AND  LOGIN AS ORACLE

10.  Next edit the user’s profile file (remember that the hostname of my server is fred.oracleserver.com)

gedit  .bash_profile      ( displays a non empty file, scroll down to the end and carefully append the following lines )

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=fred.oracleserver.com; export ORACLE_HOSTNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME

ORACLE_SID=ikeja11; 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

(save and quit)

Then reboot the system.

 B:  INSTALLATION

1.        Login in as oracle and copy the content

cp  /media/cdrecorder/ linux_x86_11gR1_database.zip /home/oracle

2.       Then unzip the copied file

unzip  linux_x86_11gR1_database.zip

3.       Change directory to the directory database

cd database

4.       Then run the oracle Installer

./runInstaller

5.       The Oracle Universal Installer will run and startup

6.       From the options available choose advanced installation. Click Next.

7.       For Inventory directory and credentials verify the inventory path should be ‘/u01/app/oraInventory’. Click next.

8.       Installation type select enterprise edition (3.18GB). Click next.

9.       Installation type select enterprise edition. Click Next.

10.     Installation location verify oracle base=/u01/app/oracle, path=/u01/app/oracle/product/11.1.0/db_1

11.      Product specific test (prerequisite checks) should have only one requirement not met which is ‘Network Configuration’ all others should work. A warning will appear ignore and Click Next.

12.     Select configuration option. Create a database.

13.     Select a database configuration. Select general purpose database.

14.    Specify database configuration options; global database name: ikeja11.livewire.com, SID: ikeja11

15.     Specify database configuration details. Click on the sample schemas tab and check create database with sample schemas. Click next.

16.     Select database management option. Use database control is checked by default. Click next.

17.     Specify database storage option, file system is the default. Click next.

18.     Specify backup and recovery options: Do not enable automated backups. Click next.

19.     Specify database schemas passwords. Select use the same password for all the accounts, enter password and click next.

20.    Oracle configuration manager registration. Click next.

21.     Summary (Click install)

22.    Observe the Installation process and make sure the extraction is going to a path that starts with ‘/u01/app/oracle/….’

23.    After installing the software and the database. The password management is next. Click ok.

24.   Two scripts that need to be run as the root user.

25.    Right click on your desktop and open a new terminal type ‘su  –  root’ and supply your root password.

26.    Run both of the scripts against the root prompt

27.    The second script will need an additional path: ‘/usr/local/bin’ to be typed. After that type ‘exit’ at the root prompt to return to the ‘$’ prompt.

28.    Click ok on the scripts window open. It should give a message that the installation of oracle was successful. Write down all the URLs that show up with that message.

Good luck.