Re: migration emergency !

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