ODBC connection to Oracle 9 db trough Cisco VPN and ISA

Posted on 2010-01-02
Last Modified: 2013-12-19
I need to establish ODBC connection from one server trough ISA server and Cisco VPN  to remote Oracle 9 db. VPN works fine, i can connect to remote network, I think that I have some problems in the ISA configuration which blocking traffic to the remote database. The same thing works fine from the another PC (directly connected to the internet, without ISA, so I think that everything is fine with credentials). This issue is very urgent, thank to all of experts for quick response.
Question by:sbajsic
    LVL 67

    Accepted Solution

    In most cases this is caused by the Oracle Listener working as portmapper only. That is, the connect port (1521 by default) is not used for data, only for getting information about the dynamically negotiated ports to contact Oracle DBMS. You can switch that behaviour off, but that requires to modify the target listener config, and a restart of the DBMS instance.
    If that is an option, you need to set a registry value:
    LVL 67

    Expert Comment

    ... on Oracle Server side. And restart Listener and instance.
    LVL 51

    Assisted Solution

    by:Keith Alabaster
    If it is that urgent, call Microsoft and pay for an incident to be raised.
    Alternatively, telling me the version of ISA Server and the level of Service pack applied would be helpful.
    Assuming it is a supported version (and not ISA2000) then open the ISA gui - select monitoring - logging - click on start query. Make an attempt to create the ODBC connection - what do you see appear in the realtime log in respect to the attempt?

    Author Closing Comment

    Thank you guys. The problem was probably in the fact that Cisco VPN client was installed on the ISA server and that cause multiply problems. I have moved Cisco VPN client to another PC in the network and everything work fine.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Common practice undertaken by most system administrators is to document the configurations and final solutions of anything performed by them for their future use and reference. So here I am going to explain how to export ISA Server 2004 Firewall pol…
    I've written this article to illustrate how we can implement a Dynamic Multipoint VPN (DMVPN) with both hub and spokes having a dynamically assigned non-broadcast multiple-access (NBMA) network IP (public IP). Here is the basic setup of DMVPN Pha…
    This video shows how to recover a database from a user managed backup
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    734 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

    20 Experts available now in Live!

    Get 1:1 Help Now