Solved

Oracle connection through ASA

Posted on 2008-10-25
2
1,594 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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.
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
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now