SPFILE - URGENT!!!!! - Big Mistake
Posted on 2004-08-31
I opened the PFILE in wordpad to look at it. Then being a newbie to Oracle and not following the directions I made a change to it and saved it (OOPS!!!).
Anyway, now I can't connect with SQLPlus, or even get into the Enterprise Manager in Oracle 10g.
Is there a way to replace this file with a "default" one? I am really lost and need some help fast! I think I will read the directions a little more carefully next time.
I am running the 10g suite of tools and made a change to the file because I was trying to install the repository. The file still has the parameters in it. But it looks like something was messed up since I changed it with Wordpad.
Any help or if you can point me in the right direction would be greatly appreciated