Sponsored Content
Top Forums UNIX for Beginners Questions & Answers How to connect to a DB installed on another host using shell script? Post 303030758 by harishshankar on Friday 15th of February 2019 05:41:05 AM
Old 02-15-2019
Thank you vbe for the reply. This is what i have written. Could you please see if this is going to work:

Script on Host B:

Code:
#Variables
rval=0

#Check if DB is up
ps -ef|grep -v grep|grep pmon > /dev/null
rval=$?
if (( $rval == 0 ))
then
   echo "DB is up and running."
else
    echo "Waiting for DB to start"
fi

while [ "$rval" != "0" ]
 do
    echo " Trying again after 10 seconds"
    sleep 10
ps -ef|grep -v grep|grep pmon > /dev/null
rval=$?
echo "DB is up and running."
done


Script on Host A:

Code:
#Variables
rval1=0
local checkDB
checkDB=$(ssh user@server /scripts/checkDB.sh)
echo $?
if (( $rval == 0 ))
then
ps -ef|grep -v grep|grep server.sh > /dev/null
rval1=$?
if (( $rval1 == 0 ))
then
   echo "Server is already running."
else
   echo "Starting Server ..."
   $home/bin/startup.sh
   ps -ef|grep -v grep|grep server.sh > /dev/null
   rval1=$?
   if (( $rval1 == 0 ))
   then
      echo "Server is starting."
   fi
fi
 exit $rval



Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!

Last edited by RudiC; 02-15-2019 at 07:10 AM.. Reason: Added CODE tags.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

sendmail : connect local host (brocken)

hi there I've got a strange problem with a webserver box (suse linux 7.2). My MTA is sendmail, and when I tried manually send a mail. Sendmail -v "user@something" < /etc/hosts The Server tried "simon@localhost... Connecting to local..." but nothing happend and the system hold on. This... (3 Replies)
Discussion started by: mrsaint
3 Replies

2. Shell Programming and Scripting

How can my unix shell script automatically connect to remote host?

How can my unix shell script automatically connect to remote host? Assume that there is a remote host called "rhost". When I connect to that host i give the command "telnet rhost". It then asks me for my id and password. Once i give it connects there. I want to automate these steps. I want... (8 Replies)
Discussion started by: digdarshan
8 Replies

3. Shell Programming and Scripting

Run a shell script from one host which connext to remote host and run the commands

I want to write a script which would run from one host say A and connect to other remote host B and then run rest of commands in that host. I tried connecting from A host to B with SSH but after connecting to host B it just getting me inside Host B command prompt. Rest of the script is not running... (6 Replies)
Discussion started by: SN2009
6 Replies

4. Shell Programming and Scripting

How to use ssh execute other shell script on other host (shell script include nohup)?

i want use ssh on the host01 to execute autoexec.sh on the host02 like following : host01> ssh host02 autoexec.sh autoexec.sh include nohup command like follwing : nohup /home/jack/deletedata.sh & after i execute ssh host02 autoexec.sh one the host01. i can't found deletedata.sh... (1 Reply)
Discussion started by: orablue
1 Replies

5. Red Hat

Installed apache server , can't connect from outside (using CentOS in WMware )

Hello all I installed apache in CentOS 5.5 ,after searching the web for tips on configuration I did the fallowing stuff to unable connecting the http server from outside. In /etc/httpd/conf/httpd.conf I changed the Listen value to 0.0.0.8011 Then checked with then check with: netstat -anp and I... (2 Replies)
Discussion started by: umen
2 Replies

6. Shell Programming and Scripting

Connect to Oracle in Windows XP from Linux HOST

Hi everyone, I have oracle 9i installed in Windows XP and i have ubuntu in VM WARE. I would like to know how to connect to Oracle in windows xp from Linux through shel scripting...... (3 Replies)
Discussion started by: Zimbu
3 Replies

7. Shell Programming and Scripting

