Step By Step Installation of 11.2.0.3.0 Standalone RDBMS Software

Going forward with 11gR2 oracle recommending out of place upgrade so providing full installer for major upgrades (i.e. 11.2.0.1.0 , 11.2.0.2.0, 11.2.0.3.0) instead of patchsets. Then we can apply bundle patch or custom patches based on our requirement.

For 11.2.0.3.0, software is available on MOS with patch number 10404530 and could be easily downloadable. This patch contains total 7 files but we need only p10404530_112030_platform_1of7.zip & p10404530_112030_platform_2of7.zip (2.32 GB) to install DB software. This patch is actually full release and could be used for upgrade as well as new installation.

Prerequisite RPMs

binutils-2.17.50.0.6

compat-libstdc++-33-3.2.3

elfutils-libelf-0.125

elfutils-libelf-devel-0.125

elfutils-libelf-devel-static-0.125

gcc-4.1.2

gcc-c++-4.1.2

glibc-2.5-24

glibc-common-2.5

glibc-devel-2.5

glibc-headers-2.5

kernel-headers-2.6.18

ksh-20060214

libaio-0.3.106

libaio-devel-0.3.106

libgcc-4.1.2

libgomp-4.1.2

libstdc++-4.1.2

libstdc++-devel-4.1.2

make-3.81

numactl-devel-0.9.8.i386

sysstat-7.0.2

unixODBC-devel-2.2.11-7.1.i386.rpm

unixODBC-2.2.11-7.1.i386.rpm

Note: 64 bit installation also searches for i386 unixodbc rpms.


In order to check missing or old RPM use following commands:

rpm -qa | egrep -i ‘binutils|compat-libstdc|elfutils-libelf’ | sort -k1

rpm -qa | egrep -i ‘^gcc|^glibc|^kernel-headers|^ksh|^libaio|^libgcc|^libgomp’ | sort -k1

rpm -qa | egrep -i ‘^libstdc|^make|numactl|sysstat|unix’| sort -k1

Resource limits in /etc/security/limits.conf file

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

oracle hard stack 32768

Kernel parameters in /etc/sysctl.conf file

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

Installation

Download the software and unzip it then go to software stage directory and start installer:

./runInstaller



Uncheck “I wish to receive security updates via My Oracle Support” and click “Next”


Click “Yes”


Opt for “Skip software updates” and click “Next”


Opt for “Install database software only” and click “Next”


Opt for “Single instance database Installation” and click “Next”


Click “Next”


I have opted for “Enterprise Edition” , you could choose as per your requirement and click “Next”


Click “Next”


Provide Oracle Base & Software Location and click “Next”.

On my server this wasn’t first installation, so oracle inventory was already in place otherwise installer would have asked you to do so.


Choose appropriate groups for OSDBA & OSOPER and click “Next”


In case OUI detected any mismatch with pre-requisites then it will give you option to click on “fix and check” which will pop-up a window suggesting “/tmp/CVU_11.2.0.3.0_oracle/runfixup.sh” script to run as root. It will fix the gaps for you. It’s one of the great feature in OUI which is removing complexity during installation.


Click “Install”


Wait and watch… it will take 5-10 minutes, based on your system to complete the installation.


Now open a new session as root and execute root.sh script.

[root@mask11g ~]# /u01/app/oracle/product/11.2.0.3/dbhome_1/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/oracle/product/11.2.0.3/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of “dbhome” have not changed. No need to overwrite.

The contents of “oraenv” have not changed. No need to overwrite.

The contents of “coraenv” have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

Click “Close”.

RDBMS Installation is now done.

Advertisements

Share Your Comment

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Pierre blog

Pierre Forstmann Oracle Database blog

flashdba

Oracle databases, storage and the high-performance world of flash memory

Future Veterans

Ramblings about Oracle

Ranjeet Srivastava

Smile! You’re at the best blog ever

Kevin Closson's Blog: Platforms, Databases and Storage

Platform, Database and Storage Topics

Real Life Database / SQL Experiences : An Oracle Blog from Vivek Sharma

Being an Oracle Professional, I like to share all my Real Life Performance Tuning Challenges and Experiences. The Content and Views on this site are my own and not necessarily those of Oracle. While, I write on my real life experiences, the resolutions mentioned are solely mine. Comments / Criticisms are always a welcome.

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting

OraStory

Dominic Brooks on Oracle Performance, Tuning, Data Quality & Sensible Design ... (Now with added Sets Appeal)

ASM Support Guy

Just Another Crazy Oracle DBA

Exadata Certification

Just Another Crazy Oracle DBA

Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Sangram keshari's Oracle Blog

The Fusion Middleware Administration & Database Administration Blog

Amit Saraswat

Just Another Crazy Oracle DBA

Oracle Scratchpad

Just another Oracle weblog

The Tom Kyte Blog

Just Another Crazy Oracle DBA

Hemant's Oracle DBA Blog

Just Another Crazy Oracle DBA

Uwe Hesse

about Database Technology

Richard Foote's Oracle Blog

Focusing Specifically On Oracle Indexes, Database Administration and Some Great Music

%d bloggers like this: