Studio Creatio
PDF
This documentation is valid for Creatio version 7.16.0. We recommend using the newest version of Creatio documentation.

Deploy Oracle Database for Creatio

Install Oracle Database on the database server. Installation instructions are available in the Oracle Database Online Documentation. The “sqlplus” and “impdp” utilities required for restoring the application database from backup are installed with Oracle Database.

Note

Creatio have not been tested on Oracle high-availability configurations, however, there are cases of successful deployment of Creatio using Oracle RAC. Please refer to the Oracle Database Online Documentation for more details on Oracle Database clustering.

In Oracle Database, create two database users.

  • A user with the “admin” role, who has maximum access privileges on the database server level. This user will restore the Creatio database from a backup file and assign access permissions.

  • A user with the “public” role, whose permissions are limited. You will need this user to set up a secure connection to the restored Creatio database using Oracle authentication.

For more on creating users and access permissions on the database server, see Oracle Database Online Documentation.

Download and unzip the archive with the SQL scripts that are used to restore the database from the Oracle backup file.

By default the Oracle DB backup file is located in the ~\db folder with the Creatio executable files. If the backup file is located not on the Oracle server, it should be located in the network folder with general access.

Note

To restore the database:

1.Open the CreateUser.sql and RecompileSchema.sql scripts in the editor and modify the following macros:

YOUR_SCHEMA_NAME – schema name

YOUR_SCHEMA_PASSWORD – schema password

\\your_server.com\Share – path to the backup (*.dmp file).

2.Open the backup file in a text editor, find and save the name of the used schema located before the “.SYS_EXPORT_SCHEMA” record (Fig. 1).

Fig. 1 The schema name in the backup file

chapter_setup_oracle_find_schema_name.png 

3.Remove the modified scripts on the Oracle server. To create a new schema, execute the following command from the folder with the scripts:

sqlplus.exe "SYS/SYS_PASSWORD@your_server.com:1521/YOUR_SERVICE_NAME AS SYSDBA" @CreateUser.sql

SYS_PASSWORD – a password for authorization on the Oracle server

your_server.com – network address of the Oracle server

YOUR_SERVICE_NAME – Oracle service name.

4.Run import of the DB backup copy in the created schema:

impdp "YOUR_SCHEMA_NAME/YOUR_SCHEMA_NAME@//your_server.com:1521/BPMBUILD"
REMAP_SCHEMA=ORIGINAL_SCHEMA_NAME:YOUR_SCHEMA_NAME
DIRECTORY=BACKUPDIR DUMPFILE=filename.dmp NOLOGFILE=YES

YOUR_SCHEMA_NAME – the name of the schema specified in the CreateUser.sql

your_server.com – network address of the Oracle server

ORIGINAL_SCHEMA_NAME – the name of the schema from the backup file (step 2).

5.Consistently run:

sqlplus.exe "YOUR_SCHEMA_NAME/YOUR_SCHEMA_PASSWORD@your_server.com:1521/YOUR_SERVICE_NAME"
@tspkg_UtilitiesGlobalTypes.sql

sqlplus.exe "YOUR_SCHEMA_NAME/YOUR_SCHEMA_PASSWORD@your_server.com:1521/ YOUR_SERVICE_NAME"
@RecompileSchema.sql

See also

Set up Creatio caching server

Set up Creatio application server on IIS

Creatio setup FAQ

Did you find this information useful?

How can we improve it?