manually create a new oracle database

using dbca to create a database is preferred approach:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/create002.htm

The following describes MANUALLY creating a new oracle database:

Oracle online doc reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/create003.htm

Reference 2:
Search youtube "Oracle DBA Justin - How to create an 11g Oracle database"
http://www.youtube.com/watch?v=QCYIo2Pkke4

1. Create the database ini file under location "$ORACLE_HOME/database".
    The file name must be "initMydbname.ora". for instance, for database 
    SID(less than 8 characters?) "AWCC", the file would be
    "$ORACLE_HOME/database/initAWCC.ora".

    two mandatory params are "db_name" and "control_files". for example: 
    db_name=AWCC and control_files="/u02/oracle/databae/oradata
    /AWCC/control_01.ctl"

2. create the directories to store database files, this can be anywhere, like:
    mkdir /u02/database/oradata/AWCC

3. set env variables:
    export ORACLE_HOME=Oracel_installation_dir/product/11.x.x/db_1
    export ORACEL_SID=AWCC

4. sqlplus to the database to create, ie, AWCC
    sqlplus / as sysdba

5. startup the database, though it's not created yet!
    SQL>startup;

6. run your create database script (create database AWCC ...) from sqlplus
    SQL>@full_path_to_your_create_db_script;

    After complete successfully, database files would be created, including
    control files(.CTL), log files(.LOG) and data files (.DBF) etc.

7. run two Oracle scripts "catalog.sql" and "catproc.sql" from sqlplus, these
    files are located at $ORACLE_HOME/rdbms/admin

    SQL>@?/rdbms/admin/catalog.sql;
    SQL>@?/rdbms/admin/cataproc.sql;

    ? means $ORACLE_HOME

8. restart your database
    SQL>shutdown;
    SQL>startup;

Warning: these only the steps to create a new Oracle database on the video, not yet tested on a linux machine.