Home » RDBMS Server » Server Administration » SPFILE ERROR
SPFILE ERROR [message #211788] Tue, 02 January 2007 05:17 Go to next message
sarankaran_y@yahoo.co.in
Messages: 5
Registered: November 2006
Location: CHENNAI
Junior Member
i changed some changes in spfile.It gives some error.after that i removd the contents from spfile.But now also it gives some error

the error is

ORA-01078:falilure in processing system parameters

ORA-01565: error in identifying file 'C:\oracle\SPFILEMRTEDEV.ora'

ORA-27046:file size is not a multiple of logical block size

pls help.......


the file is


    |_g$ mrtedev.__db_cache_size=419430400

mrtedev.__java_pool_size=4194304

mrtedev.__large_pool_size=12582912
mrtedev.__shared_pool_size=159383552
mrtedev.__streams_pool_size=4194304
*.audit_file_dest='C:/admin/MRTEDEV/adump'

*.background_dump_dest='C:/admin/MRTEDEV/bdump'

*.compatible='10.2.0.1.0'
*.control_files='D:\OracleDB\MRTEDEV\MRTEDEV\control01.ctl',
'D:\OracleDB\MRTEDEV\MRTEDEV\control02.ctl',
'D:\OracleDB\MRTEDEV\MRTEDEV\control03.ctl'

*.core_dump_dest='C:/admin/MRTEDEV/cdump'

*.db_block_size=8192
*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='MRTEDEV'

*.db_recovery_file_dest='C:/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648

*.dispatchers='(PROTOCOL=TCP)
(SERVICE=MRTEDEVXDB)'

*.job_queue_processes=10

*.open_cursors=300

*.pga_aggregate_target=202375168

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=607125504

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='C:/admin/MRTEDEV/udump'

Re: SPFILE ERROR [message #211802 is a reply to message #211788] Tue, 02 January 2007 06:23 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
The SPFILE is a binary file and you will corrupt it if you edit it directly.
Re: SPFILE ERROR [message #211804 is a reply to message #211788] Tue, 02 January 2007 06:26 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

i changed some changes in spfile
This is your big mistake...who told you directly edit spfile.
spfile is server managed binary file you cann't edit directly. if you want to change first edit pfile ( text file) and create new spfile file.
now you can do that.
1.shutdown your database.
2.delete old spfile and create new spfile from pfile. like
cmd>create spfile from pfile;
if you have no pfile then create new pfile and startup your database.

here spfile ===== spfile<sid>.ora === server managed file/binary file
pfile ===== init<sid>.ora === text file

regards
Taj
Re: SPFILE ERROR [message #211974 is a reply to message #211804] Wed, 03 January 2007 05:30 Go to previous messageGo to next message
sarankaran_y@yahoo.co.in
Messages: 5
Registered: November 2006
Location: CHENNAI
Junior Member
thnks lot.

I got it.
Re: SPFILE ERROR [message #213067 is a reply to message #211788] Tue, 09 January 2007 05:33 Go to previous message
tech123
Messages: 6
Registered: April 2006
Junior Member
This is a common error for 10g users .
Do not edit spfile. Always there is a spfile default.
So first make a backup of spfile, then
If you need to change the spfile parameter settings use following steps


sqlplus> create pfile from spfile;

Pfile will create in defalt path (ORACLE_HOME/dbs/) .
Edit pfile and save.

sqlplus> create spfile from pfile;

below artical describe basic defference between pfile and spfile
http://www.easywebtech.com/artical/spfile_and_pfile.html
Previous Topic: ORA-01002 Fetch Out of Sequence Error
Next Topic: Env variables
Goto Forum:
  


Current Time: Sat Dec 03 18:32:59 CST 2016

Total time taken to generate the page: 0.08372 seconds