Solved

alter system error

Posted on 2011-02-25
4
813 Views
Last Modified: 2012-05-11
Hi
Getting error below while doing alter any idea where it can be wrong.

SQL> alter system set job_queue_process=20;
alter system set job_queue_process=20
                 *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
0
Comment
Question by:sam2929
  • 2
4 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34985378
What version of Oracle are you using?
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 34985379
Also from a sqlplus prompt:
Show parameter job_queue_processes
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 34985837
the parameter name is plural, you had it singular

alter system set job_queue_processes=20
0
 
LVL 3

Expert Comment

by:gopisera
ID: 34985894
Yes,  the above is correct...

The range of values if from 0 to 1000

alter system set job_queue_processes=<Range>

Range<0-1000>

Multiple instances can have different values if the database lies in RAC
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question