have the DBA run the following Query and change LOCK_DATE and EXPIRY_DATE for the user you are referencing select LOCK_DATE,EXPIRY_DATE from DBA_USERS where USERNAME='UserNameFromOracleDatasource'
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.
> To: users_at_glassfish.java.net
> Subject: HTTP Status 500 exception 'java.lang.IllegalStateException' GlassFish3 & Oracle 11gr2
> From: forums_at_java.net
> Date: Sat, 30 Mar 2013 10:28:30 -0500
>
> Hello! I need help urgently :-( I have a virtual machine with Glassfish3 +
> Oracle11gr2 installed. It worked correctly until last week when power has
> been unexpectedly disabled. So virtual machine has been stopped incorrectly
> and I still can't start my server. I'm trying to enter
> http://192.16.34.228:8080 (this is local IP of my server) and receive error
> message: 'HTTP Status 500 - type Exception report message descriptionThe
> server encountered an internal error () that prevented it from fulfilling
> this request. exception java.lang.IllegalStateException' So I typed in
> console: sudo /home/oracle/glassfish3/bin/asadmin stop-domain domain1 sudo
> /home/oracle/glassfish3/bin/asadmin start-domain domain1 and checked logs:
> cat /home/oracle/glassfish3/glassfish/domains/domain1/logs/server.log ...
> [#|2013-03-30T16:19:32.681+0300|INFO|glassfish3.1.1|javax.enterprise.system.core.com.sun.enterprise.v3.server|_ThreadID=10;_ThreadName=Thread-2;|GlassFish
> Server Open Source Edition 3.1.1 (12) startup time : Felix (1,354ms), startup
> services(2,819ms), total(4,173ms)|#]
> [#|2013-03-30T16:19:32.882+0300|INFO|glassfish3.1.1|javax.enterprise.system.tools.admin.org.glassfish.server|_ThreadID=16;_ThreadName=Thread-2;|JMXStartupService:
> Started JMXConnector, JMXService URL =
> service:jmx:rmi://localhost.localdomain:8686/jndi/rmi://localhost.localdomain:8686/jmxrmi|#]
> [#|2013-03-30T16:20:54.585+0300|SEVERE|glassfish3.1.1|oracle.dbtools.apex.OWA|_ThreadID=17;_ThreadName=Thread-2;|The
> log message is null. java.sql.SQLException: Exception occurred while getting
> connection: oracle.ucp.UniversalConnectionPoolException: Cannot get
> Connection from Datasource at
> oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:541) at
> oracle.ucp.jdbc.PoolDataSourceImpl.throwSQLException(PoolDataSourceImpl.java:588)
> at
> oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:669)
> at
> oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:614)
> at
> oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:608)
> at oracle.dbtools.apex.Connections.getConnection(Connections.java:215) at
> oracle.dbtools.apex.ModApexContext.getConnection(ModApexContext.java:288) at
> oracle.dbtools.apex.Procedure.getProcedure(Procedure.java:45) at
> oracle.dbtools.apex.OWA.validateProcedure(OWA.java:274) at
> oracle.dbtools.apex.security.Security.isValidRequest(Security.java:121) at
> oracle.dbtools.apex.ModApex.validateRequest(ModApex.java:220) at
> oracle.dbtools.apex.ModApex.doGet(ModApex.java:81) ....39 more Caused by:
> java.sql.SQLException: ORA-28001: the password has expired at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388) at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381) at
> oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:564) at
> oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431)
> at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) ...46 more
> [#|2013-03-30T16:20:54.618+0300|SEVERE|glassfish3.1.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=17;_ThreadName=Thread-2;|Exception
> occurred while getting connection:
> oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from
> Datasource|#]
> [#|2013-03-30T16:20:54.619+0300|WARNING|glassfish3.1.1|javax.enterprise.system.container.web.com.sun.enterprise.web|_ThreadID=17;_ThreadName=Thread-2;|StandardWrapperValve[ModApex]:
> PWC1406: Servlet.service() for servlet ModApex threw exception
> java.lang.IllegalStateException I REALLY don't understand why I see error
> "ORA-28001: the password has expired". What happened with my server after
> power loss? What password has been expired and why? By the way I found backup
> from 12th of January 2013 - same virtual machine. And it works OK. Can you
> tell me how to resolve my problem, please? :-( Thank you for answers.
>
> --
>
> [Message sent by forum member 'shupike']
>
> View Post: http://forums.java.net/node/896021
>
>
>