Manual db creation

1.create spfile/pfile
2.startup nomount
3.Run below script (change the file names depends on your environment)

CREATE DATABASE DB_NAME
   USER SYS IDENTIFIED BY avery123
   USER SYSTEM IDENTIFIED BY avery123
   LOGFILE GROUP 1 ('/oradata/data/oracle_dev/NOTL01UD/datafile02/redo01.log') SIZE 100M,
           GROUP 2 ('/oradata/data/oracle_dev/NOTL01UD/datafile02/redo02.log') SIZE 100M,
           GROUP 3 ('/oradata/data/oracle_dev/NOTL01UD/datafile02/redo03.log') SIZE 100M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET WE8ISO8859P1
   DATAFILE '/oradata/data/oracle_dev/NOTL01UD/datafile01/system01.dbf' SIZE 500M REUSE
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE '/oradata/data/oracle_dev/NOTL01UD/datafile01/sysaux01.dbf' SIZE 500M REUSE
   DEFAULT TABLESPACE USERTBS datafile '/oradata/data/oracle_dev/NOTL01UD/datafile01/usertbs01.dbf' size 500M
   DEFAULT TEMPORARY TABLESPACE TEMP
      TEMPFILE '/oradata/data/oracle_dev/NOTL01UD/datafile01/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE UNDOTBS
      DATAFILE '/oradata/data/oracle_dev/NOTL01UD/datafile01/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

4 Run below scripts for data dictionary tables creation

@/u01/oracle/rdbms/admin/catalog.sql
@/u01/oracle/rdbms/admin/catproc.sql


Comment me if you find this post is useful also let me know if you need any new topics.