Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only
  • 1.  Dxtoolkit not working for us after migrate to Red Hat Enterprise Linux 8.9

    Posted 07-05-2024 02:24:00 PM

    One of our server were migrate from redhat 7 to redhat 8.   So we have download the dxtoolkit2-v2.4.24-redhat8-installer.tar.gz but we still have this issue when issue any delphix command.  nothing return.

    For example:

    cat /etc/os-release
    NAME="Red Hat Enterprise Linux"
    VERSION="8.9 (Ootpa)"
    ID="rhel"
    VERSION_ID="8.9"

    [dxtoolkit2]$ ./dx_get_snapshots -help
    [dxtoolkit2]$

    In our redhat7 server will return information.

    Please help us find the root cause.

    Thanks,

    kihong



    ------------------------------
    kihong wong
    dba
    California Statewide Automated Welfare System (CalSAWS) Consortium
    ------------------------------


  • 2.  RE: Dxtoolkit not working for us after migrate to Red Hat Enterprise Linux 8.9

    Posted 07-06-2024 08:37:00 AM

    Hi Kihong-

    I've tried to reproduce this issue in my own Environment, but I don't see an immediate behavioral issue with the dxToolkit and OS versions.

    [root@myhost dxtoolkit2]# cat /etc/os-release
    NAME="Red Hat Enterprise Linux"
    VERSION="8.9 (Ootpa)"
    ID="rhel"
    ID_LIKE="fedora"
    VERSION_ID="8.9"
    PLATFORM_ID="platform:el8"
    PRETTY_NAME="Red Hat Enterprise Linux 8.9 (Ootpa)"
    
    [root@myhost dxtoolkit2]# dx_get_appliance -d deobj
    
    Appliance            Status   Version  Total [GB] Used [GB]  Free [GB]  PctUsed(%) dSource# VDBs#    Total Ob
    -------------------- -------- -------- ---------- ---------- ---------- ---------- -------- -------- --------
    deobj                UP       22.0.0.0     100.00      21.80      78.20 21.80      3        3        6
    
    [root@myhost dxtoolkit2]# dx_get_snapshots -help
    SYNOPSIS
         dx_get_snapshots    [ -engine|d <delphix identifier> | -all ] [ -configfile file ]
                             [ -group group_name | -name db_name | -host host_name | -type dsource|vdb | -dsource name ]
                             [ -timeloc t|l]
                             [ -startDate startDate]
                             [ -endDate endDate]
                             [ -snapshotname snapshotname]
                             [-output_unit K|M|G|T]
                             [ -format csv|json ]
                             [ -notime ]
                             [ -help|? ] [ -debug ]
    
         dx_get_snapshots    [ -engine|d <delphix identifier> | -all ] [ -configfile file ]
                             -size [ asc | desc ]
                             [ -group group_name | -name db_name | -host host_name | -type dsource|vdb | -dsource name ]
                             [ -format csv|json ]
                             [ -help|? ] [ -debug ]
    

    You may need to share additional debug information to get further feedback. Can you try executing one of the problem commands with -debug appended (there are multiple debug levels, so you can also consider higher levels such as -debug 4), as this may provide better detail on the functional problem.

    You may also consider using strace to look at the execution; this may expose a permission or other issue in the installation or environment... for example, in some instances we've seen permission issues in /tmp where dxToolkit creates temporary objects.



    ------------------------------
    Sean Nothdurft
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 3.  RE: Dxtoolkit not working for us after migrate to Red Hat Enterprise Linux 8.9

    Posted 07-09-2024 02:57:00 AM

    This is typically due to the new ACL access in /tmp that is enabled by default in RHEL 8.

    Create a new temporary folder and define your TMP environment variable to point there like so:
    mkdir ~/tmp

    export TMP=~/tmp

    Then try your dxtoolkit commands as usual and let us know the outcome.



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



  • 4.  RE: Dxtoolkit not working for us after migrate to Red Hat Enterprise Linux 8.9

    Posted 07-10-2024 02:58:00 PM

    Yes, it is the issue with /tmp.    Our Unix team is asking if dxtoolkit use other location instead of /tmp?

    Please advise.

    Kihong



    ------------------------------
    kihong wong
    dba
    California Statewide Automated Welfare System (CalSAWS) Consortium
    ------------------------------



  • 5.  RE: Dxtoolkit not working for us after migrate to Red Hat Enterprise Linux 8.9

    Posted 07-10-2024 05:21:00 PM

    Hi Kihong-

    Jose provided a workaround above that you can use for dxToolkit operation, was that not successful in your own testing?



    ------------------------------
    Sean Nothdurft
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 6.  RE: Dxtoolkit not working for us after migrate to Red Hat Enterprise Linux 8.9

    Posted 07-10-2024 06:07:00 PM

    @Kihong - just to clarify, I think idea here is to define a different TMP environment variable so it's not defaulting to /tmp. The sugesstion is to create a folder in your home directory (the '~' part in front of /tmp) and then assign the TMP variable to '~/tmp'.

    So I think the answer to your question is yes, a separate location defined by your team if that makes sense.  I'm far from a technical expert - just wanted to throw that out there in case there was confusion.



    ------------------------------
    Jake Wright
    Delphix Community Members
    ------------------------------



  • 7.  RE: Dxtoolkit not working for us after migrate to Red Hat Enterprise Linux 8.9

    Posted 07-16-2024 08:41:00 AM

    Jake

    it worked for me

     
    Starting session with SessionId: GutierrezBlancoJ@CalSAWS.org-ya6wxdnzn5gzo3lydfhul4uzky
    sh-4.4$ sudo su - oracle
    Last login: Mon Jul 15 16:40:55 PDT 2024 on pts/2
    [oracle@ATST-META1-RHEL8 ~]$ cd /u01/dxtoolkit/dxtoolkit248/dxtoolkit2
    [oracle@ATST-META1-RHEL8 dxtoolkit2]$ #./dx_get_db_env -configfile dxtools.conf
    [oracle@ATST-META1-RHEL8 dxtoolkit2]$ mkdir ~/tmp
    [oracle@ATST-META1-RHEL8 dxtoolkit2]$ export TMP=~/tmp
    [oracle@ATST-META1-RHEL8 dxtoolkit2]$ ./dx_get_db_env -configfile dxtools.conf
    There is no engine selected to process.
    now the question is how to get the hostname for the delphix engine as it is an ec2 instance I was using the canonical name 
    but I guess it's not working, unless I have to pass another argument 
    [
    [oracle@ATST-META1-RHEL8 dxtoolkit2]$ ./dx_get_db_env -configfile dxtools.conf -d ip-10-81-12-108.us-west-2.compute.internal
    login to 10.81.12.108  failed.
    Can't connect to Dephix Engine ip-10-81-12-108.us-west-2.compute.internal
     
     
    Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time
    -------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- -----------------------------------
    [oracle@ATST-META1-RHEL8 dxtoolkit2]$


    ------------------------------
    Jesus Alejandro Gutierrez Blanco
    Database Specialist
    Delphix Community Members
    ------------------------------



  • 8.  RE: Dxtoolkit not working for us after migrate to Red Hat Enterprise Linux 8.9

    Posted 07-16-2024 08:41:00 AM

    Thanks Jake , Jose it worked for me 

    [oracle@ATST-META1-RHEL8 ~]$ cd /u01/dxtoolkit/dxtoolkit248/dxtoolkit2
    [oracle@ATST-META1-RHEL8 dxtoolkit2]$ #./dx_get_db_env -configfile dxtools.conf
    [oracle@ATST-META1-RHEL8 dxtoolkit2]$ mkdir ~/tmp
    [oracle@ATST-META1-RHEL8 dxtoolkit2]$ export TMP=~/tmp
    [oracle@ATST-META1-RHEL8 dxtoolkit2]$ ./dx_get_db_env -configfile dxtools.conf
    There is no engine selected to process.

    Jesus



    ------------------------------
    Jesus Alejandro Gutierrez Blanco
    Database Specialist
    Delphix Community Members
    ------------------------------



  • 9.  RE: Dxtoolkit not working for us after migrate to Red Hat Enterprise Linux 8.9

    Posted 07-16-2024 08:41:00 AM

    Jake,, Jose

    I got it worked with the connectivity part thanks

    [oracle@ATST-META1-RHEL8 dxtoolkit2]$ ./dx_get_db_env -configfile dxtools.conf -d ip-10-81-12-108.us-west-2.compute.internal

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

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

    ip-10-81-12-108.us-w NA                   dev_msk6@ip-10-77-110-12-3     Targets@ip-10-7 VDB                                     N/A                                       8.14 NA         N/A        dev_msk6                       N/A                                 2022-05-27 17:08:56                 2024-05-18 13:18:29

    ip-10-81-12-108.us-w 10.81.2.119          at1saws                        Targets         VDB      dev_msk6@ip-10-77-110-12-3     2024-05-18 13:28:15 PDT                1835.74 RUNNING    enabled    at1saws                        2024-05-18 13:28:15 PDT             2022-06-30 14:39:59                 2024-05-24 21:18:05

    ip-10-81-12-108.us-w 10.81.2.119          at3saws                        Targets         VDB      dev_msk6@ip-10-77-110-12-3     2024-05-18 13:28:15 PDT                 176.23 RUNNING    enabled    at3saws                        2024-05-18 13:28:15 PDT             2022-06-30 15:02:48                 2024-05-24 21:32:22

    ip-10-81-12-108.us-w 10.81.2.119          at4saws                        Targets         VDB      dev_msk6@ip-10-77-110-12-3     2024-05-18 13:28:15 PDT                 172.42 RUNNING    enabled    at4saws                        2024-05-18 13:28:15 PDT             2022-06-30 15:13:59                 2024-05-27 02:02:55

    ip-10-81-12-108.us-w 10.81.2.119          at5saws                        Targets         VDB      dev_msk6@ip-10-77-110-12-3     2024-05-18 02:22:48 PDT                 140.52 RUNNING    enabled    at5saws                        2024-05-18 02:22:48 PDT             2022-07-06 17:49:40                 2024-06-01 21:10:41

    ip-10-81-12-108.us-w 10.81.2.79           brg1saws                       Targets         VDB      dev_msk6@ip-10-77-110-12-3     2024-05-18 13:28:15 PDT                2457.05



    ------------------------------
    Jesus Alejandro Gutierrez Blanco
    Database Specialist
    Delphix Community Members
    ------------------------------