dx_get_instance - delphix/dxtoolkit GitHub Wiki

SYNOPSIS

dx_get_instance  [-engine|d <delphix identifier> | -all ]
                 [-group group_name | -name db_name | -host host_name | -type dsource|vdb ]
                 [-format csv|json ]
                 [-help|? ]
                 [-debug ]

DESCRIPTION

Get the information about Oracle instances.

ARGUMENTS

Delphix Engine selection - if not specified a default host(s) from dxtools.conf will be used.

  • -engine|d Specify Delphix Engine name from dxtools.conf file
  • -all Display databases on all Delphix appliance
  • -configfile file Location of the configuration file. A config file search order is as follow:
  • configfile parameter
  • DXTOOLKIT_CONF variable
  • dxtools.conf from dxtoolkit location

Filters

Filter databases using one of the following filters

  • -group Group Name
  • -name Database Name
  • -host Host Name
  • -type Type (dsource|vdb)
  • -envname Environment name

OPTIONS

  • -format Display output in csv or json format If not specified pretty formatting is used.
  • -help Print this screen
  • -debug Turn on debugging
  • -nohead Turn off header output

EXAMPLES

Display a Oracle instance status

dx_get_instance -d Landshark43

Appliance  Env name             Hostname                       Group           Database                       Instance   Type     Status
---------- -------------------- ------------------------------ --------------- ------------------------------ ---------- -------- ----------
Landshark4 racattack            192.168.1.61                   Analytics       racd                           racd1      VDB      down
Landshark4 racattack            192.168.1.62                   Analytics       racd                           racd2      VDB      down
Landshark4 LINUXTARGET          172.16.180.251                 Analytics       test1                          test1      VDB      down
Landshark4 LINUXSOURCE          172.16.180.250                 Sources         Employee Oracle 11G DB         orcl       dSource  up