Reset/Unset a spfile parameter

Reset/Unset a spfile parameter

Setting a parameter to =' ' often isn't enough. Do this instead...

alter system reset <parameter> scope=spfile sid='*'
/

The sid='*' bit is always necessary, even in non RAC database.