Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Migrate oracle 8.1.6 database to 8.1.7
"zhao" <zhaohui_at_goconnect.net> wrote in message
news:Pc3r9.13$Mj2.2410_at_nsw.nnrp.telstra.net...
> Hi,
>
> I have got an error message "following parameter does not have 0 vealue:
> job_queue_processes" when I upgrade the daabase. Actual I have set the
> _SYSTEM_TRIG_ENABLED=FALES.
>
> Thanks for your reply.
>
> Zhao
>
>
>
Change the job_queue_processes parameter to 0 by modifying the init.ora and
bouncing the database or issue
alter system set job_queue_processes = 0
Also please don't repost a question when it is not answered in a few
minutes.
Hth
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Tue Oct 15 2002 - 23:44:31 CDT