Re: Oh, lovely!......
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Wed, 7 Mar 2012 07:55:34 -0800 (PST)
Message-ID: <18409433.30.1331135734713.JavaMail.geo-discussion-forums_at_yncd14>
On Tuesday, March 6, 2012 8:26:27 PM UTC-5, Mladen Gogala wrote:
> On Tue, 06 Mar 2012 14:07:04 -0800, Noons wrote:
>
> > Excuse moah? I can't see the IP Address of my session?
> > This has only worked since I forgot when, now it stopped working?
>
> That is because you are using evil AiX and not good Linux or Solaris:
>
>
>
> Connected to:
> Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
>
> SQL> SELECT SYS_CONTEXT('USERENV','IP_ADDRESS')
> 2 from dual;
>
> SYS_CONTEXT('USERENV','IP_ADDRESS')
> --------------------------------------------------------------------------------
> 192.168.1.100
>
> Elapsed: 00:00:00.00
> SQL>
>
> On the other hand, a silly question: is your AIX using IPv6? I
> distinctly remember reading something like that, but as I am not using, I
> am haven't paid much attention to it. If that is IPv6 configuration, your
> Oracle might be right.
>
> --
> http://mgogala.byethost5.com
Date: Wed, 7 Mar 2012 07:55:34 -0800 (PST)
Message-ID: <18409433.30.1331135734713.JavaMail.geo-discussion-forums_at_yncd14>
On Tuesday, March 6, 2012 8:26:27 PM UTC-5, Mladen Gogala wrote:
> On Tue, 06 Mar 2012 14:07:04 -0800, Noons wrote:
>
> > Excuse moah? I can't see the IP Address of my session?
> > This has only worked since I forgot when, now it stopped working?
>
> That is because you are using evil AiX and not good Linux or Solaris:
>
>
>
> Connected to:
> Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
>
> SQL> SELECT SYS_CONTEXT('USERENV','IP_ADDRESS')
> 2 from dual;
>
> SYS_CONTEXT('USERENV','IP_ADDRESS')
> --------------------------------------------------------------------------------
> 192.168.1.100
>
> Elapsed: 00:00:00.00
> SQL>
>
> On the other hand, a silly question: is your AIX using IPv6? I
> distinctly remember reading something like that, but as I am not using, I
> am haven't paid much attention to it. If that is IPv6 configuration, your
> Oracle might be right.
>
> --
> http://mgogala.byethost5.com
AIX is only evil because it is a better implementation of UNIX than Solaris or Linux.
HTH -- Mark D Powell -- Received on Wed Mar 07 2012 - 09:55:34 CST