1 Reply Latest reply on Jun 13, 2012 4:47 PM by 943267

    APEX doesn't work after apex listener configuration on Tomcat 6.0.35

    943267
      server info:
      CentOS 5.7 x86_64
      java version "1.6.0_31"
      Java(TM) SE Runtime Environment (build 1.6.0_31-b04)
      Java HotSpot(TM) 64-Bit Server VM (build 20.6-b01, mixed mode)
      apache-tomcat-6.0.35
      httpd 2.2.3
      Oracle 11.2.0.1.0 64bit
      apex 4.1.1
      apex listener 1.1.3

      tomcat startup variables:
      /usr/java/jdk1.6.0_31/bin/java -Djava.util.logging.config.file=/opt/apache-tomcat-6.0.35/apps/conf/logging.properties -server -Xms1024m -Xmx2048m -XX:PermSize=512m -XX:MaxPermSize=1024m 
      -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=/opt/apache-tomcat-6.0.35/apps/endorsed -classpath /opt/apache-tomcat-6.0.35/apps/bin/bootstrap.jar -Dcatalina.base=/opt/apache-tomcat-6.0.35/apps 
      -Dcatalina.home=/opt/apache-tomcat-6.0.35/apps -Djava.io.tmpdir=/opt/apache-tomcat-6.0.35/apps/temp org.apache.catalina.startup.Bootstrap start
      tomcat config:
      <Connector port="8081" protocol="HTTP/1.1"
              maxHttpHeaderSize="32767" maxThreads="150" minSpareThreads="25"
              maxSpareThreads="75" enableLookups="false" acceptCount="100"
              disableUploadTimeout="true"  connectionTimeout="20000"
              redirectPort="8444" />
      
      <Connector port="8010" protocol="AJP/1.3" redirectPort="8444" />
      httpd proxy config:
      ProxyPass /apex ajp://127.0.0.1:8010/apex
      ProxyPassReverse /apex ajp://127.0.0.1:8010/apex
      Problem:
      After installation of all apex related software. I go to the apex listener configuration page "localhost/apex/listenerConfigure" here I am able to configure the general connection and security parameters.

      <li>Set Password same as you did set for user APEX_PUBLIC_USER previously
      <li>Hostname: localhost
      <li>SID: orcl
      <li>Go Security tab and open "Database Validation Function"
      <li>Enter to Validation Function: wwv_flow_epg_include_modules.authorize
      <li>Press Apply

      I hit "Apply" and then get the following stacktrace:
      Jun 12, 2012 11:55:39 PM org.apache.catalina.core.StandardWrapperValve invoke
      SEVERE: Servlet.service() for servlet HttpEndPoint threw exception
      java.lang.NoClassDefFoundError: Could not initialize class oracle.sql.CHAR
              at java.lang.Class.forName0(Native Method)
              at java.lang.Class.forName(Class.java:169)
              at $Proxy17.<clinit>(Unknown Source)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
              at java.lang.reflect.Proxy.newProxyInstance(Proxy.java:588)
              at oracle.ucp.jdbc.proxy.CallableStatementProxyFactory.createCallableStatementProxy(CallableStatementProxyFactory.java:64)
              at oracle.ucp.jdbc.proxy.ConnectionProxyFactory.proxyInvokeAfterTargetInvoke(ConnectionProxyFactory.java:154)
              at oracle.ucp.jdbc.proxy.JDBCConnectionProxyFactory.invoke(JDBCConnectionProxyFactory.java:266)
              at $Proxy15.prepareCall(Unknown Source)
              at oracle.dbtools.apex.OWA.getStatement(OWA.java:454)
              at oracle.dbtools.apex.OWA.resetSession(OWA.java:306)
              at oracle.dbtools.apex.ModApex.close(ModApex.java:142)
              at oracle.dbtools.apex.ModApex.doGet(ModApex.java:81)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
              at oracle.dbtools.rt.web.HttpEndpointBase.defaultServlet(HttpEndpointBase.java:133)
              at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:90)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
              at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
              at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
              at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)
              at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
              at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
              at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
              at java.lang.Thread.run(Thread.java:662)
      I check for the listener configuration by going to the url "localhost/apex/listenerAdmin". Configuration has been saved.

      I try to load the page "localhost/apex/apex" and get the following stacktrace:
      Jun 12, 2012 11:58:07 PM org.apache.catalina.core.StandardWrapperValve invoke
      SEVERE: Servlet.service() for servlet HttpEndPoint threw exception
      java.lang.NoClassDefFoundError: Could not initialize class $Proxy17
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
              at java.lang.reflect.Proxy.newProxyInstance(Proxy.java:588)
              at oracle.ucp.jdbc.proxy.CallableStatementProxyFactory.createCallableStatementProxy(CallableStatementProxyFactory.java:64)
              at oracle.ucp.jdbc.proxy.ConnectionProxyFactory.proxyInvokeAfterTargetInvoke(ConnectionProxyFactory.java:154)
              at oracle.ucp.jdbc.proxy.JDBCConnectionProxyFactory.invoke(JDBCConnectionProxyFactory.java:266)
              at $Proxy15.prepareCall(Unknown Source)
              at oracle.dbtools.apex.OWA.getStatement(OWA.java:454)
              at oracle.dbtools.apex.OWA.resetSession(OWA.java:306)
              at oracle.dbtools.apex.ModApex.close(ModApex.java:142)
              at oracle.dbtools.apex.ModApex.doGet(ModApex.java:81)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
              at oracle.dbtools.rt.web.HttpEndpointBase.defaultServlet(HttpEndpointBase.java:133)
              at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:90)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
              at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
              at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
              at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)
              at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
              at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
              at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
              at java.lang.Thread.run(Thread.java:662)
      Im totaly clueless to what is going down here. ANY help would be much appreciated. What am I doing wrong here?

      Cheers,
      Steve