Wrong IP Fetched Running the OFSAA Schema Creator Utility in Multi Tier Environment (Doc ID 2096133.1)

Last updated on MAY 18, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)

Symptoms

On OFSAA 8.0.0, during ALM and OFSAAI Installation the process is interrupted by the Schema Creation failure, while running the Schema Creator Utility (osc.sh).

ERROR

[Fri  13/11/2015 04:04:37] [SCHEMAUTILITY] [ INFO] - ===================================================================================
[Fri  13/11/2015 04:04:37] [SCHEMAUTILITY] [ INFO] -                           Schema Creation Started
[Fri  13/11/2015 04:04:37] [SCHEMAUTILITY] [ INFO] - ===================================================================================
[Fri  13/11/2015 04:04:37] [SCHEMAUTILITY] [ INFO] - Checking OFSAA installation...
[Fri  13/11/2015 04:04:37] [SCHEMAUTILITY] [ INFO] - OFSAA installation not found.
[Fri  13/11/2015 04:04:37] [SCHEMAUTILITY] [ INFO] - Validating the dat file OFS_ALM_CFG.dat started...
[Fri  13/11/2015 04:04:37] [SCHEMAUTILITY] [ INFO] - Sucessfully validated OFS_ALM_CFG.dat file
[Fri  13/11/2015 04:04:37] [SCHEMAUTILITY] [ INFO] - ===================================================================================
[Fri  13/11/2015 04:04:37] [SCHEMAUTILITY] [ INFO] - Validating the input XML file.../export/home/ofsaa/all_softwares/OFS_ALM_PACK/schema_creator/conf/OFS_ALM_SCHEMA_IN.xml
[Fri  13/11/2015 04:04:37] [SCHEMAUTILITY] [ INFO] - Input XML file validated successfully.
[Fri  13/11/2015 04:04:37] [SCHEMAUTILITY] [ INFO] - ===================================================================================
[Fri  13/11/2015 04:04:37] [SCHEMAUTILITY] [ INFO] - Validating Connection URL ...jdbc:oracle:thin:@//ssc-appxxxx:1521/OFSAA
[Fri  13/11/2015 04:04:38] [SCHEMAUTILITY] [ INFO] - Successfully connected to User - sys as sysdba URL - jdbc:oracle:thin:@//ssc-appxxxx/OFSAA
[Fri  13/11/2015 04:04:38] [SCHEMAUTILITY] [ INFO] - Connection URL successfully validated...
[Fri  13/11/2015 04:04:38] [SCHEMAUTILITY] [DEBUG] - Executing ...SELECT VALUE FROM v$option WHERE parameter = 'Partitioning'
[Fri  13/11/2015 04:04:38] [SCHEMAUTILITY] [ERROR] - HostName in input xml is not matching with the local hostname.
[Fri  13/11/2015 04:04:38] [SCHEMAUTILITY] [ INFO] - ===================================================================================
[Fri  13/11/2015 04:04:38] [SCHEMAUTILITY] [ INFO] -                            Schemas Creation Failed.
[Fri  13/11/2015 04:04:38] [SCHEMAUTILITY] [ INFO] - ===================================================================================

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms