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