We want to change the location of asmparameterfile, at the moment it is under +DATA and want to move to +CRS
Log in to asm as sysasm
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
CRS MOUNTED
DATA MOUNTED
FRA MOUNTED
SQL>
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/scandr/asmparameterfile/
registry.253.866558147
SQL>
Now create pfile from spfile and from that file create the spfile.
SQL> create pfile='/home/oracle/temp/initASM.ora' from spfile;
File created.
SQL> !ls -lah /home/oracle/temp/initASM.ora
-rw-r--r--. 1 oracle oinstall 186 Jan 12 19:16 /home/oracle/temp/initASM.ora
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/scandr/asmparameterfile/
registry.253.866558147
SQL>
SQL> create spfile='+CRS' from pfile='/home/oracle/temp/initASM.ora';
File created.
SQL>
Stop HAS and start it this will use spfile to start it and it will be new location.
[root@racdr1 ~]# . ./grid_env
[root@racdr1 ~]# crsclt stop has
-bash: crsclt: command not found
[root@racdr1 ~]# crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'racdr1'
CRS-2673: Attempting to stop 'ora.crsd' on 'racdr1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'racdr1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'racdr1'
CRS-2673: Attempting to stop 'ora.cvu' on 'racdr1'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'racdr1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'racdr1'
CRS-2673: Attempting to stop 'ora.rac_stby.db' on 'racdr1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'racdr1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'racdr1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'racdr1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'racdr1'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'racdr1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.racdr1.vip' on 'racdr1'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'racdr1'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'racdr1'
CRS-2677: Stop of 'ora.cvu' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.rac_stby.db' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'racdr1'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'racdr1'
CRS-2677: Stop of 'ora.scan1.vip' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.scan2.vip' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.scan3.vip' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.racdr1.vip' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'racdr1' succeeded
CRS-2679: Attempting to clean 'ora.DATA.dg' on 'racdr1'
CRS-2681: Clean of 'ora.DATA.dg' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'racdr1'
CRS-2677: Stop of 'ora.asm' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'racdr1'
CRS-2677: Stop of 'ora.ons' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'racdr1'
CRS-2677: Stop of 'ora.net1.network' on 'racdr1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'racdr1' has completed
CRS-2677: Stop of 'ora.crsd' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'racdr1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'racdr1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'racdr1'
CRS-2673: Attempting to stop 'ora.evmd' on 'racdr1'
CRS-2673: Attempting to stop 'ora.asm' on 'racdr1'
CRS-2677: Stop of 'ora.evmd' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.asm' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'racdr1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'racdr1'
CRS-2677: Stop of 'ora.cssd' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'racdr1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.crf' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'racdr1'
CRS-2677: Stop of 'ora.gipcd' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'racdr1'
CRS-2677: Stop of 'ora.gpnpd' on 'racdr1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'racdr1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@racdr1 ~]#
[root@racdr1 ~]#
[root@racdr1 ~]# crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[root@racdr1 ~]#
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +CRS/scandr/asmparameterfile/r
egistry.253.868799821
SQL>
ASMCMD> spget
+CRS/scandr/asmparameterfile/registry.253.868799821
ASMCMD>
ASMCMD>
ASMCMD> rm +DATA/scandr/asmparameterfile/registry.253.866558147
Log in to asm as sysasm
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
CRS MOUNTED
DATA MOUNTED
FRA MOUNTED
SQL>
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/scandr/asmparameterfile/
registry.253.866558147
SQL>
Now create pfile from spfile and from that file create the spfile.
SQL> create pfile='/home/oracle/temp/initASM.ora' from spfile;
File created.
SQL> !ls -lah /home/oracle/temp/initASM.ora
-rw-r--r--. 1 oracle oinstall 186 Jan 12 19:16 /home/oracle/temp/initASM.ora
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/scandr/asmparameterfile/
registry.253.866558147
SQL>
SQL> create spfile='+CRS' from pfile='/home/oracle/temp/initASM.ora';
File created.
SQL>
Stop HAS and start it this will use spfile to start it and it will be new location.
[root@racdr1 ~]# . ./grid_env
[root@racdr1 ~]# crsclt stop has
-bash: crsclt: command not found
[root@racdr1 ~]# crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'racdr1'
CRS-2673: Attempting to stop 'ora.crsd' on 'racdr1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'racdr1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'racdr1'
CRS-2673: Attempting to stop 'ora.cvu' on 'racdr1'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'racdr1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'racdr1'
CRS-2673: Attempting to stop 'ora.rac_stby.db' on 'racdr1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'racdr1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'racdr1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'racdr1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'racdr1'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'racdr1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.racdr1.vip' on 'racdr1'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'racdr1'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'racdr1'
CRS-2677: Stop of 'ora.cvu' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.rac_stby.db' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'racdr1'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'racdr1'
CRS-2677: Stop of 'ora.scan1.vip' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.scan2.vip' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.scan3.vip' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.racdr1.vip' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'racdr1' succeeded
CRS-2679: Attempting to clean 'ora.DATA.dg' on 'racdr1'
CRS-2681: Clean of 'ora.DATA.dg' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'racdr1'
CRS-2677: Stop of 'ora.asm' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'racdr1'
CRS-2677: Stop of 'ora.ons' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'racdr1'
CRS-2677: Stop of 'ora.net1.network' on 'racdr1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'racdr1' has completed
CRS-2677: Stop of 'ora.crsd' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'racdr1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'racdr1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'racdr1'
CRS-2673: Attempting to stop 'ora.evmd' on 'racdr1'
CRS-2673: Attempting to stop 'ora.asm' on 'racdr1'
CRS-2677: Stop of 'ora.evmd' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.asm' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'racdr1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'racdr1'
CRS-2677: Stop of 'ora.cssd' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'racdr1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'racdr1' succeeded
CRS-2677: Stop of 'ora.crf' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'racdr1'
CRS-2677: Stop of 'ora.gipcd' on 'racdr1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'racdr1'
CRS-2677: Stop of 'ora.gpnpd' on 'racdr1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'racdr1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@racdr1 ~]#
[root@racdr1 ~]#
[root@racdr1 ~]# crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[root@racdr1 ~]#
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +CRS/scandr/asmparameterfile/r
egistry.253.868799821
SQL>
ASMCMD> spget
+CRS/scandr/asmparameterfile/registry.253.868799821
ASMCMD>
ASMCMD>
ASMCMD> rm +DATA/scandr/asmparameterfile/registry.253.866558147
No comments:
Post a Comment