Creating Tablespaces and Defining User Information

You can create tablespaces and define user information by executing the configureTablespaceAndUser command that is included with your SIMULIA Execution Engine installation.

Be sure to execute the command in the following procedure on the computer containing the database (the computer running Oracle).

  1. Log on to the computer that contains the Oracle software.
  2. Verify that you have created the SIMULIA Execution Engine-specific database using the procedure described in Creating the Database in Oracle.
  3. Open a Command Prompt window (terminal window on Linux).
  4. Navigate to the following directory: 

    <SEE_install_dir>/<os_dir>/reffiles/SMAFIPserver/db/oracle/
    where <os_dir> is one of the following:
    • /win_b64/ for Windows 64-bit
    • /linux_a64/ for Linux 64-bit

  5. Based on your operating system, you should perform the following procedure on the computer on which you have installed your Oracle database:

    Note: Before performing the following procedure, make sure that:
    1. If Oracle is not defined in your path or your ORACLE_HOME environment variable is not set, you will have trouble executing the command. Set the necessary system information, or navigate to the <oracle_install_directory>\bin directory, and execute the command from the directory.
    2. It is necessary to ensure that you are connecting to the correct database by setting the ORACLE_SID environment variable to the correct database.

    • Windows: configureTablespaceAndUser.bat SYS_user_pwd db_instance_name default_tablespace_name datafile_name user_name user_pwd

    • Linux: ./configureTablespaceAndUser SYS_user_pwd db_instance_name default_tablespace_name datafile_name user_name user_pwd

    configureTablespaceAndUser script requires exactly 6 arguments in the following sequence:

    • SYS_user_pwd: It is the password for SYS user, that you specified when you created the database instance.

    • db_instance_name: It is the database instance name.

    • default_tablespace_name: It is the name to create default tablespace, for example FIPERTS1.

    • Datafile_name: It is the data file name, for example, see2024.dbf.

    • user_name: It is the user name used to create user, for example, seeadmin.

    • user_pwd: It is the user password for above user seeadmin.

    configureTablespaceAndUser script internally execute configureTablespaceAndUser.sql script to create tablespace and configure user.

  6. Verify the successful execution of command by examining the log file named configureTablespaceAndUser.log gets generated in the same directory of the configureTablespaceAndUser command itself.
  7. Continue to Creating the Database Tables.