Tips for Oracle DBA: DBCA

Create Oracle Database with DBCA (4/4)

Create Oracle Database with DBCA (1/4)
Create Oracle Database with DBCA (2/4)
Create Oracle Database with DBCA (3/4)
Create Oracle Database with DBCA (4/4) [You are here]

17. If you tick Save as a Database Template, the text time you visit DBCA those above configuration will be retain under the template name call edba01.
If you tick Generate Database Creation Scripts then Oracle will create CREATE DATABASE scripts with all database base objects creation scripts in /u01/app/oracle/admin/edba01/scripts
Click Finish to start creation.

18. An pop pup Confirmation of summary of our request of creation template and database scripts, click OK to acknowledge.

19. A pop up windows appear tell us that our template is sucesfully created, click Ok to acknowledge.

20. A pop up windows appear tell us that our CREATE DATABASE scripts are sucesfully created, click Ok to acknowledge.

21. Database is start creation process.

22. Database is created.

Ok now we have one Oracle Database created.

Create Oracle Database with DBCA (1/4)
Create Oracle Database with DBCA (2/4)
Create Oracle Database with DBCA (3/4)
Create Oracle Database with DBCA (4/4) [You are here]

Create Oracle Database with DBCA (3/4)

Create Oracle Database with DBCA (1/4)
Create Oracle Database with DBCA (2/4)
Create Oracle Database with DBCA (3/4) [You are here]
Create Oracle Database with DBCA (4/4)

12. I am installing all available components, even though I do not need them, I just install, tick all components and click Next to continue.

13. Leave the memory,sizing, character sets connection mode setting to default.
click Next to continue.

14. Choose Keep the enhanced 11g default security settings, and click Next to continue.

15. Tick Enable automatic maintenance tasks and click Next to continue.

16. Click Next to continue.

Create Oracle Database with DBCA (1/4)
Create Oracle Database with DBCA (2/4)
Create Oracle Database with DBCA (3/4) [You are here]
Create Oracle Database with DBCA (4/4)

Create Oracle Database with DBCA (2/4)

Create Oracle Database with DBCA (1/4)
Create Oracle Database with DBCA (2/4) [You are here]
Create Oracle Database with DBCA (3/4)
Create Oracle Database with DBCA (4/4)

6. SID is Oracle database unique identifier, if in 1 of your server you have more than 1 oracle database SID is use to identify which database you are try to use.

In this example I name the database edba01 and then click Next to continue.

7. Untick the Configuration Enterprise Manager and click Next to continue

8. SYS and SYSTEM are default orace super user, we tick Use the Same Administrative Password for All Accounts.and click Next to continue.

9. We are using File System to store our datafiles, choose File System and click Next to continue.

10. Choose Use Common Location for All Database Files and fill in /datafiles/edba01
Click Next to continue.

11. Set Flash Recovery Area to /datafiles/edba01/flash_recovery_area and untick Enable Archving. Click Next to continue.

Create Oracle Database with DBCA (1/4)
Create Oracle Database with DBCA (2/4) [You are here]
Create Oracle Database with DBCA (3/4)
Create Oracle Database with DBCA (4/4)

Create Oracle Database with DBCA (1/4)

Create Oracle Database with DBCA (1/4) [You are here]
Create Oracle Database with DBCA (2/4)
Create Oracle Database with DBCA (3/4)
Create Oracle Database with DBCA (4/4)

DBCA is stand for Database Configuration Assistant, is Oracle utility is part of Oracle software that we install previously.
DBCA wizard GUI to create Oracle database, there are two method of creating Oracle Database, the other method is using SQLPlus command line with CREATE DATABASE command.

Now before I begin to create database, I will create a directory where I will store whole set of my database files.

1. I am creating /datafiles/edba01 to store all my database files.

mkdir -p /datafiles/edba01
chwon -R oracle:dba /datafiles
chmod -R 750 /datafiles