Re: Oh, lovely!......
From: joel garry <joel-garry_at_home.com>
Date: Tue, 6 Mar 2012 16:29:25 -0800 (PST)
Message-ID: <aacf915e-9dc4-4c86-a4d7-987d89a74263_at_gj7g2000pbc.googlegroups.com>
On Mar 6, 4:08 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Mar 6, 2:07 pm, Noons <wizofo..._at_gmail.com> wrote:
>
>
>
>
>
>
>
>
>
> > Release: 11.2.0.3
> > OS: Aix 7.1 64-bit
> > Problem:
> > 1 SELECT SYS_CONTEXT('USERENV','SESSION_USER')
> > 2 ,SYS_CONTEXT('USERENV','IP_ADDRESS')
> > 3* from dual
> > SQL> /
> > SYS_CONTEXT('USERENV','SESSION_USER')
> > --------------------------------------------------------------------------------
> > SYS_CONTEXT('USERENV','IP_ADDRESS')
> > --------------------------------------------------------------------------------
> > SYS
> > ****(null)
>
> > Excuse moah? I can't see the IP Address of my session?
> > This has only worked since I forgot when, now it stopped working?
> > Yes, this is "dba1.0" sqlplus code - any problems with that?
> > No, we are not on IPV6 - we are on IPV4 and according to the 11.2 SQL guide this MUST work.
> > No, we are NOT going to change our entire OS platform so that Oracle doesn't have to do testing of their Aix releases!!!!
>
> > Who authorized this ABORTION to reach production-ready status, mr Oracle??????
> > Worse: how come in the two years this nonsense has been out NO ONE has detected this BASIC problem?
> > How come I have to do alpha testing for software that is costing me 5 figures yearly to maintain a support contract on?
>
> > No, I don't expect an answer here.
> > Just venting.
> > And looking at options for future database software:
> > this entire rigmarole has now reached "beyond the joke" status...
>
> I find the same thing in XE 11g on windows and 10.2.0.4 on hp-ux, both
> as sysdba and as a user. When was the last time it worked? I see
> some package owa_sec in the docs, maybe it just got old/replaced by
> fusion. You don't have to be 2.0 to be super-duper-packages-man.
>
> jg
> --
> _at_home.com is bogus.
> So I'm waiting at a stoplight, press the radio button for business
> news, take a big swig from the water bottle, and hear "... go to
> Wizard Of Bras dot com!"
Date: Tue, 6 Mar 2012 16:29:25 -0800 (PST)
Message-ID: <aacf915e-9dc4-4c86-a4d7-987d89a74263_at_gj7g2000pbc.googlegroups.com>
On Mar 6, 4:08 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Mar 6, 2:07 pm, Noons <wizofo..._at_gmail.com> wrote:
>
>
>
>
>
>
>
>
>
> > Release: 11.2.0.3
> > OS: Aix 7.1 64-bit
> > Problem:
> > 1 SELECT SYS_CONTEXT('USERENV','SESSION_USER')
> > 2 ,SYS_CONTEXT('USERENV','IP_ADDRESS')
> > 3* from dual
> > SQL> /
> > SYS_CONTEXT('USERENV','SESSION_USER')
> > --------------------------------------------------------------------------------
> > SYS_CONTEXT('USERENV','IP_ADDRESS')
> > --------------------------------------------------------------------------------
> > SYS
> > ****(null)
>
> > Excuse moah? I can't see the IP Address of my session?
> > This has only worked since I forgot when, now it stopped working?
> > Yes, this is "dba1.0" sqlplus code - any problems with that?
> > No, we are not on IPV6 - we are on IPV4 and according to the 11.2 SQL guide this MUST work.
> > No, we are NOT going to change our entire OS platform so that Oracle doesn't have to do testing of their Aix releases!!!!
>
> > Who authorized this ABORTION to reach production-ready status, mr Oracle??????
> > Worse: how come in the two years this nonsense has been out NO ONE has detected this BASIC problem?
> > How come I have to do alpha testing for software that is costing me 5 figures yearly to maintain a support contract on?
>
> > No, I don't expect an answer here.
> > Just venting.
> > And looking at options for future database software:
> > this entire rigmarole has now reached "beyond the joke" status...
>
> I find the same thing in XE 11g on windows and 10.2.0.4 on hp-ux, both
> as sysdba and as a user. When was the last time it worked? I see
> some package owa_sec in the docs, maybe it just got old/replaced by
> fusion. You don't have to be 2.0 to be super-duper-packages-man.
>
> jg
> --
> _at_home.com is bogus.
> So I'm waiting at a stoplight, press the radio button for business
> news, take a big swig from the water bottle, and hear "... go to
> Wizard Of Bras dot com!"
Correction: it works when connected remotely, not locally. I got snookered by having my sid in my sql prompt.
jg
-- _at_home.com is bogus. http://topics.bloomberg.com/bloomberg-billionaires-index/Received on Tue Mar 06 2012 - 18:29:25 CST