Not able to Access Web or OneClick Console due account locked

Document ID : KB000004445
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Error When try to login at OCE/Web
Invalid User Exception: ORA-28000: the account is locked

java.sql.SQLException: ORA-28000: the account is locked

 

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:384)
    at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:684)
    at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:447)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:200)
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:379)
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:806)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:446)
    at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:557)
    at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:233)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:556)
    at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:454)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:328)
    at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:329)
    at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:164)
    at oracle.jdbc.pool.OracleImplicitConnectionCache.makeCacheConnection(OracleImplicitConnectionCache.java:2476)
    at oracle.jdbc.pool.OracleImplicitConnectionCache.makeOneConnection(OracleImplicitConnectionCache.java:715)
    at oracle.jdbc.pool.OracleImplicitConnectionCache.getCacheConnection(OracleImplicitConnectionCache.java:652)
    at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:490)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:665)
    at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:291)
    at com.concord.api.util.jdbc.ConnectionUtil.getConnectionFromPool(ConnectionUtil.java:103)
    at com.concord.servletApp.web.common.ConnectionHelper.openConnection(ConnectionHelper.java:178)
    at com.concord.servletApp.web.common.Frames.doGet(Frames.java:122)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.Appl

Environment:
eHealth 6.3.x versionsAny OS
Resolution:

Check what users are locked:

nhisql -sysdba "select username,account_status from dba_users"

 

Then run this command with the correct user:

nhisql -sysdba "SELECT 'ALTER USER '|| name ||' IDENTIFIED BY VALUES '''|| spare4 ||';'|| password ||''';' FROM sys.user$ WHERE name='<User>';"

 

Finally:

nhisql -sysdba alter user <User> account unlock;