Re: COMPATIBLE parameter not being read...why?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 11 Aug 1999 16:51:54 +0800
Message-ID: <37B139AA.2E15@yahoo.com>

Christopher Allen wrote:
>
> It shows no value at all. Here is the result it produces:
>
> SVRMGR> show parameter compatible
> NAME TYPE VALUE
> ----------------------------------- ------- ------------------------------
> compatible string
> compatible_no_recovery string
>
> tmgn <tmgn_at_excite.com> wrote in message news:37B06B6D.4858D2D_at_excite.com...
> > What does
> > svrmgrl> show parameter compatible
> > say ?
> > If it shows a lesser value,Bounce the Database...
> >
> > -Thiru
> >
> > Christopher Allen wrote:
> >
> > > I'm trying to perform a simple DDL operation that my Solaris Oracle
> > > 7.3.4.0.1 server is refusing to run, citing a problem with its
> COMPATIBLE
> > > parameter. The thing is: its COMPATIBLE parameter is actually fine.
> > >
> > > The problem appears when I run this command:
> > > CREATE TABLE T2
> > >
> > > C1 NUMBER NOT NULL,
> > > C2 VARCHAR2(30) NULL,
> > > C3 DATE NULL,
> > > CHECK (C1 IS NOT NULL)
> > > )
> > > PCTFREE 10
> > > PCTUSED 40
> > > INITRANS 1
> > > MAXTRANS 255
> > > STORAGE (
> > > INITIAL 1024K
> > > NEXT 1024K
> > > MINEXTENTS 1
> > > MAXEXTENTS 2147483645
> > > PCTINCREASE 1)
> > > ;
> > >
> > > The response is:
> > > CHECK (C1 IS NOT NULL)
> > > *
> > > ERROR at line 5:
> > > ORA-00406: COMPATIBLE parameter needs to be 7.3.0.0.0 or greater
> > >
> > > The COMPATIBLE parameter *is* greater than 7.3.0.0.0. Here is the line
> from
> > > the initORCL.ORA file:
> > > compatible = 7.3.4.0
> > >
> > > I would appreciate ANY ideas about what could be causing this problem.
> >

How big is your initxxx.ora ?

(I think) any text past the 2048 byte mark is (silently) ignored ? --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Aug 11 1999 - 03:51:54 CDT