Sunday, October 03, 2010

Oracle (out-of-place install)

From the first patchset of Oracle 11gR2 (, we are able to install it from “scratch” without having the need to install the based version (in most of the case *.1, e.g., called out-of-place install or upgrade.
This is rather nice for any new installation, let’s say you start a brand new project, you want to be on the latest patchset. No need anymore to do it in two steps (first then, you can directly install the latest available patchset.
Moreover, the Installer offers also the possibilities to install the latest PSU (PatchSet Update, a set of one-off patches and CPU) within a special step.

So, why waiting more, let’s install it.
From the
patchset page download on MOS, we can see 7 zipped files (!), but each one is for different usage :
* Files 1_of_7 and 2_of_7 are for Database
* Files 3_of_7 are for Grid Infrastructure
* Files 4_of_7 are for the Client
* Files 5_of_7 are for Gateway
* Files 6_of_7 are for Examples
* Files 7_of_7 are for Deinstaller

Don’t download everything if you don’t need, in the case below, only the first two are in used. I would say name of files would have been choose more carefully…
The install below is on Linux x86_64 OEL5.3.

Oracle11gR2.2_001 Oracle11gR2.2_002 Oracle11gR2.2_003

 Oracle11gR2.2_005  Oracle11gR2.2_006
The screen above is new from, you are prompted for email/password of My Oracle Support in case you want to apply the latest PSU, rather nice ! (in our case there is not). 
Oracle11gR2.2_008    Oracle11gR2.2_009 Oracle11gR2.2_010
Remember, I’m doing an out-of-place installation (not based on any previous installation), and I already have a installation on the same server, that’s why my oracle home directory contains the patchset number. It could become a name convention as of now.
Oracle11gR2.2_013   Oracle11gR2.2_014 Oracle11gR2.2_015  Oracle11gR2.2_016   Oracle11gR2017  
Right now, I have two Oracle home for 11gR2 ( and, so, I modified my .bash_profile to be able to switch from one to the other easily :

[root@orion3:/]# su - oracle
[oracle@orion3:/home/oracle(OH-]$ more .bash_profile
# .bash_profile

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

# User specific environment and startup programs


export PATH

export ORACLE_BASE=/apps/oracle


export ORACLE_HOME=$ORACLE_BASE/product/11.2.0
PS1="[\u@\h:\$PWD(OH-]\\$ "

export ORACLE_HOME=$ORACLE_BASE/product/
PS1="[\u@\h:\$PWD(OH-]\\$ "

[oracle@orion3:/home/oracle(OH-]$ sqlplus -v

SQL*Plus: Release Production

[oracle@orion3:/home/oracle(OH-]$ o2
[oracle@orion3:/home/oracle(OH-]$ sqlplus -v

SQL*Plus: Release Production


There are a couple of new features coming within this patchset, find out more in the documentation. I like the point (While truncating a table or partition, you can now specify whether or not to keep any segments), it has been discussed several times over here. It is also now the case for partitioned table, point

Enjoy the new version !


No comments: