RE: Ports in listener.log

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 26 Jun 2008 13:23:07 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF01E26C71@EXCNYSM0A1AJ.nysemail.nyenet>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bradd Piontek Sent: Thursday, June 26, 2008 1:05 PM
To: Sherrie.Kubis_at_swfwmd.state.fl.us
Cc: oracle-l_at_freelists.org
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_at_swfwmd.state.fl.us> 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_at_watermatters.org
	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/

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 26 2008 - 12:23:07 CDT