:
[EMAIL PROTECTED]Subject: How to get user's IP address?
.com
Hi Anne
I tried this on 9iR1
oracle:jupiter sqlplus system/manager
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 25 20:45:54 2003
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning
Hi!
It looks like you need to use the service name when connecting to get
the IP Address.
Could it be because you can't have an IP address when using protocol other
than TCP/IP ;)
Connecting using just ORACLE_SID goes through IPC (or Beq if you like)
Tanel.
--
Please see the official
This is probably related to the protocol that your client uses
to connect to the Oracle server. If you use Bequeth or Netware
for instance, there really isn't an IP address to speak of.
-Original Message-
Sent: Wednesday, June 25, 2003 4:58 PM
To: Multiple recipients of list ORACLE-L
Hi