And you wonder why companies don't do a more through check on the people whom they trust to run the heart beat of the company.
You know, I really don't know if having people who know nothing about Oracle database administration being in such a position is good for us (the people who know wtf they're doing). If it will hurt us in the long run or benifit us (at least financially)?
Oracle it's not just a database it's a lifestyle!
-------------- BTW....You need to get a girlfriend who's last name isn't .jpg
I think some of you are being a bit over critical, the poster does'nt claim to be an expert or running this on behalf of a company so why the attack. Sure thier way of solving the problem was not perfect but "absolute stupidity" I think not!
Remeber all of us have to start somewhere and all of us at some time have overworked a solution.
And to be fair it is running on Windoz where basically the answer to most problems is to reinstall
Oracle Certified Professional "Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Originally posted by davey23uk he edited it, he wasnt copying contents from it - he was editing it, which is stupidity as it clearly shouldnt be edited
Read what is written next time
I may be way off the mark here (its been a while since I played with SPfiles) but isn't it possible to corrupt them if you alter a parameter online and do a typo on the parameter value whilst doing it?
Re: Re: Re: Corrupt SPFILE & no back up - now what?
Originally posted by bazza I may be way off the mark here (its been a while since I played with SPfiles) but isn't it possible to corrupt them if you alter a parameter online and do a typo on the parameter value whilst doing it?
Apologies in advance if I'm talking crap.
Think here we are talking about editing the actual file, perfectly possible to corrupt it then
No, not possible to corrupt it using alter system = ... as any invalid parameter wont be written to the file.
although you can make it so your instance doesnt start that way - but the file itself is still valid