Have you checked the limitations on your firewall? We ran into a similar
situation (with a similar network configuration), and we discovered that it
was because our firewall (Raptor) only supported 30 concurrent Oracle
connections at a time, which essentially made all of our DMZ CF/Oracle sites
non-functional. To alleviate the situation, we used Connection Manager to set
up the connections, and everything has been fine since.
Debbie McDaniel
<debbie.mcdaniel@data To: CF-Talk
<[EMAIL PROTECTED]>
-line.com> cc:
Subject: Oracle Error
02/07/2002 09:57 AM
Please respond to
cf-talk
Hi everyone,
I keep getting these weird errors with Oracle 8i that of course are being
blamed on ColdFusion. Here goes.
Our webserver sits in the DMZ and our database server is inside the
firewall. All traffic going from the webserver goes through the firewall to
talk to the database.
I seem to be able to access the database through coldfusion 90% of the time,
but sometimes I will get an ORA-0 error or an ORA-12203:TNS:unable to
connect to destination error, both of which result in massive errors in the
application and the eventual rebooting of the machine.
I am thinking it may be a network issue, but because coldfusion is new to
this company they want to blame it. If I log in with sql+ (an oracle client)
I can access the datasource w/o trouble, although cf can't even verify the
datasource. This usually happens after several moderate hits to the
datasource.
We are running CF 4.5.2 with all the appropriate patches applied on a Compaq
Windows 2000 machine with all the appropriate service packs applied to
Win2K. Our database is Oracle 8i - anyone have some suggestions?
Greatly appreciated!
Debbie M.
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
