Re: Firewall Problem with Oracle 8.1.5 on Linux SQL *NET

From what I understand, Oracle uses:

• default port 1521 to listen for connection requests, then
• asks the client to use another port for the actual connection, as specified by the server

Your problem is the second phase of the connection, as shown above. I have read before that there are some firewalls that integrate or understand SQL*Net, so as to allow the second stuff.

What about Oracle Connection Manager?

John Salvo

Michael Poremski wrote:
>
> Dear "marketmaker",
>
> your hint does not work! Sorry. If I look in the listener.log file on
> the Server I see the following lines:
>
> TNSLSNR for Linux: Version 8.1.5.0.0 - Production on 12-MAR-00
> 12:42:37
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> System parameter file is
> /opt/oracle/orahome/network/admin/listener.ora
> Log messages written to /opt/oracle/orahome/network/log/listener.log
>
> Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lisrv1.edv-poremski.de)(PORT=1521))(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))
> TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN
> CODE
> 12-MAR-00 12:42:37 *
> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=lisrv1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135286784))
> * status * 0
> 12-MAR-00 12:43:29 * service_register * ORCL * 0
> 12-MAR-00 12:43:38 * service_register * ORCL * 0
> 12-MAR-00 12:43:38 * service_register * ORCL * 0
> 12-MAR-00 12:44:29 *
> (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\Programme\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=WRK01)(USER=Michael)))
> * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.21)(PORT=1057)) * establish
> * orcl * 0
> 12-MAR-00 12:46:06 *
> (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\Programme\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=WRK01)(USER=Michael)))
> * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.21)(PORT=1060)) * establish
> * orcl * 0
>
> The Problem is: Port 1057, 1060 ..... are dynamical. I need a fixed
> Port!
>
> Thanks for all tips.
>
> Michael
>
> On Sat, 11 Mar 2000 19:39:54 -0800, marketmaker
> <wensheng_98NOweSPAM_at_yahoo.com.invalid> wrote:
>
> >You can configure your Oracle listener through Net8 (netasst on
> >Linux). This starts an Java application. Select Listener node
> >and click on "Create" menu item under one of the menus. Follow
> >the wizzard and you can reset your listener port to 1521.
> >
> >
> >* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> >The fastest and easiest way to search and participate in Usenet - Free!
 

-- 
* Oracle8i on RedHat 6.0:
http://homepages.tig.com.au/~jmsalvo/linux/oracle8i.html
* OpenJGraph: http://openjgraph.sourceforge.net/
* DBDependency:
http://homepages.tig.com.au/~jmsalvo/dbdependency/index.html