How to create database in oracle 11g using dbca

In Oracle database we can create database using the DBCA command. it will give you graphical interface where you can choose the database template to create the database.

In this article I have created the database on 11gR2 on Linux platform. For creating new database you must have the oracle software installed on that machine. We already installed the 11gR2 64bit software on Oracle Linux 7.9 release and we will share the link at the end of this page if you want to learn the 11g database software installation step by step.

Oracle Database Software Downloads :

You can download the Oracle software from OTN or MOS as per your environment.

OTN: Oracle Universal Installations (OUI) Software download

Create the ASM DISKGROUP for your OEM database – MSDB

$ sudo -iu grid
[sudo] password for <user_id>:
[grid@testserver01 ~]$ cd scripts/
[grid@testserver01 scripts]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 8 09:06:14 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Automatic Storage Management option

SQL> CREATE DISKGROUP OMS_DATA
           EXTERNAL REDUNDANCY
           DISK '/dev/oracle/MSDB_ASM01p1'
           ATTRIBUTE 'AU_SIZE'='1M',
          'compatible.asm' = '11.2.0.2.0',
          'compatible.rdbms' = '11.2.0.2.0';

diskgroup created.

Now go to OEM database OS USER and create OEM repository database on 11GR2 (11.2.0.4.0) for OEM12C

$ sudo -iu omonitor
[sudo] password for <user_id>:
$ bash
bash-4.1$
Make a folder for oracle home directory path.
bash-4.1$ mkdir -p /msdb/db/omonitor11g/11.2.0/db
bash-4.1$ chmod -R 777 /msdb/db/omonitor11g/11.2.0/db

Set the profile parameter

[testserver01 ]$ cat profile_omonitor.stg
export ORACLE_HOME=/msdb/db/omonitor11g/11.2.0/db
ORACLE_SID=msdb; export ORACLE_SID
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
export TMP=$HOME/tmp

[testserver01 ]$ . profile_omonitor.stg

Database creation using DBCA

Run – dbca

select create a Database

Give the database name – here i have given the db name (msdb)

Uncheck the configure enterprise manager and click next.

Use the same administrative password for SYS and SYSTEM account

Password should have minimum 8 character limit.

Here I have select the Oracle-Managed-Files option to create the database files with unique name and OMF will automatically managed the path of database files.

Here you can check the ASM Diskgroup name where you want to create the database files physically.

You can select or leave archive enable checkbox and enable it later.

Click next

Set the custom SGA memory management and set the size as per your system.

Select the character set for your newly created database as mentioned below in the screenshot.

Click next

Click next

Database summary.

Database details.

Database has been created successfully.

Check the database details after login.

[omonitor@testserver01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 31 18:00:12 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> define
DEFINE _DATE	       = "31-JAN-22" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "msdb" (CHAR)
DEFINE _USER	       = "SYS" (CHAR)
DEFINE _PRIVILEGE      = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1102000400" (CHAR)
DEFINE _EDITOR	       = "ed" (CHAR)
DEFINE _O_VERSION      = "Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options" (CHAR)
DEFINE _O_RELEASE      = "1102000400" (CHAR)

SQL> select name,open_mode from v$database;

NAME	  OPEN_MODE
--------- --------------------
MSDB	  READ WRITE

You can click here to learn about Oracle Database 11gR2(11.2.0.4.0) Installation on Oracle Linux Server 7.9 step by step

Please share this Blog with your colleagues or friends. Your suggestions and feedback are very helpful for everyone who come to this site and learn it from oracleocpworld.com.
Please comment here for your any query related to above post. You can email me on : oracleocpworld@gmail.com.