I edited the spdile (ora file) and in some way it got corupt. I need to create a new file but don't know how. This is what I read:
if you are on unix,
$ cd $ORACLE_HOME/dbs
$ strings spfilename temp_pfile.ora
edit the temp_pfile.ora, clean it up if there is anything "wrong" with it.
then
SQL> startup pfile=temp_pfile.ora
SQL> create spfile from pfile;
SQL> shutdown
SQL> startup
On windows -- just try editing the spfile, create a pfile from it. save it, and do the same.
Does anyone understand the Windows way?
Regards,
Magnus
Enter your message below
Sign in or Join us (it's free).