01-01-2017
Oracle has a tool - $ORACLE_HOME/bin.tnsping. You should have it installed on your desktop machine if you have an oracle client install.
This will tell you if you connect to a server on a remote host - i.e., does one exist and is it up. sqlplus binary exists on any box that has either the client software set or the server software set. So, locating sqlplus in each $ORACLE_HOME on a machine tells you the instance name(s). e.g., /u01/blah/blah/bin/sqlplus , plus it shows the version as well.
If you want to connect to every server you can (you need passwords and usernames) see, you should consider having all of the versions like 9, 10, 11 client installed on the box doing the searching.
9 More Discussions You Might Find Interesting
1. IP Networking
The problem I am facing now is that the QNX host could not ping the SCO host and vice versa. They are in the same domain, ie, 172.20.3.xx. As I am very new to Unix, I guess I must have missed out some important steps. Pls help... Thanx alot (2 Replies)
Discussion started by: gavon
2 Replies
2. Solaris
First off, I'm pretty new to Solaris, although I know Windows very well.
I have a mixed Wintel, Linux and SPARC/Solaris environment and am looknig for a way to make short work of installing Solaris. I know there is a network booting option and there are the WebStart (configurable) and JumpStart... (1 Reply)
Discussion started by: BeekerC
1 Replies
3. Linux
Hello all,
Please can someone assist?
I am attempting to install an external dvdrw on fedora 6.
I attach the dvdrw device to the USB port and run dmesg:
scsi2 : SCSI emulation for USB Mass Storage devices
usb-storage: device found at 4
usb-storage: waiting for device to settle before... (0 Replies)
Discussion started by: chlawren
0 Replies
4. HP-UX
This will undoubtedly seem like a problem that should be easily resolved but...
We are having some 'issues' getting multiple versions of Perl installed on our HP-UX servers (11.11 & 11.23). Now, I'm not a Sys Admin but I believe the reason behind this is that the Perl installation which comes... (2 Replies)
Discussion started by: Macer
2 Replies
5. Solaris
Hello everybody,
I'd like to install several important packages on my servor like for instance, man pages package..
I found a .tar.gz package of man pages. So, after to do "gtar zxvf name_of_file.tar.gz" I can access on the folder "name_of_file" (by cd name_of_file). Then, I read on my readme... (4 Replies)
Discussion started by: MasterapocA
4 Replies
6. UNIX for Advanced & Expert Users
I do a ssh to remote host(A1) from local host(L1). I then ssh to another remote(A2) from A1.
When I do a who -m from A2, I see the "connected from" as "A1".
=> who -m
userid pts/2 2010-03-27 08:47 (A1)
I want to identify who is the local host who initiated the connection to... (3 Replies)
Discussion started by: gomes1333
3 Replies
7. Programming
i have installd oracle 10 on Solaris 10 now i want to access this database from remote machine.
-bash-3.00$ tnsping 192.168.92.49
TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 17-DEC-2010 21:06:51
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter... (23 Replies)
Discussion started by: akhaliq22
23 Replies
8. Shell Programming and Scripting
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
9. UNIX for Dummies Questions & Answers
I'm trying to find the version of the underlying Oracle forms from out Unix Server.
I have tried
frmcmp.sh -h
but I get the error
frmcmp.sh -h : not found
Its a Unix Sun server running an oracle database
Any ideas? (1 Reply)
Discussion started by: dbajtr
1 Replies
LEARN ABOUT DEBIAN
bup-on
bup-on(1) General Commands Manual bup-on(1)
NAME
bup-on - run a bup server locally and client remotely
SYNOPSIS
bup on <hostname> index ...
bup on <hostname> save ...
bup on <hostname> split ...
DESCRIPTION
bup on runs the given bup command on the given host using ssh. It runs a bup server on the local machine, so that commands like bup save
on the remote machine can back up to the local machine. (You don't need to provide a --remote option to bup save in order for this to
work.)
See bup-index(1), bup-save(1), and so on for details of how each subcommand works.
This 'reverse mode' operation is useful when the machine being backed up isn't supposed to be able to ssh into the backup server. For
example, your backup server can be hidden behind a one-way firewall on a private or dynamic IP address; using an ssh key, it can be autho-
rized to ssh into each of your important machines. After connecting to each destination machine, it initiates a backup, receiving the
resulting data and storing in its local repository.
For example, if you run several virtual private Linux machines on a remote hosting provider, you could back them up to a local (much less
expensive) computer in your basement.
EXAMPLES
# First index the files on the remote server
$ bup on myserver index -vux /etc
bup server: reading from stdin.
Indexing: 2465, done.
bup: merging indexes (186668/186668), done.
bup server: done
# Now save the files from the remote server to the
# local $BUP_DIR
$ bup on myserver save -n myserver-backup /etc
bup server: reading from stdin.
bup server: command: 'list-indexes'
PackIdxList: using 7 indexes.
Saving: 100.00% (241/241k, 648/648 files), done.
bup server: received 55 objects.
Indexing objects: 100% (55/55), done.
bup server: command: 'quit'
bup server: done
# Now we can look at the resulting repo on the local
# machine
$ bup ftp 'cat /myserver-backup/latest/etc/passwd'
root:x:0:0:root:/root:/bin/bash
daemon:x:1:1:daemon:/usr/sbin:/bin/sh
bin:x:2:2:bin:/bin:/bin/sh
sys:x:3:3:sys:/dev:/bin/sh
sync:x:4:65534:sync:/bin:/bin/sync
...
SEE ALSO
bup-index(1), bup-save(1), bup-split(1)
BUP
Part of the bup(1) suite.
AUTHORS
Avery Pennarun <apenwarr@gmail.com>.
Bup unknown- bup-on(1)