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.
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.
Hi, Be the first leave some reply