ORA-28001

From the ICN SystemOut.log, the following exception is happening after opening url of Admin/icm/icmadmin/ier desktops:

[11/15/18 11:21:27:171 PKT] 000000ec SystemOut O [11/15/18 11:21:27:171 PKT] 000000ec SystemOut O CIWEB Error: [ ] null.processCleanup() There was a SQL configuration error. org.apache.commons.configuration.event.ConfigurationErrorEvent[source=com.ibm.ecm.configuration.DatabaseConfiguration@d92c6d5c]
[11/15/18 11:21:27:171 PKT] 000000ec SystemOut O [11/15/18 11:21:27:171 PKT] 000000ec SystemOut O CIWEB Error: [ ] com.ibm.ecm.configuration.DatabaseConfiguration.getProperty() key = settings.navigator.default
java.sql.SQLException: ORA-28001: the password has expired
DSRA0010E: SQL State = 99999, Error Code = 28,001
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:207)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:139)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:88)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:70)
at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:1366)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:1385)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:2154)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.getConnection(WSManagedConnectionFactoryImpl.java:1802)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1572)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1128)
at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:2168)
at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1838)
at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:3835)
at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:3111)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:1548)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:1031)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:646)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:613)
at org.apache.commons.configuration.DatabaseConfiguration.getConnection(DatabaseConfiguration.java:632)
at com.ibm.ecm.configuration.DatabaseConfiguration._getProperty(DatabaseConfiguration.java:821)
at com.ibm.ecm.configuration.DatabaseConfiguration.getProperty(DatabaseConfiguration.java:788)
at org.apache.commons.configuration.AbstractConfiguration.getStringArray(AbstractConfiguration.java:1081)
at org.apache.commons.configuration.AbstractConfiguration.getProperties(AbstractConfiguration.java:607)
at org.apache.commons.configuration.AbstractConfiguration.getProperties(AbstractConfiguration.java:584)
at com.ibm.ecm.configuration.ConfigurationObject.load(ConfigurationObject.java:245)
at com.ibm.ecm.configuration.SettingsConfig.load(SettingsConfig.java:226)
at com.ibm.ecm.configuration.ConfigurationObject.<init>(ConfigurationObject.java:105)
at com.ibm.ecm.configuration.SettingsConfig.<init>(SettingsConfig.java:194)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:83)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:57)
at java.lang.reflect.Constructor.newInstance(Constructor.java:437)
at com.ibm.ecm.configuration.Config._getConfiguration(Config.java:1445)
at com.ibm.ecm.configuration.Config.getConfiguration(Config.java:1498)
at com.ibm.ecm.configuration.Config.getSettingsConfig(Config.java:529)
at com.ibm.ecm.configuration.Config.getSettingsConfig(Config.java:509)
at com.ibm.ecm.configuration.ConfigWrapper.getSettingsConfig(ConfigWrapper.java:723)
at com.ibm.ecm.configuration.ApplicationConfig.getSettingsConfig(ApplicationConfig.java:638)
at com.ibm.ecm.configuration.LoggingConfigThread.run(LoggingConfigThread.java:70)

Environment:

WAS 8.5.x

ICN 3.0.x

ICM 5.3.x

Oracle 11g

Solution:

This problem occurred when icn schema password expired or user locked.

• Stop IBM FileNet P8 services.
• Unlock icn schema by performing following:

SELECT username, account_status FROM DBA_USERS;

ALTER profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;
ALTER profile DEFAULT limit PASSWORD_LIFE_TIME unlimited;

ALTER USER ICN_USER ACCOUNT UNLOCK IDENTIFIED BY password;

• Start services and try to connect to icn desktops again. It will work fine.