There’s been some debate about how to get the parameters from a spfile. A spfile is a binary version of the parameter file of the Oracle database.
I added to the debate that my experience is that there are is some weirdness with using the strings command on the spfile. The discussion was on twitter, I didn’t add that doing that it most of the time meant it costed more time than I saved from using the “shortcut” of using strings on a spfile.
Let me show you what it means.
I’ve got a database with storage on ASM. Among other options, there are two simple methods to get the spfile from ASM:
You can get the spfile by logging on to the database, and create a pfile from the spfile, and create a spfile again: