>>> [EMAIL PROTECTED] 01/13/03 12:35PM >>>
Were you using any of the new tablespace
features or using dictionary managed tablespaces?
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 9iRel2I 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).