MANUAL DATABASE CREATION THROUGH COMMAND.

 MANUAL DATABASE CREATION THROUGH COMMAND.

*****************************
Directory structure
********************************

mkdir -p /u01/app/oracle/admin/nashim/adump
mkdir -p /u01/app/oracle/admin/nashim/bdump
mkdir -p /u01/app/oracle/admin/nashim/cdump
mkdir -p /u01/app/oracle/admin/nashim/udump
mkdir -p /u01/app/oracle/admin/nashim/pfile/init.ora
mkdir -p /u01/app/oracle/oradata/nashim/


**********************************************************
Make parameter file in /u01/app/oracle/admin/nashim/pfile

file_name=initnashim.ora
***********************************************************
COPY below contents in initnashim.ora

************************************************************

db_name=nashim
instance_name=nashim

db_unique_name=nashim

sga_max_size=400m

sga_target=390m 

control_files='/u01/app/oracle/oradata/nashim/control01.ctl'
background_dump_dest='/u01/app/oracle/admin/nashim/bdump'
user_dump_dest='/u01/app/oracle/admin/nashim/udump'
undo_management=auto
undo_tablespace=undotbs
db_block_size=8192
compatible=10.2.0


orapwd file=/u01/app/oracle/product/10.2.0/db_1/dbs/orapwnashim.ora password=oracle entries=10 

ORACLE_SID=nashim export ORACLE_SID

export $ORACLE_SID=nashim

sql>sqlplus

sql> sys/sys as sysdba

sql>startup nomount pfile='/u01/app/oracle/admin/nashim/pfile/initnashim.ora'

sql>create database nashim
logfile
group 1 '/u01/app/oracle/oradata/nashim/redo01.log' size 20m,
group 2 '/u01/app/oracle/oradata/nashim/redo02.log' size 20m
maxdatafiles 20
datafile '/u01/app/oracle/oradata/nashim/system01.dbf' size 400m
sysaux datafile '/u01/app/oracle/oradata/nashim/sysaux01.dbf' size 300m
undo tablespace undotbs
datafile '/u01/app/oracle/oradata/nashim/undo01.dbf' size 100m
default temporary tablespace temp
tempfile '/u01/app/oracle/oradata/nashim/tem01.dbf' size 30m

sql> @?/rdbms/admin/catproc.sql

sql> @?/rdbms/admin/catalog.sql