You need to create the database with compatible set to 8.1.7.0. You can't create a database at one version and then lower the compatible level without downgrading or recreating.
Jared On Monday 13 January 2003 09:16, Ehresmann, David wrote: > I am trying to apply a "fix" for some developers here. They used this fix > in 8 and 8i by changing the compatible parameter and running their sql > script. I just want to be able to tell them that they need to fix their > application now that we are using 9iRel2. I tried this morning and got the > ORA-402 and ORA-405 errors. I don't want to strip away features of 9i just > to get their security script to run. > thanks, > David Ehresmann. > > -----Original Message----- > Sent: Monday, January 13, 2003 9:55 AM > To: Multiple recipients of list ORACLE-L > > > David - What are you trying to accomplish? > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Monday, January 13, 2003 8:44 AM > To: Multiple recipients of list ORACLE-L > > > List, > > I recently tried to set the compatible=8.1.7.0 parameter in a 9iRel2 > Solaris 8 database. If you bounce the instance the > sql>show parameter compatible=9.0.0 stays the same, it does not change. > If you shutdown and reboot the server you get an: > > ora-01033: Initialization or shutdown in progress Which basically states > that you are trying to connect to an instance that is being shutdown down > or starting up. I believe it goes into NOMOUNT stage and reads the > init.ora and hangs because of the compatible parameter being set to 8i. I > saw the document Oracle9i Database Migration Release 2 (9.2) Part Number > A96530-01 stating how to downgrade, but it seems to defeat the purpose of > having a 9i instance. Is there any way to do this without stripping the > 9i database down to 8i? > > > David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
