RE: Ports in listener.log

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <piontekdd@xxxxxxxxx>, <Sherrie.Kubis@xxxxxxxxxxxxxxxxxx>
  • Date: Thu, 26 Jun 2008 13:23:07 -0400

Bradd is correct about this.  But Sherrie's question was how was a
connection being made from a machine that did not have an entry in it's
tnsnames file for the database server.
 
Java programs do not need the Oracle client (tns stuff) installed to
connect to a database.

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bradd Piontek
Sent: Thursday, June 26, 2008 1:05 PM
To: Sherrie.Kubis@xxxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Ports in listener.log


Do you have some example listener log entries?

Are you sure they are connecting on some other port and that the port is
not the port on the client ? Windows connects initially on the listener
port but than spawns a new thread which is on a different port each
time. 


On Thu, Jun 26, 2008 at 11:58 AM, <Sherrie.Kubis@xxxxxxxxxxxxxxxxxx>
wrote:


        Oracle 10.2.0.3
        HP-UX
        
        I have a 10.2 listener listening on port 1522, and see
connections established using that. However, I also see connections
coming in on other ports, that look like the increment by 1 each time.
The connections are coming from a .net application on a windows server
through IIS, and that server does not have a tns entry in tnsnames.ora.
We removed it from there to specifically prevent connections to this
database. Anyone have any idea how this could be happening?
        
        
        
------------------------------------------------------------------------
        Sherrie Kubis
        Oracle DBA Supervisor
        Information Resources Department
        Application Systems Section 
        Southwest Florida Water Management District
        352-796-7211 x4033
        mailto:Sherrie.Kubis@xxxxxxxxxxxxxxxx
        http://www.watermatters.org
        
------------------------------------------------------------------------
-
        
        Good judgement comes from experience, 
        and a lot of that comes from bad judgement.
        
        

        IMPORTANT NOTICE:  All E-mail sent to or from this address are
public record and archived.  The Southwest Florida Water Management
District does not allow use of District equipment and E-mail facilities
for non-District business purposes.
        




-- 
Bradd Piontek
Twitter: http://www.twitter.com/piontekdd
Oracle Blog: http://piontekdd.blogspot.com
Linked In: http://www.linkedin.com/in/piontekdd
Last.fm: http://www.last.fm/user/piontekdd/ 

Other related posts: