Search This Blog

Showing posts with label oracle parameter change. Show all posts
Showing posts with label oracle parameter change. Show all posts

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