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