How to Create Database using OMF parameter

In this article we are going to discuss How to Create Database using OMF parameter, we don’t need to create a location for Datafile, Controlfile, Tempfile, Redolog file, and RMAN backups, it all managed automatically.

There are three new parameter which is using for making new database.

  • DB_CREATE_FILE_DEST (This parameter defines the location of the default file system directory for datafiles and temporary files)
  • DB_CREATE_ONLINE_LOG_DEST_n (This parameter defines the location for redo log files and control file creation)
  • DB_RECOVERY_FILE_DEST (This parameter defines the location for RMAN backups)

Lets Start Creating omf Database

create some mandatory directory for Database using the below commands, In my case, I’m going to create a database name with Acer.

#mkdir /u01/acer
#mkdir -p /u01/acer/flash_recoevry_area
#mkdir -p /u01/acer/pfile

Create parameter file using OMF Parameters

Create pfile to start OMF database as mansion below.

$vim /u01/acer/pfile/init.ora

db_name=acer
db_block_size=8192
db_cache_size=70m
shared_pool_size=100m
db_create_file_dest=/u01/acer
db_create_online_log_dest_1=/u01/acer
db_recovery_file_dest=/u01/acer/flash_recovery_area
db_recovery_file_dest_size=2g
compaible=11.2.0.3
remote_login_passwordfile=exclusive

Now export your ORACLE_SID using the export command. After that login to your Database using sys user, using the below commands.

$export ORACLE_SID=acer
$sqlplus sys/sys as sysdba

STARTUP NOMOUNT

start your database nomount using below command.

startup nomount pfile=/u01/acer/pfile/init.ora;

Now run the CREATE DATABASE command, once you run this command all Datafiles, Controlfiles, and Redo log files will be created automatically.

create database;

Now run catalog and catproc command for creating pl/sql objects and permissions.

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

Now your OMF Database has been created successfully, it is ready to use. But EM (Enterprise Manager) and Listener not configured right now. Configured as per your requirement.

I hope you enjoyed How to Create Database using OMF parameter article, if yes please write in comment box.

ReadHow to create manually Database Click Here.

Connect with me on:

Instagram: https://www.instagram.com/shripaldba
Linkedin: 
https://www.linkedin.com/in/shripal-singh
Twitter: 
https://twitter.com/ocptechnology
Facebook: 
https://www.facebook.com/ocptechnology
YouTube:
https://www.youtube.com/ocptechnology

1 thought on “How to Create Database using OMF parameter”

Leave a Comment

%d bloggers like this: