Unknown

Oracle 11g Install in Linux Environment Step by Step



###############################################################################

DISCLAIMER:

This document is for practice purpose only and can not be compared with others.

This document does not gurantee anything and never will. Please advise if you find

something missing from this document.

################################################################################



Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6:

-----------------------------------------------------------------------------------

Basic Installation Step:

1. Boot from the DVD/Image. At the boot screen, press the "Enter" key.

2. Press the "tab" key to move focus to the "Skip" key, then press the "Enter" key to continue.

3. On the "Welcome" screen, click the "Next" button.

4. Select the appropriate language, then click the "Next" button.

5. Select the relevant keyboard setting, then click the "Next" button.

6. Select "Basic Storage Devices" option for the installation, then click the "Next" button.

7. Enter host name (greenlink), then click the "Configure Network" button.

8.Select the relevant time zone by clicking on your nearest city on the map. Click on the "Next" button to proceed.

9. Enter a root password for the server, then click the "Next" button to proceed.

10. Check "Use All Space" option. Click the "Next" button.

11. Click "Write changes to disk" then click the "Next" button to proceed.

12. Click "Basic Server" and check the "Customize now" option, then click the "Next" button.

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

13. Wait for the installation to complete then click on "Reboot".

14. On the "Welcome" screen, click the "Forward" button.

15. Accept the license agreement and click the "Forward" button.

16. Click "No, I prefer..." and click "Forward" button.

17. Click the "No thanks, I'll connect later." button.

18. Finish the software updates setup by clicking the "Forward" button.

19. Do not create any user just click the "Forward" button.

20. Adjust the time and click Forward.

21. Do not select "Kdump" and click Forward.

22. Now, you are presented with the login screen.



OS install has been completed.

============================================================================

Download the Oracle Database software from www.oracle.com



Perform the following steps as ROOT:

==========================================================================

#STEP 1



The "/etc/hosts" file must contain a fully qualified name for the server:



For example:-

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

#::1 localhost localhost.localdomain localhost6 localhost6.localdomain6



192.168.1.100 greenlink





Log in as root and run the following commands: Copy and Paste



Creating the OSDBA Group

/usr/sbin/groupadd dba



Creating the Oracle Inventory Group

/usr/sbin/groupadd oinstall



Creating an OSOPER Group

/usr/sbin/groupadd oper



To determine whether an Oracle software owner user named oracle exists, run the following command:

id oracle



If the oracle user exists, then the output from this command looks like this:

uid=440(oracle) gid=200(oinstall) groups=201(dba),202(oper)



Creating an Oracle Software Owner User:



/usr/sbin/useradd -g oinstall -G dba,oper oracle



passwd oracle

change password accordingly.



Verifying that the User nobody Exists

id nobody



If the nobody user does not exist, then enter the following command to create it:

/usr/sbin/useradd nobody



==========================================================================

#STEP 2 (Copy and Paste)



yum install binutils.x86_64 \

compat-db.x86_64 \

compat-libcap1.i686 \

compat-libcap1.x86_64 \

compat-libstdc++-33.i686 \

compat-libstdc++-33.x86_64 \

elfutils-libelf.i686 \

elfutils-libelf.x86_64 \

gcc-c++.x86_64 \

gcc.x86_64 \

gdbm.x86_64 \

glibc-devel.i686 \

glibc-devel.x86_64 \

glibc-headers.x86_64 \

glibc.i686 \

glibc.x86_64 \

ksh.x86_64 \

libaio-devel.i686 \

libaio-devel.x86_64 \

libaio.i686 \

libaio.x86_64 \

libstdc++.i686 \

libstdc++.x86_64 \

libXp.i686 \

libXtst.i686 \

libXtst.x86_64 \

make.x86_64 \

sysstat.x86_64 \

unixODBC.i686 \

unixODBC.x86_64 \

xorg-x11-utils.x86_64



==========================================================================

#STEP 3 (Copy and Paste)



mkdir -p /app/oracle/app

mkdir -p /app/oracle/oradata

mkdir -p /app/oracle

mkdir -p /app/software

chown -R oracle:oinstall /app/oracle/app /app/oracle/oradata /app/oracle /app/software

chmod 755 /app/oracle /app/oracle/app /app/oracle/oradata

=====

# Create the Oracle Base Directory Path

The directories will be used to store the data files



mkdir -p /app/oracle/oradata

chown -R oracle:oinstall /app

chmod -R 775 /app



=====

# Create the Fast Recovery Area Directory Path



mkdir -p /app/oracle/fast_recovery_area

chown -R oracle:oinstall /app

chmod -R 775 /app



==========================================================================

#STEP 4 (Copy and Paste)



cat >> /etc/security/limits.conf <<EOF

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft nofile 4096

oracle hard nofile 65536

oracle soft stack 10240

EOF



=====

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

fi

EOF



=====

cat >> /etc/sysctl.conf <<EOF

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

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=1048586

EOF



/sbin/sysctl -p

=====

cat >> /etc/pam.d/login <<EOF

session required pam_limits.so

EOF



===



Amend the "/etc/security/limits.d/90-nproc.conf" file as described below:

vi /etc/security/limits.d/90-nproc.conf



# Change this

* soft nproc 1024



# To this

* soft - nproc 16384





Set secure Linux to permissive by editing the "/etc/selinux/config" file:



SELINUX=permissive

------------------------------------------------------------------

Configure Network:



Click on 'System' --> Preferences --> Network Connections

Click on eth0 and "Edit..." --> select 'connect automatically' and Available to all users

Select "IPv4 Settings" --> Method: Manual --> click on "Add"

and enter the following:

Address: 192.168.1.100

Netmask: 255.255.255.0

Gateway: 192.168.1.1



DNS Server: 192.168.1.1

tick the: connect automatically - right below the connection name.

========================================================================

Now log out of Root and Log in as "oracle":



vi .bash_profile



ORACLE_BASE=/app/oracle

ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1



ORACLE_SID=orcl

#PATH=$PATH:$HOME/bin::$ORACLE_HOME/bin

PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_HOME ORACLE_BASE ORACLE_SID PATH

umask 022



PATH=$PATH:$HOME/bin::$ORACLE_HOME/bin

umask 022



================================================================

>>>Reboot your computer.

-----------------------------------------------------------------

Login as ORACLE user:



Unzip the database zip files:

unzip linux.x64_11gR2_database_1of2.zip

unzip linux.x64_11gR2_database_2of2.zip



Go to database folder and look for rpm folder and run the rpm as root:

rpm -ivh cvq.....



Now go back to database folder and perform the following:



./runInstaller



Uncheck security update

Installing database Software Only

Single instance

Enterprise Edision

Continue doing the remaining steps.



dbca

creating database: orcl



netca (create a listener for 'orcl')

Local Net Service Name Configuration

and Continue to Configure Listener.



netmgr

under local >Listener add database name to register.

===============================================================================

Post Installation:



Edit the "/etc/oratab" file setting the restart flag for each instance to 'Y'.



orcl:/app/oracle/product/11.2.0/dbhome_1:Y

================================================================================

lsnrctl status

Listener 'orcl' should be running........

--------------------------------------------------------------------------------

sqlplus sys/oracle@orcl as sysdba;

===============================================================================



Thank you.

shaikat

skype: shaikatustc09

email:shaikatustc09@hotmail.com

=================================================================================



