My oracle apex_public_user password expired, I reset apex_public_user password by following sql:
alter user apex_public_user identified by my_new_password;
After that I start apex listener by running following command:
D:\app\administrator\apex_listener.2.0.0.354.17.05>java -jar apex.war
Sep 03, 2013 12:16:52 PM oracle.dbtools.standalone.Standalone execute
INFO: NOTE:
Standalone mode is designed for use in development and test environments. It is not supported for use in production environments.
Sep 03, 2013 12:16:52 PM oracle.dbtools.standalone.Standalone execute
INFO: Starting standalone Web Container in: D:\app\administrator\apex_listener.2.0.0.354.17.05\apex
Sep 03, 2013 12:16:52 PM oracle.dbtools.standalone.Deployer deploy
INFO: Will deploy application path = D:\app\administrator\apex_listener.2.0.0.354.17.05\apex\apex\WEB-INF\web.xml
Sep 03, 2013 12:16:53 PM oracle.dbtools.standalone.Deployer deploy
INFO: Deployed application path = D:\app\administrator\apex_listener.2.0.0.354.17.05\apex\apex\WEB-INF\web.xml
Sep 03, 2013 12:16:53 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
INFO: Using configuration folder: D:\app\administrator\apex_listener.2.0.0.354.17.05\apex
Default Database connection not configured properly
Sep 03, 2013 12:16:54 PM oracle.dbtools.rt.web.SCListener contextInitialized
INFO: Oracle Application Express Listener initialized
Application Express Listener version : 2.0.0.354.17.06
Application Express Listener server info: Grizzly/1.9.49
Sep 03, 2013 12:16:54 PM com.sun.grizzly.Controller logVersion
INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 9/3/13 12:16 PM
Sep 03, 2013 12:16:54 PM oracle.dbtools.standalone.Standalone execute
INFO: http://localhost:8080/apex started.
-
There is message showing:Default Database connection not configured properly
If I access Apex from web browser, I got following error logs:
Sep 03, 2013 12:16:54 PM com.sun.grizzly.Controller logVersion
INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 9/3/13 12:16 PM
Sep 03, 2013 12:16:54 PM oracle.dbtools.standalone.Standalone execute
INFO: http://localhost:8080/apex started.
Sep 03, 2013 12:18:38 PM oracle.dbtools.rt.web.HttpEndpointBase modApex
SEVERE: The pool named: apex is not correctly configured, error: ORA-01017: invalid username/password; logon denied
oracle.dbtools.common.jdbc.ConnectionPoolException: The pool named: apex is not correctly configured, error: ORA-01017: invalid username/password; logon denied
at oracle.dbtools.common.jdbc.ConnectionPoolException.badConfiguration(ConnectionPoolException.java:65)
at oracle.dbtools.common.config.db.DatabaseConfig.badConfiguration(DatabaseConfig.java:153)
at oracle.dbtools.common.config.db.DatabaseConfig.createPool(DatabaseConfig.java:174)
at oracle.dbtools.common.config.db.DatabaseConfig.getConnection(DatabaseConfig.java:70)
at oracle.dbtools.common.jdbc.ora.OraPrincipal.connection(OraPrincipal.java:69)
at oracle.dbtools.apex.ModApexContext.getConnection(ModApexContext.java:331)
at oracle.dbtools.apex.Procedure.getProcedure(Procedure.java:167)
at oracle.dbtools.apex.OWA.validateProcedure(OWA.java:392)
at oracle.dbtools.apex.security.Security.isValidRequest(Security.java:225)
at oracle.dbtools.apex.ModApex.validateRequest(ModApex.java:277)
at oracle.dbtools.apex.ModApex.doGet(ModApex.java:95)
at oracle.dbtools.apex.ModApex.service(ModApex.java:316)
at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:260)
at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:110)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.doFilter(ServletAdapter.java:1059)
at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.invokeFilterChain(ServletAdapter.java:999)
at com.sun.grizzly.http.servlet.ServletAdapter.doService(ServletAdapter.java:434)
at oracle.dbtools.standalone.SecureServletAdapter.doService(SecureServletAdapter.java:65)
at com.sun.grizzly.http.servlet.ServletAdapter.service(ServletAdapter.java:379)
at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.service(GrizzlyAdapterChain.java:196)
at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:849)
at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:746)
at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1045)
at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:228)
at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
at java.lang.Thread.run(Unknown Source)
Is there anyway I can reset apex_public_user's password from apex listener environments so it can use the new password I reset through "alter user apex_public_user identified by my_password" sql statement in oracle 11g environments? Thanks for your help.
Kevin