Re: ORA-00406: COMPATIBLE parameter needs to be 7.2.0.0.0 or greater

You only need to change the COMPATABLE parameter in the initSID.ora file for the database in question and bounce (stop and start) the database instance.

I reckon that what storage manager is trying to do under the surface is manage the database using instructions that only work from the version quoted and beyond.

You need to check carefully what version you want the instance to act like and why. Might be best to check with Oracle Worldwide Support. There can be a kinds of strange dependencies when you change it from the version of the server software installed.

Kevin

--
The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. <patrick.bugner_at_cgtec.sema.de> wrote in message news:371608EF.B3255F76_at_cgtec.sema.de...
> Hi,
>
> we are running Oracle7 Server Release 7.2.2.3.0 on a Unix box.
> I want to decrease the datafile for a tablespace, using Oracle Storage
> Manager.
> When I try to do this, I get the message:
>
> ORA-00406: COMPATIBLE parameter needs to be 7.2.0.0.0 or greater
>
> Unfortunately I don't know how to set this parameter.
> Any idea?
>
> Regards
> Patrick
>
Received on Thu Apr 15 1999 - 11:25:05 CDT