|
 |
|
Oracle Tips by Burleson |
Oracle10g Grid Computing
with RAC
Chapter 6 - Install,
Configure and Database Creation
Database
Creation Manually
Then create a temporary tablespace:
CREATE TEMPORARY
TABLESPACE "TEMP" TEMPFILE
'/dev/RAC/temp_01_50.dbf'
SIZE 40M REUSE
Now Create a 2nd UNDO tablespace for the use of second instance:
CREATE
UNDO TABLESPACE "UNDOTBS2"
DATAFILE
'/dev/RAC/undotbs_02_210.dbf' SIZE 200M
REUSE NEXT 5120K
MAXSIZE UNLIMITED;
Run the necessary scripts to build views,
synonyms, etc.
The primary scripts that must be run are:
a. CATALOG.SQL--creates the views of data
dictionary tables and the dynamic performance views.
b. CATPROC.SQL--establishes the usage of PL/SQL
functionality and creates many of the PL/SQL Oracle-supplied
packages.
c. CATCLUST.SQL--creates RAC specific views.
(The CATPARR.SQL script is still provided but will not be
maintained.)
The above text is
an excerpt from:
Oracle 10g Grid & Real Application
Clusters
Oracle 10g
Grid
Computing with RAC
ISBN 0-9744355-4-6
by Mike Ault, Madhu Tumma
|
