Oracle-L: RE: o7_dictionary

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 30 Apr 2003 14:11:40 -0800
Message-ID: <F001.0058D14F.20030430141140@fatcity.com>

bulbultyagi

Your statement says to just change the spfile, not the running database. I don't have my 9i notes here, so I'm just going from memory, but you may want to try a different scope. I would recommend studying how spfile and init.ora work in 9i. You can also command 9i to create an init.ora file for you. If you then delete the spfile, Oracle9i will just use the init.ora. That is what I've done because I haven't needed spfile yet and I am more familiar with init.ora. You may also consider upgrading your Oracle version. I've had problems with 9.0.1.

Dennis Williams
DBA, 60%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, April 30, 2003 3:12 PM
To: Multiple recipients of list ORACLE-L

Hi all,
I am having a problem with a static parameter, I am using an spfile and Oracle 9.0.1.1.1 on win32

SQL> show user
USER is "SYS"

SQL> alter system set o7_dictionary_accessibility=true scope=spfile ; System altered.

but even after shutting down and restarting the database

SQL> show user
USER is "SYS"
SQL> show parameter o7

NAME                                                            TYPE
VALUE
------------------------------------                            -----------
--------------------
O7_DICTIONARY_ACCESSIBILITY          boolean     FALSE

Any ideas?? I am able to change all other static parameters but not this one

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <bulbultyagi_at_now-india.net.in
INET: bulbultyagi_at_now-india.net.in

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

RE: o7_dictionary_accessibility