Re: warning about compatible= parameter on HP

From: Robert Liziniewicz <Robert.Liziniewicz_at_ci.comarch.pl>
Date: Wed, 29 Jul 1998 16:16:13 +0200
Message-ID: <35BF2EAC.69574E58@ci.comarch.pl>

axnels2_at_uswest.com wrote:

> In article <6ohv4m$h8c$1_at_sunrise.pg.gda.pl>,
> "Piotr Kolodziej" <pkol_at_otago.gda.pl> wrote:
> > axnels2_at_uswest.com wrote in message <6ogpt3$an7$1_at_nnrp1.dejanews.com>...
> > >I would like to warn you about <compatible> parameter that should be
> > >specified in the init.ora files for your databases. One of the databases I
> > >am supporting is v7.3.2.1 on HP10.20. The database was originally created
> > >without the compatible flag set. When we determined that some of the
> > >features can only become available with compatible flag set to 7.3.0.0 I have
> > >decided to set that value as it was recommended. Guess what? When the
> > >database was restarted, everything appeared to be ok, until someone tried to
> > >execute a DDL command, such as create table. The result was a boatload of
> > >ORA-00600. We all love those. After sorting through the trace files I
> > >determined that my dictionary is corrupt. The odd thing is that you can read
> > >the database, but you could not write to it. No way to get around that. I
> > >clinched my teeth and proceeded to recreate the database from the export.
> > >
> > >So be warned.
> > >
> >
> > Yes. We are warned.
> > But 7.3.2.1 is probably no longer supported on HP-UX.
> > Why did not you upgrade it to 7.3.2.3 or higher?
> > I don't remember exactly, but such upgrade was strongly
> > recommended by Oracle because of problems with 7.3.2.1.
> >
> > Piotr
> > --
> > Piotr Kolodziej
> > <pkol_at_otago.gda.pl>
> > * My voice. My private opinion. *
> >
> >

> Piotr, This version of oracle is supported on HP10.20, and will be until
> 10/99, but we are going to do an upgrade to 7.3.4 anyway. We have come
> across several other problems recently.

Be aware of 7.3.4 unless 7.3.4.2 patchset is installed on HPRobert

>
>

> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

Robert Liziniewicz                    C.I. HTS-ComArch SA
Z-ca Kierownika Dzialu Produkcji      ul. Ujastek 10, 31-752 Krakow
Oprogramowania                        tel. (+48 12) 644-66-31,
                                                    643-03-56,
Robert.Liziniewicz_at_ci.comarch.pl                    643-08-56

Received on Wed Jul 29 1998 - 09:16:13 CDT