Wednesday, September 16, 2009

How to Change Static parameters in SPFILE and PFILE

Change Static parameters in SPFILE:
Changing static parameters requires the SPFILE option for the SCOPE clause with ALTER SYSTEM Statement and changes applies to SPFILE only. The changes cannot be applied to active Instance and the database needs to be restarted to take effect the modified parameters.

62 comments:

A PFILE is a static, client-side text file that must be updated with a standard text editor like "notepad" or "vi". This file normally reside on the server, however, you need a local copy if you want to start Oracle from a remote machine. DBA's commonly refer to this file as the INIT.ORA file. An SPFILE is a persistent server-side binary file that can only be modified with the "ALTER SYSTEM SET" command. This means you no longer need a local copy of the pfile to start the database from a remote machine. Editing an SPFILE will corrupt it, and you will not be able to start your database anymore.

About Me

I have been working with Database technologies for over 16 years, specialized in High Availability Solutions such as Oracle RAC, Data Guard, Grid Control, SQLServer Cluster, SAPHANA. I have experience on wide range of products such as MySQL, Oracle Essbase, Agile, SAP Basis, SharePoint, Linux and Business Apps admin. I have implemented many business critical systems for fortune 500, 1000 companies.