I am new to oracle, spent a lot of time with Sybase.
In our new server I was having an issue updating the amount of concurrent
sessions we could have. I edited the spfile manually with vi. I did not
restart the server because I stumbled upon this sql command to fix it.

alter system set sessions = 512 scope = spfile;

This gets me the following error which I think happens because I edited the
spfile manually.

ERROR at line 1:
ORA-27046: file size is not a multiple of logical block size
Additional information: 1


How do I fix my spfile, is there a way to copy running configuration from
memory to the spfile? I can't even log into the Oracle Enterprise Manager
now that I have corrupted the spfile.


Oracle LazyDBA home page