Create database using dbca

[root@testdb1 ~]#  mkdir -p /holding/testdb1/archive_logs

[root@testdb1 ~]# chown oracle:oinstall /holding/testdb1/archive_logs

[oracle@testdb1 ~]$ /opt/oracle/product/11.2.0.3/bin/dbca


Click "Next Button"

Select "Create a Database" and Click "Next" Button

Choose the Template and Click "Next" 

provide Global Database name and SID, and Click "Next"
Click "Next"

Provide Administrative Password and Clieck "Next"

Specify Storage type and Locations for database files and Click "Next". Here I have chosen ASM as Storage Type.

Select the Disk Group Name where you would like to install a database and Click "OK".

Click "Next" 

Specify ASMSNMP Password specific to ASM and click "OK".

Choose the recovery options for the database and click "Next". 

Show the Archive logs location and click "OK".

Click Sample Schemas if you want sample schemas in the database and click "Next"

Click Tab Sizing and provide the maximum number of operating system user processes. Here I have choosen the default which is 150.

Click Character Sets and Choose database character Set.

Click Connection Mode Tab and choose the connection Mode and Click "Next". 

Click "Next". 

Select the Database Creation Option and Click "Finish". 

Click "OK". 





Click Exit.
Comments