Database Creation

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 ;