0 Replies Latest reply: Jul 27, 2012 8:27 AM by ongoer23 RSS

    ColdFusion 9 Enterprise - Error Connecting to Oracle

    ongoer23

      Hi,

       

      I'm in the process of configuring our production server with ColdFusion 9 Enterprise. The prod build is carried out according to the same build document used to implement our DEV and QA environments which are working correctly.

       

      When setting up the datasources, I get the following:

       

      Connection verification failed for data source: sara_eng

      java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]Error establishing socket to host and port: ginge.ic.gc.ca:1521. Reason: Connection refused: connect

      The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]Error establishing socket to host and port: ginge.ic.gc.ca:1521. Reason: Connection refused: connect

       

      Since our production environment is located within a DMZ and our Oracle db is on the other side of the DMZ I consulted with our firewall group to ensure there was a rule for port 1521 between the app and db servers. There is the approriate rule in place. They sent me some log entries which state that the ColdFusion app server is attempting to send a TCP Reset to the Oracle server which the firewall is blocking.

       

      My current production server is in the same DMZ running ColdFusion MX7 without this issue. Any suggestions?

       

      Thanks,

       

      Chad