CREATE DATABASE Manually

 CREATE DATABASE  Manually 11G Database
1. Firstly, export Environment Variables. To export EV automatically for every session, do below changes to /DBUNI/.bashrc file:
 export ORACLE_SID=TEST
export ORACLE_HOME=/DBUNI/oracle/product/10.2.0/db_1
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

2. Create parameter file and modify it by setting minimum required parameters:
*.db_name=orcl
*.db_block_size=8192
*.sga_target=1677721600
*.undo_management=’AUTO’
*.control_files = (‘/DBUNI/oracle/product/10.2.0/control01.ctl’)
*.adump=’/DBUNI/oracle/product/10.2.0/adump’
After creation of this parameter file, create below folders in /DBUNI/oracle/product/10.2.0/ directory. Three of them are dump folders (needed for trace files and alert.log file). We’re going to keep Control Files and DataFiles in oradata folder.
-          oradata
-          adump
-          dpdump
-          pfile


3. Create Server parameter file (SPFILE) using this parameter file and STARTUP the instance in NOMOUNT mode.
 CREATE SPFILE FROM PFILE=’/DBUNI/oracle/product/10.2.0/init.ora’;
STARTUP NOMOUNT


Now our instance started, SGA allocated and background processes started

4. To create a new database, use the CREATE DATABASE statement

CREATE DATABASE test
    USER SYS IDENTIFIED BY test
    USER SYSTEM IDENTIFIED BY test
LOGFILE GROUP 1 (‘/DBUNI/oracle/product/10.2.0/oradata/redo01.log’) SIZE 50 m,
    GROUP 2 (‘/DBUNI/oracle/product/10.2.0/oradata/redo02.log’) SIZE 50 m,
    GROUP 3 (‘/DBUNI/oracle/product/10.2.0/oradata/redo03.log’) SIZE 50 m
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET us7ascii
   NATIONAL CHARACTER SET al16utf16
   DATAFILE ‘/DBUNI/oracle/product/10.2.0/oradata/system01.dbf’ SIZE 325 m REUSE EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE ‘/DBUNI/oracle/product/10.2.0/oradata/sysaux.dbf’ SIZE 400 m REUSE
    DEFAULT TABLESPACE tbs_1 DATAFILE ‘/DBUNI/oracle/product/10.2.0/oradata/users.dbf’ SIZE 200m REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
    DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE ‘/DBUNI/oracle/product/10.2.0/oradata/temp_tbs.dbf’ SIZE 20m REUSE
    undo TABLESPACE undotbs DATAFILE ‘/DBUNI/oracle/product/10.2.0/oradata/undo01.dbf’ SIZE 200m REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

 5. Run the scripts necessary to build views, synonyms, and PL/SQL packages
CONNECT / AS SYSDBA
Execute the catalog.sql,catproc.sql and pupbld.sql scripts:
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.
connect /as sysdba
spool dictionary.out
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catblock.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catoctk.sql
@?/rdbms/admin/owminst.plb
@?/javavm/install/initjvm.sql
@?/xdk/admin/initxml.sql
@?/xdk/admin/xmlja.sql
@?/rdbms/admin/catjava.sql
@?/rdbms/admin/catexf.sql
@?/rdbms/admin/catclust.sql

connect SYSTEM/srikanth
spool sqlplus.log
@?/sqlplus/admin/pupbld.sql
@?/sqlplus/admin/help/hlpbld.sql helpus.sql
spool off

spool off


6. Shutdown the instance and startup the database. Your database is ready for use!