Sponsored Content
Full Discussion: Checking SQL DB Availability
Top Forums Shell Programming and Scripting Checking SQL DB Availability Post 302888304 by Yoda on Thursday 13th of February 2014 06:15:35 PM
Old 02-13-2014
Why you want to test connectivity remotely using ssh?

I would suggest you to create your own tnsnames.ora with database address for establishing connection.

Then point TNS_ADMIN variable to the path where tnsnames.ora is placed and test connectivity locally.
This User Gave Thanks to Yoda For This Post:
 

10 More Discussions You Might Find Interesting

1. IP Networking

Checking for availability of remote server

Hi. In my KSH script I'm running a command on a remote server. I want to know how I can test to see if the remote server is available (accessible) prior to running the command. Any ideas? My command looks like: `ssh $USER@$TARGET_SERVER_DNS ls -l $REMOTE_FOLDER ` This check should be... (1 Reply)
Discussion started by: dylanmilks
1 Replies

2. Shell Programming and Scripting

Checking for availability of remote server

Hi. In my KSH script I'm running a command on a remote server. I want to know how I can test to see if the remote server is available (accessible) prior to running the command. Any ideas? My command looks like: `ssh $USER@$TARGET_SERVER_DNS ls -l $REMOTE_FOLDER ` This check should be... (4 Replies)
Discussion started by: dylanmilks
4 Replies

3. Shell Programming and Scripting

Checking availability of Web pages through Unix script

Hi Guru's, I need to check the availability of a web page for every one hour through a script. Following is the requirement. 1. Go to http://vsn.srivsn.com 2. If any error encountered in openeing the home page, it should trigger an email with the appropriate error message. 3. If page opens... (6 Replies)
Discussion started by: srivsn
6 Replies

4. Solaris

Printer availability

Hi, Im new in shell programming. I need to know the availability for specific printers. We send requests from solaris to printers located at an NT server. My idea is creating a shell that will monitor availbaility and send an email when something is wrong. I have a file with printers and its... (2 Replies)
Discussion started by: agsarm1971
2 Replies

5. Shell Programming and Scripting

checking sql connectivity in unix

hi, i am using a sqlplus connection in one of my shell scripts. i want to check if the connection is set properly or not.. can i use '$?' to check the status of the sql connectivity..? or is there any other option to do that..? thanks, (1 Reply)
Discussion started by: kripssmart
1 Replies

6. Shell Programming and Scripting

Checking availability of service

HI CAN ANY ONE HELP ME FOR BELOW QUESTION CHECKING AVAILABILITY OF SERVICE IN LINUX (2 Replies)
Discussion started by: satheeshkr_cse
2 Replies

7. Programming

Checking columns in SQL, comparing user input and sizes.

I'm writing a KSH shell script that's using SQL though DB2. If I have a table defined and populated db2 "create table tb(num int,letter char(4))" db2 "insert into tb values(111,a) db2 "insert into tb values(112,b) db2 "insert into tb values(111,c) How can I check if a letter user... (0 Replies)
Discussion started by: busdude
0 Replies

8. Shell Programming and Scripting

Script should keep checking for availability of files.

Hi, I want my script to check for availability of few files contineously for some time. Lets say from 10:00 AM to 10:30 AM script should keep checking on a particular location for each file one by one. If all the files are available then only it should complete the next processing part, else... (2 Replies)
Discussion started by: amit.mathur08
2 Replies

9. SCO

Stop boot system at "Checking protected password and checking subsystem databases"

Hi, (i'm sorry for my english) I'm a problem on boot sco unix 5.0.5 open server. this stop at "Checking protected password and checking subsystem databases" (See this image ) I'm try this: 1) http://www.digipedia.pl/usenet/thread/50/37093/#post37094 2) SCO: SCO Unix - Server hangs... (9 Replies)
Discussion started by: buji
9 Replies

10. Programming

Dynamically checking rules in database tables using SQL

I want to check for rows in a table where all values (except the key) is empty. I am using MySQL 5.5. I plan to do this mechanically, so the approach should work for any table in my database schema. Suppose for illustration purposes I start with the following table: CREATE TABLE `sources` ( ... (4 Replies)
Discussion started by: figaro
4 Replies
linkloop(1M)															      linkloop(1M)

NAME
linkloop - verify LAN connectivity with link-level loopback SYNOPSIS
PPA] count] rif] size] timeout] linkaddr ... Remarks The and commands are deprecated. See for more information. DESCRIPTION
The command uses IEEE 802.2 link-level test frames to check connectivity within a local area network (LAN). linkaddr is the hardware station address of a remote node. Several addresses can be specified at one time. tests the connectivity of the local node and the remote node specified by each hardware station address. The hardware station address of a remote node can be found by executing on the remote node. This hardware station address is usually represented as a hexadecimal string prefixed with It can also be represented as a octal string prefixed with or as a decimal string. The hardware station address must not be a multicast or broadcast address. Options recognizes the following options: Specify the PPA to use. If this option is omitted, uses the first PPA it encounters in an internal data structure. Set the number of frames to transmit. If count is transfers frames indefinitely until an interrupt signal (defined by the user shell) is received. The default value for count is Specify the particular bridge route over which token ring packets should be delivered. rif is the routing information field used for token-ring net- works. Its value is given as an even number of hexadecimal bytes separated by colons, up to a maximum of 16 bytes. Set the size in bytes of the data message to send. The maximum data size is dependent on the type of LAN link being used. The default value is the maximum data byte count that can be used for the particular link. Set the amount of time in seconds to wait for a reply from the remote node before aborting. If timeout is waits indefinitely for a reply. The default value is 2 seconds. Set the verbose option. In addition to the regular summary of test results, this option displays more extensive error information. If there are header or length errors, appropriate messages are displayed. All verbose output is preceded by the number of replies accepted before an error occurred. Connectivity Test Results aborts upon receipt of an interrupt signal. If aborted, the current results are printed. prints the result of the link-level connectivity test. If the test fails, it prints a summary of the test and indicates the type of error. The possible messages are: An incorrect hardware station address was entered on the command line. The station address entered on the command line is either a multicast or broadcast address. Total number of frames sent. Total number of frames received without errors. Received frame length does not match transmitted frame length. If the verbose option is set, the length received is printed. Received frame does not match transmitted frame. Number of frames received containing unexpected frame header information. Either the source address does not match the remote address, the destination address does not match the local address, or the control field is not the TEST frame control field. These frames are ignored. continues to try to receive the reply frame until the operation times out. Count of how many operations timed out before the reply was received. DIAGNOSTICS
The count specified in the option is a negative integer, or the number specified is too large for the local computer. The timeout specified in the option is a negative integer, or the value specified multiplied by 1000 is too large for the local com- puter. The size specified in the option is not in the range from 0 to the maximum link data size. Remember that the maximum link data size can vary in value for different LAN connection types. The current MTU can be obtained with the command. The PPA specified in the option is not a valid PPA. Device file does not exist. The rif value in the option is invalid. The number of bytes in rif in the option exceeded 16, which is the maximum allowed. The number of bytes in rif in the option is odd. The number of bytes must be even. WARNINGS
The and commands are deprecated. These commands will be removed in a future HP-UX release. HP recommends the use of replacement command nwmgr(1M) to perform all network interface-related tasks. AUTHOR
was developed by HP. SEE ALSO
lanadmin(1M), lanscan(1M), nwmgr(1M), lan(7). TO BE OBSOLETED linkloop(1M)
All times are GMT -4. The time now is 08:48 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy