Re: IDENTIFYING USERS

In article <58pm1t$kbe_at_crc-news.doc.ca>,

        collinsde_at_ic.gc.ca (denise collins) writes:
>
>I am fairly new to developing in Oracle. Is there any simple way
>(with the aid of a DBA) to capture the TCP/IP address of an end-user
>who is logged on to Oracle under windows 3.1/windows 95. Any help would
>be greatly appreciated.
>
>Regards, Denise.

Denise,
I tried replying to you, but your mail domain (ic.gc.ca) doesn't seem to be known to the DNS severs around here.

1. What you have to do is obtain the package 'lsof', and compile and install it on the ORACLE server (assuming it uses UNIX ... NT is out of luck).
2. Generate the query that you want from the v$ tables, and put its output to a temporary location.
3. Run lsof against the ORACLE sockets that you have active ... i.e. 1521 & 1525 or SQL*NET V2 and 1. Save to a temp location.
4. Sort non-numerically each temp file by UNIX process ID.
5. Outer join the V$ output against the lsof output.
6. Format the output for reporting (I use awk). Note that
7. Local server connections will not show an IP number or name
8. SQL*NET V1 connections will show 2 processes.

If you email me with a valid address, I can send you an actual working sample, and the tar file for lsof.

Bill

-- 
----------------------------------
E-Mail: Beatonb_at_cadvision.com or Bill_Beaton_at_calgary.qc-data.com
----------------------------------