Manual DB creation

###Command##

CREATE DATABASE JOSHI
USER SYS IDENTIFIED BY abc#1234
USER SYSTEM IDENTIFIED BY abc#1234
LOGFILE GROUP 1 ('/u03/oracle/JOSHI/redo01a.log','/u03/oracle/JOSHI/redo01b.log') SIZE 1000M BLOCKSIZE 512,
GROUP 2 ('/u03/oracle/JOSHI/redo02a.log','/u03/oracle/JOSHI/redo02b.log') SIZE 1000M BLOCKSIZE 512,
GROUP 3 ('/u03/oracle/JOSHI/redo03a.log','/u03/oracle/JOSHI/redo03b.log') SIZE 1000M BLOCKSIZE 512
MAXLOGHISTORY 1
MAXLOGFILES 32
MAXLOGMEMBERS 3
MAXDATAFILES 1024
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u03/oracle/JOSHI/system01.dbf' SIZE 800M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SYSAUX DATAFILE '/u03/oracle/JOSHI/sysaux01.dbf' SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TABLESPACE USERS DATAFILE '/u03/oracle/JOSHI/users01.dbf'SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u03/oracle/JOSHI/temp01.dbf'SIZE 200M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE UNDOTBS1 DATAFILE '/u03/oracle/JOSHI/undotbs01.dbf'SIZE 280M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

OR

CREATE DATABASE JOSHI
   USER SYS IDENTIFIED BY ora123$
   USER SYSTEM IDENTIFIED BY ora123$
   LOGFILE GROUP 1 ('+DATA','+FLASH') SIZE 1000M BLOCKSIZE 512,
           GROUP 2 ('+DATA','+FLASH') SIZE 1000M BLOCKSIZE 512,
           GROUP 3 ('+DATA','+FLASH') SIZE 1000M BLOCKSIZE 512
   MAXLOGHISTORY 1
   MAXLOGFILES 16
   MAXLOGMEMBERS 3
   MAXDATAFILES 1024
   CHARACTER SET US7ASCII
   NATIONAL CHARACTER SET AL16UTF16
   EXTENT MANAGEMENT LOCAL
   DATAFILE '+DATA'
     SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
   SYSAUX DATAFILE '+DATA'
     SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
   DEFAULT TABLESPACE users
      DATAFILE '+DATA'
      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '+DATA'
      SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
   UNDO TABLESPACE undotbs1
      DATAFILE '+DATA'
      SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

             On WINDOWS

oradim -NEW -SID test -STARTMODE MANUAL -PFILE E:\pfiletest.ora

startup nomount;
CREATE DATABASE TEST
USER SYS IDENTIFIED BY sys1234
USER SYSTEM IDENTIFIED BY sys1234
LOGFILE GROUP 1 ('E:\test\REDO01.LOG') SIZE 100M,
GROUP 2 ('E:\test\REDO02.LOG') SIZE 100M,
GROUP 3 ('E:\test\REDO03.LOG') SIZE 100M
MAXLOGHISTORY 1
MAXLOGFILES 32
MAXLOGMEMBERS 3
MAXDATAFILES 1024
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
NLS_LENGTH_SEMANTICS CHAR
EXTENT MANAGEMENT LOCAL
DATAFILE 'E:\TEST\SYSTEM01.DBF' SIZE 800M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SYSAUX DATAFILE 'E:\TEST\SYSAUX01.DBF' SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TABLESPACE USERS DATAFILE 'E:\TEST\USERS01.DBF'SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'E:\TEST\TEMP01.DBF'SIZE 200M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE UNDOTBS1 DATAFILE 'E:\TEST\UNDOTBS01.DBF'SIZE 280M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

###Once DB created run below###

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

alter user system account unlock;
connect system/manager;

@?/sqlplus/admin/pupbld.sql

a)catalog.sql =>Creates dictionary tables and views
b)catproc.sql =>Creates PL/SQL procedures,functions and packages necessary.
c)pupbld.sql  =>Creates user profiles.