Question: In want to add a new instance to my Solaris
server, and I don't know how to add a new $ORACLE_HOME to my
existing database. I also need to know how to add a new
instance on Linux.
Answer: Start b y reviewing these
important notes on
Oracle instance consolidation, as shops worldwide are
recognizing the advantages of running dozens of instances on a
single monolithic server where it's easy to share computing
resources. Also see my notes on
adding a new instance to a RAC database server.
the basic steps for installing a new instance on your server:
1 - If you are adding an instance on a different
release, run DBCA and install the new Oracle software in another
$ORACLE_HOME directory under your
existing $ORACLE_BASE directory.
2 - Create
a new pfile, making sure that you
size the SGA
and PGA to allow enough room for the other instances on the
2 - Now
make your oratab file. In Solaris, make an entry in /var/opt/oratab
for the new instance. In Linux, HP/UX and AIX, make the entry
3 - Change your .profile (or .login)
depending on your shell to allow you to
specify the new environment.
4 - You are now ready to
change your environment to point to your new $ORACLE_HOME.
backup controlfile to trace from an existing database to
generate a set of "create database syntax. Beginners can get
the create database syntax by running DBCA to
create a new database under your new $ORACLE_HOME.
6 - Now populate your new data dictionary by running
6 - Finally, start
and populate your new instance with tables and indexes.
Also see how to
remove an instance from an Oracle server.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.