Skip to main content

HTTP Status 500 exception 'java.lang.IllegalStateException' GlassFish3 & Oracle 11gr2

Please note these java.net forums are being decommissioned and use the new and improved forums at https://community.oracle.com/community/java.
1 reply [Last post]
shupike
Offline
Joined: 2013-03-30

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.

AttachmentSize
GlassFish.jpg58.04 KB

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
mgainty
Offline
Joined: 2004-05-21

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@glassfish.java.net
> Subject: HTTP Status 500 exception 'java.lang.IllegalStateException' GlassFish3 & Oracle 11gr2
> From: forums@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
>
>
>