Configuring the Oracle database

After the database engine is installed, a database instance must be created and configured as follows:

  1. Enter the dbca command to start the Database Configuration Assistant from $ORACLE_HOME/bin
  2. In step 1 - Welcome select Create a Database and click Next .
    wizard_oracle12_01.png
  3. In step 2 - Create Database select Advanced Mode and click Next .
    wizard_oracle12_02.png
  4. In step 3 - Database Template select Custom Database box, and then click Next .
    wizard_oracle12_03.png
  5. In step 4 - Database Identification enter a name for the new database in the Global Database Name box, if you do not want to use the default name, and then click Next .
    wizard_oracle12_04.png
  6. In step 5 - Management Options configure the Enterprise Manager and consult your DBA as needed. Then click Next .
    wizard_oracle12_05.png
  7. In step 6 - Database Credentials configure the passwords and click Next.
    wizard_oracle12_06.png
  8. In step 7 - Network Configuration click Next.
    wizard_oracle12_07.png

  9. In step 8 - Storage Locations select the Database files Storage Type from the dropdown list and the Use Common location for All Database Files option. Click Next .

    • Consult the Oracle-recommendations for the recommended disk layout.
    • Consult your DBA for any additional required information.
    wizard_oracle12_08.png

  10. In step 9 - Database Options clear all unnecessary components and consult your DBA as needed. Click Next.
    wizard_oracle12_09.png

  11. In step 10 - Initialization Parameters select Typical and allocate the memory.

    Consult the Oracle-recommendations for the recommended memory size.wizard_oracle12_10.png

  12. Select the Sizing tab.
    wizard_oracle12_11.png

  13. Configure the block size and number of background processes.

    Consult the Oracle-recommendations for the recommended block size and background processes.

    Consult your DBA as needed.

  14. Select the Character Sets tab.
    wizard_oracle12_12.png
  15. Select Use Unicode (AL32UTF8) .
  16. In the National Character Set box select UTF8 - Unicode 3.0 UTF-8 .
  17. (Optional) Modify the Default Language and Default Territory if necessary.
  18. Select the Connection Mode tab.
    wizard_oracle12_13.png
  19. Select Dedicated Server Mode.

  20. Click All Initialization Parameters .A table with all initialization parameters and their properties displays in a new window.
    wizard_oracle12_14.png
  21. Click Advanced Parameters to display the complete list.
  22. Modify the values of the parameters as explained in Oracle-recommendations.
  23. Click Close and Next .
  24. In step 11 - Creation Options click Finish . 
    wizard_oracle12_15.png
  25. In step 13 - Summary click Finish if all configuration values are correct.
    wizard_oracle12_16.png
  26. Wait for the database creation process to finish, then click Finish.
    wizard_oracle12_17.png
  27. Click Close.
    wizard_oracle12_18.png

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*