One can easily create a database using a DBCA as it provides the following advantages:-
It provides the necessary templates for defining and configuring a database which the other methods might not provide.
Customization can be a lot easier to do and manage using a DBCA.
One need not install the features that we are going to use but it is automatically done during the installation.
The steps to create a database is as follows:-
Step 1:-
Open the command prompt and type dbca and press enter.
One can see a screen which popups as shown in Fig 5.1.
Step 2:
One gets an option to create a database by default options or advanced options.
We need to choose the advanced options in the forthcoming steps.
Step3:
Choose the templates for the database to be created. One should choose the custom templates for the database creation .Please refer to Fig 5.2
- Fig 5.1
- Fig 5.2
Step 4:
In the next step the process will ask you to enter the global database name and the SID. You can enter both and can proceed to the next step.
Step5:
In the next step ,the installation process will ask you how do you want to manage the database ie:-
Configure Enterprise Manager (EM) Database Express
Register with Enterprise Manager (EM) Cloud Control
- Fig 5.3
Step 6:
In the next step you need to set the credentials. There are two approaches for the same.
Either you can different passwords for different users created with the database or we can have a common password for all the users.
The choice is with the user creating the database.
We recommend you to use different passwords for different users which is much more secure.
Step 7:-Step 7:-
The next step is to register the database with a listener .There are two approaches for the same.
One can register a new listener.
You can use the existing listener.
Step 8:
The next step is to choose the storage mechanism .There are two approaches for the same:-
File system –All the datafiles are stored in the formatted drives attached
Automatic Storage system
Step 9:-
The next step is to choose the places where you want to store the files where be default the system chooses the locations or one can browse and upload the specified location.
Step10:-
In this the initialization parameters need to be set.
We need to set the typical settings and the custom settings, like the size tab, block size ,modifying the character set ,setting the connection mode.
- Fig 5.4
The initialization parameters make you to adjust certain changes as shown in
Fig 5.4 and fig 5.5 and do the initial settings and set the requirements for a database.
- Fig 5.5
Step 11:-
The next step is customizing the storage for all the datafiles stored so that the files are stored across multiple mount points as shown in Fig 5.6
Step 12:-
Click the close button when has finished the customizing of the file system.
Step 13:-
The next step is to decide whether you need to save the current database parameters as a template for future use so that the same procedure need not be repeated.
Step 14:
When one click on next the next screen shows the summary screen where the entire summary is shown .Click on Finish to complete the process and Exit the DBC
- Fig 5.6