skip to main | skip to sidebar

Sam's Oracle BLOG

Dec 17, 2008

remove db parameter from spfile

Required when obsolete db parameter needs to be removed or reset from the spfile.

alter system reset "parameter name" scope=spfile sid='*'
Posted by Sam
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: database
Newer Post Older Post Home

My Blog List

  • Oracle Scratchpad
    Pagination Cost – 2
    2 months ago
  • The Momen Blog
    Oracle Database In-Memory Advisor Released
    10 years ago
  • The Tom Kyte Blog
    Upcoming Events...
    11 years ago

www.xobni.com

Xobni outlook add-in for your inbox

Archive

  • ►  2012 (1)
    • ►  Mar (1)
  • ►  2011 (13)
    • ►  Nov (5)
    • ►  Aug (3)
    • ►  May (3)
    • ►  Feb (2)
  • ►  2010 (7)
    • ►  Nov (1)
    • ►  Sep (2)
    • ►  Jun (2)
    • ►  Apr (1)
    • ►  Feb (1)
  • ►  2009 (17)
    • ►  Dec (2)
    • ►  Oct (5)
    • ►  Jul (3)
    • ►  May (3)
    • ►  Apr (1)
    • ►  Mar (2)
    • ►  Jan (1)
  • ▼  2008 (44)
    • ▼  Dec (5)
      • DB Links
      • Password File
      • remove db parameter from spfile
      • clustering factor
      • tracing
    • ►  Nov (1)
    • ►  Oct (1)
    • ►  Sep (20)
    • ►  Aug (17)
  • ►  2007 (21)
    • ►  Dec (4)
    • ►  Nov (6)
    • ►  Oct (7)
    • ►  Sep (4)