Prepare Database

In the Prepare database form you execute a predefined script for preparing your database for IFS Applications.

A predefined script to prepare your database is selected.

Actions

  1. Pre selected script creates the application owner into the database but also some other users needed for the application to run. These users are granted necessary privileges, and they are assigned to a IFS specific Oracle profile. Included is also to create tablespaces used for IFS Applications. They are by default placed where the SYSTEM tablespace is found, but the path can individually be overridden for each tablespace by settings in Define.tem. Only the SYS user is allowed to execute this script.
  2. Browse, or write directly in the field, where you want the output logs from the execution. If you enter the path to folder that doesn't exist, you will be prompted if you want to create a new folder at that path. Note: This is a top location for the log files, a sub folder named prepare_<timestamp> will be created under this folder. Off course, you must have write access to this directory.
    Parameter Description Alternatives/Suggestion
    Script to run  Just for verification, the prepare.sql script is displayed. NA
    Top location of logs Top location for output logs during the execution, e.g.
    Windows: D:\MyWorkSpace\logs
    Linux/Unix: /home/ifs/logs    		 NA

     

  3. Fill in information for database connection
    Parameter Description Alternatives/Suggestion
    Database host On which server is the database located NA
    Database port Database port Normally 1521
    Database Service Name Name of the database service NA

     

  4. Enter the oracle user name and password. When you are about to execute the prepare database script, SYS is the only valid user.
    Parameter Description Alternatives/Suggestion
    User Must be SYS when you are prepare your DB for IFS Applications SYS
    Password User password NA

     

  5. Click the Test Connect button to verify the username and password at the given database. A popup tells you whether you manage to connect or not. An error message is available if you did not succeed in connecting the database.

    You manage to connect to the database.

     

  6. Click the Edit Settings if you want to edit the define.tem settings, please read details here. This button is enabled if the file define.tem exist and something is defined to be edited for prepare database process.

You can change the value in the Value column. Depending on the definition, value can be as free text or to be selected from a list. You save the values by pressing Save settings button. If Save settings button is disabled, you don't have write privileges.
A popup will inform you that you have to save the file in your version control system if you want to reuse changed values in future deployments.

Note! No space character allowed in entered values.

 

  1. Click Next to continue 

Verify

When the following conditions are met, the Installer will jump to the next form when you click Next:
  • all fields contain proper values (i.e. the script you want to run really exists)
  • the top location for logs exists
  • you have write access to this directory
  • it is possible to connect to the database ("Test Connect" button)
To close the program click Exit
It's not possible to go to the next step if you haven't written values in all fields. Also, the installer prevent you from continuing if it is not possible to connect with database using the given logon parameters before.