Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connecting IIS to Oracle through a Firewall
Am I labouring under a misaprehension here - I understood Connection Manager to be *only* available with EE.
-- Niall Litchfield Oracle DBA Audit Commission UK "Sean Zhang" <sean_at_cnfei.com> wrote in message news:bcAo5.1656$N2.6058_at_firenze...Received on Wed Aug 23 2000 - 08:20:52 CDT
> 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
> >
> >
>
>