Click here to Skip to main content
13,138,372 members (51,704 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


9 bookmarked
Posted 22 Nov 2011

Oracle 11g Report Installation on RedHat Linux 5x

, 22 Nov 2011
Rate this:
Please Sign up or sign in to vote.
Oracle 11g Report Installation on RedHat Linux 5x

Table of Contents

  1. Introduction
    1. Change O/s Configuration and parameters
    2. Change the Hosts File Entry
    3. Go to /etc/security (cd /etc/security)
    4. Go to /etc/pam.d (cd /etc/pam.d)
    5. Required rpm
    6. Create user and groups
    7. Install weblogic first
    8. Install forms and report services
      • Unzip
      • Unzip
      • Unzip
      • Unzip
    9. Shutdown or reboot the machine
    10. Run Install Steps:
      • Check all pre-requisites are verified and status should be the above
    11. Rest follow the GUI provided by Oracle
    12. Some Tips

1. Introduction

This article covers the Installation of Oracle Database 11g on Enterprise Linux 5 and CentOS 5. The server needs a minimum of 4GB RAM for the installation. Swap should have double of physical RAM.

I recommend the following server configuration:

  • Xeon – Server with 1/2 cpu and 6gb/8gb Ram (an ideal configuration)

The following packages are mandatory for Enterprise Linux 5: GNOME Desktop Environment, Graphical Internet, X Window System, Editors, Development Tools, Server Configuration Tools, System Tools and Administration Tools.

11g Reports License needs to procure before the installations.

You can download the software, subject to Oracle Licensing.

  • ofm_pfrd_linux_11.
  • ofm_pfrd_linux_11.
  • ofm_pfrd_linux_11.
  • ofm_pfrd_linux_11.
  • oepe111130_wls1032_linux32.bin

After download, unzip or extract the files.

To download the weblogic:


Download 11g Report Services:


1.1 Change O/s Configuration and Parameters

Copy sysctl.conf.

cp sysctl.conf sysctl.confold 
Cd /etc 
Vi sysctl.conf 

Add the following:

# Kernel sysctl configuration file for Red Hat Linux
# For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and
# sysctl.conf(5) for more details.
# Controls IP packet forwarding
net.ipv4.ip_forward = 0
# Controls source route verification
net.ipv4.conf.default.rp_filter = 1
# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0
# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0
# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1
# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1
# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536
# Controls the default maxmimum size of a message queue
kernel.msgmax = 65536
# Controls the maximum shared segment size, in bytes
kernel.shmmax = 4294967295
# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 268435456
Press Esc :wq
(configuration based on 4gb ram)

1.2 Change the Hosts File Entry

	Cd /etc
	Cp hosts hostsold
	Vi hosts               localhost.localdoamin localhost
::1             localhost6.localdomain6 localhost6  hostname
Press Esc and :wq

1.3 Go to /etc/security (cd /etc/security)

Vi limits.conf
Add or change  /etc/security/limits.conf file:
orarep              soft    nofile  4096
orarep              hard    nofile  65536
orarep              soft    nproc   2047
orarep              hard    nproc   16384
to save Esc :wq

1.4 Go to /etc/pam.d (cd /etc/pam.d)

Vi login
Add or change line to the /etc/pam.d/login file
session    required
session    required     /lib/security/
to save Esc :wq

Very important steps:

The following packages(rpm) are required for Enterprise Linux:

1.5 Required rpm

Checking rpm:

Rpm –q rpmname
rpm -q gcc-4.1.0-28.4 
rpm -q gcc-c++-4.1.0-28.4
rpm -q setarch-1.6-1
rpm -q sysstat-5.0.5-1 – to be done
rpm -q libaio-0.3.106
rpm -q libaio-devel-0.3.106 – to be don
rpm -q libstdc++-4.1.0-28.4
rpm -q libstdc++-devel-4.1.0-28.4
rpm -q compat-libstdc++-296-2.96-132.7.2
rpm -q compat-db-4.1.25-9
rpm -q control-center-2.8.0-12
rpm -q glibc-common-2.3.4-2.9 
rpm -q binutils- 
rpm -q make-3.80-202.2 -dibe
rpm -q openmotif22-2.2.3 (for Oracle Reports Server)
rpm -q openmotif-2.2.3 (for Oracle Reports Server)  

1.6 Create User and Groups

Adding Groups:

groupadd oinstall
groupadd dba
groupadd oper
Adding user and assign the group:
	useradd -g oinstall -G dba,oper orarep
Add password for Oracle user
	passwd orarep

1.7 Install weblogic First

./ oepe111130_wls1032_linux32.bin
Select default path
Do not create separate domain

1.8 Install Forms and Report Services


1.9 Shutdown or Reboot the Machine

Login as Oracle 
Change/add user environment
Go to /home/oracle
Vi .bash_profile
Add the following:

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc

# User specific environment and startup programs


export ORACLE_MIDDLEWARE=/home/orarep/Middleware
export ORACLE_HOME=/home/orarep/Middleware/as_1
export ORACLE_INSTANCE=/home/orarep/Middleware/asinst_1
export ORACLE_DOMAIN=/home/orarep/Middleware/user_projects/domains/fm_rep

export PATH

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
    ulimit -u 16384 -n 65536
Press Esc key :wq

Log out
Login as Oracle user

1.10 Run Install Steps

Set the Display first
              export DISPLAY=hostname:0.0
export DISPLAY

Go setup Disk directory
Cd Disk1


Select next.


Select Install and Configure and click next.


Check all pre-requisites are verified and status should be the above.


Create user and add passwords, then click next.



1.11 Rest Follow the GUI Provided by Oracle

1.12 Some Tips

Reloading keymap file.

Open the

Added the below entry and re-start the wls_reports:


For manual startup:

1 - set and confirm environment (each time before starting a component)
Sample script setEnv_11g:
export FMW_HOME=/home/oracle/Middleware
export ORACLE_HOME=/home/oracle/Middleware/as_1
export ORACLE_INSTANCE=/home/oracle/Middleware/asinst_1
export DOMAIN_HOME=/home/oracle/Middleware/user_projects/domains/ClassicDomain
export TNS_ADMIN=/home/oracle/Middleware/asinst_1/config

Open command prompt
2 - start Admin Server
3 - start nodeManager
cd wlserver_10.3/server/bin &
4.  start reports engine
./opmnctl startall
To find out the status
./opmnctl status
To stop the Engine
./opmnctl stopall
                Administrator Console: http://hostname:7001/console
                EM Console: http://hostname:7001/em
                EMAgent URL: http://hostname:5155/emd/main
                Reports URL: http://hostname:8090/reports/rwservlet

Configuration Information

Name of the FileDirectory structure on Unix $ORACLE_INSTANCE/config/reports/bin/
rwbuilder (executable) $ORACLE_HOME/bin/ $ORACLE_INSTANCE/config/reports/bin/ $ORACLE_INSTANCE/config/reports/bin/ $ORACLE_INSTANCE/config/reports/bin/ $ORACLE_INSTANCE/config/reports/bin/ $ORACLE_INSTANCE/config/reports/bin/ ** $DOMAIN_HOME/servers/WLS_REPORTS/stage/reports/
cgicmd.dat ** $DOMAIN_HOME/servers/WLS_REPORTS/stage/reports/
rwserver.conf (standalone) $ORACLE_INSTANCE/config/ReportsServerComponent/
rwnetwork.conf (standalone) $ORACLE_INSTANCE/config/ReportsServerComponent/
rwnetwork.conf $ORACLE_INSTANCE/config/ReportsToolsComponent/ReportsTools/
rwserver.conf (in-process)** $DOMAIN_HOME/servers/WLS_REPORTS/stage/reports/
rwnetwork.conf ** $DOMAIN_HOME/servers/WLS_REPORTS/stage/reports/
targets.xml $DOMAIN_HOME/sysman/state/
opmnctl (executable) $ORACLE_INSTANCE/bin/
opmn.xml $ORACLE_INSTANCE/config/OPMN/opmn/
uifont.ali $ORACLE_INSTANCE/config/FRComponent/frcommon/
uiprint.txt $ORACLE_INSTANCE/config/FRComponent/frcommon/
Tk2motif.rgb $ORACLE_INSTANCE/config/FRComponent/frcommon/
portlist.ini $ORACLE_HOME/install/
httpd.conf $ORACLE_INSTANCE/config/OHS/ohs1/
tnsnames.ora $ORACLE_INSTANCE/config/

After successful installation, you will have to download the patches from Oracle Metalink. Report patches: 9473270. This needs to be applied.


./opatch apply /home/orarep/9473270

cd $ORACLE_HOME/reports/lib
make -f install

shutdown weblogic
shutdown reports

Revision History

  • 18th November, 2011: 1.0 Oracle 11g Installation on Enterprise Linux 5 and CentOS 5  by Srivalsalakumar Menon


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

President FunDtech India Ltd
India India
Twenty years of experience in the IT Industry in Software, MIS,development, design and database administration. Worked for more than 15 years as Oracle Database Administrator.

Strengths Include: Database Administration on 11g,10g,9i,8i, 8.0 and 7.x,6i,9i,10g,11g Reports in Unix, Windows NT and Novel Netware Environment. Conducted design reviews with an aim to enhance performance in production scenario. Has also carried out Design and Development in Oracle and Developer 2000 and Forms Reports 10g.

Working with FunDtech India Ltd, since 2003 as Asst. Vice President - Oracle Tech. and DBA

You may also be interested in...

Comments and Discussions

GeneralMy vote of 5 Pin
Member 842620623-Nov-11 22:10
memberMember 842620623-Nov-11 22:10 
GeneralMy vote of 5 Pin
kiran200923-Nov-11 22:06
memberkiran200923-Nov-11 22:06 
GeneralMy vote of 5 Pin
Mark Philip122-Nov-11 17:12
memberMark Philip122-Nov-11 17:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.170915.1 | Last Updated 22 Nov 2011
Article Copyright 2011 by Srivalsalakumar
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid