ports 1521 & 1526

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Thu, 05 Nov 1998 15:14:10 -0500
Message-ID: <36420711.C58DF558@bigfoot.com>

I just posted a couple of notes about a situation that seems resolved now,
but with no explanation...
A box (999.99.999.99)has an oracle listener on port 1526, and only on 1526, and has
been that way for months. A Tnsnames.ora file like below (names changed)
ASID.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = 999.99.999.99)


          (Port = 1521)


        )
        (ADDRESS =


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = 999.99.999.99)


          (Port = 1526)


        )

    )
    (CONNECT_DATA = (SID = ASID)
    )
  )

Has allowed SQL*Plus connections for months as well, until this morning,

when
TNS: packet checksum error
happened to everyone. Until, the 1521 was changed to 1526 so that it was 1526
in both places. Now everything is fine. But I don't know the cause.. The box
(999.99.999.99) has not had any maintenance done on it, the database was not
recycled et., The only variable that is not under our control is that the packets
would make a hop to another machine that I know nothing about, before being
passed through a firewall (also no maintenance). From what I understand, some
versions of SQL*Net used 1521 as a failover, and now in Net 8, only one port
is specified. Any thoughts would be appreciated.

Any suggestions?

Dc. Received on Thu Nov 05 1998 - 14:14:10 CST