My Oracle Support Banner

OFSAAI 8.1.1.1 Password Change and startofsaai.sh Failing With DB Connection failed ORA-01017 (Doc ID 2802990.1)

Last updated on SEPTEMBER 03, 2021

Applies to:

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

Symptoms

When attempting to reset config schema password and running startofsaai in foreground, the following issue occurred.


Error:

Configuring log from: /app/ofsaai/ofsaa8/ficapp/common/FICServer/conf/log4j.conf.properties
com.ofs.aai.exception.OFSAAException: DB Connection failed.
  at com.ofs.aai.database.impl.GenericOFSAAConnectionFactory.getConfigConnection(GenericOFSAAConnectionFactory.java:116)
  at com.iflex.fic.util.ftpService.SFTPUtil.getConfigConnection(SFTPUtil.java:1959)
  at com.iflex.fic.util.ftpService.SFTPUtil.getWebServerDetails(SFTPUtil.java:117)
  at com.iflex.fic.util.ftpService.SFTPUtil.(SFTPUtil.java:85)
  at com.iflex.fic.util.ftpService.fileTranferer.(fileTranferer.java:53)
  at com.iflex.fic.ficserver.FICServer.initialize(FICServer.java:334)
  at com.iflex.fic.ficserver.FICServer.(FICServer.java:297)
  at com.iflex.fic.ficserver.FICServer.main(FICServer.java:227)
Caused by: java.lang.NullPointerException
  at com.ofs.aai.database.impl.GenericOFSAAConnectionFactory.getConfigConnection(GenericOFSAAConnectionFactory.java:98)
  ... 7 more

SMSService.log shows:
[DEBUG] [APP] [SMS] [NA] [INFORMATIONDOMAINSERVICES] [AESCryptor] File exists at /app/ofsaai/ofsaa8/conf/AESCryptKey.ext
[DEBUG] [APP] [SMS] [NA] [DACCONNECTIONPROVIDER] Connection Type getting used ->
[DEBUG] [APP] [SMS] [NA] [SMSSERVICES] Error in getting Configuration Informationnull
[DEBUG] [APP] [SMS] [NA] [SMSSERVICES] null
java.lang.NullPointerException
  at com.iflex.fic.client.SMSServices.getConfiguration(SMSServices.java:2507)
  at com.iflex.fic.ficserver.services.DAC.DACDatabaseGateway.isADWEnabled(DACDatabaseGateway.java:4025)
[ERROR] [APP]  [SMS]  [NA] [DACCONNECTIONPROVIDER] Error getting connection : java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Steps To Replicate:
1. Log into the database and change the config schema password.

    ALTER USER <ConfigSchema> IDENTIFIED BY <NewConfigPassword>;
   
2. Log into the OFSAA server.
3. Stop all OFSAA services.
4. Delete Reveleus.sec from FIC_HOME/conf.
   cd $FIC_HOME/conf
   rm Reveleus.SEC

5. Restart OFSAA service in foreground.
   cd $FIC_APP_HOME/common/FICServer/bin
   ./startofsaai.sh

6. Enter the latest config schema password when prompted at the console.

7. Found the following:
   - SMSService.log shows what looks like FICserver is running but has invalid username/password error.   
   - The foreground hangs.
   - Reveleus.SEC is created with new encrypted password but missing a CR/LF at the end.
   - DB_MASTER and AAI_DB_AUTH_ALIAS are not updated with new encrypted CONFIG password


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.