Re: compatible in 9iRel2

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.
> dwilliams_at_lifetouch.com
>
>
> -----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: jkstill_at_cybcon.com

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