Search This Blog

Monday, March 9, 2020

Procedure of updating oracle parameters in spfile



Oracle has two parameter files from which it reads while it's beginning .

They are spfile (server parameter file) and pfile (parameter file). Spfile is binary format file where manual changes are not allowed.
Below document shows us the procedure on the way to change/update the oracle parameters in spfile.

This procedure is on linux operating system.



Take a backup of pfile and spfile







Create pfile from spfile
























Make the changes to the pfile by editing the file
The init<orasid>.ora file has been edited by inserting the required  parameters

























Stop SAP only










Shutdown DB










Startup Database in mount state by giving the pfile path










Create spfile from pfile








Shutdown DB













Start DB


'









Start SAP


2 comments:

  1. If truth be told informative and valuable detail is here.Small Business ERP Software

    ReplyDelete
  2. Great Article Cloud Computing Projects

    Networking Projects

    Final Year Projects for CSE

    JavaScript Training in Chennai

    JavaScript Training in Chennai

    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete