CLI cookbook: changing the SID of Oracle RAC VDBs

This topic describes how to change the SID of instances in an Oracle RAC VDB.

This example demonstrates how to switch the instance name and number between two different hosts, from

Copy 
SQL> select * FROM V$ACTIVE_INSTANCES;
INST_NUMBER INST_NAME
----------- ------------------------------------------------------------
      1 cnrac3:VchiBEB1
      2 cnrac4:VchiBEB2

to

Copy 
SQL> select * FROM V$ACTIVE_INSTANCES;
INST_NUMBER INST_NAME
----------- ------------------------------------------------------------
      1 cnrac4:VchiBEB1
      2 cnrac3:VchiBEB2

 Procedure

  1. Stop the VDB through the GUI and log in to the Delphix CLI.

  2. Select the sourceconfig of the RAC VDB whose instances you would like to rename. 

    Copy 
    kfc-manual.dcenter> sourceconfig
    kfc-manual.dcenter sourceconfig> select Vchicago_BEB

  3. Use the update command to change the properties of the sourceconfig. 

    Copy 
    kfc-manual.dcenter sourceconfig "Vchicago_BEB"> update

  4. Type 'ls' to view the complete list of properties associated with the VDB's sourceconfig. For configurations with larger numbers of RAC instances, the listing may not show the individual instances but will instead display [ ... ]. In order to see the instance configuration, type 'edit instances'.

    Copy 
    kfc-manual.dcenter sourceconfig "Vchicago_BEB" update *> ls
    Properties
        type: OracleRACConfig
        credentials:
            type: PasswordCredential
            password: ********
        environmentUser: ora1024
        instances:
            0:
                type: OracleRACInstance
                instanceName: VchiBEB1
                instanceNumber: 1
                node: cnrac4
            1:
                type: OracleRACInstance
                instanceName: VchiBEB2
                instanceNumber: 2
                node: cnrac3
        linkingEnabled: true
        nonSysCredentials: (unset)
        nonSysUser: (unset)
        repository: '/u01/app/ora1024/product/10.2.0/db_1'
        services: [ ... ]
        user: delphix

  5. Use the Set command to change the values for instanceName and instanceNumber for each instance.

    Copy 
    kfc-manual.dcenter sourceconfig "Vchicago_BEB" update *> set instances.0.instanceName=VchiBEB2
    kfc-manual.dcenter sourceconfig "Vchicago_BEB" update *> set instances.0.instanceNumber=2
    kfc-manual.dcenter sourceconfig "Vchicago_BEB" update *> set instances.1.instanceName=VchiBEB1
    kfc-manual.dcenter sourceconfig "Vchicago_BEB" update *> set instances.1.instanceNumber=1

  6. Finally, commit the changes.

    Copy 
    kfc-manual.dcenter sourceconfig "Vchicago_BEB" update *> commit;

  7. Restart the VDB through the GUI for the changes to take effect on the VDB.