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

Reply via email to