Creating Single Instance database using DBCA is easiest way to create database in Oracle. Most of the DBA's prefer this tool for database creation. Here we are going to create a single instance database on Oracle 11g Software installed on Unix system. In this post I will give step by step screen shot and their details for creating database using DBCA.
1. Launch DBCA and Choose Database Operation: Launch DBCA by executing dbca command on unix prompt. If DBCA is not executing, Set appropriate Environment variables.
[oracle@database ~] dbca
This is just a welcome screen, User need not to give any input on this other than click on "Next".
Since, We have only Oracle Database S/W installed i.e. no grid Software So we will see only single instance related operations on the welcome screen. Though, Grid Software also has option to create Single instance database.
2. Choose Type of Database: Here, DBA has to choose which type of database he wants to create. There are not so much differences. I am going with default option "General Purpose or Transaction purpose".
Click on "Next" after choosing the database type.
3. Provide Instance Name for Database: Database Instance name is the unique name give to the database on database host machine. i.e. you can't have more than one database with same SID. The length of SID should not be more that 8 characters.
Global Database Name is database name with it's domain name. I choose database name as "newdb" and domain name for organization is oracle.com so the Global Database Name would be "newdb.oracle.com".
4. Database Control Configuration: This step give you detail about configuring database with database control.
Let it be with default option and move forward by clicking "Next".
5. Password for Sys and System user: Provide password for sys, system and DBSNMP user. Make sure you follow Oracle password policy otherwise you will see warning, though you can move forward by bypassing that warning.
I am giving same password for all listed accounts, DBA can easily change these passwords in future if needed.
6. Database Files Location Details: We are using flat file system to store all database related files and "File System" is default storage type chosen. So let's move forward with default option.
Click "Next" button.
7. Provide Recovery Configuration: Database administrator has to provide Database recovery path details in this step. Default location is $ORACL_BASE/fast_revoery_aren. DBA can also enable archive log by clicking "Enable Archiving".
DBA can also change Recovery area size by giving appropriate input into Fast Recovery Area Size text box. I face a small challenge during this step show below.
DBA has to either reduce Fast Recovery Area Size in above input box or get some more free space at provided OS location. Click "Next" after filling these details.
8. Database Content Setting: If you want some sample schema to be installed in your database then click on "Sample Schemas" check box and this will install Human Resources, Order entry and Product Media like schemas into the database.
If DBA has to configure some scripts which automatically run after database creation In that case DBA can give their detail at Custom Scripts tab on this page.
After configuring all these Click on "Next" to move forward.
9. Initialization Parameter Inputs: If you wants to change some initialization parameter like SGA Size, PGA size, Database block size, Number of process, Character set and Connection mode use this GUI to do so. DBA can also change these value after database creation.
Change required parameters or go with default setting and click "Next".
10 Database Storage Summary: This page will show DBA database storage summary, You can expend a tree in the left panel of this Screen. This page doesn't need any input for DBA.
Click "Next" to move forward.
11. Database Creation Options: Here you will find three options Create Database (default), Save as a database Template and Generate Database Creation Scripts.
Create database will create a database only for this time.
Save database template will save this template for future use, In future DBA can use same template for database creation and this template will have all customizations done by Database Administrator.
Generate Database Creation Scripts will create a script for database creation which can can execute manually as well.
Database administrator can chose multiple options at one time or all options as well. Here, I am just creating a database.
Click on "OK" button. Next database creation will start automatically. see below screen.
Database creation will take around 15 to 20 Minutes, Database Administrator can also see the Percentage of work done using above screen. One this process is done you will see a password management screen like below.
If you want's to unlock few uses Click "Password Management" and provide password for user or you can do this manually after database creation. DBA can also see log files for database creation at location given in this screen "/etc/oracle/cfgtoollogs/dbca/newdb". Here You are done with RAC database creation with DBCA.
Now, check if you database is working or not using below unix command. This will list the database running by name newdb.
ps -ef | grep newdb
To create database using DBCA, Database Administrator need GUI access of the system, but in some cases which is not possible. In that situation DBA can use Manual Database Creation Script.
Since DBA has created database, Next step would be configure Listener.ora and Tnsname.ora to access database from outside. DBA can use Quick Steps to Configure Tnsnames.ora and Listener.ora file.
Please share your views about this post.