Change parameter in pfile

How to change the log_archive_format parameter in pfile if corresponding issys_modifiable parameter is "FALSE"
give me the full step by step procedure.

Thanks
Gyan

gyanudba
Profile Answers by gyanudba Questions by gyanudba
Aug 10th, 2011
3
4873

Questions by gyanudba answers by gyanudba

Database Administration

Answer

Showing Answers 1 - 3 of 3 Answers

Srinivasa Reddy

Aug 18th, 2011

As per Oracle document if the parameter value in ISSYS_MODIFIABLE column ( in v$parameter view ) is ...

*IMMEDIATE - Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
*DEFERRED - Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.
*FALSE - Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.