Step To Create Oracle Database Using DBCA

If you choose to install software only and later create a database, or if you want to create additional databases using the release software that you just installed, you can do so by using the Database Configuration Assistant (DBCA).

Follow the steps below to create a database:

- Log onto your computer as a member of the administrative group that is authorized to install Oracle software and create and manage the database.
- Launch the DBCA on a Windows operating system as follows :                           Start > Programs > Oracle - home_name > Configuration and Migration Tools >DatabaseConfigurationAssistant
- The Welcome page appears. 
- Select Create a Database on the Operations window to begin an interview that enables you to configure and create a database.
- On the Database Templates page, select the type of database template to be used in creating the database. You can click Show Details to see the configuration for each type of database. Choose the template suited to the type of workload your database will support. If you are not sure, select the default General Purpose template.
- On the Database Identification page, enter the Global Database Name and SID. 
- The Management Options page appears. To use Enterprise Manager, select Configure the Database with Enterprise Manager. Select Use Database Control for Database Management to manage your database locally or select Use Grid Control for Database Management as appropriate to your configuration.
- Enter passwords for the administrative users.
- Select File System, Automatic Storage Management, or Raw Devices as appropriate to your environment.
- Specify the location for the creation of the datafiles. Choose one of the following:Use Database File Locations from Template, Use Common Location for All Database Files, or Use Oracle-Managed Files.
- Select Flash Recovery Area and specify a directory location and size. Select Enable Archiving to place your database in ARCHIVELOG mode.
- Click the Sample Schemas tab. Select Sample Schemas if you want to include the Sample Schemas (EXAMPLE) tablespace in your database. Click the Custom Scripts tab.
- Specify one or more SQL scripts to be run after your database is created if required in your environment. Otherwise, accept the default No scripts to run.
- The Memory page appears. Select Typical and enter a percentage value. Click the Sizing tab. - The Sizing page appears. Specify the smallest block size and the maximum number of operating system user processes that can simultaneously connect to the database. 
- The Character Set page appears. Select the character set for your database. Click the Connection Mode tab.
- The Connection Mode page appears. Select Dedicated Server or Shared Server as appropriate for your environment.
 - The Database Storage page appears. Accept the configuration or make changes as needed.
 - Select Create Database to create your database. You can also select Save as a Database Template to save your configuration. Click Finish.
 -  At the Confirmation window, confirm the options that will be installed and click OK.
 - Your database is now being created.

People who read this post also read :


Twitter Delicious Facebook Digg Stumbleupon Favorites More