Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

questions about spfile


To change the parameters using spfile

1) does it require the DB to be down first?

2) If DB is NOT down while the parameter is changed, DB needs to be re-started?

3) I am NOT used to the spfile, can I do in the old fashioned way?


Former Member replied


you can find the answers to your questions on SAP Note 601157.

In short:

1) you do not need to shutdown the database first,

2) Db needs to be restarted if you change static parameters.

3) As mentioned on note 601157, th are cases where "the init.ora file may exist several times on several hosts, which complicates the synchronization if a parameter is changed. This problem no longer occurs with a server parameter file."

So, you can still do it the old fashioned way. But, it is generally recommended to use the spfile.

Please, read the SAP note. You will find much more info there.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question