I’ve just transferred my oracle 11g 11.2.0.4 DB to ASM and I want to look at the contents of some of the files. At first I tried using ASMCMD but then realized it doesn’t have such a command, and when trying to read from the diskgroup path it returns “no such file…”. is there any way to accomplish that?
thnx in advance, Jack.
Advertisement
Answer
the spfile is the file I was trying to read after I recreated it in ASM from the fs pfile.
The spfile is a binary format and can’t be read directly. You can look at the settings through use of the “show parameter” command in sqlplus, or the v$parameter view in the database, or you can “create pfile from spfile” in sqlplus to make a text copy of it to a normal file system for viewing – just be sure to use a non-standard file name for the new pfile/copy and not to overwrite your existing “live” pfile, which should be a pointer to the spfile location in ASM.