Create Database

We shall create a database in 3 different ways.

1.dbca (Database Configuration Assistant )
2.CREATE DATABASE
3.Automatic creation.

1.dbca

Start Database Configuration Assistant by executing the dbca command on RHEL or OEL machine.

[oracle@localhost ~]$ dbca

• Click on next in welcome page.
• On the Operations page (Step -1), Select create database and then click on next.
• On the Database template page (Step -2), Select General purpose and Transaction Processing.
• On the Database identification Page(Step -3), Enter the database name and SID and the click on next.
• On the Management Options page(Step – 4), Accept the default settings and then click on Next.
• On the Database Credentials page(Step -5), Set the user and password for the database and then click on Next.
• On the Database File Locations page(Step -6), Select “File System” for the Storage Type, Select “Use Database File Locations from Template” for the Storage Locations and then click on Next.
• On the Recovery Configuration page(Step -7), Accept the default settings, and then click on Next.
• On the Database Content page(Step -8), Accept the default settings, and then click on Next.
• On the Initialization Parameters page(Step -9), Select the following options, and then click on Next.
• Memory tab: Select Typical and Use automatic storage management (Provide the Memory Size).
  1.Sizing tab: Accept the default settings.
  2.Character Sets tab: Accept the default settings.
  3.Connection Mode tab: Select Dedicated Server mode. 
  4.On the Database Storage page(Step -10), Accept the default settings and then click on Next.
• On the Creation Options page(Step -11), Select Create Database and then click on Finish.

A Confirmation dialog box opens, review the configuration options and then click on OK.

Click on Exit in the message box that opens when Oracle finishes creating the database.

Connect to Databases

[oracle@localhost ~]$ sqlplus oracleuser@My_New_DB 

2. CREATE DATABASE

1. Specify an Instance Identifier (SID)
2. Ensure That the Required Environment Variables Are Set
3. Choose a Database Administrator Authentication Method
4. Create the Initialization Parameter File
5. Connect to the Instance
6. Create a Server Parameter File
7. Start the Instance
8. Issue the CREATE DATABASE Statement
9. Create Additional Tablespaces
10. Run Scripts to Build Data Dictionary Views Run Scripts to Install Additional Options (Optional)
11. Back Up the Database.
12. (Optional) Enable Automatic Instance Startup