Create Database Using DBCA In Oracle 11G

Hello friends today we will explore how to create database in ORACLE 11G using DBCA Command. This is the simplest way to create database in oracle database. Follow below given steps to create database.

First login using oracle system user using GUI Console and then execute dbca command

1

Now Select Create Database

2

Select Type Of Database You want to create

3

Now give Database Name SID name will be same as database name.

4

Select appropriate option

5

Create Listener if you get this Error or Warning

6

Give Password you want 

8

This is just password policy warning can configured as per your need

9

Now Select Database File Location

10

Check file location using File Location Variables

11

Now specify flash recovery area

12

Check if you want sample schema

13

Now give Memory Details etc

14

Click Next

15

Now select Finish

16

Ok

17

Now Installation will start

18

19

Now Select EXIT

20

Now Database is created . You can login to database and verify

21

Now Database is created properly

Comments and suggestion are welcome

Tagged: , , , , , , , , , ,

Leave a comment