Editing the CREATEDB18.SQL Script

You must edit the CREATEDB18.SQL script to so that the database has:

• sufficient maxinstances.

• sufficient maxlogfiles.

• different logfiles for each Oracle instance.

• a different thread for each Oracle instance.

Example: Original CREATEDB18.SQL

The following is an unmodified CREATEDB18.SQL file.

create database   <SID>
    maxdatafiles  1021
    maxinstances  1
    maxlogfiles   8
    maxlogmembers 4
    CHARACTER SET WE8ISO8859P15
    NATIONAL CHARACTER SET AL32UTF8
0240K MAXSIZE UNLIMITED<SID>/system01.dbf' SIZE 2000M REUSE AUTOEXTEND ON NEXT⇒
 1EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oradata/<SID>/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON
NEXT  10240K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/oradata/<SID>/temp01.dbf' SIZE
20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITEDSID>/psundots01.dbf' SIZE 300
LOGFILE GROUP 1 ('/u01/oradata/<SID>/redo01.log') SIZE 100M,
        GROUP 2 ('/u01/oradata/<SID>/redo02.log') SIZE 100M,
        GROUP 3 ('/u01/oradata/<SID>/redo03.log') SIZE 100M;

Example: CREATEDB18.SQL Modified for RAC

The following is an example of a CREATEDB18.SQL used for setting up Oracle RAC.

create database   RAC
   		 maxdatafiles  1021
    		maxinstances  2
   		 maxlogfiles   8
    		maxlogmembers 4
    		character set WE8ISO8859P15
   	 datafile
       		 '/dev/did/rdsk/rlv_system'      size 350M
SYSAUX DATAFILE '/dev/did/rdsk/rlv_sysaux' SIZE 500M
UNDO TABLESPACE PSUNDO1 DATAFILE '/dev/did/rdsk/rlv_psundo1' SIZE 300M   
maxinstances  2
	    logfile
       		 '/dev/did/rdsk/rlv_log1'         size 190M,
       		 '/dev/did/rdsk/rlv_log2'         size 190M;
   	 alter database add logfile thread 2
       		 '/dev/did/rdsk/rlv_log3'         size 190M,
       		 '/dev/did/rdsk/rlv_log4'         size 190M;
   	 alter database enable thread 2;