How to set 'job_queue_processes' ?
426408Jul 29 2004 — edited Jul 29 2004
Hello,
I have installed Oracle 10 on Linux RedHat Advanced Server 3, and during the database creation part of the install I got the message 'ORA-12547: TNS: lost contact' several times. At the end, I was told that the configuration failed because job_queue_processes must be greater than or equal to 1. I set job_queue_prcesses to 1 in init.ora When I ran emca to configure the database, I got the same error message at the end: "SEVERE: 'job_queue_processes' must be greater than or equal to 1'.
Am I setting job_queue_processes correctly ?
job_queue_processes = 1
Is it neccessary to shutdown and restart an oracle process before the new job_queue_processes setting can take effect ? If so, can someone please show me what to stop and restart ? If not, can someone please show me how to correctly set job_queue_processes ?
Thanks,
Colm.