$ sqlplus / as sysdba
SQL> create pfile='/home/oracle/pfile_Bhuvan1.ora' from spfile;
File created.
SQL> create spfile='+BHUVAN1' from pfile='/home/oracle/pfile_zp1.ora';
File created.
you have to find the file name details in the asmcmd
After finding the name, you have to change to the database
After finding the name, you have to change to the database
$ srvctl modify database -d BHU -p +BHUVAN/BHU/PARAMETERFILE/spfile.272.762954069
STOP AND START THE RAC DATASBASE
CHECK THE SPFILE LOCATION IN ALL NODES
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +BHUVAN/BHU/parameterfile
/spfile.272.762954069
Note: Remove your old spfile using rm command or ALTER DISKGROUP DISK_GROUP_NAME DROP FILE ‘OLD_LOCATION’;
Thanks a lot.... You saved my life :)
ReplyDelete