Re: Ports in listener.log

I think I already explained the port question. Port 1098 is the client port that is talking to the shadow process on the database server.

As for how it is connecting. Getting with your sysadmin is the best idea. I would be hard-pressed to find something that isn't using the Oracle client and a tnsnames.ora on the IIS server (I think even the Microsoft ODBC Driver requires the Oracle client to be there, but I could be wrong).

On Thu, Jun 26, 2008 at 12:25 PM, <Sherrie.Kubis_at_swfwmd.state.fl.us> wrote:

> 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 <Sherrie.Kubis_at_watermatters.org>
> http://www.watermatters.org
> -------------------------------------------------------------------------
>
> Good judgement comes from experience,
> and a lot of that comes from bad judgement.
>
>
> [image: Inactive hide details for "Bradd Piontek" <piontekdd_at_gmail.com>]
> "Bradd Piontek" <piontekdd_at_gmail.com>
>
>
>
> *"Bradd Piontek" <piontekdd_at_gmail.com>*
>
> 06/26/2008 01:04 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*<Sherrie.Kubis_at_swfwmd.state.fl.us>>
> wrote:
>
> Oracle *10.2.0.3* <http://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*<Sherrie.Kubis_at_watermatters.org>
> *
> **http://www.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*<http://www.twitter.com/piontekdd>
> Oracle Blog: *http://piontekdd.blogspot.com*<http://piontekdd.blogspot.com/>
> Linked In: *http://www.linkedin.com/in/piontekdd*<http://www.linkedin.com/in/piontekdd>
> Last.fm: *http://www.last.fm/user/piontekdd/*<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.
>
>
>

-- 
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