Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only
  • 1.  problem when creating VDB - Source database not found.

    Posted 06-08-2022 03:17:00 AM

    Hi Team,

    We are trying to create a VDB via the command line using the following command line code:

    #!/bin/bash

    TOOLKIT="/nfs/oradump_dba/delphix/dxtoolkit/Linux/2.4.8/dxtoolkit2"
    CONFIG_AREA="/u01/app/oracle/global/delphix/dxtoolkit/config"

    ${TOOLKIT}/dx_provision_vdb -engine ${engine_nm} -configfile ${CONFIG_AREA}/dx_${engine_nm}.conf -group "${ENV}" -sourcename "PSWPF${source_name_suffix}@dxswpp01-1" -targetname ${db_name} -dbname ${db_name} -rac_instance `hostname`,${db_name},1 -environment "${ENV}" -type oracle -envinst "/u01/app/oracle/product/19.8.0/dbhome_1" -timestamp LATEST_SNAPSHOT -uniqname ${db_name}${location_suffix} -mntpoint "/delphix" -archivelog yes -redoGroup 4 -redoSize 4096 -srcgroup "${source_group}" -template RSWP_FIN

    We have used this before but for a 'golden source'.

    In this current example we are going direct.

    We believe we have the correct syntax but we are continually getting the following error when trying to create the VDB:

    Source database not found.

    Any idea whats going on?

    This is quite urgent to get the VDBs created, could we have a Teams session early on June 8?

    Thanks in advance for any help.

    Best reards,

    John

    We have tried using the following:

    -sourcename "PSWPF${source_name_suffix}@dxswpp01-1"
    &
    -sourcename PSWPF${source_name_suffix}"

    The variable ${source_name_suffix} is confirmed as being 01.



    ------------------------------
    JOHN DICKINSON
    Mr
    London Stock Exchange Group
    ------------------------------


  • 2.  RE: problem when creating VDB - Source database not found.

    Posted 06-08-2022 04:53:00 AM
    Hi John,
    My colleague Paul looks to have answered this via a support case so I will add the resolution for completeness here:

    From your syntax above you are specifying the parameters  -srcgroup and -sourcename and both of these will also need the suffix @<namespace>.
    -sourcename "PSWPF${source_name_suffix}@<namespace>"
    -srcgroup "${source_group}@<namespace>"
    If you use the command 
    ./dx_get_db_env -d <engine>
    it will show you the naming convention used for the replicated objects.
     
    Many Thanks

    Darren

    ------------------------------
    Darren White
    Senior Support Specialist
    Delphix
    ------------------------------



  • 3.  RE: problem when creating VDB - Source database not found.

    Posted 06-08-2022 07:13:00 AM

    Thank you Darren.

    Please could you advice on the correct syntax when creating a multi-node RAC VDB using the parameter -rac_instance.

    We are trying to use:

    -rac_instance ${hostname1},${db_name},1 -rac_instance ${hostname2},${db_name},2

    But we get the error:

    Problem with node names or instance numbers. Please double check.Job wasn't defined. If there is no error on the screen, try with -debug flag to find a root cause.

    The documentation states:

    "-rac_instance env_node,instance_name,instance_no Comma separated information about node name, instance name and instance number for a RAC provisioning Repeat option if you want to provide information for more nodes"

    How should all nodes in the cluster be specified using rac_instance?



    ------------------------------
    JOHN DICKINSON
    Mr
    London Stock Exchange Group
    ------------------------------



  • 4.  RE: problem when creating VDB - Source database not found.

    Posted 06-09-2022 04:41:00 AM
    Hi,

    To create RAC VDB you need to specify the following:

    -rac_instance env_node,instance_name,instance_no

    where:

    env_node is a name / IP of the RAC cluster node discovered by Delphix environment 
    instance_name - is a requested instance name for a VDB 
    instance_no - is a requested instance number for a VDB

    for example for VDB testrac with 2 discovered nodes - server1 and server2 in the environment called racenv the command will look like this

    dx_provision_vdb -d Landshark -sourcename "Employee Oracle DB" -dbname testrac -targetname testrac -group Analytics -environment racenv -type oracle -envinst "/u01/app/oracle/product/19c/dbhome_1"  -rac_instance server1,testrac1,1 -rac_instance server2,testrac2,2

    Hope this help.

    regards,
    Marcin 




    ------------------------------
    Marcin Przepiorowski
    Director, Technical Services
    Delphix
    ------------------------------