Updating the Database

You must update your database to verify that it will run correctly with the SIMULIA Execution Engine. To update the database, you need to log in as a sysdba and execute several grant commands.

  1. Open a Command Prompt dialog box (terminal window on Linux).

  2. If you are updating a database that is running on a Linux system, verify that the ORACLE_SID environment variable is set to the correct database.

  3. Execute the following command to connect to Oracle’s SQLPlus utility, where <password> is the sys user password specified during database creation: 

    sqlplus sys/<password> as sysdba

    If you followed the instructions in Creating the Database in Oracle to create the database, this password is probably seeadmin.

    Note: 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. If you have more than one database running on your system, it may be necessary to set the ORACLE_SID environment variable to ensure that you are connecting to the correct database.

    You are connected to the SQLPlus utility.

  4. Execute the following commands by typing each command individually and pressing the Enter key: 

    grant select on pending_trans$ to public;
grant select on dba_2pc_pending to public;
grant select on dba_pending_transactions to public;
grant execute on dbms_system to seeadmin;

    Note: The seeadmin user name in the last command refers to the Oracle user account that was defined when the database was created. Be sure that your database uses the same user name or substitute the appropriate user name in this command.

  5. Type exit to close the SQLPlus utility.

    The database update is complete.

  6. Continue to Creating the Database Tables.