Skip to main content
Version: 8.1All Creatio products

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.


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.

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.

    \\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
    Fig. 1 The schema name in the backup file
  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/ AS SYSDBA" @CreateUser.sql

    SYS_PASSWORD – a password for authorization on the Oracle server – network address of the Oracle server

    YOUR_SERVICE_NAME – Oracle service name.

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


    YOUR_SCHEMA_NAME – the name of the schema specified in the CreateUser.sql – 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/"


See also

Set up Creatio caching server

Set up Creatio application server on IIS

Creatio setup FAQ

System requirements calculator