Skip to content

Deploy Database Objects and Import Data

When running the IFS Cloud Installer with action=install (default setting), and if there exist a middle tier already, the middle tier will be stopped (replicas=0) prior to the db deployment.

Depending on the content of the delivery following will be performed:
1. If <delivery>/database/_utils/prepare.sql exist, and password for SYS user given, the prepare.sql will be executed.
2. If <delivery>/database/install.tem exist (as in all automatically created deliveries), the file will be executed.
3. If <delivery>/server folder contains data to be imported, the import of data will be executed

If prepare step should be excluded, although prepare.sql exists in <delivery> (e.g. prepare step has already been performed separatly) the sysPassword should not be defined.

Example:  
CMD> cd c:\exampletmp\deliveries\build_home\ifsinstaller   
CMD> ./installer.cmd `  
   --set dbInstaller.jdbcUrl="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=1.2.3.4)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MYSID)))" `  
   --set dbInstaller.ifsappPassword=example `  
   --set dbInstaller.sysPassword=example `  
   --set logFileLocation=..\..\..\logs\ifscloudinstaller `  
   --set action=dbinstaller `  
   --set ifscore.passwords.ifsiamPassword.data=example `  
   --set ifscore.passwords.ifssysPassword.data=example `  
   --set ifscore.passwords.ifsmonPassword.data=example  

Note: All or some of the parameters passed to the installer above can be stored in a values yaml file.
e.g. .\installer.cmd --values values.yaml --set dbInstaller.sysPassword= <password>

Parameters for db_deploy

Parameter Purpose Examples/Defaults
dbInstaller.deliveryPath Path to delivery or build_home defaults to the delivery or build home from where the installer was started.
ifscore.secrets.jdbcUrl.data or
dbInstaller.jdbcUrl
Full jdbc connection string. If the ifscore.secrets.jdbcUrl.data string can't be used (e.g. an Oracle RAC url or DB has different IPs from installer and k8s cluster) the dbInstaller.jdbcUrl can be specified to overide the ifscore.secrets.jdbcUrl.data string. jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= <HOST/IP> )(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME= <sid> )))
ifscore.passwords.ifsappUser.data The IFS Cloud application owner Username defaults to IFSAPP
dbInstaller.ifsappPassword The IFS Cloud application owner password.
Used when creating the application owner in prepares.sql

dbInstaller.sysPassword The oracle sys password. If prepare.sql is included in delivery and the sys password is given, the prepare.sql will be executed, otherwise not.  
dbInstaller.extLogging Will generate verbose logging of DB deployment. defaults to "N"
--set dbInstaller.extLogging=Y
logFileLocation Top location for output logs during the execution. default to the OS temp folder, e.g. windows  %TEMP%/ifsinstaller_<namespace>
action If only the db_deploy should be run from the installer, action can be set to "dbinstaller", if a single file is to be executed, then action should be set to "fileexec" --set action=dbinstaller

If action should be fileexe, read File Executor
ifscore.passwords.ifsiamPassword.data Password when creating the user ifsiamsys in prepares.sql Default values are defined in define.tem
ifscore.passwords.ifssysPassword.data Password when creating the user ifssys in prepares.sql Default values are defined in define.tem
ifscore.passwords.ifsmonPassword.data Password when creating the user ifsmonitoring in prepares.sql Default values are defined in define.tem

Generated deploy files

A list of files are generated at the same time as the install.tem is generated. These files, whose purposes are described below, are started from install.tem in every installation, but in many cases they could be empty if no new information is added.

File Name Purpose
ActivateComponents.sql A translation of the solutionset.yaml file into a DB deployable format. It lists the active and inactive components and store this information in the database.
CompRegAndDep.sql Pre registration of all components, as well of all dependencies between them.
DeliveryRegistration.sql If the delivery should be stored in the database, the build process must be fed with information about the delivery ID in a file named deliveryid.txt. Such file is generated by the LE build process.
ObsoleteComponents.sql Components, which have a drop script in the PRIFS components are considered as obsolete. These components are listed in this file and updated in the database.