AnsweredAssumed Answered

ORA-28001: the password has expired during startup

Question asked by Tushar Sutar on Aug 1, 2016
Latest reply on Aug 1, 2016 by Daniel Cinnamon


Detailed Error :

 

2016-08-01 08:56:02,919 INFO  [com.aveksa.client.datacollector.agent.AgentConfiguration] COMPLETED method=LoadProperties http://localhost:8445/aveksa/agent.submit, 1

2016-08-01 08:56:02,923 INFO  [com.aveksa.client.datacollector.agent.AgentConfiguration] Aveksa Product Version: 6.9.1

2016-08-01 08:56:02,973 INFO  [com.aveksa.server.agent.core.AgentMessageHandler] Agent message handler registered to Data reset manager

2016-08-01 08:56:03,001 INFO  [com.aveksa.client.component.communication.DefaultCommunicationManager] DCM82: Initiating handshake with server

2016-08-01 08:56:03,190 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-28001: the password has expired

)

  at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)

  at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:577)

  at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:262)

  at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:500)

  at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)

  at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:315)

  at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)

  at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)

  at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)

  at com.aveksa.server.utils.PerfStatUtil.getNewPerfConnection(PerfStatUtil.java:96)

  at com.aveksa.server.utils.PerfStatUtil.hasConnection(PerfStatUtil.java:109)

  at com.aveksa.server.runtime.AveksaSystem.initialize(AveksaSystem.java:321)

  at com.aveksa.init.Startup.init(Startup.java:41)

  at com.aveksa.gui.core.ACMFramework.init(ACMFramework.java:93)

  at com.aveksa.gui.core.ACMFramework.initInstance(ACMFramework.java:82)

  at com.aveksa.init.InitServlet.init(InitServlet.java:42)

  at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)

  at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)

  at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4071)

  at org.apache.catalina.core.StandardContext.start(StandardContext.java:4375)

  at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790)

  at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770)

  at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:622)

  at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)

  at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)

  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

  at org.apache.catalina.core.StandardContext.init(StandardContext.java:5312)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:622)

  at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)

  at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)

  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

  at org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301)

  at org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104)

  at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375)

  at org.jboss.web.WebModule.startModule(WebModule.java:83)

  at org.jboss.web.WebModule.startService(WebModule.java:61)

  at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)

  at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)

  at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:622)

  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

  at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)

  at com.sun.proxy.$Proxy0.start(Unknown Source)

  at org.jboss.system.ServiceController.start(ServiceController.java:417)

  at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:622)

  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

  at com.sun.proxy.$Proxy43.start(Unknown Source)

  at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:622)

  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

  at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)

  at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

  at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)

  at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)

  at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)

  at org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87)

  at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)

  at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)

  at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

  at com.sun.proxy.$Proxy44.start(Unknown Source)

  at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)

  at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1015)

  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)

  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)

  at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:622)

  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

  at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)

  at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

  at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)

  at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

  at com.sun.proxy.$Proxy9.deploy(Unknown Source)

  at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)

  at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)

  at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)

  at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)

  at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)

  at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)

  at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:622)

  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

  at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)

  at com.sun.proxy.$Proxy0.start(Unknown Source)

  at org.jboss.system.ServiceController.start(ServiceController.java:417)

  at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:622)

  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

  at com.sun.proxy.$Proxy4.start(Unknown Source)

  at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)

  at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)

  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)

  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)

  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:622)

  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

  at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)

  at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

  at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)

  at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

  at com.sun.proxy.$Proxy5.deploy(Unknown Source)

  at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)

  at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)

  at org.jboss.Main.boot(Main.java:200)

  at org.jboss.Main$1.run(Main.java:508)

  at java.lang.Thread.run(Thread.java:701)

Caused by: java.sql.SQLException: ORA-28001: the password has expired

 

 

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

  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:675)

  at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:448)

  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

  at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:383)

  at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:776)

  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:432)

  at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)

  at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)

  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)

  at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:171)

  ... 153 more

2016-08-01 08:56:03,204 WARN  [com.aveksa.server.utils.PerfStatUtil] unable to get perfstat connection org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-28001: the password has expired

); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-28001: the password has expired

))

2016-08-01 08:56:03,204 INFO  [com.aveksa.server.runtime.AveksaSystem] Unable to get performance statistics connection (avperf). This may limit some ASR report data.

 

 

 

And output from SQL

 

USERNAMEACCOUNT_STATUSCREATEDLOCK_DATEEXPIRY_DATE
AVDWUSEROPEN01-OCT-14
AVUSEROPEN17-FEB-15
MYACCESSOPEN14-SEP-15
ACMDBOPEN01-OCT-14
AFXTESTOPEN23-DEC-15
SEARSDBUSEROPEN13-OCT-15
SCOTTOPEN17-SEP-11
AVUSER_ROEXPIRED(GRACE)26-NOV-1509-JUN-16
SPATIAL_WFS_ADMIN_USREXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
SPATIAL_CSW_ADMIN_USREXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
APEX_PUBLIC_USEREXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
DIPEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
MDDATAEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
XS$NULLEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
ORACLE_OCMEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
DBSNMPOPEN17-SEP-11
PERFSTATOPEN03-JUL-13
SYSMANOPEN29-APR-16
OLAPSYSEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
SI_INFORMTN_SCHEMAEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
OWBSYSEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
ORDPLUGINSEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
XDBEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
ANONYMOUSEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
CTXSYSEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
ORDDATAEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
OWBSYS_AUDITEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
APEX_030200EXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
APPQOSSYSEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
WMSYSEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
EXFSYSEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
ORDSYSEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
MDSYSEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
FLOWS_FILESEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11
SYSTEMOPEN17-SEP-11
SYSOPEN17-SEP-11
MGMT_VIEWOPEN29-APR-16
OUTLNEXPIRED & LOCKED17-SEP-1117-SEP-1117-SEP-11

 

 

Question :

 

I am not sure exactly for which user we are getting above error during start up ? And how severe this error is ?

Outcomes