Setup Oracle Database - EcoSys - 3.1 - Installation & Upgrade - Hexagon

EcoSys Connect Installation and Configuration (Microk8s Kubernetes)

Language
English
Product
EcoSys
Search by Category
Installation & Upgrade
EcoSys Version
3.1

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

  1. Open the \database\create\oracle\setup\create.sql for editing.

    1. If you are using Oracle on Linux, comment out the windows section and enable the windows section.

    2. For each tablespace statement, modify the datafile statement to a path for your environment.

    3. Update the ‘create user ecadmin identified by ecadmin’ line, by changing the section instance of ecuser to your preferred password.

    4. Update the ‘create user ecuser identified by ecuser’ line, by changing the section instance of ecuser to your preferred password.

    5. Modify the line, connect ecadmin/ecadmin@ecconnect and update the password and/or the Oracle SID.

    6. Save the file.

  2. Run the create.sql script against your oracle database as sysdba.

  3. Apply schema updates as follows:

    1. Copy the correct JDBC jar file to the \database\upgrade\ folder

    2. Open the \database\upgrade\liquibase.properties file for editing

      1. Locate the SQL Server section and add a # character at the start of each line to comment out each of the settings.

      2. Locate the section for Oracle and remove the # character for each setting.

      3. Edit the URL, username, and classpath based on your environment.

      4. Save the file.

    3. Open a shell on the host

    4. Change directories to \database\upgrade

    5. Ensure JAVA is on the path.

      JRE 1.8 or above is required.

    6. Using one of the syntaxes below, run the upgrade script to apply the database changes while replacing password (keep the quotes) with the password for the database user specified in the liquibase.properties file.

      For Windows, execute the following command:

      - upgrade.bat “password”

      For Linux, execute the following commands:

      set +H

      ./upgrade.sh “password”

      Set -H

      The result of the command appears as follows: