Oracle Database Setup - EcoSys - 8.8 - Installation & Upgrade - Hexagon PPM

EcoSys Installation

Language
English (United States)
Product
EcoSys
Search by Category
Installation & Upgrade
EcoSys Version
8.8

Oracle database prerequisites and setup. If using Oracle version 11.2.0.1, refer to the EcoSys System Admin Guide for environmental considerations.

Oracle Database Prerequisites

  1. EcoSys is supported on the WE8MSWIN1252 and AL32UTF8 character sets.

  2. Execute the set_db_params script specific to the version of Oracle database being run located in the \EcoSys\database\oracle\setup directory. For example, if using Oracle 12c Release 1, execute the fm_or_12_1_set_db_params.sql script. After doing so, restart the database.

Setting Up the Oracle Database

  1. Create a general-purpose Oracle database called ESFM.

  2. Edit the \EcoSys\database\oracle\setup\fm_or_create_users_and_tablespaces.sql script:

    1. If the database server’s operating system is UNIX, comment out the Windows "create tablespace" blocks and uncomment the UNIX blocks.

    2. Change the .dbf datafile locations in the uncommented "create tablespace" blocks accordingly. Do not change the names of the files.

    3. If a password other than "fmuser" will be used for the "fmuser" login, modify the portion of the script that creates the "fmuser" login and password (create user fmuser identified by fmuser)

    4. If a password other than "fmadmin" will be used for the "fmadmin" login, modify the portion of the script that creates the "fmadmin" login and password (create user fmadmin identified by fmadmin)

  3. Execute the fm_or_create_users_and_tablespaces.sql script as SYSTEM or a DBA privileged user.

  4. Import the EcoSys Standard Products Database .dmp file. For example:

    impdp \"user/password@ESFM as sysdba\" DIRECTORY=DATA_PUMP_DIR DUMPFILE= FILENAME.DMP table_exists_action=replace logfile=impfull.log schemas=fmadmin,fmuser

  5. When Ecosys is installed, the EcoSys Standard Products Database backup file name includes full version name including the date. For example, EcoSys EC<Standard Product version><EcoSys version><Database platform and version>.zip. This will be the minimum version of EcoSys that the backups will be compatible with. If you want to use the database with a later version of EcoSys, refer to Determining the Database Upgrade Path and Upgrading the Database to determine which database upgrade scripts need to be run after it is restored, if any.

  6. Execute the \EcoSys\database\oracle\utils\fm_or_job_update_stats.sql script as SYSTEM or a DBA privileged user. For additional information on this script, refer to Updating EcoSys Database Statistics section. When Ecosys is installed, the backup file name includes full version name including the date

The default schema is 'fmadmin'. If this is changed, the following line must be added to the FMServerSettings.properties file:

oracle.schema=<schema-name>

For example, if the schema name is ‘ecosysadmin’

oracle.schema=ecosysadmin