Oracle Database Administration: The Essential Refe

A sample script

The following SQL script will create a database called DB1 using the OFA architecture. You will find a copy of this script at the O’Reilly web site (see the Preface for details).

REM * *********************************************************** REM * Script to create DB1 instance with db_block_size = 8192 REM * REM * Created: Dave Kreines - 10/18/98 REM * REM * REM * *********************************************************** spool /disk00/oracle/software/7.3.4/dbs/crdbDB1.log REM * Start the instance (ORACLE_SID must be set to <DB1>). REM * connect internal startup nomount pfile=/disk00/oracle/software/7.3.4/dbs/initDB1.ora REM * Create the <DB1> database. REM * create database "DB1" maxinstances 2 maxlogfiles 32 maxdatafiles 1000 character set "US7ASCII" datafile '/disk00/oracle/oradata/DB1/system01.dbf' size 50M logfile '/disk01/oracle/oradata/DB1/log01.log' size 512K, '/disk01/oracle/oradata/DB1/log02.log' size 512K, '/disk01/oracle/oradata/DB1/log03.log' size 512K, '/disk01/oracle/oradata/DB1/log04.log' size 512K; REM * Now perform all commands necessary to create REM * the final database after the CREATE DATABASE command has REM * succeeded. REM * install data dictionary: @/disk00/oracle/software/7.3.4/rdbms/admin/catalog.sql REM * install procedural components: @/disk00/oracle/software/7.3.4/rdbms/admin/catproc.sql REM * Create additional rollback segment in SYSTEM since REM * at least one non-system rollback segment is required REM * before creating a tablespace. ...