Re: Connecting IIS to Oracle through a Firewall

From: Sean Zhang <sean_at_cnfei.com>
Date: Tue, 22 Aug 2000 14:59:00 -0400
Message-ID: <bcAo5.1656$N2.6058@firenze>

Hi, Ryan,

I believe you can use Oracle Connection Manger to accomplish this. 1. Install Oracle connection manager on the IIS server machine from any Oracle 8i
  CD ( Including Oracle Personal 8i).
2. User Net assistant to configure a TNSNAMES.ora file on IIS server

   ( see Oracle Network administrator's guide)

After you got your new tnsnames.ora file ( something like :

(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = IIS_SERVER)(PORT = 1630))
      (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE_SERVER)(PORT = 1521))
      (SOURCE_ROUTE = yes)
      (FAILOVER = false)

    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORACLE_SID.domain)     )
then you just make your connection to the port 1630, Oracle connection manager will
route the request to Oracle DB. ( which means IIS-server <----> Oracle_server is
a fixed connection between port 1630---1521 ).

Hope this helps.

Sean zhang
sean_at_cnfei.com
"Ryan" <stuffedlobster_at_hotmail.com> wrote in message news:Tpmo5.21995$xg1.200746_at_news1.rdc1.sdca.home.com...
> Does anyone know of a way to lock down the TCP/IP ports that Oracle
> communicates over. We have an IIS Server that is outside our firewall and
> an Oracle 8i Server inside the firewall. We established an ODBC
 connection
> using Oracles's ODBC driver between the two IP's. We, also opened up
 ports
> 1521 and 1526 to negotiate over. However, once it negotiates, it appears
 to
> want to pass data over a random port. Is there a way to identify what
 ports
> it can and cannot use?
>
> thanks,
> ryan
>
>
Received on Tue Aug 22 2000 - 13:59:00 CDT