failure in processing system parameters

From: Doggy <tru64dog_at_yahoo.com>
Date: 22 Jun 2003 07:50:58 -0700
Message-ID: <18239c3a.0306220650.6a2a740c@posting.google.com>

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'
Received on Sun Jun 22 2003 - 09:50:58 CDT