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 19c 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, select Programs (or All Programs) /Oracle - OraDB19Home1/ Configuration and Migration Tools, and click Database Configuration Assistant.

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

  2. From the Database Operation screen, verify that Create a Database is selected.
  3. Click Next.
  4. Select Advanced Configuration from the Creation Mode screen.
  5. Click Next.

    The Database Deployment Type screen appears.

  6. Verify that General Purpose or Transaction Processing is selected.
  7. Click Next.

    The Database Identification screen appears.

  8. Enter the database name in the Global Database Name text box (for example, SEE).
  9. Verify that the database name appears in the SID text box.
  10. Verify that Create As Container Database is not selected.
  11. Click Next.

    The Storage Options screen appears.

  12. Verify that Use template file for database storage attributes is selected.
  13. Click Next.

    The Fast Recovery Option screen appears.

  14. Verify that Specify Fast Recovery Area is selected.
  15. Verify that File System is selected as Storage Type for Recovery files storage type.
  16. Provide valid directory path for Fast Recovery Area.
  17. Click Next.

    The Database Options screen appears.

  18. Click Next.

    The Network Configuration screen appears.

  19. Select the default listener for the database instance.

    You might also create the new listener from the same Network Configuration screen by selecting option Create a New Listener and providing Listener Name and Listener Port.

  20. Click Next.

    The Data Vault Option screen appears.

    Verify that all options on this screen are not selected.

  21. Click Next.

    The Configuration Options screen appears.

  22. Verify that the Memory tab is selected.
  23. Depending on your system environment, select Use Automatic Memory Management or Use Automatic Shared Memory Management option:
    Note: If the total physical memory of a database instance is greater than 4 GB, then you cannot specify the Automatic Memory Management option during the database installation and creation. Oracle recommends that you use Automatic Shared Memory Management in such environments. For more information, see https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-0F348EAB-9970-4207-8EF3-0F58B64E959A
  24. Click the Sizing tab.
  25. Type 300 in the Processes text box.
  26. Click the Character Sets tab.
  27. Click Use Unicode (AL32UTF8).
  28. Verify that the UTF8 - Unicode 3.0 UTF-8 Universal character set, CESU-8 compliant is selected as National Character Set.
  29. Click the Connection Mode tab.
  30. Verify that Dedicated Server Mode is selected.
  31. Click Next.

    The Management Options screen appears.

  32. Verify that Configure Enterprise Manager (EM) Database Express is selected.
  33. Change the EM Database Express Port if required.
  34. Click Next.

    The User Credentials screen appears.

  35. Verify that Use the Same Administrative Password for All Accounts is selected.
  36. Enter the password of your choice in the Password and Confirm Password area.
  37. Click Next.

    The Creation Option screen appears.

  38. Verify that Create Database is selected.
  39. Click All Initialization Parameters.
    The default value of the open_cursors parameter is 300. This might or might not be sufficient, depending on the load on your database server. If necessary, modify the value of the open_cursors parameter as appropriate.
    Note: After database instance creation, you can change the value of the open_cursors parameter by running the following SQL command using the SYSDBA role

    "alter system set open_cursors = [number of open cursors] scope=both;"

    and restarting the database instance.

    For more information about the open_cursors parameter, see the Oracle documentation https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/OPEN_CURSORS.html#GUID-FAFD1247-06E5-4E64-917F-AEBD4703CF40

  40. Click Next.

    After the automatic Pre Requisite Check is done, the Summary screen appears.

  41. Verify the correctness of the values in the Summary screen.
  42. Click Finish.

    The Finish screen appears.

    A message "Database creation complete" appears when the database is created.

  43. Make a note of the URL given as EM Database Express URL (for example, https://hostname.yourcompany.com:5500/em). It is the address you will use to access the Enterprise Manager to perform administrative tasks such as managing user security and managing database memory and storage. You can also view performance and information about your database.
  44. Click Close.