To Create a Database

To create an Oracle database, use the Oracle Database Configuration Assistant utility.

1. Start the utility using the dbca command:

   dbca

2. On the Welcome screen, click Next.

3. On the Step 1 screen (Operations), select the Create a Database radio button and click Next.

4. On the Step 2 screen (Database Templates), select the General Purpose radio button and click Next.

5. On the Step 3 screen (Database Identification), specify a Global Database Name and a System Identifier (SID) for the database and click Next.

   For the Global Database name, specify soar followed by a domain name, as in soar.mydomain.mycompany.com.

   For the SID, specify soar.

6. On the Step 4 screen (Management Options), accept the default settings and click Next.

   The Configure the Database with Enterprise Manager checkbox is selected, and the Use Database Control for Database Management radio button is selected.

7. On the Step 5 screen (Database Credentials), select the Use the Same Password for All Accounts radio button, type a password of your choice in the text fields, and click Next.

8. On the Step 6 screen (Storage Options), accept the default settings and click Next.

   The File System radio button is selected.

9. On the Step 7 screen (Database File Locations), accept the default settings and click Next.

   The Use Database File Locations from Template radio button is selected.

10. On the Step 8 screen (Recovery Configuration), accept the default settings and click Next.

    The Specify Flash Recovery Area checkbox is selected, and default values are filled in for the two fields.

11. On the Step 9 screen (Database Content), accept the default settings and click Next.

    The Sample Schemas checkbox is not selected.

12. On the Step 10 screen (Initialization Parameters), select the Character Sets tab.

13. Select the radio button labeled “Choose from the list of character sets”, then select UTF8 from the menu.

14. At the bottom of the Step 10 screen, select the All Initialization Parameters radio button.

15. In the All Initialization parameters dialog, scroll to the open_cursors parameter.

16. Change the value to 3000 and click Close.

17. Click Next.

18. On the Step 11 screen (Database Storage), click Next.

19. On the Step 12 screen (Creation Options), accept the default selection of Create Database and click Finish.