Re: warning about compatible= parameter on HP

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.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 15 1998 - 09:47:57 CDT