Re: Possible Security Breach

On Fri, 27 Aug 2004 08:37:16 +0100, rc <rc_at_spam.com> wrote:

>Well here is the tnsnames.ora
>///////////////////////////////////////////////////////////////////////////////////////////
># TNSNAMES.ORA Network Configuration File:
>/opt/oracle/product/8.1.7/network/admin/tnsnames.ora
># Generated by Oracle configuration tools.
>
>TEST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = sunoracle)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = TEST)
> )
> )
>
>SUN =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = sunoracle)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = SUN)
> )
> )
>
>INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = sunoracle)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = TEST)
> (PRESENTATION = http://admin)
> )
> )
>
>EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
>///////////////////////////////////////////////////////////////////////////////////////////////////
>
>There is nothing in here about the blueyounder host our server is
>trying to contact.
>
>Can I ask some one waht the PLSExtProc does, this is the first time I
>have had to look into this, and I know little about the tnslistner

Evidently you have a listener running on port 1521. As Howard explains each instance registers itself with the listener every minute. I guess you would do better to spend your time on something else, eg. reading in the net 8 manual what the Plsextproc does, rather than misusing this group as a replacement for reading manuals.

--
Sybrand Bakker, Senior Oracle DBA