Re: How to get client's IP or name instead of OraUser

Reza Abouk,

Take a look at V$SESSION. Depending on your clients' O/S, it will show varying levels of information. You can also add USERNAME={client name} on your clients' ORACLE.INI as others have suggested.

If your clients are using SQLNet TCP/IP to connect your database, you can run NETSTAT (available for Unix and MS Windows NT) on your server. You should see a list of all active TCP connections with Oracle connections shown with a local machine name as {server host}.orasrv and the foreign machine name shown as your clients' host alias or ip address.

I use netstat along with other ip utilities to track down unknown connections.

I hope this helps.

-William Huang / mailto:whuang_at_earthlink.net

Reza Abouk <rabouk_at_mcimail.com> wrote:
>
> Hi,
>
> Is there a way to find out the IP address or the user name of
> the clients.
> A while back one DBA told me to put a line :
> OS_USER=any user name or IP address
> in the oracle.ini file, but that wasn't the solution.
> Feel free to call or send e-mail.
>
> Regards,
>
> Reza Abouk
> Sr. Systems Analyst
> Network Systems Integration Lab - Automation
> M.C.I Telecommunications
> (214) 918-2268
> rabouk_at_mcimail.com
Received on Mon Feb 26 1996 - 00:00:00 CET