Monday, September 12, 2011

Oracle Database 10gR2 10.2.0.1.0 Installation On Red Hat Enterprise Linux 5.3

In this article I will describe the installation of Oracle Database 10g R2 on Red Hat Enterprise Linux 5.3. Before any proceedings with installation make sure that C library RPMs are installed.
First of all create oinstall, dba and oper OS groups by running following commands using “root” OS user


groupadd oinstall
groupadd dba
groupadd oper

Now create “Oracle 10gR2 Server Software Owner” OS user named “oracle” by running following command


useradd –m –g oinstall –G dba, oper –d /home/oracle –s /bin/bash –c “Oracle Database 10gR2 Server” oracle


And change the password of “oracle” user by passwd command


passwd oracle


These steps are shown in following figure

Figure - 1


Now add/update following kernel parameters in /etc/sysctl.conf file that are required for Oracle Installation and will be verified by Oracle Installer later on.


Figure - 2


To make these parameters active in the current session, run /sbin/sysctl -p command

/sbin/sysctl –p


Add following line in /etc/pam.d/login file as shown in this figure:

session required          pam_limits.so


Figure - 3

Add following lines in /etc/security/limits.conf file

oracle    soft        nproc    2047

oracle    hard       nproc    16384
oracle    soft        nofile    1024
oracle    hard       nofile    65536

Figure - 4

Now make directories for Oracle Database Installation and change ownership of these directories to “oracle” user by running following

mkdir –p /u01/oracle/product/10.2.0/db_1

chown –R oracle:oinstall /u01


Figure - 5

Add following oracle variables in /home/oracle/.bash_profile by switching to oracle user


su – oracle

vi /home/oracle/.bash_profile

export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=db10g


Figure - 6

Log out from “root” user and log in with “oracle” user.
Copy setup files to /u01/oracle_10gr2_linux

Start Oracle Database installation by running following command

/u01/oracle_10gr2_linux/runInstaller


Select Advanced Installation radio button and then click Next button on following screen.


Figure - 7

Click Next On following screen.


Figure - 8

Click Next On following screen. 

Figure - 9


Make sure that overall result is passed in following screen. If not then make sure that required packages and parameters are configured correctly. Click Next On following screen.


Figure - 10

 Select “Create a database” and click next on following screen.

Figure - 11

Click next on following screen.
 
Figure - 12

Select “Unicode standard UTF-8 AL32UTF8” from Database character set and Click next on following screen 




Figure - 13

Click next on following screen.


Figure - 14


Click next on following screen.


Figure - 15


Click next on following screen.


Figure - 16


Provide password and Click next on following screen.


Figure - 17

Review information about installation and Click Install on following screen.
 
Figure - 18


View progress.


Figure - 19

View progress. 

Figure - 20


View progress.


Figure - 21


Note the Database Control URL and click OK on following screen.


Figure - 22

Start a Terminal, change user to “root” by using “su – root” command and copy Script Location from following screen to Terminal. Press enter and accept default options.


Figure - 23


Review information on following screen and click Exit.


Figure - 24


Open browser and paste the URL of “Enterprise Manager 10g Database Control URL:” to browser. Provide “sysman” as username and its password and click login.


Figure - 25


Review information about your 10g database using Database Control Home page.


Figure - 26

Insha-Allah this will help and serve the purpose. For any corrections and improvements please suggest.

1 comment:

  1. Hi nasir i want to convert single instance to Rac envit=ronment in 10gr2.So if u have any your own documentation please forword me.My mail id:sathilinks@gmail.com

    ReplyDelete