Manual creation of Database

In LINUX:

Create folders for Admin log files

$ cd /app/oracle/admin/<db_name>/   -(Example db_name = xyz)

$ cd /app/oracle/admin/xyz

$ mkdir adump cdump bdump dpdump pfile udump script

Create/modify init.ora file under pfile

Modify the following parameters in init.ora file according to your need

db_name, background_dump_dest,core_dump_dest,user_dump_dest , control_files , db_recovery_file_dest , audit_file_dest, SERVICE

Create folders for physical files ( Datafiles, Redofiles, Controlfiles,etc.,)

$ cd  /app/oracle/oradata/<db_name>                

(Example db_name=xyz)

$ mkdir xyz

Create the password for the database

$ cd /app/oracle/product/10.2.0/dbs/

$ export  ORACLE_SID=<db_name>

$ orapwd  file=oraxyzpw  password=xyz  entries=3  force=y

Connect to SQLPLUS

$ sqlplus  /nolog

connect  sys  as sysdba

Password:  xyz

Startup the Instance

startup pfile=’/app/oracle/admin/<db_name>/pfile/init.ora ‘ nomount

Create database script(Createdb.sql) under script directory

(/app/oracle/admin/<db_name>/script)

@/app/oracle/admin/<db_name>/script/dbcreate.sql

select username from dba_users;

select tablespace_name from dba_tablespaces;

@/app/oracle/product/10.2.0/rdbms/admin/catalog.sql

@/app/oracle/product/10.2.0/rdbms/admin/catproc.sql

select username from dba_users;

select tablespace_name from dba_tablespaces;

Note: Please ensure that the name given in init.ora file and database creation script are same.