Oracle Database Creation Command

Database Creation

Two examples are detailed below.

--
-- Example #1
--

SPOOL output.log

STARTUP NOMOUNT PFILE=initXX.ora

CREATE DATABASE XX
        MAXLOGFILES 3
        MAXLOGMEMBERS 2
        MAXDATAFILES 100
        MAXLOGHISTORY 1
        MAXINSTANCES 1
LOGFILE
        GROUP 1 ('/data/disk1/log1a.rdo','/data/disk2/log1b.rdo') SIZE 10 M,
        GROUP 1 ('/data/disk3/log2a.rdo','/data/disk3/log2b.rdo') SIZE 10 M
DATAFILE
        '/data/disk8/system01.dbf' SIZE 50 M AUTOEXTEND ON,
        '/data/disk9/filexx01.dbf' SIZE 1000 M AUTOEXTEND ON,
        '/data/disk10/filexx02.dbf' SIZE 1000 M AUTOEXTEND ON,
        '/data/disk11/sortxx99.dbf' SIZE 100 M
CHARACTER SET WE8ISO8859P1 ;

SPOOL OFF


--
-- Example #2
--

connect internal/oracle

SPOOL output.log

STARTUP NOMOUNT PFILE=/apps/oracle/admin/DB19/pfile/init.ora

CREATE DATABASE DB19
        MAXLOGFILES 4
        MAXLOGMEMBERS 2
        MAXDATAFILES 100
        MAXLOGHISTORY 1
        MAXINSTANCES 1
LOGFILE
        GROUP 1 ('/data1/oradata/DB19/log1a.rdo','/data1/oradata/DB19/log1b.rdo') SIZE 20 M,
        GROUP 2 ('/data1/oradata/DB19/log2a.rdo','/data1/oradata/DB19/log2b.rdo') SIZE 20 M,
        GROUP 3 ('/data1/oradata/DB19/log3a.rdo','/data1/oradata/DB19/log3b.rdo') SIZE 20 M,
        GROUP 4 ('/data1/oradata/DB19/log4a.rdo','/data1/oradata/DB19/log4b.rdo') SIZE 20 M
DATAFILE
        '/data1/oradata/DB19/system01.dbf' SIZE 100 M AUTOEXTEND ON,
        '/data1/oradata/DB19/system02.dbf' SIZE 100 M AUTOEXTEND ON,
        '/data1/oradata/DB19/system03.dbf' SIZE 100 M AUTOEXTEND ON
CHARACTER SET WE8ISO8859P1 ;


SPOOL OFF


**************************************************
Next Steps:

2) The following SQL scripts should be run, as internal, following 
   the DB creation:  

   catalog.sql    catproc.sql   dbmspool.sql   
   catblock.sq    catparr.sql   pupbld.sql

   See oracle/rdbms/admin directory.


3) Creation of temp (sort) tablespace


CREATE TABLESPACE temp01 
DATAFILE  '/data1/oradata/DB19/temp01.dbf'
SIZE 500 M
TEMPORARY
ONLINE ;


4) Creation of rollback segments

(See Post of Creating Rollback Segment)