ORACLE 12C Modified SPFile path

Here's how to modify it:
Create pfile= '/tmp/init0924.ora ' from SPFile;


Shutdown immediate--two nodes to stop

Startup Nomout pfile= '/tmp/init0924.ora '


Create spfile= ' +data_mxsz/mxcn/spfilemxcn.ora ' from pfile= '/tmp/init0924.ora '


Srvctl Modify Database-d mxcn-p +data_mxsz/mxcn/spfilemxcn.ora



Through the above method. After creating SPFile create spfile= ' +data_mxsz/mxcn/spfilemxcn.ora ' from pfile= ' .... '

will have a Spfilemxcn.ora file under this directory and point to parameterfile/the latest SPFile

Asmcmd> ls-l
Type redund striped Time Sys Name
Y controlfile/
Y datafile/
Y onlinelog/
Y parameterfile/
Y password/
Y tempfile/
Parameterfile Unprot Coarse SEP 10:00:00 N Spfilemxcn.ora = +data/rac/parameterfile/spfile.272.890566063

This article is from the "SYSDBA" blog, make sure to keep this source http://sysdba.blog.51cto.com/10492366/1702531

ORACLE 12C Modified SPFile path