easy, fast cloning ORACLE_HOME

updated 27.4.2012

Building a master-installation for cloing has multiple benefits

1. a new Oracle installation can be done very fast
2. all clones from the master are identical – e.g. no one off is missing
3. the installation can be scripted very easy, no creation of responsefile necessary

Quick overview

create tarfile from master

extract tarfile to the new location

start clone

that’s all 😉

Advertisements

unix scripts – hints

This section lists a some usefull unix commands and sample

---

• find files with specific content
  find . -atime +30 -exec grep -il “abc” {} \;
• find files  with special pattern and access-time
  find . -name “*tr?” -atime +3
  and delete those
  find . -name “*tr?” -atime +2  -delete
• looping n-times

  I=1
  while test $I -le 100
  do
  sqlplus /nolog @script
  I=`expr $I + 1`
  Done

• remove blank / empty lines from file
         grep -v "^$" filename > newfilename
• convert UPPER to lower case
  host=`hostname`
  lhost =$(echo $host | tr [:upper:] [:lower:])

enable, disable options in 11.2

Starting with 11.2 the installation procedure changed.
There is no more custom installation – all options will be installed.

To check which options are active run
select * from v$option order by parameter;

Stop all instances using this ORACLE_HOME !

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk part_on ioracle

SQL>  select * from v$option where upper(parameter) like ‘%PARTI%’;
PARAMETER                                        VALUE
—————————————- —————————————————————-
Partitioning                                           TRUE

make -f ins_rdbms.mk part_off ioracle

SQL>  select * from v$option where upper(parameter) like ‘%PARTI%’;
PARAMETER                                        VALUE
—————————————- —————————————————————-
Partitioning                                           FALSE

These options can be disabled or enabled

                             Enable      Disable
Partitioning                  part_on     part_off
Datamining                    dm_on       dm_off
OLAP                          olap_on     olap_off
Data Vault                    dv_on       dv_off
Real Application Testing      rat_on      rat_off

to disable ALL those options:

make -f ins_rdbms.mk part_off dm_off olap_off dv_off rat_off ioracle

Is it possible to deinstall/remove a specific component from already installed Oracle Database Home using OUI? (Doc ID 888934.1)