Oracle Database Setup - EcoSys - Version 8.6 - Installation - Hexagon PPM

EcoSys Installation

PPMProduct
EcoSys
PPMCategory_custom
Installation & Upgrade
Version_EcoSys
8.6

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. The EcoSys Standard Products Database is provided at EcoSys major release (.01) schema versions. If a non-major release of the EcoSys application is being installed, refer to Determining the Database Upgrade Path and Upgrading the Database sections to determine which database upgrade scripts need to be run, 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.

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