Angel,
This error can occur with an incorrect setting for
COMPATIBLE in the init.ora. What is it set to on your
prod db?
HTH,
- Anita
- Angel Munte Salvador <angel_at_edreams.com> wrote:
> Hi,
>
> curiously, I've begun to have problems with "alter
> session" statements
> after applying this patch for 8.1.6.3 on Solaris.
> But maybe it is not due to the patchset, because
> I've applied it on 2
> servers and I'm only having problems in one of them,
> the production one!!!
> Have you ever seen this kind of error?
>
> SQL> alter session set optimizer_mode=all_rows;
> ERROR:
> ORA-00096: invalid value ALL_ROWS for parameter
> optimizer_mode, must be from
> among signature, timestamp
>
> Thx,
> Àngel
>
>
> At 23.55 18/7/01 -0800, you wrote:
>
> >You can't get more secure than that!
> >John
> >
> >-----Original Message-----
> >From: John Lewis
>
>[<mailto:jlewis_at_punchnetworks.com>mailto:jlewis_at_punchnetworks.com]
> >Sent: 19 July 01 00:01
> >To: Multiple recipients of list ORACLE-L
> >Subject: Oracle listener security patch -
> >
> >Just installed p1859778_8162_Solaris patch for
> listener security problems.
> >Before I installed it - everything was hunky-dory.
> >Afterwards the listener wouldn't start any
> 'services'.
> >Haven't tried metallink yet.
> >
> >Anybody had this problem?
> >
> >(Using 8.1.6.2 on Sun Solaris)
> >
> >TIA -
> >john f. lewis
> >
> >--
> >Please see the official ORACLE-L FAQ:
> ><http://www.orafaq.com>http://www.orafaq.com
> >--
> >Author: John Lewis
> > INET: jlewis_at_punchnetworks.com
> >
> >Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> >San Diego, California -- Public Internet
> access / Mailing Lists
>
>--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an
> E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB
> ORACLE-L
> >(or the name of mailing list you want to be removed
> from). You may
> >also send the HELP command for other information
> (like subscribing).
> >
> >
> >
>
>**********************************************************************
> >This email and any attachments may be confidential
> and the subject of
> >legal professional privilege. Any disclosure, use,
> storage or copying
> >of this email without the consent of the sender is
> strictly prohibited.
> >Please notify the sender immediately if you are not
> the intended
> >recipient and then delete the email from your inbox
> and do not
> >disclose the contents to another person, use, copy
> or store the
> >information in any medium.
>
>**********************************************************************
>
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sun Jul 22 2001 - 11:50:02 CDT