Re: Ports in listener.log
Date: Thu, 26 Jun 2008 13:25:15 -0400
Message-ID: <OFF0F5617C.95A3CD01-ON85257474.005F66CE-85257474.005FB20E@swfwmd.state.fl.us>
25-JUN-2008 13:49:20 *
(CONNECT_DATA=(SERVICE_NAME=devdbs.ad.swfwmd.net)(SERVER=DEDICATED)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=BKVVMIMS03P)(USER=JDOE)))
- (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.25.117)(PORT=1098)) * establish * devdbs.ad.swfwmd.net * 0
I'm waiting to get with the sysadmin on the server to confirm that there is not a tns entry over there, but it would be on 1522 if it was.
I'm trying to under (1) how would this connect from the .NET application without a tnsnames entry, and (2) if it's not through tns, why are there entries in my listener.log?
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.
"Bradd Piontek"
<piontekdd_at_gmail.
com> To
Sherrie.Kubis_at_swfwmd.state.fl.us
06/26/2008 01:04 cc
PM 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/ 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.Received on Thu Jun 26 2008 - 12:25:15 CDT-- http://www.freelists.org/webpage/oracle-l
