RE: HP-UX 11i/8.1.7/DB Link Question

Mike,

The listener.log provides a ton of information if handled properly. I used a Perl program to process this.. Basically, you have to look for connections from the set of identified hosts that connect to the database.

16-NOV-2002 12:55:18 *
(CONNECT_DATA=(SID=XXXX)(GLOBAL_NAME=XXXXX)(CID=(PROGRAM=)(HOST=(<source_hos t>)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xxxx)(PORT=38675)) * establish * XXXX * 0

This is assuming that you do not normally allow users to login to UNIX hosts and use SQL*Net to connect across systems...

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

What would you see if you were allowed to look back at your life at the end of your journey in this earth?

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: Vergara, Michael (TEM) [mailto:mvergara_at_guidant.com]
> Sent: Wednesday, January 29, 2003 11:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: HP-UX 11i/8.1.7/DB Link Question
>
>
> Hi Everyone!
>
> I have been tasked with finding out how often connections are
> made between
> databases using DB links. Does anyone know of a tracking or auditing
> tool, or perhaps a audit methodology, that would provide this
> information?
>
> Thanks,
> Mike
>
> ---
> ==============================================================
> =============
> Michael P. Vergara
> Oracle DBA
> Guidant Corporation
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Vergara, Michael (TEM)
> INET: mvergara_at_guidant.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).