Manually Creating an Oracle Database

I think ,many one of you have already have created your database by dbca. DBCA is a bery good graphical tool by which you can create your database. You can also create your database manually.
In 10g I want to show how easily you can create database.

I want to show an example of Unix environment.

1)Set your ORACLE_SID.
export ORACLE_SID=arju
2)Create the Initialization Parameter File.
touch $ORACLE_HOME/dbs/initarju.ora
3)Edit the Initialization Parameter File.
Just entry,
db_name=arju
db_create_file_dest='/oradata'
4)Connect to the Instance.
sqlplus / nolog
conn / as sysdba
5)Create database
startup nomount
create database;
6)Run Scripts to Build Data Dictionary Views
CONNECT / AS SYSDBA
@/u01/oracle/rdbms/admin/catalog.sql
@/u01/oracle/rdbms/admin/catproc.sql

7)Back Up the Database.

In this example I have created database with pfile. If you want to create database manually by spfile then create an spfile after step 5 as SQL>CREATE SPFILE FROM PFILE;

Related Documents
Create the Data Dictionary in Oracle