Re: Which PC is connected

In article <richard_avery-100895074526_at_nnsgm25.lon40.nt.com>, richard_avery_at_nt.com (Richard Avery) writes:
>> In article <725584852wnr_at_unisol.demon.co.uk>, "D:WINSOCKKA9QSPOOLMAIL"
>> <mark_at_unisol.demon.co.uk> wrote:
>>
>> > In a PC-Unix client-server setup using TCP/IP and orasrv how can I
>> > deteremine which PC has an open connection to the database ?
>> > I can get the process id and some related info from sys.v$session and
>> > sys.v$process but I cannot relate an IP address to a particular
>> > process.
>> >
>> Mark,
>>
>> I am not sure what tools you need to extract the information into but you
>> are going to have to go to the Unix level to get this information. The
>> easiest way would be to grep the terminal name from the command "who -R"
>> and to cur the machine name from the output from that command.
>>
>> e.g. who -R | grep ttyp3 | cut -d \( -f2 | cut -d\) -f1
>>
>> Post again if this is not the info you required. I hope who -R is supported
>> on your machine.
>>
>> Richard Avery
>> --
>> The above posting does not represent the views of Nortel in any way.

Set USERNAME=xxx in the PC oracle.ini file. This xxx will come out in the v$session.osuser column.

--
*****************************************************
* Burt Peltier Shell Offshore    ep94bvps_at_shell.com *
* (504) 588-0179 701 Poydras #1660 New Orleans 70139*
*****************************************************