Xref: alice comp.databases.oracle.misc:56708 comp.databases.oracle.server:90275 comp.databases.oracle.tools:42283 Path: alice!news-feed.fnsi.net!netnews.com!newspeer1.nac.net!yellow.newsread.com!netaxs.com!newsread.com!POSTED.newshog.newsread.com!not-for-mail From: "Van Messner" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools References: <8cbu9p$13s$1@toster.Te.NeT.UA> <8ccnl9$9l7$1@news1.xs4all.nl> <8cd30c$j4o$1@soap.pipex.net> Subject: Re: ORACLE TCP port usage Lines: 52 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Message-ID: Date: Tue, 04 Apr 2000 23:54:26 GMT X-Complaints-To: Abuse Role , We Care X-Trace: newshog.newsread.com 954892466 216.179.16.127 (Tue, 04 Apr 2000 19:54:26 EDT) NNTP-Posting-Date: Tue, 04 Apr 2000 19:54:26 EDT Organization: BestWeb (bestweb.net) You'll have to search dejanews but there was a detailed posting a month or so ago. The gist was that while you can specify which port to use (1521 and 1526 are the most common), going through the firewall may involve a random assignment of ports so that you can't just list them in tnsnames.ora. Find the post cause it has the solution. Van Niall Litchfield wrote in message news:8cd30c$j4o$1@soap.pipex.net... > IIRC and it has been a long day > > 1521 (and maybe 1526) are required for the listener to receive requests for > a connection from a client. the actual connection is then handed off to a > free tcp port. To use thru a firewall i believe you need to look at using > connection manager. Otherwise it might be worth sqlplussing to internet > databases with system/manager to see what people are exposing! > > -- > Niall Litchfield > Oracle DBA > Audit Commission UK > "Patrick van Zuilen" wrote in message > news:8ccnl9$9l7$1@news1.xs4all.nl... > > Look in TNSNAMES.ORA file. > > Here is port the port number default 1521 > > > > Dmitry Yakimenkov wrote in message > > news:8cbu9p$13s$1@toster.Te.NeT.UA... > > > Hello! > > > Can somebody help me to know, what ports does Oracle use for it > connection > > > between client and server, and how to control ports reservation. I have > to > > > do this because of firewall. > > > Thanks! > > > > -------------------------------------------------------------------------- > > -- > > > Dmitry Yakimenkov > > > > > > > > > > > > > > >