Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!news.maxwell.syr.edu!newsfeed.sovam.com!sovam!not-for-mail
From: Ushkalo Igor <igorus@protek.ru>
Newsgroups: comp.databases.oracle.server
Subject: Re: migration emergency !
Date: Wed, 12 Dec 2001 11:15:56 +0300
Organization: Protek
Lines: 32
Message-ID: <3C17123C.5060309@protek.ru>
References: <9v2jg0$a9f$1@reader1.imaginet.fr> <3C14D3A8.64289F72@indra.com> <3C15D85F.6B501D5C@hotmail.com> <9v4m1e$q47$1@reader1.imaginet.fr> <3bbfc440.0112111232.1f5b3bf9@posting.google.com>
NNTP-Posting-Host: 194.154.72.10
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.sovam.com 1008144914 1588 194.154.72.10 (12 Dec 2001 08:15:14 GMT)
X-Complaints-To: abuse@online.ru
NNTP-Posting-Date: Wed, 12 Dec 2001 08:15:14 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4) Gecko/20011128 Netscape6/6.2.1
X-Accept-Language: ru,en
Xref: easynews comp.databases.oracle.server:127921
X-Received-Date: Wed, 12 Dec 2001 02:06:02 MST (news.easynews.com)

Patrick wrote:

>  
> job_queue_processes is not a dynamically configurable parameter.  You
> must change the init.ora file and then bounce the database.  To do the
> migration, the database must be up and running under the 'old' Oracle
> version and then the 'new' version takes over.  If I'm not mistaken,
> it shutdowns the database and restarts with the new binaries.  For the
> migration tool to make the init.ora changes it would have to know
> where the init.ora file is, modify it and then restart the database
> using the 'old' version.
> 
> It is unrealistic to think that a tool as powerful and flexible as
> Oracle could be a turn it on and forget about it type of thing.  The
> migration instructions are fairly short and are generally clear on
> what steps need to be taken before the migration can begin.
> 
> HTH,
> Patrick
> 

Oracle Reference (8 or 8i):


JOB_QUEUE_PROCESSES
Parameter type: Integer
Parameter class: Dynamic. Scope = ALTER SYSTEM.
                  ^^^^^^^

-- Best regards, Igor Ushkalo (igorus!) - igorus(at)mail.ru,
    ICQ #19972198