Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!h40g2000pro.googlegroups.com!not-for-mail From: joel garry Newsgroups: comp.databases.oracle.server Subject: Re: Illegal option for "ALTER SYSTEM"??? Date: Wed, 7 Jul 2010 09:12:29 -0700 (PDT) Organization: http://groups.google.com Lines: 105 Message-ID: References: <306d3576-166b-4707-9229-2368b3442557@c10g2000yqi.googlegroups.com> NNTP-Posting-Host: 12.232.112.189 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1278519150 27772 127.0.0.1 (7 Jul 2010 16:12:30 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 7 Jul 2010 16:12:30 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: h40g2000pro.googlegroups.com; posting-host=12.232.112.189; posting-account=tpQovAkAAABNoH5bwsZAiff2L0zxGwdv User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 ( .NET CLR 3.5.30729),gzip(gfe) Xref: news.cambrium.nl On Jul 7, 6:22=A0am, Mark D Powell wrote: > On Jul 7, 8:21=A0am, Mladen Gogala wrote: > > > > > This is 10.2.0.4 on Linux x86-64: > > > SQL> alter system set events=3D'1013 trace name context off' scope=3Dbo= th > > sid=3D'*'; > > alter system set events=3D'1013 trace name context off' scope=3Dboth si= d=3D'*' > > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 * > > ERROR at line 1: > > ORA-02065: illegal option for ALTER SYSTEM > > > What's going on? When I try something else, this works: > > > SQL> alter system set global_names=3Dfalse scope=3Dboth sid=3D'*'; > > > System altered. > > > Elapsed: 00:00:00.17 > > SQL> > > > Why are "SCOPE=3DBOTH SID=3D'*'" illegal options for alter system set e= vents > > and yet work perfectly well with set global_names? > > > --http://mgogala.byethost5.com > > Maybe because the correct spelling is event, not events, in the ALTER > SYSTEM command per the SQL manual which also says the parameter is not > modifiable > > SQL> alter system set event =3D '1013 trace name context off' > scope=3Dspfile; > > System altered. > > SQL> / > alter system set event =3D '1013 trace name context off' scope=3Dboth > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0* > ERROR at line 1: > ORA-02095: specified initialization parameter cannot be modified > > Though strangely enough if you leave scope=3D off the command works with > events: > > SQL> alter system set events =3D '1013 trace name context off'; > > System altered. > > Posted tests use 9.2.0.6 and appear to match initial posted results, > but reference to SQL manual based on 10.2. > > HTH -- Mark D Powell -- Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SYS@TTST> alter system set event =3D '1013 trace name context off' scope=3Dboth ; alter system set event =3D '1013 trace name context off' scope=3Dboth * ERROR at line 1: ORA-02095: specified initialization parameter cannot be modified SYS@TTST> alter system set event =3D '1013 trace name context off'; alter system set event =3D '1013 trace name context off' * ERROR at line 1: ORA-02095: specified initialization parameter cannot be modified SYS@TTST> alter system set events=3D '1013 trace name context off'; System altered. SYS@TTST> alter system set event =3D '1013 trace name context off' scope=3Dspfile; System altered. "The default is SCOPE=3DBOTH if a server parameter file was used to start up the instance, and MEMORY if a text initialization parameter file was used to start up the instance." And here I am, using a server parameter file. I wonder if someone had the idea of using events to mean something different than event, but the reality became confused when someone said "let's document it and call it a feature." The manual does not say event is not modifiable (I could've missed something...), but rather should only be modified under supervision. jg -- @home.com is bogus. http://hosted.ap.org/dynamic/stories/U/US_TEC_TECHNOLOGY_CONSOLIDATION?SITE= =3DKYWAM&SECTION=3DHOME&TEMPLATE=3DDEFAULT