REM * --------------------------------------------------------------------------
REM * Program ID  cr_EOM1_db.sql
REM *
REM * Author      Indira Aramandla
REM *
REM * Function    Script to create the a new eom1 database 
REM *

spool cr_eom1_database

REM * Start the eom1 instance (ORACLE_SID here must be set to eom1).
REM *

connect internal
startup nomount pfile=/opt/oracle/admin/reom1/pfile/initeom1.ora

create database eom1
    maxinstances 1
    character set "US7ASCII"
    datafile 	'/ora01/oradata/eom1/system_eom1.dbf'	   size 100M
    logfile group 1 ('/ora01/oradata/eom1/log1a_eom1.rdo',
		     '/ora01/oradata/eom1/log1b_eom1.rdo') size 25M,
	    group 2 ('/ora01/oradata/eom1/log2a_eom1.rdo',
	    	     '/ora01/oradata/eom1/log2b_eom1.rdo') size 25M,
	    group 3 ('/ora01/oradata/eom1/log3a_eom1.rdo',
	    	     '/ora01/oradata/eom1/log3b_eom1.rdo') size 25M
    maxdatafiles 255
    maxlogfiles  16
    maxlogmembers 2
    noarchivelog;

REM * Now run cr_base_tablespaces.sql to create the rest of the database objects
REM Then execute the catproc and catalog scripts

disconnect
spool off