OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » SPFILE ERROR

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SPFILE ERROR [message #211788]

Tue, 02 January 2007 05:17

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'

Attachment: SPFILEMRTEDEV.txt
(Size: 1.49KB, Downloaded 1142 times)

Report message to a moderator

Re: SPFILE ERROR [message #211802 is a reply to message #211788]

Tue, 02 January 2007 06:23

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

The SPFILE is a binary file and you will corrupt it if you edit it directly.

Report message to a moderator

Re: SPFILE ERROR [message #211804 is a reply to message #211788]

Tue, 02 January 2007 06:26

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

Report message to a moderator

Re: SPFILE ERROR [message #211974 is a reply to message #211804]

Wed, 03 January 2007 05:30

sarankaran_y@yahoo.co.in
Messages: 5
Registered: November 2006
Location: CHENNAI

Junior Member

thnks lot.

I got it.

Report message to a moderator

Re: SPFILE ERROR [message #213067 is a reply to message #211788]

Tue, 09 January 2007 05:33

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

Report message to a moderator

Previous Topic:	ORA-01002 Fetch Out of Sequence Error
Next Topic:	Env variables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 22:56:23 CST 2024