Create DB Scripts

Below is a sample script for creating a dummy database.

CREATE DATABASE dev
   USER SYS IDENTIFIED BY change_on_inst
   USER SYSTEM IDENTIFIED BY sysdev
   LOGFILE GROUP 1 ('/u02/app/oracle/oradata/dev/redo01.log') SIZE 100M,
           GROUP 2 ('/u02/app/oracle/oradata/dev/redo02.log') SIZE 100M,
           GROUP 3 ('/u02/app/oracle/oradata/dev/redo03.log') SIZE 100M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   CHARACTER SET US7ASCII
   NATIONAL CHARACTER SET AL16UTF16
   EXTENT MANAGEMENT LOCAL
   DATAFILE '/u02/app/oracle/oradata/dev/system01.dbf' SIZE 325M REUSE
   SYSAUX DATAFILE '/u02/app/oracle/oradata/dev/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE users
      DATAFILE '/u02/app/oracle/oradata/dev/users01.dbf'
      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/u02/app/oracle/oradata/dev/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs1
      DATAFILE '/u02/app/oracle/oradata/dev/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
   

Run the below after DB is successfully created.

#########
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql
#########