Move Spfile to ASM
Check if your database is running with SPFILE, if yes then create pfile from spfile
oracle configurationintermediate
by OracleDba
15 views
📋Steps in this guide1/1
1
Overview
Code/Command (click line numbers to comment):
12345678910111213141516171819202122
show parameter spfile
NAMEÂ Â Â Â TYPE VALUE
-------- ----------- ------------------------------
spfile string /oracle/app/oracle/product/dbs/spfilePRIM.ora
Create pfile from spfile;
File created.
ASMCMD> mkdir +DATA/PRIM/PARAM
SQL> create spfile='+DATA/PRIM/PARAM/spfilePRIM.ora' from pfile;
Rename the SPFILE under $ORACLE_HOME/dbs location
cd $ORACLE_HOME/dbs
mv spfilePRIM.ora spfilePRIM_old.ora
vi initPRIM.ora
spfile='+DATA/PRIM/PARAM/spfilePRIM.ora'Comments (0)
Please to add comments
No comments yet. Be the first to comment!