$ sqlplus / as
sysdba
$ srvctl modify
database -d RAJU -p +RAJU1/RAJU/PARAMETERFILE/spfile.272.762954069
SQL> create pfile='/home/oracle/pfile_Raju1.ora'
from spfile;
File created.
SQL> create spfile='+RAJU1' 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
STOP AND START THE RAC DATASBASE
CHECK THE SPFILE LOCATION IN ALL NODES
SQL> show parameter spfile
NAME TYPE
VALUE
--------- ----------- ------------------------------
spfile string
+RAJU1/RAJU/parameterfile/spfile.272.762954069
Note: Remove your old spfile using rm
command or ALTER DISKGROUP DISK_GROUP_NAME DROP FILE ‘OLD_LOCATION’;
No comments:
Post a Comment