1.1 Set up Internal Handoffs Grants Utility

This topic explains the steps involved in setting up Internal Handoffs Grants Utility.

  1. Double-click FCUBSInstaller.bat batch file to start Oracle FLEXCUBE Universal Installer.
    The Oracle FLEXCUBE Universal Installer screen is displayed.

    Figure 1-1 Oracle FLEXCUBE Universal Installer



  2. On Oracle FLEXCUBE Universal Installer screen, enter the following details.
    Refer to the table for JDK and Oracle Home path.

    Table 1-1 JDK and Oracle Home path

    Field Description
    JDK Path

    Provide Home folder path of JDK1.8.

    Oracle Home

    Provide home folder path of Oracle Client or Database.

    Application Server Home

    Provide home folder path of Application Server.

    Note: In case any of the selected directories is incorrect, the Installer will display an appropriate error message. In that case, you need to correct the directory path and proceed.

    Application Server Location

    Select location of the application server either as local or remote.

  3. Click Next to select the utility option for installation.
  4. Select Internal Handoff Grants from the lists of Utilities option.
    The options available for installation are displayed.

    Figure 1-2 Utilities_Internal Handoff Grants



  5. Click Next to provide Internal Handoff Grants schema details.
    The following screen is displayed.

    Figure 1-3 Internal Handoff Grants Schema Details



  6. Specify the following Internal Handoff Grants schema details. This is the Schema on which scripts of other schema are to be executed.
    Refer to the table for Internal Handoff Grants schema details.

    Table 1-2 Internal Handoff Grants schema details

    Field Description
    Target Schema

    Specify target schema name for grants to be executed.

    User Name

    Specify the user name to access the schema.

    Password

    Enter the schema password.

    Service Name

    Specify service name of Database.

    TNS Connect Descriptor

    Specify a valid connect string that contains the details for database connectivity.

    IP Address

    Specify the IP address of the system where the database schema is installed.

    Port

    Specify the port number.

  7. Click the Test Connection button to check the status of the connection to database.
    • If the connection is established, the installer displays a message Connection Successful.
    • If there is an error in establishing the connection, the system displays the message Invalid DB Credentials.
    • If the TNS entry is not proper, the installer displays the message TNS entries are not proper.
    Once the connection is established, the following message is displayed.

    Figure 1-4 Information Message on Successful Connection



  8. Click Next after testing the connection successfully.
  9. Click Execute to execute the Internal Handoff Grants.
    The execution status of Internal Handoff Grants is displayed.

    Figure 1-5 Execution Status of Internal Handoff Grants