Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: creating a 9i database in 8.1 compatibility mode

Re: creating a 9i database in 8.1 compatibility mode

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Wed, 26 Dec 2001 08:39:41 -0800
Message-ID: <F1nW7.62$GN5.3679@inet-nntp1.oracle.com>


Never tried doing this so I can't be sure but I would be surprised if the isntance would actually start in this case (i.e. you're using a 9.0 parameter set when compatible is set to pre-9.0.0). However, I've been wrong in the past and probably will be again. ;)

Fundamentally though, I think you're taking the wrong tack here. You're addressing the symptom, not the cause. That's necessary sometimes, but maybe we can help with getting the application to work with the database release rather than the database release to work with the application, if you see what I mean. What's the problem with the app that you're trying to address here?

--
HTH.  Additions and corrections welcome.

Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Currently writing the "Oracle9i New Features for Administrators Exam Cram"

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

"Chris S" <cschofie_at_nospam.slip.net> wrote in message
news:snh72u07037ekm9vrm30g13s6d69sg1r7j_at_4ax.com...

> Anyone tried this? Succeeded?
>
> I recently upgraded a server with numerous databases on it from 8i
> (8.1.7) to 9i. (actually did full exports, uninstalled/deleted oracle
> 8i, installed 9i, imported data). 5 out of 6 databases were fine.
> Just one database is giving me trouble with just one client - some
> older financial application.
>
> Bottom line is I can't get rid of that client immediately so I need to
> solve this quickly. I tried to modify the 'compatibility' parameter
> but ran into ora-00402 errors - basically, can't down-grade the
> compatibility once the database is built, since too many features are
> built into the database already. Fair enough, makes sense.
>
> So I built a whole new test database, and set compatibility to 8.1.0
> at the initial creation stage - but it would not build due to an
> obscure error (ora-01092 - instance terminated unexpectedly...),
> pointing to same fundamental issue. I guess I optimistically hoped
> that if I set compatibility to 8.1.0 during creation, Oracle would
> figure out what that meant but it seems like they expect me to change
> all the other paramters that are problematic in a 9i environment. Is
> this true?
>
> Based on the query 'select * from v$compatibility where
> release != '0.0.0.0.0', I found several items that were set to
> 9.0.0.0.0. I can presumably change all them .. but what to exactly
> ...?
> Here they are:
> redodata
> undodata
> txnaudn
> undotbsp
> lgmr_b
> pdmlitls
>
> For now, I've moved the whole database over to an 8.1 server, but I
> can't keep it there either!
>
> Thanks for any insight. Chris
>
Received on Wed Dec 26 2001 - 10:39:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US