1 - 2 minutes readCreate 10g OMF Database Manually

Step 1

Create a initSID.ora(Example: initTEST.ora) file in $ORACLE_HOME/dbs/ directory.

Example: $ORACLE_HOME/dbs/initTEST.ora

Put following entry in initTEST.ora file

##############################################################

background_dump_dest=<put BDUMP log destination>

core_dump_dest=<put CDUMP log destination>

user_dump_dest=<put UDUMP log destination>

control_files = (/<Destination>/control1.ctl,/ <Destination>/control2.ctl,/ <Destination>/control3.ctl)

undo_management = AUTO

undo_tablespace = UNDOTBS1

db_name = test

db_block_size = 8192

sga_max_size = 1073741824

sga_target = 1073741824

db_create_file_dest = /<Put DB File Destination> #OMF

db_create_online_log_dest_1 = /<Put first redo and control file destination> #OMF

db_create_online_log_dest_2 = /<Put second redo and control file destination> #OMF

db_recovery_file_dest = /<put flash recovery area destination> #OMF

################################################################

Step 2 Create a password file

$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/pwd<sid>.ora password=<password> entries=5

Step 3 Set your ORACLE_SID

export ORACLE_SID=test

export ORACLE_HOME=/<oracle home path>

Step 4 Run the following sqlplus command to connect to the database and startup the instance.

sqlplus ‘/ as sysdba’

SQL> startup nomount

Step 5 Create the database

create database test

character set WE8ISO8859P1

national character set utf8

undo tablespace undotbs1

default temporary tablespace temp;

Step 6  Run catalog and catproc

@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql