Home » RDBMS Server » Server Administration » error in adding initialization parameters (oracle 10g)
error in adding initialization parameters [message #306157] Thu, 13 March 2008 01:29 Go to next message
sidd_411
Messages: 30
Registered: March 2008
Member
Hi,

When I tried to add the initialization parameters

MAX_DUMP_FILE_SIZE = 100M
log_archive_start = true

in oracle 10g in SPFILEORCL.ora, I got the following error while startup:


SQL> startup mount exclusive
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfileorcl.ora'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 3643)

Kindly suggest me the way to do it

Report message to a moderator

Re: error in adding initialization parameters [message #306161 is a reply to message #306157] Thu, 13 March 2008 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I bet you modified your spfile with an editor.
Spfile is a BINARY file, it can only be modified using ALTER SYSTEM statement.

Regards
Michel

Report message to a moderator

Re: error in adding initialization parameters [message #306168 is a reply to message #306161] Thu, 13 March 2008 01:56 Go to previous messageGo to next message
sidd_411
Messages: 30
Registered: March 2008
Member
Michel,

I want to add parameters in spfile (parameters mentioned above). How to do it with alter system command ?

Report message to a moderator

Re: error in adding initialization parameters [message #306169 is a reply to message #306168] Thu, 13 March 2008 02:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ALTER SYSTEM, see SET

Regards
Michel

Report message to a moderator

Re: error in adding initialization parameters [message #306176 is a reply to message #306169] Thu, 13 March 2008 02:37 Go to previous message
sidd_411
Messages: 30
Registered: March 2008
Member
Thanks a lot Michel ! I am able to do it.

Report message to a moderator

Previous Topic: Removing Row chaining
Next Topic: database characterset migration from WE8DEC to UTF8
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 03:31:07 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.