HOME > > Create 10g OMF Database Manually

Create 10g OMF Database Manually

Anup - Monday, May 25, 2009

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

sap testing said...

I never thought of creating 10g OMF database manually as I find the procedure difficult but I got simple steps on this post to create it. I just followed the given steps and result is creation of the database. I want to thank you for writing this post.

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me