Re: Oracle Data Migration from 8.1.6 to 8.1.7

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 29 Nov 2000 00:10:37 +0100
Message-ID: <901ern$62oli$3@ID-62141.news.dfncis.de>

Fire up svrmgrl
and issue
show parameter job_queue_process
Then edit your init<sid>.ora and bounce the database if it appears to be non-zero.

Hth,

Sybrand Bakker, Oracle DBA

"Qingsong Zhang" <Qingsong_Zhang_at_Agilent.com> wrote in message news:975450892.727187_at_cswreg.cos.agilent.com...
> Hi,
>
> I have sucessfully upgraded Oracle server from 8.1.6 to 8.1.7 on an NT
> server 4.0 SP6a machine. However when I migrate one of the database from
> 8.1.6 to 8.1.7, I got following error message:
>
> -following parameter(s) does not have 0 (zero) value:
> job_queue_process
> Please refer to the migration documentation for details.
>
> Do you have any clue where is the problem for this database? How can I
check
> queued process?
>
> Many thanks.
>
> Qingsong Zhang
>
>
>
Received on Tue Nov 28 2000 - 17:10:37 CST