Solved

Oracle connection through ASA

Posted on 2008-10-25
2
1,606 Views
Last Modified: 2013-12-19
I have a web server running Apache 5.1 connected to the DMZ port on the ASA 5510. We have an Oracle server inside our network. I have an open 1521 port between the web server ip and the oracle server ip. when anyone connects to the web server through the web app and tries to create a BOL we intermittantly get an error saying the connection timed out. Below is a copy of the error:
Anyway, we need someone to do some testing to see if we can replicate this error 

2008-10-24 21:29:00,312 [http-8080-Processor25] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/ecoenergy].[action] - Servlet.service() for servlet action threw exception
java.lang.IllegalStateException: Cannot forward after response has been committed
          at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:313)
          at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
          at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1056)
          at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:388)
          at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:231)
          at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
          at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
          at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
          at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
          at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
          at java.lang.Thread.run(Thread.java:534)
The ASA is 2 months old, both the web server and the oracle server are running Windows 2003 server R2, this problem only started when we connected the web server to the DMZ 2 days ago. we have 2 other web apps running on the same server connected to the DMZ port, one pointing to a SQL server with no problems and another pointing to the same oracle server with no problems.
0
Comment
Question by:johnsross
2 Comments
 
LVL 13

Expert Comment

by:Quori
ID: 22806411
Run a debug on the ASA and initiate the connection again and see what happens.

I'd suggest doing this in a time of low usage. :)
0
 

Accepted Solution

by:
johnsross earned 0 total points
ID: 22807058
Thx, already started that process after submitting the question. turns out the ASA 5510 and its SQL*NET filter has a glitch in the buffer size limit, Cisco had a patch for the device, after patching it the traffic is flowing through between the DMZ and the internal server.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle SQL - Query help 7 59
exp/imp 25 76
Allow IP range in sonicwall 1 19
Juniper SRX3600 - block all traffic to two IP's 5 18
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example, show how to take different types of Oracle backups using RMAN.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question