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

Last updated on SEPTEMBER 18, 2023

Applies to:

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

Cause

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