1 Reply Latest reply on Jun 11, 2013 1:02 PM by Paul M.

    Database Account Got Lock While Login

    monoj

      Dear All,

       

      My Application Server version is 10.2.0.1.0

       

      My database version:10.2.0.1.0  and OS version is: RHEL4

       

      We have newly install oracle 10g Application Server 2 days back and than we deploy our application,everything was successful but suddenly from today we received error.

      And than i dig a much as possible and found that database user account to which application user trying to connect has got lock.

       

      Please help me out in identifying the error.Below is the error messages that i received from my application server log:

       

       

       

      13/06/11 15:59:12 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:571)
      13/06/11 15:59:12 at com.evermind.sql.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:101)
      13/06/11 15:59:12 at com.evermind.sql.DriverManagerXADataSource.getXAConnection(DriverManagerXADataSource.java:120)
      13/06/11 15:59:12 at com.evermind.sql.OrionCMTDataSource.getPooledConnection(OrionCMTDataSource.java:197)
      13/06/11 15:59:12 at com.evermind.sql.PooledConnectionUsage.getPooledConnection(PooledConnectionUsage.java:39)
      13/06/11 15:59:12 at com.evermind.sql.OrionPooledDataSource.checkAndGetMinConnections(OrionPooledDataSource.java:376)
      13/06/11 15:59:12 at com.evermind.sql.OrionPooledDataSource.getTheConnection(OrionPooledDataSource.java:251)
      13/06/11 15:59:12 at com.evermind.sql.OrionPooledDataSource.getOPDSConnection(OrionPooledDataSource.java:329)
      13/06/11 15:59:12 at com.evermind.sql.OrionCMTConnection.getConnection(OrionCMTConnection.java:206)
      13/06/11 15:59:12 at com.evermind.sql.OrionCMTConnection.<init>(OrionCMTConnection.java:126)
      13/06/11 15:59:12 at com.evermind.sql.OrionCMTConnectionFinalize.<init>(OrionCMTConnectionFinalize.java:42)
      13/06/11 15:59:12 at com.evermind.util.ClassOptimizerFactory.getOrionCMTConnection(ClassOptimizerFactory.java:80)
      13/06/11 15:59:12 at com.evermind.sql.OrionCMTDataSource.getConnection(OrionCMTDataSource.java:237)
      13/06/11 15:59:12 at com.evermind.sql.OrionCMTDataSource.getConnection(OrionCMTDataSource.java:217)
      13/06/11 15:59:12 at com.tims.utility.ServiceLocator.getConnection(ServiceLocator.java:384)
      13/06/11 15:59:12 at com.tims.exception.ErrorHandler.getErrorMessage(ErrorHandler.java:39)
      13/06/11 15:59:12 at com.tims.exception.InvalidLocation.processException(InvalidLocation.java:9)
      13/06/11 15:59:12 at com.tims.exception.InvalidLocation.<init>(InvalidLocation.java:20)
      13/06/11 15:59:12 at com.tims.statforms.DlrRequestAMImpl.validateUserLocation(DlrRequestAMImpl.java:191)
      13/06/11 15:59:12 at _statforms._DlrRequestController._jspService(_DlrRequestController.java:188)
      13/06/11 15:59:12 at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
      13/06/11 15:59:12 at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:350)
      13/06/11 15:59:12 at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
      13/06/11 15:59:12 at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
      13/06/11 15:59:12 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      13/06/11 15:59:12 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:824)
      13/06/11 15:59:12 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
      13/06/11 15:59:12 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
      13/06/11 15:59:12 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:224)
      13/06/11 15:59:12 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:133)
      13/06/11 15:59:12 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
      13/06/11 15:59:12 at java.lang.Thread.run(Thread.java:534)
      13/06/11 15:59:12 ErrorHandler:getErrorMsg The error message returned = null
      13/06/11 15:59:12 IN GET CONNECTION:::::::
      13/06/11 15:59:16 java.sql.SQLException: ORA-28000: the account is locked
      13/06/11 15:59:16 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
      13/06/11 15:59:16 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
      13/06/11 15:59:16 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
      13/06/11 15:59:16 at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:647)
      13/06/11 15:59:16 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:307)
      13/06/11 15:59:16 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:433)
      13/06/11 15:59:16 at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150)
      13/06/11 15:59:16 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
      13/06/11 15:59:16 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:571)
      13/06/11 15:59:16 at com.evermind.sql.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:101)
      13/06/11 15:59:16 at com.evermind.sql.DriverManagerXADataSource.getXAConnection(DriverManagerXADataSource.java:120)
      13/06/11 15:59:16 at com.evermind.sql.OrionCMTDataSource.getPooledConnection(OrionCMTDataSource.java:197)
      13/06/11 15:59:16 at com.evermind.sql.PooledConnectionUsage.getPooledConnection(PooledConnectionUsage.java:39)
      13/06/11 15:59:16 at com.evermind.sql.OrionPooledDataSource.checkAndGetMinConnections(OrionPooledDataSource.java:376)
      13/06/11 15:59:16 at com.evermind.sql.OrionPooledDataSource.getTheConnection(OrionPooledDataSource.java:251)
      13/06/11 15:59:16 at com.evermind.sql.OrionPooledDataSource.getOPDSConnection(OrionPooledDataSource.java:329)
      13/06/11 15:59:16 at com.evermind.sql.OrionCMTConnection.getConnection(OrionCMTConnection.java:206)
      13/06/11 15:59:16 at com.evermind.sql.OrionCMTConnection.<init>(OrionCMTConnection.java:126)
      13/06/11 15:59:16 at com.evermind.sql.OrionCMTConnectionFinalize.<init>(OrionCMTConnectionFinalize.java:42)
      13/06/11 15:59:16 at com.evermind.util.ClassOptimizerFactory.getOrionCMTConnection(ClassOptimizerFactory.java:80)
      13/06/11 15:59:16 at com.evermind.sql.OrionCMTDataSource.getConnection(OrionCMTDataSource.java:237)
      13/06/11 15:59:16 at com.evermind.sql.OrionCMTDataSource.getConnection(OrionCMTDataSource.java:217)
      13/06/11 15:59:16 at com.tims.utility.ServiceLocator.getConnection(ServiceLocator.java:384)
      13/06/11 15:59:16 at com.tims.exception.ErrorHandler.logError(ErrorHandler.java:84)
      13/06/11 15:59:16 at com.tims.exception.InvalidLocation.processException(InvalidLocation.java:11)
      13/06/11 15:59:16 at com.tims.exception.InvalidLocation.<init>(InvalidLocation.java:20)
      13/06/11 15:59:16 at com.tims.statforms.DlrRequestAMImpl.validateUserLocation(DlrRequestAMImpl.java:191)
      13/06/11 15:59:16 at _statforms._DlrRequestController._jspService(_DlrRequestController.java:188)

      Thanks and Regards

      Monoj Das