How To Create Oracle Database Using DBCA tool

Oracle Database

After installing the oracle database software’s we need to create oracle database to start with our tasks. Here to achieve the same we will use the DBCA ( Database Configuration Assistant) tool to create oracle database instance . After installing the Oracle database software’s ¬†we can follow below mentioned steps to create a new database.

dbca tool will be available in environment variables itself after Oracle database installation or at $ORACLE_HOME/bin/dbca location.

Please follow below steps to create a new DB instance.

cd to $ORACLE_HOME/bin/ and run ./dbca to start the database configuration Assistant wizard .

Database Configuration Assistant Screen

Select general purpose database like below screenshot

Database Configuration Assistant Screen

Show details screen shall show details like below screenshot

Database Configuration Assistant Screen

Provide the database name and SID, you can keep both same.

Database Configuration Assistant Screen

If you want to configure EM console then select the check mark for configure Enterprise Manager

Database Configuration Assistant Screen

If automatic maintenance tasks needs to be enabled then select the check box.

Database Configuration Assistant Screen

Provide the passwords for the user. It can be assigned individually or at a bulk.

Database Configuration Assistant Screen

You can choose other types of storage or can keep the default one.

Database Configuration Assistant Screen

After clicking on the File Location Variables make sure all the parameters are correct.

Database Configuration Assistant Screen

If you are unsure about the recovery area, you can keep the fast recovery area default.

Database Configuration Assistant Screen

In case of any ©Copyright or missing credits issue please check CopyRights page for faster resolutions.

Leave a Reply