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

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. Run the command update.bat <DB Password>

   7. The result of the command appears as follows: