Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: migration emergency !

Re: migration emergency !

From: Ron Reidy <rereidy_at_indra.com>
Date: Mon, 10 Dec 2001 10:01:27 -0700
Message-ID: <3C14EA67.41BC6C9@indra.com>


Laurent Boutet wrote:
>
> I agree with you !!!!!
> But I finally solved my problem...
> I set job_queue_processes to 0 !!! And now it works fine !!!
> But I don't understand why it did not work the first time I set it to 0 !!!
> Because I first did it !!!
> tsssss....
> I reboot my computer and now it's all fine...
>
> "Carl Rosenberger" <carl_at_db4o.com> a écrit dans le message news:
> 9v2ljg$4rt$04$1_at_news.t-online.com...
> > Ron Reidy wrote:
> > > > But I've intended today to migrate from Oracle 8.0.5 to Oracle 8.1.7.
> >
> > ...
> > [snip]
> > ...
> >
> > > > Upgrade or migration cannot proceed beacause of the following(s) :
> > > > - following parameter(s) does not have 0 (zero) value :
> job_queue_processes
> > >
> > > It means the parameter job_queue_processes must have a non-zero value.
> >
> > Now what additional help does your statement provide?
> >
> >
> > > Just out of curiosity, didn't you read the migration docs **before** you
> > > attempted this? And, didn't you test on a non-production system
> > > **before** attempting on a production system? just some things to
> > > ponder for the next time.
> > > --
> > > Ron Reidy
> > > Oracle DBA
> > > Reidy Consulting, L.L.C.
> >
> >
> > Is this the kind of help to expect, if you have problems with Oracle?
> > ...people even making fun of you...
> >
> > In my opinion a database engine should take care to migrate it's versions
> > automatically, *without having to read documentation*, ideally without
> > you even noticing anything but a startup message:
> > "This database needs to be migrated. It will not be backward compatible.
> > Proceed?"
> > ...especially on minor version changes like 8.0.5 to 8.1.7...
> > All previous features should be available without worries.
> > Why can't Oracle provide *easy* functionality, with all the money that
> they
> > earn? I am afraid they don't even care.
> >
> >
> > Kind regards,
> > Carl
> > ---
> > Carl Rosenberger
> > db4o - database for objects - http://www.db4o.com
> >
> >
> >

After you made the initial change, did you restart the instance?

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Mon Dec 10 2001 - 11:01:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US