Portable Shell Script - Determine Which Version of Binary is Installed?

I currently have a shell script that utilizes the "Date" binary - this application is slightly different on OS X (BSD General Commmand) and Linux systems (gnu date). In particular, the version on OS X requires the following to get a date 14 days in the future "date -v+14d -u +%Y-%m-%d" where gnu... (1 Reply)
Discussion started by: colinjohnson
1 Replies

8. Shell Programming and Scripting

CURL getting Error- couldn't connect to host

Hi i am trying to open HTTP by curl command. i am tryng to do that from command or script BASH. also iptables is off it doesnt work i am getting an error: curl: (7) coudn't connect to host the scipt is: #! /bin/bash curl http://www.cnn.com (1 Reply)
Discussion started by: zigizag
1 Replies

9. Shell Programming and Scripting

Connect to target host from Source host.

Hi All, Need to connect to target host and execute a command and connect back to source host to continue with next set of command execution. Is there a utility/command using which we can connect to target host ? Please suggest. Note: Netezza database is instaled on Linux server. ... (4 Replies)
Discussion started by: Nagaraja Akkiva
4 Replies

10. Shell Programming and Scripting

Shell script to connect

hello i try to made a report to conect all database to diferent OS HP-UX/LINUX/SOLARIS/AIX this is my example i have 5 db OS are HP-UX ps -fea | grep pmon root 1120 1 0 Nov 29 ? 5:14 ipmon -sD oracle 10286 1 0 Nov 29 ? 27:19 ora_pmon_BD1 oracle 10431... (7 Replies)
Discussion started by: ceciaide
7 Replies
TFTP(1) 						      General Commands Manual							   TFTP(1)

NAME
tftp - trivial file transfer program SYNOPSIS
tftp [ host ] DESCRIPTION
Tftp is the user interface to the Internet TFTP (Trivial File Transfer Protocol), which allows users to transfer files to and from a remote machine. The remote host may be specified on the command line, in which case tftp uses host as the default host for future transfers (see the connect command below). COMMANDS
Once tftp is running, it issues the prompt tftp> and recognizes the following commands: connect host-name [ port ] Set the host (and optionally port) for transfers. Note that the TFTP protocol, unlike the FTP protocol, does not maintain connec- tions betweeen transfers; thus, the connect command does not actually create a connection, but merely remembers what host is to be used for transfers. You do not have to use the connect command; the remote host can be specified as part of the get or put com- mands. mode transfer-mode Set the mode for transfers; transfer-mode may be one of ascii or binary. The default is ascii. put file put localfile remotefile put file1 file2 ... fileN remote-directory Put a file or set of files to the specified remote file or directory. The destination can be in one of two forms: a filename on the remote host, if the host has already been specified, or a string of the form host:filename to specify both a host and filename at the same time. If the latter form is used, the hostname specified becomes the default for future transfers. If the remote-direc- tory form is used, the remote host is assumed to be a UNIX machine. get filename get remotename localname get file1 file2 ... fileN Get a file or set of files from the specified sources. Source can be in one of two forms: a filename on the remote host, if the host has already been specified, or a string of the form host:filename to specify both a host and filename at the same time. If the latter form is used, the last hostname specified becomes the default for future transfers. quit Exit tftp. An end of file also exits. verbose Toggle verbose mode. trace Toggle packet tracing. status Show current status. rexmt retransmission-timeout Set the per-packet retransmission timeout, in seconds. timeout total-transmission-timeout Set the total transmission timeout, in seconds. ascii Shorthand for "mode ascii" binary Shorthand for "mode binary" ? [ command-name ... ] Print help information. BUGS
Because there is no user-login or validation within the TFTP protocol, the remote site will probably have some sort of file-access restric- tions in place. The exact methods are specific to each site and therefore difficult to document here. 4.3 Berkeley Distribution 1Q TFTP(1)
All times are GMT -4. The time now is 07:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy