Creating an Oracle 9i database from the command line only

Creating a database consists basically of the following things:

*Creating the database's datafiles, its controlfiles and its redo log files.
*Creating the system tablespace
*Creating the system rollback segment
*Creating the data dictionary
*Setting the character set that stores data in the database
*Setting the database time zone

All these steps are executed through the create database sql statement. The location of the control files is specified in the init.ora file.

First, a SID must be defined. This is in order to distinguish several Instances that run on the same machine. The SID's value is stored in the ORACLE_SID environmental Variable:

ORACLE_HOME=/appl/oracle/product/9.2.0.2
export ORACLE_HOME
PATH=$PATH:$ORACLE_HOME/bin

ORACLE_SID=adpdb
export ORACLE_SID

Windows Users will set the variable like so:

set ORACLE_HOME=adpdb;


Note:- To obtain the full article, mail to r.krishnachaitanya@gmail.com