Hi.

If the ALTER SYSTEM SET .... SCOPE=SPFILE fails it means you are using an init.ora file. In this case the changes to the init.ora file will be picked up the next time you restart the instance.

If you want to start using an spfile you should check out:

http://www.oracle-base.com/Articles/...Parameters.asp

Cheers

Tim...