Messageserver Fails with 'Unable to Connect to the Config Database' Using Wrong Database Name (Doc ID 2193996.1)

Last updated on OCTOBER 21, 2016

Applies to:

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

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), the messageserver is not starting.

Initially, the messageserver log, msg_trace_file.log, in $FIC_DB_HOME/log is 0 bytes.  The following is output starting the messageserver:

$ ./messageserver
DEBUG: main started.
DEBUG: TraceFileName = /app/ofsaa73/ficdb/log/msg_trace_file.log
DEBUG: OpenFiles done.
[LOG] Starting up.....
$

If you try to start the messageserver again, the following error is output to the msg_trace_file.log:

FAILED: log_on()
CI18NProvider::CI18NProvider, Error, unable to connect to the config database
Warning : Could not log off 0
CI18NProvider::CI18NProvider, Error, generic exception while trying to construct an instance of I18NProvider
ClsUSmsConnect::ClsUSmsConnect(), Error, a generic exception was caught while trying to initializing the class
Log Message here 1: Mon Oct 10 10:16:08 2016||INFO||ConnectToDatabase, trying to connect to the config DB with USERNAME = configSID = ofsaa01
FAILED: log_on()
Log Message here 1: Mon Oct 10 10:16:08 2016||SEVERE||ConnectToDatabase: FatalError, could not connect to the DB server using
Warning : Could not log off 0
Log Message here 1: Mon Oct 10 10:16:08 2016||SEVERE||Could not start Message Logger Server ...


The error message contains the wrong SID value (ex. SID = ofsaa01).  The router and am processes start successfully.

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