RE: compatible in 9iRel2

[david hill]

I was curious about this parameter I have an application that is certified on 8.1.7 only Could I create a 9i database set compatible to 8.1.7 and essentially call it an 8.1.7 database?   -----Original Message----- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 1:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: compatible in 9iRel2   We are running 9.2.0.1., do you think that could be the reason.   the .1=component specifiec Release Number?  Was your 9i  9.2.0.0.0? David Ehresmann. -----Original Message----- From: John Shaw [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:41 AM To: Multiple recipients of list ORACLE-L Subject: RE: compatible in 9iRel2 I had a 9.2/solaris database that I could set compatible 8.1.7 on - but since I have done the 9.2.0.2. upgrade I can't set compatible below 9 either - never really needed it so I haven't bothered with metalink/tar. >>> [EMAIL PROTECTED] 01/13/03 11:16AM >>> 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: Ehresmann, David   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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS   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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David   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).