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

Deploy Oracle Database for Creatio

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

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).

Note

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.

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).

Note

The sqlplus and impdp utilities are installed with the Oracle server.

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

Did you find this information useful?

How can we improve it?