Re: failure in processing system parameters

Doggy wrote:

> First of all, thanks in advance for your help!
>
> I have just installed 9.2.0.1.0 on NT. I just created an instance
> using the Database Configuration Assistant using primarily default
> values. I then wanted to add more system parameters into the spfile,
> which I believe are legal in 9.2 but when I add the new system
> parameters, save the file, and try to start the database I'm getting
> the following error below. I also copied and pasted my spfile that was
> created by the database assistant configuration.
>
> for for *.dml_locks=500 I'm getting:
> SQL> startup
> ORA-01078: failure in processing system parameters
> LRM-00111: no closing quote for value 'C:\oracle\'
>
> ==========================
> for *.log_buffer=163840 I'm getting:
> SQL> startup
> ORA-01078: failure in processing system parameters
> LRM-00111: no closing quote for value 'C:\oracle'
> SQL>
>
> ==========================
>
> for *.max_dump_file_size=10240 I'm getting:
> ORA-01078: failure in processing system parameters
> LRM-00111: no closing quote for value 'C'
> SQL>
>
> ==============================
>
> *.background_dump_dest='C:\oracle\admin\salsa\bdump'
> *.compatible='9.2.0.0.0'
> *.control_files='C:\oracle\oradata\salsa\CONTROL01.CTL','C:\oracle\oradata\salsa\CONTROL02.CTL','C:\oracle\oradata\salsa\.ctl'
> *.core_dump_dest='C:\oracle\admin\salsa\cdump'
> *.db_block_size=8192
> *.db_cache_size=16777216
> *.db_domain=''
> *.db_file_multiblock_read_count=32
> *.db_name='salsa'
> *.dispatchers='(PROTOCOL=TCP) (SERVICE=salsaXDB)'
> *.fast_start_mttr_target=300
> *.hash_join_enabled=TRUE
> *.instance_name='salsa'
> *.java_pool_size=20971520
> *.job_queue_processes=32
> *.large_pool_size=0
> *.open_cursors=300
> *.pga_aggregate_target=16777216
> *.processes=200
> *.query_rewrite_enabled='FALSE'
> *.remote_login_passwordfile='shared'
> *.shared_pool_size=9000000
> *.log_checkpoint_interval=10000
> *.sort_area_size=524288
> *.star_transformation_enabled='FALSE'
> *.timed_statistics=TRUE
> *.undo_management='AUTO'
> *.undo_retention=10800
> *.undo_tablespace='UNDOTBS1'
> *.user_dump_dest='C:\oracle\admin\salsa\udump'

Good lord man don't you read documentation before you try things? ;-)

The SPFILE is not editable.

Make the changes to the init.ora then recompile the spfile.

SQL> CREATE spfile FROM pfile='init<SID>.ora';

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)