Monday, January 12, 2015

Change the location of asmparameterfile

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


No comments: