Path: news.f.de.plusline.net!news-fra1.dfn.de!storethat.news.telefonica.de!telefonica.de!news.germany.com!feed.xsnews.nl!border-1.ams.xsnews.nl!news.astraweb.com!newsrouter-eu.astraweb.com!border2.nntp.ams.giganews.com!nntp.giganews.com!transit.news.xs4all.nl!xs4all!textnews.nntp.hccnet.nl!textreader.nntp.hccnet.nl!not-for-mail From: sybrandb@hccnet.nl Newsgroups: comp.databases.oracle.server Subject: Re: SQL Net port Date: Sat, 05 May 2007 16:25:02 +0200 Message-ID: References: <463c8878$0$15897$426a74cc@news.free.fr> X-Newsreader: Forte Agent 4.2/32.1118 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 39 Organization: Hobby Computer Club News Network NNTP-Posting-Date: 05 May 2007 14:25:20 GMT NNTP-Posting-Host: 62.251.43.140 X-Trace: 1178375120 textreader.nntp.hccnet.nl 741 62.251.43.140:1844 X-Complaints-To: abuse@hccnet.nl Xref: news.f.de.plusline.net comp.databases.oracle.server:197467 On Sat, 5 May 2007 15:35:20 +0200, "astalavista" wrote: >Hi, > >I am trying to connect to a database through a firewall >according the documentation sometimes >a port redirection arise: >- to UNIX : no port redirection >- to windows : port redirection >- with MTS : port redirection > >am I right ? > >so if I have to connect to a UNIX database (no MTS) >I only have to open the listener port (1521), no ? > >Thanks for your lights ... > Could you point to the *Oracle* documentation in which you have been reading this? If you really read that, you should submit that as a documentation bug. There is *always* port redirection, on whatever platform. There are three situations where you won't have port redirection (and I posted them over and over again, but I appreciate people like you can't be bothered with searching the archives) 1 sqlnet.use_shared_sockets = true in sqlnet.ora *on the server* (Unix) or registry key USE_SHARED_SOCKETS=true (Windows) Disadvantage: when you stop the listener all sessions are disconnected 2 setting up MTS on a *hardcoded* port in the dispatcher parameter. Disadvantage: need to configure your database for MTS 3 Setting up Connection Manager, and change your tnsnames.ora accordingly. This is the only option that doesn't have any disadvantages. Sybrand Bakker Senior Oracle DBA