Modify Web.config
Generate a unique machineKey
value for your Creatio application. To do this:
-
Download the PowerShell script. Download the script.
-
Run the PowerShell console as an administrator.
-
Specify the path to the root Creatio directory in the PowerShell terminal and run the script. Example of the command to run:
.\UpdateMachineKey.ps1 "[Path to the root Creatio directory]"
As a result, the script will generate a unique machineKey
value in Web.config files located in the root Creatio directory and the Terrasoft.WebApp directory.
Additional Web.config setup for Oracle
After you set up the database connection parameters in the ConnectionStrings.config file for the Oracle database, set up the Web.config configuration file that includes certain configuration parameters required for Creatio to operate as intended.
To set up Web.config:
-
Ensure the Creatio website can access the configuration parameters described in the ConnectionStrings.config configuration file. To do this, open the Web.config configuration file in the root Creatio directory and set the
currentSchemaName
attribute of thegeneral
parameter in thedb
section to the name of the schema specified in the ConnectionStrings.config configuration file.<configuration>
...
<terrasoft>
<db>
<general ... currentSchemaName="SOME_SCHEMA_NAME_OF_ORACLE_DATABASE" />
</db>
</terrasoft>
...
</configuration>where
currentSchemaName
is the name of the Oracle database schema. -
Save the changes.
Enable the Managed ODAC 12 library
Make sure that you are using Creatio version 8.0 Atlas or later. If you are using an earlier version, update Creatio. To do this, follow the update guide.
To enable the Managed ODAC 12 library:
-
Check the Oracle 19c database connector the website uses.
<configuration>
...
<system.data>
<DbProviderFactories>
<add name="Oracle.ManagedDataAccess, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess"/>
</DbProviderFactories>
</system.data>
...
</configuration> -
Back up the Web.config configuration file in the root Creatio directory.
-
Set up the interaction between the Creatio website and database via the Managed ODAC 12 library. To do this, set the
executorType
parameter in the Web.config configuration file toTerrasoft.DB.Oracle.OracleManagedExecutor, Terrasoft.DB.Oracle
:<configuration>
...
<terrasoft>
<db>
<general ... executorType="Terrasoft.DB.Oracle.OracleManagedExecutor, Terrasoft.DB.Oracle" ... />
</db>
</terrasoft>
</configuration>where
executorType
is the library that manages the Creatio database. -
Set up the interaction between the scheduler and database tables via the Managed ODAC 12 library. To do this, set the
quartz.dataSource.SchedulerDb.provider
key in the Web.config configuration file toOracleManagedProvider
:<configuration>
...
<quartzConfig defaultScheduler="BPMonlineQuartzScheduler">
<quartz isActive="true">
...
<add key="quartz.dataSource.SchedulerDb.provider" value="OracleManagedProvider" />
</quartz>
</quartzConfig>
</configuration>where
quartz.dataSource.SchedulerDb.provider
is the key that enables the scheduler to interact with database tables. -
Run Creatio and check the functionality in operation. If you notice issues, restore the Web.config configuration file from backup and repeat the setup.
-
Repeat the setup in the production environment or transfer changes to the production environment. Learn more in developer documentation: Environments.
Update the Oracle DBMS to version 19c
To update the Creatio Oracle DBMS to version 19c, follow the official vendor documentation.
As a result, your Creatio application will use Oracle 19c DBMS.
See also
Enable required Windows components
Set up Creatio application server on IIS
Switch a Creatio website from HTTP to HTTPS
Official Oracle 19c documentation