Re: question on COMPATIBLE parameter

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 27 May 1999 08:19:25 -0700
Message-ID: <374D627D.7126574E@us.oracle.com>

The problem will be addressed by what Kenny suggested (the COMPATIBLE parameter defaults to either null or 7.0.12 depending on the version you're using). There is however something to be careful of here. Once you change the compatible parameter and start using the new functionality, you will have a more complex downgrade path if you should ever need to downgrade. It's probably not an issue to be concerned of with this particular case, since the likelihood of having to downgrade an unsupported version to an earlier unsupported version is probably low, but still it should be kept in mind.

Pete

Kenny Gump wrote:

> In your init.ora file put the following line:
>
> compatible = 7.3.2.1.0
>
> This will take care of the problem once you bounce the instance. (shutdown
> and restart).
>
> Kenny Gump
>
> lokikal_at_my-dejanews.com wrote in message <7ii5r8$n3p$1_at_nnrp1.deja.com>...
> >Hi,
> >In our database installation, we create a
> >database instance without specifying
> >the value for parameter COMPATIBLE.
> >We are using oracle7 server Release 7.3.2.1.0
> >on solaris 2.6
> >From the svrmgrl prompt, as sysdba, when I tried
> >the following:
> >alter rollback segment rbs_1 storage (optimal 2M
> >maxextents 605);
> >
> >...I got the following error:
> >ORA-00406: COMPATIBLE parameter needs to be
> >7.3.0.0.0 or greater
> >
> >Also when I tried
> >alter database datafile 'xxx.dbf' resize 120M
> >I got the same type of COMPATIBLE error as above
> >(well this time the figure was 7.2.2.0.0)
> >
> >Can one of the oracle gurus out there help me
> >decipher this error? I could not find much
> >information on this parameter from oracle manuals.
> >
> >As to why I am changing rollback segment storage
> >settings, it is the solution that I was trying
> >out for a different problem that I encountered
> >in my application. If it is necessary, I will
> >post the details of this problem.
> >
> >Thanks
> >laks
> >
> >
> >
> >--== Sent via Deja.com http://www.deja.com/ ==--
> >---Share what you know. Learn what you don't.---

Regards

Pete

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application 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

Received on Thu May 27 1999 - 10:19:25 CDT