Creating Tablespaces and Defining User Information

Using the Oracle Enterprise Manager web-based console, you need to create a tablespace for the SIMULIA Execution Engine data and define the user that will access the database.

  1. Log on to the computer that contains the Oracle software.

    Although you can access the database from any computer on your network using a web browser, this procedure is written assuming that you are directly accessing the system running Oracle.

  2. Verify that you have created the SIMULIA Execution Engine-specific database using the procedure described in Creating the Database in Oracle.

    You must create a database following these steps to ensure that the database contains the correct internal settings.

  3. Access the database with the Oracle Enterprise Manager, using one of the following methods, based on your operating system:

    • Windows: Click Start, point to All Programs, Oracle - OraDb11g_home1, and click Database Control - SEE. (In this example, SEE is the name of the database you are accessing.)

    • Linux: Use a browser to open the following page:

      https://hostname.yourcompany.com:portnumber/em

    For more information about determining the port number for your database, see About Oracle URLs and Port Numbers.

  4. Type SYS as the user name in the corresponding text box, and enter the password you specified when you created the database.

  5. From the Connect As list, select SYSDBA.

  6. Click Login.

  7. Verify that you have accessed the correct database.

    The screen that appears after you log in shows the database name next to the Database Instance string (in the upper left corner of the screen).

  8. At the top of the console, access the Server information (Oracle 11gR2), and click Server.

  9. In the Storage list, click Tablespaces.

    The Tablespaces page opens.

  10. On the right side of the console, click Create.

    The Create Tablespace page appears.

  11. In the Name text box, type the following:

    FIPERTS1

  12. Click Set as default permanent tablespace.

  13. In the Datafiles area, click Add.

    The Add Datafile page appears.

  14. In the File Name text box, type the following entry:

    FIPERDF1.DBF

  15. In the File Size text box, type 2048, and verify that MB is selected from the corresponding list.

  16. Click Automatically extend datafile when full (AUTOEXTEND).

  17. In the Increment text box, type 100, and select MB from the corresponding list.

  18. In the Maximum File Size area, verify that Unlimited is selected.

  19. Click Continue.

    The Create Tablespace page appears.

  20. Click OK.

    A message appears indicating that the object was created successfully.

  21. At the top of the left side of the console, click Database Instance.

    The Server page appears.

  22. In the Security list, click Users.

    The Users page appears.

  23. Click Create.

    The Create User page appears.

  24. In the Name text box, type seeadmin.

  25. From the Profile list, verify that DEFAULT is selected.

  26. In both the Enter Password and Confirm Password text boxes, type the password for the seeadmin user (you can use seeadmin for simplicity, if desired).

  27. Click the icon adjacent to the Default Tablespace text box.

    The Search and Select window appears.

  28. Verify that FIPERTS1 is selected.

  29. Click Select.

    You are returned to the Create User page.

  30. Click Roles.

  31. On the right side of the console, click Edit List.

    The Modify Roles screen appears.

  32. From the Available Roles list, select Resource.

  33. Click Move to move the role to the Selected Roles list.

  34. Click OK.

    You are returned to the Create User page.

  35. Click Object Privileges.

  36. From the Select Object Type list, select View, and click Add.

  37. Click the icon adjacent to the Select View Objects text box.

    The Select View Objects window appears.

  38. From the Schema list, select SYS.

  39. In the Search View Name text box, type the following entry:

    DBA_PENDING_TRANSACTIONS

  40. Click Go.

    The object is now listed at the bottom of the window.

  41. Click DBA_PENDING_TRANSACTIONS, and click Select.

    The Add View Objects Privileges page appears.

  42. In the Available Privileges list, click Select.

  43. Click Move to move the item to the Selected Privileges list.

  44. Click OK.

    You are returned to the Create User page.

  45. Click OK.

    A message appears indicating the object was created successfully.

  46. In the top right corner of the console, click Logout to exit the Enterprise Manager.

  47. Proceed to Updating the Database.