ORA-00904: "V_AUTH_USER_NAME": invalid identifier Error While Starting OFSAAI service (Doc ID 2575176.1)

Last updated on MAY 21, 2023

Applies to:

Symptoms

Issue while starting OFSAAI services , when startofsaai.sh is triggered it prompts for config schema password.
Even though correct password is provided and there is no lock at DB level below error is seen on console:

Creating Logger Svc Code:999 LoggerName:ESPLOGGER oggerlevel:0
LogConstants.log4jInited = true
#Comparing---DAPPINST99966665---DAPPINST99966665
Kindly enter CONFIG schema password
User has typed an incorrect password or account is locked, please check the log.
Please provide the system password again
User has typed an incorrect password twice or account is locked, please check the log.

Below error comes up in SMSService.log:

[UMMLOG] Aug 5,19 19:24:45 : [DACDATABASEGATEWAY]Trial reinitialization connection and query execution
[UMMLOG] Aug 5,19 19:24:45 : [DACCONNECTIONPROVIDER]Connection Type getting used ->
[UMMLOG] Aug 5,19 19:24:45 : [DACDATABASEGATEWAY]Failed Executing 2nd time normal Select Query : [select v_auth_string from aai_db_auth_alias where v_auth_user_name=?] [On URL: jdbc:oracle:thin:@sxx.xxx.com:<Port>/<SID>] [Driver: oracle.jdbc.driver.OracleDriver] [Metadata Required : false]
[UMMLOG] Aug 5,19 19:24:45 : [DACDATABASEGATEWAY]
java.sql.SQLSyntaxErrorException: ORA-00904: "V_AUTH_USER_NAME": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:5179)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:12485)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4793)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
at com.iflex.fic.ficserver.services.DAC.DACDatabaseGateway.executePSQuery(DACDatabaseGateway.java:1887)
at com.iflex.fic.ficserver.services.sms.SMSDACGateway.executeQueryWithDefaultParams(SMSDACGateway.java:74)
at com.iflex.fic.ficserver.services.sms.SMSServiceProvider.validatePassword(SMSServiceProvider.java:2005)
at com.iflex.fic.ficserver.services.sms.SMSServiceProvider.createSecurityFile(SMSServiceProvider.java:1802)
at com.iflex.fic.ficserver.services.sms.SMSServiceProvider.startUp(SMSServiceProvider.java:431)
at com.iflex.fic.newservice.DynamicServicePool.initializeService(DynamicServicePool.java:118)
at com.iflex.fic.newservice.ServiceProxy.initializeService(ServiceProxy.java:85)
at com.iflex.fic.newservice.NewServiceMaster.initializeServices(NewServiceMaster.java:122)
at com.iflex.fic.newservice.NewServiceMaster.init(NewServiceMaster.java:83)
at com.iflex.fic.newservice.DynamicServiceManager.initializeServiceMaster(DynamicServiceManager.java:229)
at com.iflex.fic.ficserver.FICServer.initialize(FICServer.java:311)
at com.iflex.fic.ficserver.FICServer.(FICServer.java:281)
at com.iflex.fic.ficserver.FICServer.main(FICServer.java:194)

[UMMLOG] Aug 5,19 19:24:45 : [SMSDACGATEWAY]Error while Executing query :Error Executing Query. Error: ORA-00904: "V_AUTH_USER_NAME": invalid identifier

Changes

 N/A

Cause

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