Modify GPnP Profile in Oracle12c RAC

Version 9
Visibility: Open to anyone

    Introduction:

    This article covers the Internal Oracle architecture regarding how you can modify the GPnP Profile.

     

    The GPnP profile is a XML file located at location <GRID_HOME/gpnp/<hostname>/profiles/peer as profile.xml. Each node of the cluster maintains a copy of this profile locally and is maintained by GPnP daemon along with mdns daemon.Now before understanding why Oracle came up with GPnP profile, we need to focus on what it contains.

    GPnP defines a node’s meta data about network interfaces for public and private interconnect, the ASM server parameter file, and CSS voting disks.

    This profile is protected by a wallet against modification. If you have to manually modify the profile, it must first be unsigned with $GRID_HOME/bin/gpnptool, modified, and then signed again with the same utility, however there is a very slight chance you would ever be required to do so.

     

    Now we’ll use the gpnptool with get option to dump this xml file into standard output. Below is the formatted output for the ease of readability.

     

    <?xml version=”1.0″ encoding=”UTF-8″?>
    <gpnp:GPnP-Profile Version=”1.0″ xmlns=”http://www.xyz/gpnp-profile&#8221;
    xmlns:gpnp=”http://xyz/gpnp-profile&#8221;
    xmlns:orcl=”http://xyz/gpnp-profile&#8221;
    xmlns:xsi=”http://xyz/XMLSchema-instance&#8221;
    xsi:schemaLocation=”http://xyz/gpnp-profilegpnp-profile.xsd
    ProfileSequence=”3″ ClusterUId=”002c207a71cvaljgkcea7bea5b3a49″
    ClusterName=”Cluster01″ PALocation=””>
    <gpnp:Network-Profile>
    <gpnp:HostNetwork id=”gen” HostName=”*”>
    <gpnp:Network id=”net1″ IP=”xxx.xx.x.x” Adapter=”bond0″ Use=”public”/>
    <gpnp:Network id=”net2″ IP=”xxx.xxx.x.x” Adapter=”bond1″
    Use=”cluster_interconnect”/>
    </gpnp:HostNetwork>
    </gpnp:Network-Profile>
    <orcl:CSS-Profile id=”css” DiscoveryString=”+asm” LeaseDuration=”400″ />
    <orcl:ASM-Profile id=”asm” DiscoveryString=””
    SPFile=”+DATA/prod/asmparameterfile/registry.253.699915959″ />
    <ds:Signature…>…</ds:Signature>
    </gpnp:GPnP-Profile>

    So from the above dump we can see that GPnP profile contains following information:-

    1) Cluster Name
    2) Network Profile
    3) CSS-Profile tag
    4) ASM-Profile tag

     

    Environment:

    Oracle12c 12.1.0.2 2-Node RAC with ASM

    RHEL 7.0

     

    Demonstration:

    Initial Private Interface Details

    =========================

    Node-1

    ---------

    Private Interface:  enp7s0

    Private Ip: 10.35.1.1

     

    Node-2

    ---------

    Private Interface:  enp7s0

    Private Ip: 10.35.1.2

     

    --> Due to some reason these Private IPs are not reachable

    --> Only Node-1 Clusterware and DB Services are up and running.

    --> We had taken below changes in private interconnect

     

    #We had create network alias

    #OS Configuration for enp6s0:5

    [root@clstrnode1 ~]# /u01/app/12.1.0.2/grid/bin/oifcfg getif

    enp6s0  192.168.0.0  global public

    enp7s0 10.35.1.0  global  cluster_interconnect

    [root@clstrnode1 ~]# /u01/app/12.1.0.2/grid/bin/oifcfg setif -global enp6s0:5/10.35.1.0:cluster_interconnect

    [root@clstrnode1 ~]#

    [root@csm-clstrnode1 ~]# /u01/app/12.1.0.2/grid/bin/oifcfg getif

    enp6s0 192.168.0.0  global  public

    enp7s0 10.35.1.0  global  cluster_interconnect

    enp6s0:5 10.35.1.0  global  cluster_interconnect

    [root@clstrnode1 ~]#/u01/app/12.1.0.2/grid/bin/oifcfg delif -global enp7s0/10.35.1.0

    [root@clstrnode1 ~]# /u01/app/12.1.0.2/grid/bin/oifcfg getif

    enp6s0 192.168.0.0  global  public

    enp6s0:5 10.35.1.0  global  cluster_interconnect

     

    #Reboot both the Nodes

    #Revert back the OS Configuration for enp6s0:5

     

    Node-1

    ======

    /u01/app/12.1.0.2/grid/bin/crsctl check crs

    CRS-4638: Oracle High Availability Services is online

    CRS-4535: Cannot communicate with Cluster Ready Services

    CRS-4529: Cluster Synchronization Services is online

    CRS-4534: Cannot communicate with Event Manager

     

    Node-2

    ======

    /u01/app/12.1.0.2/grid/bin/crsctl check crs

    CRS-4047: No Oracle Clusterware components configured.

    CRS-4000: Command Check failed, or completed with errors.

     

    Node-1

    ======

    /u01/app/12.1.0.2/grid/bin/crsctl stat res -t -init

     

    /u01/app/12.1.0.2/grid/bin/crsctl check crs

    /u01/app/12.1.0.2/grid/bin/crsctl query crs softwareversion

    Oracle Clusterware version on node [csm-clstrnode1] is [12.1.0.2.0]

     

    /u01/app/12.1.0.2/grid/bin/crsctl query crs activeversion

    Oracle Clusterware active version on the cluster is [12.1.0.2.0]

     

    -bash-4.2$ /u01/app/12.1.0.2/grid/bin/crsctl stat res -t -init

    --------------------------------------------------------------------------------

    Name Target  State        Server                  State details

    --------------------------------------------------------------------------------

    Cluster Resources

    --------------------------------------------------------------------------------

    • ora.asm

          1        ONLINE OFFLINE STABLE

    • ora.cluster_interconnect.haip

          1        ONLINE OFFLINE STABLE

    • ora.crf

          1        ONLINE OFFLINE STABLE

    • ora.crsd

          1        ONLINE OFFLINE STABLE

    • ora.cssd

          1        ONLINE ONLINE      clstrnode1          STABLE

    • ora.cssdmonitor

          1        ONLINE ONLINE      clstrnode1          STABLE

    • ora.ctssd

          1        ONLINE ONLINE      clstrnode1          OBSERVER,STABLE

    • ora.diskmon

          1        OFFLINE OFFLINE                              STABLE

    • ora.evmd

          1        ONLINE INTERMEDIATE clstrnode1 STABLE

    • ora.gipcd

          1        ONLINE ONLINE      clstrnode1          STABLE

    • ora.gpnpd

          1        ONLINE ONLINE      clstrnode1          STABLE

    • ora.mdnsd

          1        ONLINE ONLINE      clstrnode1          STABLE

    • ora.storage

          1        ONLINE OFFLINE STABLE

    --------------------------------------------------------------------------------

    [root@clstrnode1 ~]# /u01/app/12.1.0.2/grid/bin/crsctl config crs

    CRS-4622: Oracle High Availability Services autostart is enabled.

    [root@clstrnode1 ~]# /u01/app/12.1.0.2/grid/bin/crsctl check crs

    CRS-4638: Oracle High Availability Services is online

    CRS-4535: Cannot communicate with Cluster Ready Services

    CRS-4529: Cluster Synchronization Services is online

    CRS-4534: Cannot communicate with Event Manager

     

     

     

    Node-2

    [root@clstrnode1 ~]# /u01/app/12.1.0.2/grid/perl/bin/perl /u01/app/12.1.0.2/grid/crs/install/rootcrs.pl -deconfig -force -verbose

    Using configuration parameter file: /u01/app/12.1.0.2/grid/crs/install/crsconfig_params

    PRCR-1070 : Failed to check if resource ora.net1.network is registered

    CRS-0184 : Cannot communicate with the CRS daemon.

    PRCR-1070 : Failed to check if resource ora.helper is registered

    CRS-0184 : Cannot communicate with the CRS daemon.

    PRCR-1070 : Failed to check if resource ora.ons is registered

    CRS-0184 : Cannot communicate with the CRS daemon.

     

    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'csm-clstrnode1'

    CRS-2673: Attempting to stop 'ora.ctssd' on 'csm-clstrnode1'

    CRS-2673: Attempting to stop 'ora.evmd' on 'csm-clstrnode1'

    CRS-2673: Attempting to stop 'ora.mdnsd' on 'csm-clstrnode1'

    CRS-2673: Attempting to stop 'ora.gpnpd' on 'csm-clstrnode1'

    CRS-2677: Stop of 'ora.ctssd' on 'csm-clstrnode1' succeeded

    CRS-2677: Stop of 'ora.mdnsd' on 'csm-clstrnode1' succeeded

    CRS-2677: Stop of 'ora.evmd' on 'csm-clstrnode1' succeeded

    CRS-2673: Attempting to stop 'ora.cssd' on 'csm-clstrnode1'

    CRS-2677: Stop of 'ora.gpnpd' on 'csm-clstrnode1' succeeded

    CRS-2677: Stop of 'ora.cssd' on 'csm-clstrnode1' succeeded

    CRS-2673: Attempting to stop 'ora.gipcd' on 'csm-clstrnode1'

    CRS-2677: Stop of 'ora.gipcd' on 'csm-clstrnode1' succeeded

    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'csm-clstrnode1' has completed

    CRS-4133: Oracle High Availability Services has been stopped.

    2016/09/03 23:25:49 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.

     

    2016/09/03 23:26:09 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.

     

    2016/09/03 23:26:10 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node

     

     

    Node-1

      /u01/app/12.1.0.2/grid/bin/rootcrs.pl -deconfig -force -verbose -keepdg –lastnode

     

      [root@clstrnode1 ~]# /u01/app/12.1.0.2/grid/perl/bin/perl /u01/app/12.1.0.2/grid/crs/install/rootcrs.pl -deconfig -force -verbose -keepdg -lastnode

     

    Using configuration parameter file: /u01/app/12.1.0.2/grid/crs/install/crsconfig_params

    PRCR-1070 : Failed to check if resource ora.cvu is registered

    CRS-0184 : Cannot communicate with the CRS daemon.

    2016/09/03 23:49:03 CLSRSC-180: An error occurred while executing the command 'srvctl stop cvu -f' (error code 0)

     

    PRCR-1070 : Failed to check if resource ora.cvu is registered

    CRS-0184 : Cannot communicate with the CRS daemon.

    2016/09/03 23:49:03 CLSRSC-180: An error occurred while executing the command 'srvctl remove cvu -f' (error code 0)

     

    OC4J failed to stop

    PRCR-1070 : Failed to check if resource ora.oc4j is registered

    CRS-0184 : Cannot communicate with the CRS daemon.

    OC4J could not be removed

    PRCR-1070 : Failed to check if resource ora.oc4j is registered

    CRS-0184 : Cannot communicate with the CRS daemon.

    PRCR-1068 : Failed to query resources

    CRS-0184 : Cannot communicate with the CRS daemon.

    PRCR-1068 : Failed to query resources

    CRS-0184 : Cannot communicate with the CRS daemon.

    PRCR-1068 : Failed to query resources

    CRS-0184 : Cannot communicate with the CRS daemon.

    PRCR-1068 : Failed to query resources

    CRS-0184 : Cannot communicate with the CRS daemon.

    PRCR-1070 : Failed to check if resource ora.net1.network is registered

    CRS-0184 : Cannot communicate with the CRS daemon.

    PRCR-1070 : Failed to check if resource ora.helper is registered

    CRS-0184 : Cannot communicate with the CRS daemon.

    PRCR-1070 : Failed to check if resource ora.ons is registered

    CRS-0184 : Cannot communicate with the CRS daemon.

     

    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'csm-clstrnode1'

    CRS-2673: Attempting to stop 'ora.mdnsd' on 'csm-clstrnode1'

    CRS-2673: Attempting to stop 'ora.gpnpd' on 'csm-clstrnode1'

    CRS-2673: Attempting to stop 'ora.ctssd' on 'csm-clstrnode1'

    CRS-2673: Attempting to stop 'ora.evmd' on 'csm-clstrnode1'

    CRS-2677: Stop of 'ora.mdnsd' on 'csm-clstrnode1' succeeded

    CRS-2677: Stop of 'ora.ctssd' on 'csm-clstrnode1' succeeded

    CRS-2677: Stop of 'ora.gpnpd' on 'csm-clstrnode1' succeeded

    CRS-2677: Stop of 'ora.evmd' on 'csm-clstrnode1' succeeded

    CRS-2673: Attempting to stop 'ora.cssd' on 'csm-clstrnode1'

    CRS-2677: Stop of 'ora.cssd' on 'csm-clstrnode1' succeeded

    CRS-2673: Attempting to stop 'ora.gipcd' on 'csm-clstrnode1'

    CRS-2677: Stop of 'ora.gipcd' on 'csm-clstrnode1' succeeded

    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'csm-clstrnode1' has completed

    CRS-4133: Oracle High Availability Services has been stopped.

    CRS-4123: Oracle High Availability Services has been started.

    CRS-2672: Attempting to start 'ora.evmd' on 'csm-clstrnode1'

    CRS-2672: Attempting to start 'ora.mdnsd' on 'csm-clstrnode1'

    CRS-2676: Start of 'ora.mdnsd' on 'csm-clstrnode1' succeeded

    CRS-2676: Start of 'ora.evmd' on 'csm-clstrnode1' succeeded

    CRS-2672: Attempting to start 'ora.gpnpd' on 'csm-clstrnode1'

    CRS-2676: Start of 'ora.gpnpd' on 'csm-clstrnode1' succeeded

    CRS-2672: Attempting to start 'ora.cssdmonitor' on 'csm-clstrnode1'

    CRS-2672: Attempting to start 'ora.gipcd' on 'csm-clstrnode1'

    CRS-2676: Start of 'ora.cssdmonitor' on 'csm-clstrnode1' succeeded

    CRS-2676: Start of 'ora.gipcd' on 'csm-clstrnode1' succeeded

    CRS-2672: Attempting to start 'ora.cssd' on 'csm-clstrnode1'

    CRS-2672: Attempting to start 'ora.diskmon' on 'csm-clstrnode1'

    CRS-2676: Start of 'ora.diskmon' on 'csm-clstrnode1' succeeded

    CRS-2676: Start of 'ora.cssd' on 'csm-clstrnode1' succeeded

    2016/09/03 23:51:51 CLSRSC-115: Start of resource 'ora.asm' failed

     

    2016/09/03 23:51:51 CLSRSC-558: failed to deconfigure ASM

     

    Died at /u01/app/12.1.0.2/grid/crs/install/crsdeconfig.pm line 1039.

     

    Clusterware Alert logs (alert.log)

    2016-09-04 14:24:47.550 [OCTSSD(22694)]CRS-2405: The Cluster Time Synchronization Service on host csm-clstrnode1 is shutdown by user

    2016-09-04 14:24:47.550 [OCTSSD(22694)]CRS-8504: Oracle Clusterware OCTSSD process with operating system process ID 22694 is exiting

    2016-09-04 14:24:48.659 [ORAAGENT(19772)]CRS-5011: Check of resource "ora.asm" failed: details at "(:CLSN00006:)" in "/u01/app/oracle/diag/crs/csm-clstrnode1/crs/trace/ohasd_oraagent_oracle.trc"

    2016-09-04 14:24:48.669 [ORAAGENT(19772)]CRS-5011: Check of resource "ora.asm" failed: details at "(:CLSN00006:)" in "/u01/app/oracle/diag/crs/csm-clstrnode1/crs/trace/ohasd_oraagent_oracle.trc"

    2016-09-04 14:24:51.125 [ORAAGENT(19772)]CRS-5011: Check of resource "ora.asm" failed: details at "(:CLSN00006:)" in "/u01/app/oracle/diag/crs/csm-clstrnode1/crs/trace/ohasd_oraagent_oracle.trc"

    2016-09-04 14:24:51.155 [ORAROOTAGENT(28706)]CRS-8500: Oracle Clusterware ORAROOTAGENT process is starting with operating system process ID 28706

    2016-09-04 14:24:51.184 [OCTSSD(28719)]CRS-8500: Oracle Clusterware OCTSSD process is starting with operating system process ID 28719

    2016-09-04 14:24:52.178 [OCTSSD(28719)]CRS-2403: The Cluster Time Synchronization Service on host csm-clstrnode1 is in observer mode.

    2016-09-04 14:24:52.292 [OCTSSD(28719)]CRS-2407: The new Cluster Time Synchronization Service reference node is host csm-clstrnode1.

    2016-09-04 14:24:52.292 [OCTSSD(28719)]CRS-2401: The Cluster Time Synchronization Service started on host csm-clstrnode1.

    2016-09-04 14:25:51.172 [ORAROOTAGENT(28706)]CRS-5818: Aborted command 'start' for resource 'ora.cluster_interconnect.haip'. Details at (:CRSAGF00113:) {0:9:4} in /u01/app/oracle/diag/crs/csm-clstrnode1/crs/trace/ohasd_orarootagent_root.trc.

    2016-09-04 14:25:51.280 [ORAROOTAGENT(28706)]CRS-5017: The resource action "ora.cluster_interconnect.haip start" encountered the following error:

    2016-09-04 14:25:51.280+Start action for HAIP aborted. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/csm-clstrnode1/crs/trace/ohasd_orarootagent_root.trc".

    2016-09-04 14:25:55.174 [OHASD(18207)]CRS-2757: Command 'Start' timed out waiting for response from the resource 'ora.cluster_interconnect.haip'. Details at (:CRSPE00163:) {0:9:4} in /u01/app/oracle/diag/crs/csm-clstrnode1/crs/trace/ohasd.trc.

    2016-09-04 14:25:55.221 [OCTSSD(28719)]CRS-2405: The Cluster Time Synchronization Service on host csm-clstrnode1 is shutdown by user

    2016-09-04 14:25:55.221 [OCTSSD(28719)]CRS-8504: Oracle Clusterware OCTSSD process with operating system process ID 28719 is exiting

    2016-09-04 14:25:56.226 [OHASD(18207)]CRS-2878: Failed to restart resource 'ora.asm'

     

     

      /u01/app/12.1.0.2/grid/bin/oifcfg iflist -n

      enp6s0  192.168.0.0 255.255.240.0

      enp7s0  10.35.1.0 255.255.255.0

      virbr0  192.168.122.0 255.255.255.0

     

      ifconfig -a

      enp6s0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500

            inet 192.168.2.137  netmask 255.255.240.0  broadcast 192.168.15.255

            inet6 fe80::225:b5ff:fe10:6b  prefixlen 64  scopeid 0x20<link>

            ether 00:25:b5:10:00:6b  txqueuelen 1000  (Ethernet)

            RX packets 68379  bytes 5940128 (5.6 MiB)

            RX errors 0  dropped 1  overruns 0 frame 0

            TX packets 28936  bytes 33415850 (31.8 MiB)

            TX errors 0  dropped 0 overruns 0  carrier 0 collisions 0

      enp7s0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500

            inet 10.35.1.1  netmask 255.255.255.0  broadcast 10.35.1.255

            inet6 fe80::225:b5ff:fe10:8b  prefixlen 64  scopeid 0x20<link>

            ether 00:25:b5:10:00:8b  txqueuelen 1000  (Ethernet)

            RX packets 55008  bytes 4929099 (4.7 MiB)

            RX errors 0  dropped 1  overruns 0 frame 0

            TX packets 154  bytes 35277 (34.4 KiB)

            TX errors 0  dropped 0 overruns 0  c

     

      netstat -rn

      Kernel IP routing table

      Destination    Gateway        Genmask        Flags MSS Window  irtt Iface

      0.0.0.0        192.168.1.254  0.0.0.0        UG        0 0          0 enp6s0

      10.35.1.0      0.0.0.0        255.255.255.0  U 0 0          0 enp7s0

      192.168.0.0    0.0.0.0        255.255.240.0  U 0 0          0 enp6s0

      192.168.122.0  0.0.0.0        255.255.255.0  U 0 0          0 virbr0

     

      cat /etc/hosts

    127.0.0.1  localhost localhost.localdomain localhost4 localhost4.localdomain4

                    ::1        localhost localhost.localdomain localhost6 localhost6.localdomain6

                    192.168.2.137        csm-clstrnode1

                    192.168.2.138        csm-clstrnode2

                    192.168.2.140        csm-clstrnode1-vip

                    192.168.2.141        csm-clstrnode2-vip

                    10.35.1.1        csm-clstrnode1-priv

                    10.35.1.2        csm-clstrnode2-priv

                    192.168.2.139          csm-clstr-scan

                    #BLRDB RAC#

                    #Public network (eth0)

                    10.151.1.15    pcrfnd1

                    10.151.1.16    pcrfnd2

                    #Public Virtual IP(VIP)address - eth0:1

                    10.151.1.31    pcrfnd01-vip

                    10.151.1.32    pcrfnd02-vip

                    #scan IP

                    10.151.1.33 blrpmscan

      vi /etc/hosts

    #Comment BLRDB RAC IPs

      cat /etc/hosts

     

      Node-2

      ======

      /u01/app/12.1.0.2/grid/bin/oifcfg iflist -p

      enp6s0  192.168.0.0 PRIVATE

      enp6s0  10.35.0.0 PRIVATE

      enp7s0  10.35.1.0 PRIVATE

       

      [root@csm-clstrnode2 ~]# netstat -rn

      Kernel IP routing table

      Destination    Gateway        Genmask        Flags MSS Window  irtt Iface

      0.0.0.0        192.168.1.254  0.0.0.0        UG        0 0          0 enp6s0

      10.35.0.0      0.0.0.0        255.255.240.0  U 0 0          0 enp6s0

      10.35.1.0      0.0.0.0        255.255.255.0  U 0 0          0 enp7s0

      192.168.0.0    0.0.0.0        255.255.240.0  U 0 0          0 enp6s0

     

      cat /etc/hosts

      verified for correctness

     

      ifconfig

      /u01/app/12.1.0.2/grid/bin/crsctl stat res -t -init

    --------------------------------------------------------------------------------

      Name          Target  State Server                  State details

    --------------------------------------------------------------------------------

      Cluster Resources

    --------------------------------------------------------------------------------

      ora.asm

            1        ONLINE OFFLINE STABLE

      ora.cluster_interconnect.haip

            1        ONLINE OFFLINE STABLE

      ora.crf

            1        OFFLINE OFFLINE                              STABLE

      ora.crsd

            1        OFFLINE OFFLINE                              STABLE

      ora.cssd

            1        ONLINE ONLINE      clstrnode1          STABLE

      ora.cssdmonitor

            1        ONLINE ONLINE      clstrnode1          STABLE

      ora.ctssd

            1        ONLINE OFFLINE ST

         

      /u01/app/12.1.0.2/grid/bin/gpnptool get

      Warning: some command line parameters were defaulted. Resulting command line:

    /u01/app/12.1.0.2/grid/bin/gpnptool.bin get -o-

      <?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="8" ClusterUId="e255d3dab0027f2dbf6604e16251b01a"

    ClusterName="csm-cluster" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*">

      <gpnp:Network id="net1" IP="192.168.0.0" Adapter="enp6s0" Use="public"/>

      <gpnp:Network id="net3" Adapter="enp6s0:5" Use="cluster_interconnect" IP="10.35.1.0"/>

    </gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+a

      cd /u01/app/12.1.0.2/grid/

      cd bin/

      pwd

      ./gpnptool find

        Found 1 instances of service 'gpnp'.

    mdns:service:gpnp._tcp.local.://csm-clstrnode1:47586/agent=gpnpd,cname=csm-cluster,guid=e255d3dab0027f2dbf6604e16251b01a,

    host=csm-clstrnode1,pid=8951/gpnpd h:csm-clstrnode1 c:csm-cluster u:e255d3dab0027f2dbf6604e1

     

      mkdir /home/oracle/gpnp

       

      export GPNPDIR=/home/oracle/gpnp

     

      ./gpnptool get -o=$GPNPDIR/profile.original

      Resulting profile written to "/home/oracle/gpnp/profile.original".

      Success.

     

      cp $GPNPDIR/profile.original $GPNPDIR/p.xml

       

      ./gpnptool getpval -p=$GPNPDIR/p.xml -prf_sq -o-

      8

     

      ./gpnptool getpval -p=$GPNPDIR/p.xml -net -o-

      net1 net3

     

      ./gpnptool edit -p=$GPNPDIR/p.xml -o=$GPNPDIR/p.xml -ovr -prf_sq=<SEQ+1> -<net_num>:net_use=public,cluster_interconnect

     

      ./gpnptool edit -p=$GPNPDIR/p.xml -o=$GPNPDIR/p.xml -ovr -prf_sq=9 -net1:net_use=public,cluster_interconnect               

        Resulting profile written to "/home/oracle/gpnp/p.xml".

        Success.

     

           

      ./gpnptool sign -p=$GPNPDIR/p.xml -o=$GPNPDIR/p.xml -ovr -w=cw-fs:peer

        Resulting profile written to "/home/oracle/gpnp/p.xml".

        Success.

     

      ./gpnptool put -p=$GPNPDIR/p.xml

      Success.

     

      ./crsctl start res ora.crsd -init

    CRS-2672: Attempting to start 'ora.crf' on 'csm-clstrnode1'

    CRS-2672: Attempting to start 'ora.ctssd' on 'csm-clstrnode1'

    CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'csm-clstrnode1'

    CRS-2676: Start of 'ora.crf' on 'csm-clstrnode1' succeeded

    CRS-2676: Start of 'ora.ctssd' on 'csm-clstrnode1' succeeded

    CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'csm-clstrnode1' succeeded

    CRS-2672: Attempting to start 'ora.asm' on 'csm-clstrnode1'

    CRS-2676: Start of 'ora.asm' on 'csm-clstrnode1' succeeded

    CRS-2672: Attempting to start 'ora.storage' on 'csm-clstrnode1'

    CRS-2676: Start of 'ora.storage' on 'csm-clstrnode1' succeeded

    CRS-2672: Attempting to start 'ora.crsd' on 'csm-clstrnode1'

    CRS-2676: Start of 'ora.crsd' on 'csm-clstrnode1' succeeded

    [root@csm-clstrnode1 bin]# ./crsctl check crs

    CRS-4638: Oracle High Availability Services is online

    CRS-4692: Cluster Ready Services is online in exclusive

     

    ./crsctl stat res -t -init

    --------------------------------------------------------------------------------

    Name          Target  State Server                  State details

    --------------------------------------------------------------------------------

    Cluster Resources

    --------------------------------------------------------------------------------

    • ora.asm

          1 ONLINE  ONLINE      clstrnode1          Started,STABLE

    • ora.cluster_interconnect.haip

          1        ONLINE ONLINE      clstrnode1          STABLE

    • ora.crf

          1        ONLINE ONLINE      clstrnode1          STABLE

    • ora.crsd

          1        ONLINE INTERMEDIATE clstrnode1 EXCLUSIVE,STABLE

    • ora.cssd

          1        ONLINE ONLINE      clstrnode1          STABLE

    • ora.cssdmonitor

          1        ONLINE ONLINE      clstrnode1          STABLE

    • ora.ctssd

          1        ONLINE ONLINE      clstrnode1          OBSERVE

     

    ./gpnptool get

    Warning: some command line parameters were defaulted. Resulting command line:

            ./gpnptool.bin get -o-

    <?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="9" ClusterUId="e255d3dab0027f2dbf6604e16251b01a" ClusterName="csm-cluster" PALocation="">

    <gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*">

    <gpnp:Network id="net1" IP="192.168.0.0" Adapter="enp6s0" Use="public,cluster_interconnect"/>

    <gpnp:Network id="net3" Adapter="enp6s0:5" Use="cluster_interconnect" IP="10.35.1.0"/>

    </gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><o

         

     

      ./crsctl stop res ora.crsd -init

      CRS-2673: Attempting to stop 'ora.crsd' on 'csm-clstrnode1'

      CRS-2677: Stop of 'ora.crsd' on 'csm-clstrnode1' succeeded

     

      ./crsctl stat res -t -init

      ./gpnptool rget -h=<hostname>

      hostname

      ./gpnptool rget -h=csm-clstrnode1

    Warning: some command line parameters were defaulted. Resulting command line:

            ./gpnptool.bin rget -h=csm-clstrnode1 -o-

    Found 1 gpnp service instance(s) to rget profile from.

    get-profile request to tcp://csm-clstrnode1:47586 (mdns:service:gpnp._tcp.local.://csm-clstrnode1:47586/agent=gpnpd,cname=csm-cluster,

    guid=e255d3dab0027f2dbf6604e16251b01a,host=csm-clstrnode1,pid=8951/gpnpd h:csm-clstrnode1 c:csm-cluster u:e255d3dab0027f2dbf6604e1):

    <?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="9" ClusterUId="e255d3dab0027f2dbf6604e16251b01a" ClusterName="csm-cluster" PA

     

      ./crsctl start res ora.crsd -init

    CRS-2672: Attempting to start 'ora.crsd' on 'csm-clstrnode1'

    CRS-2676: Start of 'ora.crsd' on 'csm-clstrnode1' succeeded

     

      ./crsctl stat res -t -init

      echo $GPNPDIR

      /home/oracle/gpnp

     

      ./gpnptool find -c=csm-cluster

      ./gpnptool find -c=csm-cluster

        Found 1 instances of service 'gpnp'.

    mdns:service:gpnp._tcp.local.://csm-clstrnode1:47586/agent=gpnpd,cname=csm-cluster,guid=e255d3dab0027f2dbf6604e 16251b01a,host=csm-clstrnode1,

        pid=8951/gpnpd h:csm-clstrnode1 c:csm-cluster u:e255d3dab0027f2dbf6604e1

       

      ifconfig

      ./oifcfg iflist -n

      ./oifcfg setif -global <INTERFACE>/<SUBNET>:cluster_interconnect

     

      ./oifcfg setif -global enp6s0/192.168.0.0:cluster_interconnect

      ./oifcfg iflist -n

      ./oifcfg delif -global <INTERFACE>/<SUBNET>

     

      ./oifcfg getif

      ./gpnptool get

      ifconfig -a

      ./oifcfg delif -global enp6s0:5/10.35.1.0

      ./oifcfg getif

      ifconfig

      ./oifcfg setif -global enp6s0/192.168.0.0:public

      ./oifcfg getif

      ./gpnptool get

      ifconfig

      ./oifcfg setif -global enp7s0/10.35.1.1:cluster_interconnect

      ./oifcfg getif

      ./gpnptool get

      ./crsctl stop crs

      ./crsctl start crs

      ./crsctl stat res -t -init

      ./gpnptool get

      ./crsctl stat res -t -init

      ifconfig -a

      ./crsctl stat res -t -init

      cd

      /u01/app/12.1.0.2/grid/perl/bin/perl /u01/app/12.1.0.2/grid/crs/install/rootcrs.pl -deconfig -force -verbose -keepdg -lastnode

      /u01/app/12.1.0.2/grid/bin/crsctl start res ora.crsd -init

      /u01/app/12.1.0.2/grid/bin/crsctl stop crs -force

      /u01/app/12.1.0.2/grid/bin/crsctl stop crs -f

      cd /var/tmp/.oracle

      ls -ltr

      ls

      rm -Rf *

      pwd

      ls -la

      cd

      ./crsctl start crs

      /u01/app/12.1.0.2/grid/bin/crsctl start crs

      /u01/app/12.1.0.2/grid/bin/crsctl stat res -t -init

      cd /u01/app/12.1.0.2/grid/bin/

      ./gpnptool getpval -p=$GPNPDIR/p.xml -prf_sq -o-

      ./gpnptool getpval -p=$GPNPDIR/p.xml -net -o-

      ./gpnptool edit -p=$GPNPDIR/p.xml -o=$GPNPDIR/p.xml -ovr -prf_sq=10 -net1:net_use=public,cluster_interconnect

      ./gpnptool sign -p=$GPNPDIR/p.xml -o=$GPNPDIR/p.xml -ovr -w=cw-fs:peer

      ./gpnptool put -p=$GPNPDIR/p.xml

      gpnptool get

      ./gpnptool get

      export GPNPDIR=/home/oracle/gpnp

      ./gpnptool get -o=$GPNPDIR/profile.original

      rm /home/oracle/gpnp/profile.original

      ./gpnptool get -o=$GPNPDIR/profile.original

      cp $GPNPDIR/profile.original $GPNPDIR/p.xml

      ./gpnptool getpval -p=$GPNPDIR/p.xml -prf_sq -o-

      ./gpnptool edit -p=$GPNPDIR/p.xml -o=$GPNPDIR/p.xml -ovr -prf_sq=14 -net1:net_use=public,cluster_interconnect

      ./gpnptool sign -p=$GPNPDIR/p.xml -o=$GPNPDIR/p.xml -ovr -w=cw-fs:peer

      ./gpnptool put -p=$GPNPDIR/p.xml

      ./crsctl start res ora.crsd -init

      ./crsctl stat res -t -init

      ./gpnptool get

      oifcfg getif

      ./oifcfg get

      ./oifcfg getif

      ./oifcfg setif -global enp6s0/192.168.0.0:cluster_interconnect

      ./oifcfg getif

      ./oifcfg delif -global enp7s0/10.35.1.0

      ./oifcfg getif

      ./oifcfg delif -global enp7s0/10.35.1.1

      ./oifcfg getif

      ifconfig -a

      ./oifcfg getif

      ./oifcfg setif -global enp6s0/192.168.0.0:public

      ./oifcfg setif -global enp7s0/10.35.1.0:cluster_interconnect

      ./oifcfg getif

      ./crsctl stat res -t -init

      ./crsctl stat res -t

      ./gpnptool get

      ./crsctl stop crs

      ./crsctl start crs

      ./crsctl stat res -t -init

      ifconfig -a

      /u01/app/12.1.0.2/grid/bin/crsctl stat res -t

     

    Special Thanks to Oracle Global Support engineer - Santosh

     

    Reference:

    http://pranilesh-chand.blogspot.in/2012/08/change-network-settings-for-private.html

    https://www.linkedin.com/pulse/gpnp-profile-internals-oracle-rac-nitish-anand-srivastava

    http://oracleinaction.com/edit-gpnp-profile/

     

    Author:

    Hitesh Gondalia

    Lead Database Administrator

    OCE RACv11g,OCP v12c/11g/10g/9i

    CloudDB OTN Community - Master Tag

    https://hiteshgondalia.wordpress.com