Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3EF5E6F4.1B2738CF_at_exxesolutions.com>...
> 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';
yes, that did it, thanks for the help!!!
Received on Sun Jun 22 2003 - 16:10:47 CDT
