Archive
easy, fast cloning ORACLE_HOME
updated 27.4.2012
Building a master-installation for cloing has multiple benefits
- a new Oracle installation can be done very fast
- all clones from the master are identical – e.g. no one off is missing
- 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 😉 Read more…
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
Is it possible to deinstall/remove a specific component from already installed Oracle Database Home using OUI? (Doc ID 888934.1)