===================================
ocrconfig
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
[root@mbflxdbpdbadm01 bin]# ./ocrconfig -delete +DATAC1
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
[root@mbflxdbpdbadm01 bin]# ./crsctl query css votedisk
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 6 01:27:00 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> create pfile='/tmp/asminit.ora' from spfile;
File created.
SQL>
[grid@mbflxdbpdbadm01 ~]$ sqlplus / as sysasm
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 6 01:27:00 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> create pfile='/tmp/asminit.ora' from spfile;
File created.
SQL> create spfile='+RECOC1' from pfile='/tmp/asminit.ora';
File created.
SQL> exit
[grid@mbflxdbpdbadm01 ~]$ gpnptool get
<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="5" ClusterUId="4ac943e6090e5f51ffde516369905bf9" ClusterName="mbprodclus" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" IP="172.28.167.0" Adapter="bondeth0" Use="public"/><gpnp:Network id="net2" IP="192.168.68.0" Adapter="ib0" Use="cluster_interconnect"/><gpnp:Network id="net3" IP="192.168.68.0" Adapter="ib1" Use="cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="o/*/*" SPFile="+RECOC1/mbprodclus/ASMPARAMETERFILE/registry.253.980731721" Mode="legacy"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>I5jcSBp+klSVfahABW28jC/wjns=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>kA26UJIgyVuhw/aNFbxta6pNfqUJbjitgwf593zUZzLIoHtXZmyQ6OCHA8jfr6aS6WpglFF3b0/do8YqIwnmu/IuY41mdyujtoJGUc+UavDHKZGohr5P62073iMx7oir04OPr8/QJ70zCGKzRAY0bC9N925Fz6Tc/GmuUITw/9Q=</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>
[root@mbflxdbpdbadm01 bin]# ./crsctl start crs
GROUP_NUMBER INSTANCE_NAME
NAME TYPE VALUE
x
[root@mbflxdbpdbadm01 bin]# export ORACLE_SID=+ASM1
[root@mbflxdbpdbadm01 bin]# export ORACLE_HOME=/u01/app/12.1.0.2/grid
[root@mbflxdbpdbadm01 bin]# export PATH=$PATH:/u01/app/12.1.0.2/grid/bin
[root@mbflxdbpdbadm01 bin]# ./ocrconfig -add +RECOC1
[root@mbflxdbpdbadm01 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 409568
Used space (kbytes) : 1900
Available space (kbytes) : 407668
ID : 1202396802
Device/File Name : +DATAC1
Device/File integrity check succeeded
Device/File Name : +RECOC1
Device/File integrity check succeeded
[root@mbflxdbpdbadm01 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 409568
Used space (kbytes) : 1900
Available space (kbytes) : 407668
ID : 1202396802
Device/File Name : +RECOC1
Device/File integrity check succeeded
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 659a51b34a524f84bf883eb244f50ea2 (o/192.168.68.109;192.168.68.110/DATAC1_CD_02_mbflxdbpceladm01) [DATAC1]
2. ONLINE 1d4d1487d2624f07bf9c82d73c539dbc (o/192.168.68.111;192.168.68.112/DATAC1_CD_02_mbflxdbpceladm02) [DATAC1]
3. ONLINE d204dc678b064f9cbfbdd770a5d822cd (o/192.168.68.113;192.168.68.114/DATAC1_CD_02_mbflxdbpceladm03) [DATAC1]
4. ONLINE e65991258f004f49bfaef77bea5430d0 (o/192.168.68.115;192.168.68.116/DATAC1_CD_02_mbflxdbpceladm04) [DATAC1]
5. ONLINE c2c0a61055e34f81bf2c25460df33ed5 (o/192.168.68.117;192.168.68.118/DATAC1_CD_02_mbflxdbpceladm05) [DATAC1]
Located 5 voting disk(s).
[root@mbflxdbpdbadm01 bin]#
[root@mbflxdbpdbadm01 bin]#
[root@mbflxdbpdbadm01 bin]# ./crsctl replace votedisk +RECOC1
Successful addition of voting disk 5ed72da19a754fd7bf9a45c3a02506a9.
Successful addition of voting disk 23a445e9deaa4f44bf75890d000a25ec.
Successful addition of voting disk e9c35fa192e94f8ebf03e9eb3310a56e.
Successful addition of voting disk fd54a9a45b244f02bf9f584e4e5bef95.
Successful addition of voting disk c507ce6a04454f85bf49affaef9feb6a.
Successful deletion of voting disk 659a51b34a524f84bf883eb244f50ea2.
Successful deletion of voting disk 1d4d1487d2624f07bf9c82d73c539dbc.
Successful deletion of voting disk d204dc678b064f9cbfbdd770a5d822cd.
Successful deletion of voting disk e65991258f004f49bfaef77bea5430d0.
Successful deletion of voting disk c2c0a61055e34f81bf2c25460df33ed5.
Successfully replaced voting disk group with +RECOC1.
CRS-4266: Voting file(s) successfully replaced
[root@mbflxdbpdbadm01 bin]#
[root@mbflxdbpdbadm01 bin]#
[root@mbflxdbpdbadm01 bin]# ./crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 5ed72da19a754fd7bf9a45c3a02506a9 (o/192.168.68.109;192.168.68.110/RECOC1_CD_02_mbflxdbpceladm01) [RECOC1]
2. ONLINE 23a445e9deaa4f44bf75890d000a25ec (o/192.168.68.111;192.168.68.112/RECOC1_CD_02_mbflxdbpceladm02) [RECOC1]
3. ONLINE e9c35fa192e94f8ebf03e9eb3310a56e (o/192.168.68.113;192.168.68.114/RECOC1_CD_02_mbflxdbpceladm03) [RECOC1]
4. ONLINE fd54a9a45b244f02bf9f584e4e5bef95 (o/192.168.68.115;192.168.68.116/RECOC1_CD_02_mbflxdbpceladm04) [RECOC1]
5. ONLINE c507ce6a04454f85bf49affaef9feb6a (o/192.168.68.117;192.168.68.118/RECOC1_CD_02_mbflxdbpceladm05) [RECOC1]
Located 5 voting disk(s).
[root@mbflxdbpdbadm01 bin]#
[root@mbflxdbpdbadm01 bin]#
[root@mbflxdbpdbadm01 bin]#
[grid@mbflxdbpdbadm01 ~]$ sqlplus / as sysasm
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@mbflxdbpdbadm01 ~]$
Warning: some command line parameters were defaulted. Resulting command line:
/u01/app/12.1.0.2/grid/bin/gpnptool.bin get -o-
Success.
[grid@mbflxdbpdbadm01 ~]$
[grid@mbflxdbpdbadm01 ~]$
[grid@mbflxdbpdbadm01 ~]$
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'mbflxdbpdbadm01'
CRS-2673: Attempting to stop 'ora.crsd' on 'mbflxdbpdbadm01'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'mbflxdbpdbadm01'
CRS-2673: Attempting to stop 'ora.DATAC1.dg' on 'mbflxdbpdbadm01'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'mbflxdbpdbadm01'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'mbflxdbpdbadm01'
CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'mbflxdbpdbadm01'
CRS-2677: Stop of 'ora.DATAC1.dg' on 'mbflxdbpdbadm01' succeeded
CRS-2673: Attempting to stop 'ora.DBFS_DG.dg' on 'mbflxdbpdbadm01'
CRS-2673: Attempting to stop 'ora.RECOC1.dg' on 'mbflxdbpdbadm01'
CRS-2677: Stop of 'ora.RECOC1.dg' on 'mbflxdbpdbadm01' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'mbflxdbpdbadm01' succeeded
CRS-2673: Attempting to stop 'ora.mbflxdbpdbadm01.vip' on 'mbflxdbpdbadm01'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'mbflxdbpdbadm01' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'mbflxdbpdbadm01'
CRS-2677: Stop of 'ora.MGMTLSNR' on 'mbflxdbpdbadm01' succeeded
CRS-2672: Attempting to start 'ora.MGMTLSNR' on 'mbflxdbpdbadm04'
CRS-2677: Stop of 'ora.DBFS_DG.dg' on 'mbflxdbpdbadm01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'mbflxdbpdbadm01'
CRS-2677: Stop of 'ora.asm' on 'mbflxdbpdbadm01' succeeded
CRS-2677: Stop of 'ora.scan2.vip' on 'mbflxdbpdbadm01' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'mbflxdbpdbadm04'
CRS-2677: Stop of 'ora.mbflxdbpdbadm01.vip' on 'mbflxdbpdbadm01' succeeded
CRS-2672: Attempting to start 'ora.mbflxdbpdbadm01.vip' on 'mbflxdbpdbadm02'
CRS-2676: Start of 'ora.MGMTLSNR' on 'mbflxdbpdbadm04' succeeded
CRS-2676: Start of 'ora.scan2.vip' on 'mbflxdbpdbadm04' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'mbflxdbpdbadm04'
CRS-2676: Start of 'ora.mbflxdbpdbadm01.vip' on 'mbflxdbpdbadm02' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'mbflxdbpdbadm04' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'mbflxdbpdbadm01'
CRS-2677: Stop of 'ora.ons' on 'mbflxdbpdbadm01' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'mbflxdbpdbadm01'
CRS-2677: Stop of 'ora.net1.network' on 'mbflxdbpdbadm01' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'mbflxdbpdbadm01' has completed
CRS-2677: Stop of 'ora.crsd' on 'mbflxdbpdbadm01' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'mbflxdbpdbadm01'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'mbflxdbpdbadm01'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'mbflxdbpdbadm01'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'mbflxdbpdbadm01'
CRS-2677: Stop of 'ora.storage' on 'mbflxdbpdbadm01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'mbflxdbpdbadm01'
CRS-2677: Stop of 'ora.drivers.acfs' on 'mbflxdbpdbadm01' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'mbflxdbpdbadm01' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'mbflxdbpdbadm01' succeeded
CRS-2677: Stop of 'ora.asm' on 'mbflxdbpdbadm01' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'mbflxdbpdbadm01'
CRS-2673: Attempting to stop 'ora.evmd' on 'mbflxdbpdbadm01'
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'mbflxdbpdbadm01'
CRS-2677: Stop of 'ora.ctssd' on 'mbflxdbpdbadm01' succeeded
CRS-2677: Stop of 'ora.evmd' on 'mbflxdbpdbadm01' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'mbflxdbpdbadm01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'mbflxdbpdbadm01'
CRS-2677: Stop of 'ora.cssd' on 'mbflxdbpdbadm01' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'mbflxdbpdbadm01'
CRS-2673: Attempting to stop 'ora.gipcd' on 'mbflxdbpdbadm01'
CRS-2677: Stop of 'ora.gipcd' on 'mbflxdbpdbadm01' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'mbflxdbpdbadm01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'mbflxdbpdbadm01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@mbflxdbpdbadm01 bin]#
[root@mbflxdbpdbadm01 bin]#
[root@mbflxdbpdbadm01 bin]#
[root@mbflxdbpdbadm01 bin]#
[root@mbflxdbpdbadm01 bin]#
CRS-4123: Oracle High Availability Services has been started.
2 ;
------------ ----------------------------------------------------------------
DB_NAME CLUSTER_NAME STATUS
-------- ------------------------------- ------------
SOFTWARE_VERSION
------------------------------------------------------------
COMPATIBLE_VERSION CON_ID
------------------------------------------------------------ ----------
3 +ASM1
+ASM mbprodclus CONNECTED
12.1.0.2.0
12.1.0.2.0 0
------------------------------------ ----------- ------------------------------
spfile string +RECOC1/mbprodclus/ASMPARAMETE
RFILE/registry.253.980731721
SQL>
x
Disconnected
grid@mbflxdbpdbadm01 ~]$ export ORACLE_SID=+ASM1
Connected to:
Connected to:
[root@mbflxdbpdbadm01 bin]# ./crsctl stop crs
SQL> SELECT * from v$asm_client
SQL> show parameter spfile
x
No comments:
Post a Comment