Monday, July 3, 2017

Creating Oracle Database using DBCA in 12cR2

Database Configuration Assistant (dbca) is an Oracle provided tool to create a new database. In this document I would explain how to create a new 12cR1 database using dbca. For database creation steps for Oracle 12cR1, follow this document. Steps and screens are almost same for other Oracle database versions and different OS platforms.

If you are on windows, invoke dbca from start menu.

For Linux based systems, execute “dbca” from command prompt to initiate the dbca.
From first screen, ee want to create a new database, so click next.

I am selecting “Advance configuration” here to explain the whole process thoroughly.

Select the type of database you want to create. I am selecting default which is “General Purpose or Transaction Processing” database. If you want to create a cluster database, select this option from the drop down menu “Database type”.

Provide global database name and SID. Also select if you want this to be a container database to have one or more pluggable databases in it. In 12cR2, there is also an option to have local undo tablespaces for pluggable databases. Select this option if you want to have local undo tablespaces for your pluggable databases.  Click next.

Select the storage for database files. I am selecting ASM here as I already have an AMS diskgroup "DATA" configured. Click next.

Select if you want to enable archiving and also specify fast recovery area, if you wish so. Both of these options can also be configured later. Click next.

If you already have a default listener configured it will be selected automatically, otherwise you can also create a new listener during database creation.

Select if you want to configure Oracle Database Vault and/or Oracle Label Security.

Specify how you want to allocate the memory for the database, and also how much you want to allocate. There are also a few tabs on this screen. Sizing tab lets you set value for Process parameter and block sizing. From Character sets tab you can select character set and national character set for the database. Connection mode tab lets to configure shared server connection mode or dedicated (default) connection mode. On Sample schema tab you can select to install sample schemas in the database. Click next.

Select if you want to configure OEM database express. Otherwise, you can also
configure OEM Express Database manually after creation of the database.

Provide privileged accounts’ passwords. I am selecting same password option for all admin accounts. Click next.

On this screen, along with the database creation, you can also choose to save current configuration as a template to be used later for the creation of a database, and/or you can also create database creation scripts for manual database creation on the same server or any other server. Click next

Click finish button to start database creation.

Monitor the progress screen. Once completed, click close button. Database has been created. Set ORACLE_SID in .bash_profile file according to the database SID.

No comments:

Post a Comment