pfile is the initialization parameters of DB in plain text, while spfile is the binary one, so to be able to change it, you have to:
- Extract the pfile from the spfile:
“create pfile=’my_path/file_name.ora‘ from spfile;” - Shutdown the DB:
“shutdown immediate;” - Edit the pfile applying the new parameters with “vi”, “notepad” or any plain text editor
- Startup the DB from the pfile:
“startup pfile=’my_path/file_name.ora‘;” - Generate spfile from pfile:
“create spfile from pfile=’my_path/file_name.ora‘”