Re: Floating ports with oracle 7.3.3 on NT

Along with the that, Oracle should only be using port 1525 (by default) It was assigned to oracle and listed in the Internic's RFC 1700 ASSIGNED NUMBERS (url: ftp://ftp.isi.edu/in-notes/rfc1700.txt)

Oracle should be only using one port, which the firewall can pass it through. But why are you letting people access your database with sqlnet from outside the firewall? I hope you remembered to change the sys & system password as well as remove (or disable) the SCOTT account.

Good luck,
darryl dB Balaski Oracle DBA
Pfizer Central Research, Groton, CT
(web page coming soon: www.rdbms.org)

Thomas Kyte wrote:
>
> A copy of this was sent to "Sebastien CLEYET-MERLE"
> <sebastien.cleyet-merle_at_lemel.fr>
> (if that email address didn't require changing)
> On 29 Oct 1998 10:51:47 +0100, you wrote:
>
> >Hi,
> >
> >I am working at HP and I woudl like to ask all of you on those Newsgroups a
> >troubling question.
> >
> >With Oracle 7.3.3 on NT using SQL Net v2 to connect the Database, I have
> >BIG problem with the firewall because Oracle uses one fixed port and 2 port
> >dynamically allocated. Does anyone know a tool, patch, configuration, ...
> >that allow to solve this problem fixing the used ports ?
> >
>
> Are you using MTS? If not, then we only use the one fixed port. It is MTS that
> would cause us to use dynamically assigned ports.
>
> If you are using dedicated servers, then all network traffic happens on the one
> port.
>
> >The only answer I got from ORACLE is BUY ORACLE 8 no very efficient for me
> >because migration from Oracle 7.3.3 can cause some problems, bigger
> >problems.
> >
> >Thanks for you help and please email me you answers if so.
> >
> >Sebastien.
> >
> >sebastien.cleyet-merle_at_lemel.fr
>
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Government
> Herndon VA
>
> --
> http://govt.us.oracle.com/ -- downloadable utilities
>
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
>
> Anti-Anti Spam Msg: if you want an answer emailed to you,
> you have to make it easy to get email to you. Any bounced
> email will be treated the same way i treat SPAM-- I delete it.
Received on Thu Oct 29 1998 - 00:00:00 CET