github.com/tommi2day/tnscli@v0.0.0-20240401211958-338fc0647b73/scripts/gotodb (about)

     1  #!/bin/bash
     2  
     3  # ssh to host running oracle service
     4  # retrieve host name delivered by dbhost command
     5  # set final hostname via .ssh/config
     6  
     7  WD=$(dirname "$0")
     8  export PATH=$PATH:$WD
     9  unset DEBUG
    10  DB=$1
    11  O=${2:+-o}
    12  
    13  DBDATA=$(dbhost "$DB" )
    14  if [ -z "$DBDATA" ]; then
    15          echo "Cannot extract host info"
    16          exit 1
    17  fi
    18  DBDATA=${DBDATA#*-> }
    19  HOST=$(echo "$DBDATA"|cut -d: -f1)
    20  HOST=${HOST%%.*}
    21  INST=$(echo "$DBDATA"|cut -d: -f2)
    22  
    23  echo "connect to $HOST, Instance: $INST"
    24  ssh "${HOST}$O"
    25