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.

Author Profile

sysdba ;

Other posts by sysdba

Author's web site



Are you satisfied with this blog?
Why not subscribe our RSS Feed? you will always get the latest post.


Hi, Be the first leave some reply

Leave A Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>