Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only
  • 1.  Error when executing dx_get_db_env command - No DB selected

    Posted 7 days ago
    Edited by Horacio GrupoNet 7 days ago
      |   view attached
    Dear Delphix Community
     
    When executing the command ./dx_get_db_env -d dpxlab -rdbms oracle --debug 4, I receive the following error message:
    "There is no DB selected to process on dpxlab . Please check filter definitions."
    However, there are databases present in Delphix. I have attached images showing the existing databases.
    I've attached the execution log
    I attempted to run previous versions of dxtoolkit without success, and I also tested against a customer's engine (version 20.0.0.0) with the same results. In all cases, these were Oracle databases.
    Software Versions:
    - Delphix Continuous Data Engine 24.0.0.0
    - 2.4.24 for Red Hat 8
    - 2.4.24 for Windows
     
    Operating Systems:
    - Oracle Linux Server release 8.10
    - Windows 11
     
    How can I solve this issue?
    Thank you for your assistance.

    Horacio

    Attachment(s)



  • 2.  RE: Error when executing dx_get_db_env command - No DB selected

    Posted 4 days ago

    Hi Horacio.
    What exactly are you trying to achieve by running this command?



    ------------------------------
    Jose Manuel Rodriguez Prieto
    Technical Account Manager
    Delphix
    ------------------------------



  • 3.  RE: Error when executing dx_get_db_env command - No DB selected

    Posted 2 days ago

    Hi Jose.

    I usually use dxtoolkit to document client installations or to generate configuration reports. When executing the dx_get_db_env command, I expected to get a result like the following:

    Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time                    
    -------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- ----------------------------------- 
    dpxlab01.gruponet.co 192.168.73.163       datasets_prod                  Datasets_Prd    dSource                                 N/A                                       0.29 RUNNING    enabled    N/A                            N/A                                 2023-11-22 12:23:46                 N/A                                 
    dpxlab01.gruponet.co 192.168.73.82        ORCLCDB                        Datasets_Prd    CDB                                     N/A                                       0.87 UNKNOWN    enabled    ORCLCDB                        N/A                                 2023-12-03 12:15:39                 N/A                                 
    dpxlab01.gruponet.co 192.168.73.82        ORCLPDB1                       Datasets_Prd    dSource                                 N/A                                       0.17 INACTIVE   enabled    N/A                            N/A                                 2023-12-03 12:15:39                 N/A                                 
    dpxlab01.gruponet.co 192.168.73.80        datasets_qa                    Datasets_QA     VDB      datasets_prod                  2023-11-22 12:24:32 -03                   0.00 RUNNING    enabled    N/A                            2023-11-22 12:24:32 -03             2023-11-22 12:48:07                 2023-11-22 12:48:07           

    This command used to work with previous versions of the virtualization engine.

    Again, I get this error "There is no DB selected to process on dpxlab . Please check filter definitions." while running many other dx_ commands. I will make a list of them.

    Thanks for your help



    ------------------------------
    Horacio GrupoNet
    Innovation Manager
    Grupo Net S.A.
    ------------------------------



  • 4.  RE: Error when executing dx_get_db_env command - No DB selected

    Posted 2 days ago

    Hello Horatio,

    I upgraded my dxtoolkit to 2.4.24 and ran it against a Delphix 24.0.0.0 engine and it worked:

    % ./dx_get_db_env -version

    2.4.24

    % ./dx_get_db_env -engine venus

    Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time                    
    -------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- ----------------------------------- 
    venus                orcl-191100-src.supp DBOMSRCD94D3                   luke - worldpay dSource                                 N/A                                       1.87 RUNNING    enabled    DBOMSRCD94D3                   N/A                                 2024-02-12 11:39:43                 N/A                                 
    venus                orcl-191100-tgt.supp lukevdb                        luke - worldpay VDB      DBOMSRCD94D3                   2024-02-29 06:31:38 EST                   1.77 RUNNING    enabled    lukevdb     
    ...etc...

    In your screen shot, it shows the engine name as "dpxlab01" but in your command and debug output it shows engine "dpxlab".

    I wonder if there is a double entry or some other type of problem in your "/home/hrosende/bin/dxtoolkit2/dxtools.conf" file? In your output it shows that it is loading the configuration for "Loading engine dpxlab" twice:

    # ./dx_get_db_env -d dpxlab -rdbms oracle --debug 4
    Dxtoolkit version 2.4.24
    -Entering Engine::constructor
    -Entering Engine::load_config
    Loading engines from /home/hrosende/bin/dxtoolkit2/dxtools.conf
     -Loading engine dpxlab
     -Loading engine dpxlab
    -Entering Engine::dlpx_connect
    -Login type: password
     -Cookie file /tmp/cookies.hrosende.dpxlab
    connecting to: dpxlab ( IP/name : 192.168.73.85 )

    When I test in my environment with "-debug 4" I only see each configuration loaded once:

    Dxtoolkit version 2.4.24
    -Entering Engine::constructor
    -Entering Engine::load_config
    Loading engines from /Users/neal.stack/Downloads/dxtoolkit2424/dxtoolkit2/dxtools.conf
     -Loading engine neal1800
     -Loading engine venus
     -Loading engine saturn
     -Loading engine masking
     -Loading engine Landshark2
    -Entering Engine::dlpx_connect
    -Login type: password
     -Cookie file /var/folders/qs/t716yhb17bjct0t54jzwftyh0000gp/T/cookies.neal.stack.venus
    connecting to: venus ( IP/name : de-venus.supportlab.delphix.com )

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 5.  RE: Error when executing dx_get_db_env command - No DB selected

    Posted 2 days ago
      |   view attached

    Hello Neal,

    I posted an example of what I used to get. You are right; the hostname is not the same. I've changed dxtools.conf several times to make it work in Fedora 40, Oracle Server 8.10, and Windows 11. I uploaded a zip file with current configuration and debug output. I replaced an IP address portion and passwords with XXX on purpose.

    I get this message when running ./dx_get_db_env -d dpxlab -rdbms oracle -debug 3.

    There is no DB selected to process on dpxlab . Please check filter definitions.

    Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time
    -------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- -----------------------------------

    Thanks for your help



    ------------------------------
    Horacio GrupoNet
    Innovation Manager
    Grupo Net S.A.
    ------------------------------

    Attachment(s)

    zip
    debug.zip   1 KB 1 version


  • 6.  RE: Error when executing dx_get_db_env command - No DB selected
    Best Answer

    Posted 2 days ago

    Hi Horatio,

    It is the second entry that is causing the issue. It loads the first "dpxlab" configuration with the "admin" user. Then it overwrites that configuration when it loads the second "dpxlab" configuration for the "sysadmin" user.

    The "sysadmin" user doesn't have access to the same APIs as the "admin" user and so you get an empty result set back.

    The "hostname" field in the configuration file is not a literal host name. It is an identifier ( https://github.com/delphix/dxtoolkit/wiki#configuration ):

    hostname - Delphix identifier

    Can you try giving the two entries in your configuration file a unique host name? Maybe something like the following?

                "hostname" : "dpxlab",
                "ip_address" : "192.168.XX.XX",
                "username" : "admin",

    and

                "hostname" : "sysadmin_dpxlab",
                "ip_address" : "192.168.XX.XX",
                "username" : "sysadmin",

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 7.  RE: Error when executing dx_get_db_env command - No DB selected

    Posted 2 days ago

    Hello Neal.
    It works fine now. I could have sworn that before it wasn't necessary for the hostname to be different for each user, but it's obvious that I'm wrong.

    Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time
    -------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- -----------------------------------
    dpxlab_admin         192.168.73.82        ORCLCDB                        Datasets_Prd    CDB                                     N/A                                       2.72 RUNNING    enabled    ORCLCDB                        N/A                                 2024-07-02 10:58:13                 N/A
    dpxlab_admin         192.168.73.82        ORCLPDB1                       Datasets_Prd    dSource                                 N/A                                       0.30 RUNNING    enabled    N/A                            N/A                                 2024-07-02 10:58:13                 N/A
    dpxlab_admin         192.168.73.82        VORCLPDB1                      Datasets_Prd    VDB      ORCLPDB1                       2024-07-02 17:36:25 -03                   0.19 RUNNING    enabled    N/A                            2024-07-02 17:36:25 -03             2024-07-02 11:56:51                 2024-07-02 17:37:32


    Thank you very much for your patience and attention.
    Once again, thank you very much.



    ------------------------------
    Horacio GrupoNet
    Innovation Manager
    Grupo Net S.A.
    ------------------------------