Space banner This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

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 Disk Layout topic 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 Memory Management topic 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 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-database-initialization-parameters .
  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*