RMI Services not starting post schema migration:ORA-28000: the account is locked

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

We have migrated schema to a different master but RMI will not start and we also ran awinstall to refresh schema. 

--RMI Server log--

ErrorMsg: AwE-5001 Database Query Error 
Details: getConnection
        null
java.sql.SQLException: ORA-28000: the account is locked

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

Environment

Release : 9.3.3

Cause

JDBC String is failing as found from logs for both AgentService<TimeStamp>.log and RMIService.log

Post DBA unlocking the password, Still see error Invalid logon username/password

 

Resolution

- Running with ojdbc6.jar is causing the invalid logon credentials

- Replaced ojdbc8.jar file and connection is successful

- Brought RMI and AgentService successfully