Creating the Database in Oracle

You use the Oracle Database Configuration Assistant to create the database for your SIMULIA Execution Engine. The steps provided here are for Oracle 11gR2 databases. Other database products will have different administrative tools to accomplish these tasks.

  1. Access the Database Configuration Assistant using one of the following methods:

    • Windows: Click the Start button, point to All Programs/Oracle - OraDb11g_home1/Configuration and Migration Tools, and click Database Configuration Assistant.

    • Linux: Navigate to the <oracle_install_directory>/bin directory, and execute the dbca file.

    The Welcome message appears.

  2. Click Next.

    The Operations screen appears.

  3. Verify that Create a Database is selected.

  4. Click Next.

    The Database Templates screen appears.

  5. Verify that General Purpose or Transaction Processing is selected.

  6. Click Next.

    The Database Identification screen appears.

  7. Enter the database name in the Global Database Name text box (for example, SEE).

  8. Verify that the database name appears in the SID text box.

  9. Click Next.

    The Management Options screen appears.

  10. Verify that Configure Enterprise Manager is selected.

  11. Verify that Configure Database Control for local management is selected.

  12. Click Next.

    The Database Credential screen appears.

  13. Verify that Use the Same Administrative Password for All Accounts is selected.

  14. Enter the password (for example, seeadmin) in the Password and Confirm Password text boxes.

  15. Click Next.

    The Storage Options screen appears.

  16. Verify that File System is selected.

  17. Click Next.

    The Database File Locations screen appears.

  18. Verify that Use Database File Locations from Template is selected.

  19. Click Next.

    The Recovery Configuration screen appears.

  20. Verify that Specify Flash Recovery Area is selected.

  21. Click Next.

    The Database Content screen appears.

  22. Click Next.

    The Initialization Parameters screen appears.

  23. Verify that the Memory tab is selected.

  24. Do the following:

    1. Verify that the Typical button is selected.
    2. Set the Memory Size to the maximum amount of memory to be used by Oracle. The amount specified depends on the database system’s hardware capabilities and what other applications will be run on the system. A computer dedicated as a database server should allocate all available physical memory, less the operating system requirements, to Oracle. For example, a dedicated Windows server with 4 GB of memory should allocate about 3 GB to Oracle, leaving 1 GB for the operating system.
    3. Verify that Use Automatic Memory Management is selected.

  25. Click the Sizing tab.

  26. Type 300 in the Processes text box.

  27. Click the Character Sets tab.

  28. Click Use Unicode (AL32UTF8).

  29. In the National Character Set list, select the following:

    • Windows: UTF8 - Unicode 3.0 UTF-8 Universal character set

    • Linux: UTF

  30. Click the Connection Mode tab.

  31. Verify that Dedicated Server Mode is selected.

  32. Do the following:

    1. Click Next.

      The Security Settings screen appears.

    2. Click Next.

      The Automatic Maintenance Tasks screen appears.

  33. Click Next.

    The Database Storage screen appears.

  34. Click Next.

    The Create Options screen appears.

  35. Verify that Create Database is selected.

  36. Click Finish.

    A Confirmation message appears.

  37. Click OK.

    A message appears when the database is created.

  38. Make a note of the URL given as the Database Control URL. It is the address you will use to access the Enterprise Manager to create tables and a user account (for example, https://hostname.yourcompany.com:1158/em).

  39. Click Exit.