EcoSys Connect is supported on the WE8MSWIN1252 and AL32UTF8 character sets.
-
Open the \database\oracle\setup\create.sql for editing.
-
If you are using Oracle on Linux, comment out the windows section and enable the windows section.
-
For each tablespace statement, modify the datafile statement to a path for your environment.
-
Update the ‘create user ecadmin identified by ecadmin’ line, by changing the section instance of ecuser to your preferred password.
-
Update the ‘create user ecuser identified by ecuser’ line, by changing the section instance of ecuser to your preferred password.
-
Modify the line, connect ecadmin/ecadmin@ecconnect and update the password and/or the Oracle SID.
-
Save the file.
-
-
Run the create.sql script against your oracle database as sysdba.