DB won't start spfile has repeated attributes

[stevenriz]

Hi I added a parameter to the spfile and for some reason added it a second time forgetting I already added the parameter. Now the database won't start. It also won't let me clear the parameter telling me that Oracle isn't available. Dang. How can I get this started enough to change the spfile or do I need to create it all over again from a pfile?

ORA-16025: parameter contains repeated or conflicting attributes

ahhh!! Why would it let me alter system a second time with the same value???

 

[LKBrwnDBA]

You may need to re-start from init.ora file and create the spfile.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[KenCunningham]

ie startup pfile=/path/to/your/edited/pfile and then issue a create spfile from /path/to/your/edited/pfile I guess.

I don't mind people who aren't what they seem. I just wish they'd make their mind up.

 

[stevenriz]

ya that's what I did Ken. but I made all kinds of changes that I didn't document like an idiot so I have to figure it all out again, oh well. thanks for the tips!!
Steve