spool dbcrt.log

host date

startup nomount pfile=/opt/oracle/admin/dbname/pfile/initdbname.ora

CREATE DATABASE mynewdb 
  USER SYS IDENTIFIED BY pz6r58+almk
  USER SYSTEM IDENTIFIED BY y1tz5-ptrs7
  LOGFILE GROUP 1 ('/u01/oracle/oradata/mynewdb/redo01.log') SIZE 100M, 
          GROUP 2 ('/u01/oracle/oradata/mynewdb/redo02.log') SIZE 100M, 
          GROUP 3 ('/u01/oracle/oradata/mynewdb/redo03.log') SIZE 100M 
  MAXLOGFILES 5 
  MAXLOGMEMBERS 5 
  MAXLOGHISTORY 1 
  MAXDATAFILES 100 
  MAXINSTANCES 1 
  CHARACTER SET US7ASCII 
  NATIONAL CHARACTER SET AL16UTF16 
  DATAFILE '/u01/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE 
  EXTENT MANAGEMENT LOCAL 
  SYSAUX DATAFILE '/u01/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE 
  DEFAULT TABLESPACE users
  DEFAULT TEMPORARY TABLESPACE temp
    TEMPFILE '/u01/oracle/oradata/mynewdb/temp01.dbf' 
    SIZE 100M REUSE 
  UNDO TABLESPACE undotbs 
    DATAFILE '/u01/oracle/oradata/mynewdb/undotbs01.dbf' 
    SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

CONNECT / as sysdba

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catdbsyn.sql
CONNECT system/y1tz5-ptrs7
@?/rdbms/admin/catdbsyn.sql

REM ***************************************************************************
REM  STEP THREE: Shutdown and bring up in configured mode, and drop
REM              the temporary rollback segment.
REM ***************************************************************************

connect / as sysdba

shutdown immediate

startup  pfile=/opt/oracle/admin/dbname/pfile/initdbname.ora

REM ***************************************************************************
REM ORACLE Tablespace:  TOOLS
REM ***************************************************************************
CREATE TABLESPACE  TOOLS
       datafile '/uo1/oracle/oradata/mynewdb/tools_mynewdb_01.dbf' size 100M reuse
       EXTENT MANAGEMENT LOCAL uniform size 128k;
 
ALTER USER "SYSTEM"  DEFAULT TABLESPACE "TOOLS";
ALTER USER "SYS"  ACCOUNT LOCK;

REM Remove REM from following line to install Java in the database
REM @?/rdbms/javavm/initjvm.sql

spool off

exit

/