Delphix Products

 View Only
Back to discussions
Expand all | Collapse all

New requirements for SnapSync on dSources from Oracle.

  • 1.  New requirements for SnapSync on dSources from Oracle.

    Posted 01-27-2022 06:19:00 PM
    Edited by Ryan Fowler 01-28-2022 07:48:46 PM
    As of 6.0.11, there are new requirements for SnapSync on dSources from Oracle only when SCM is disabled.

    The first is to configure a standby PDB in mount mode, which entails providing a non-SYS user for both the CDB and the PDB. The PDB non-SYS user can only be added via the CLI. A fresh SnapSync is required after adding the non-SYS user.

    Use the following commands to configure a PDB and CDB in mount mode:

    1. Update PDB non-SYS user.

     
    delphix> /sourceconfig
delphix sourceconfig> select RH74PDB04
delphix sourceconfig 'RH74PDB04'> update
delphix sourceconfig 'RH74PDB04' update *> set nonSysUser=delphix
delphix sourceconfig 'RH74PDB04' update *> set nonSysCredentials.type=PasswordCredential
delphix sourceconfig 'RH74PDB04' update *> set nonSysCredentials.password=delphix
delphix sourceconfig 'RH74PDB04' update *> commit;

    2. Update CDB non-SYS user.

     
    delphix> /sourceconfig
delphix sourceconfig> select RH74CDB2
delphix sourceconfig 'RH74CDB2'> update
delphix sourceconfig 'RH74CDB2' update *> set nonSysUser=delphix
delphix sourceconfig 'RH74CDB2' update *> set nonSysCredentials.type=PasswordCredential
delphix sourceconfig 'RH74CDB2' update *> set nonSysCredentials.password=delphix
delphix sourceconfig 'RH74CDB2' update *> commit;
delphix sourceconfig 'RH74CDB2'>

    3. Perform sync of the PDB.

     
    delphix> /database
delphix database> select RH74PDB04
delphix database 'RH74PDB04'> sync

    The second requirement is a static listener configuration for the PDB, for the Delphix Engine to connect. A static listener can be enabled by adding a configuration into `listener.ora`, then restarting the listener.

     
    SID_LIST_LISTENER=
(SID_DESC=
(GLOBAL_DBNAME=CDOMLOSR4F71PDB1)
(SID_NAME=stby18c)
(ORACLE_HOME=/u01/app/oracle/product/18.0.0.0/dbhome_1)
)
)




    ------------------------------
    Ryan Fowler
    Senior Member of Technical Staff
    Delphix
    ------------------------------


Related Content