Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h0DMmqX10474 for ; Mon, 13 Jan 2003 16:48:52 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h0DMmqc10468 for ; Mon, 13 Jan 2003 16:48:52 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id LAA53957; Mon, 13 Jan 2003 11:30:23 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0052E158; Mon, 13 Jan 2003 11:14:50 -0800 Message-ID: Date: Mon, 13 Jan 2003 11:14:50 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "John Shaw" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "John Shaw" Subject: RE: compatible in 9iRel2 Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_144B046E.BFDE91AA" --=_144B046E.BFDE91AA Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable system is data dictionary - the rest lmt's with uniform extents >>> David.Ehresmann@ps.net 01/13/03 12:35PM >>> Were you using any of the new tablespace features or using dictionary = managed tablespaces? David Ehresmann -----Original Message----- Sent: Monday, January 13, 2003 11:41 AM To: Multiple recipients of list ORACLE-L 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. >>> David.Ehresmann@ps.net 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. dwilliams@lifetouch.com=20 -----Original Message----- Sent: Monday, January 13, 2003 8:44 AM To: Multiple recipients of list ORACLE-L List,=20 I recently tried to set the compatible=3D8.1.7.0 parameter in a 9iRel2 = Solaris 8 database. If you bounce the instance the=20 sql>show parameter compatible=3D9.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? =20 David Ehresmann --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20 Author: Ehresmann, David INET: David.Ehresmann@ps.net 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@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). --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20 Author: DENNIS WILLIAMS INET: DWILLIAMS@LIFETOUCH.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@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). --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20 Author: Ehresmann, David INET: David.Ehresmann@ps.net 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@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). --=_144B046E.BFDE91AA Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable system = is data=20 dictionary - the rest lmt's with uniform extents

>>>=20 David.Ehresmann@ps.net 01/13/03 12:35PM >>>
Were you using any of the new = tablespace=20 features or using dictionary managed tablespaces?
David Ehresmann
-----Original Message-----
From: John Shaw=20 [mailto:John.Shaw@correctionscorp.com]
Sent: Monday, January = 13,=20 2003 11:41 AM
To: Multiple recipients of list=20 ORACLE-L
Subject: RE: compatible in 9iRel2

=
I had a 9.2/solaris database that I could set compatible 8.1.7 on - = but=20 since I have done the 9.2.0.2. upgrade I can't set compatible below 9 = either -=20 never really needed it so I haven't bothered with metalink/tar.

>>> David.Ehresmann@ps.net 01/13/03 11:16AM=20 >>>
I am trying to apply a "fix" for some developers = here. =20 They used this fix
in 8 and 8i by changing the compatible parameter = and=20 running their sql
script.  I just want to be able to tell them = that=20 they need to fix their
application now that we are using 9iRel2. = I=20 tried this morning and got the
ORA-402 and ORA-405 errors.  I = don't=20 want to strip away features of 9i just
to get their security script = to=20 run.
thanks,
David Ehresmann.

-----Original Message-----
= Sent:=20 Monday, January 13, 2003 9:55 AM
To: Multiple recipients of list=20 ORACLE-L


David - What are you trying to accomplish?

Den= nis=20 Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams@lifetouch.com=20


-----Original Message-----
Sent: Monday, January 13, 2003 = 8:44=20 AM
To: Multiple recipients of list ORACLE-L


List, =

I=20 recently tried to set the compatible=3D8.1.7.0 parameter in a 9iRel2=20 Solaris
8 database.  If you bounce the instance the
sql>sh= ow=20 parameter compatible=3D9.0.0  stays the same, it does not change.&nb= sp;=20 If
you shutdown and reboot the server you get an:

ora-01033:=20= Initialization or shutdown in progress    Which = basically=20 states
that you are trying to connect to an instance that is being = shutdown=20 down or
starting up.  I believe it goes into NOMOUNT stage and = reads=20 the init.ora
and hangs because of the compatible parameter being set = to 8i.=20 I saw the
document Oracle9i Database Migration Release 2 (9.2) Part = Number=20 A96530-01
stating how to downgrade, but it seems to defeat the = purpose of=20 having a 9i
instance.   Is there any way to do this = without=20 stripping the 9i database
down to 8i? 


David=20 Ehresmann
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author= :=20 Ehresmann, David
  INET: David.Ehresmann@ps.net

Fat = City=20 Network Services    -- 858-538-5051 http://www.fatcity.com
San = Diego,=20 California        -- Mailing list and = web=20 hosting=20 services
-------------------------------------------------------------= --------
To=20 REMOVE yourself from this mailing list, send an E-Mail message
to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the = message=20 BODY, include a line containing: UNSUB ORACLE-L
(or the name of = mailing=20 list you want to be removed from).  You may
also send the HELP = command=20 for other information (like subscribing).
--
Please see the = official=20 ORACLE-L FAQ: http://www.orafaq.net=
--=20
Author: DENNIS WILLIAMS
  INET: DWILLIAMS@LIFETOUCH.COM
Fat=20 City Network Services    -- 858-538-5051 http://www.fatcity.com
San = Diego,=20 California        -- Mailing list and = web=20 hosting=20 services
-------------------------------------------------------------= --------
To=20 REMOVE yourself from this mailing list, send an E-Mail message
to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the = message=20 BODY, include a line containing: UNSUB ORACLE-L
(or the name of = mailing=20 list you want to be removed from).  You may
also send the HELP = command=20 for other information (like subscribing).

--
Please see = the=20 official ORACLE-L FAQ: http://www.orafaq.net
--
Author= :=20 Ehresmann, David
  INET: David.Ehresmann@ps.net

Fat = City=20 Network Services    -- 858-538-5051 http://www.fatcity.com
San = Diego,=20 California        -- Mailing list and = web=20 hosting=20 services
-------------------------------------------------------------= --------
To=20 REMOVE yourself from this mailing list, send an E-Mail message
to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the = message=20 BODY, include a line containing: UNSUB ORACLE-L
(or the name of = mailing=20 list you want to be removed from).  You may
also send the HELP = command=20 for other information (like=20 subscribing).


--=_144B046E.BFDE91AA-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Shaw INET: John.Shaw@correctionscorp.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@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).