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=)(GLOBAL_NAME=X)(CID=(PROGRAM=)(HOST=(source_hos
t)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=38675)) *
establish * * 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:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).