Sponsored Content
Top Forums Shell Programming and Scripting Finding all Oracle SW installations on a host Post 302988870 by gandolf989 on Wednesday 4th of January 2017 09:43:22 AM
Old 01-04-2017
Why doesn't your /etc/oratab file reflect every database running on a server and which Oracle Home that database uses? When I log in to a server I have my .bashrc script run the following commands.

Code:
export DEFAULT_SID=`grep -v "^$" /etc/oratab | grep -v "^#" | grep -v "^\*" | head -1 | cut -d":" -f1`
. ${HOME}/scripts/bin/set_oracle_env.sh ${DEFAULT_SID}

The set_oracle_env.sh script set the ORACLE_HOME, PATH, LD_LIBRARY_PATH, TNS_ADMIN which is in /etc, and the ORACLE_SID. You can write your own and have it set anything that you want. I also create the following alias's for my convenience.

Code:
alias getenv="env | egrep 'ORACLE|TNS' | sort"
alias setenv=". ${HOME}/scripts/bin/set_oracle_env.sh "
alias sqlsys="cd ${HOME}/scripts/sql ; sqlplus '/as sysdba'"

Then setting my environment is dead simple. Especially with writing scripts where I start with the set_oracle_env.sh script to set the Oracle environment variables.
 

9 More Discussions You Might Find Interesting

1. IP Networking

QNX host cannot ping SCO host, vice versa

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

Network Installations of 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

external dvdrw installations

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

Multiple Perl installations on 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

Packages installations on my servor

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

Help! How to find the local host after few ssh hops to remote host???

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

Oracle accessing from remote host

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

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

9. UNIX for Dummies Questions & Answers

Finding Oracle form Version UNIX

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
WHICH(1)						      General Commands Manual							  WHICH(1)

NAME
which - shows the full path of (shell) commands. SYNOPSIS
which [options] [--] programname [...] DESCRIPTION
Which takes one or more arguments. For each of its arguments it prints to stdout the full path of the executables that would have been exe- cuted when this argument had been entered at the shell prompt. It does this by searching for an executable or script in the directories listed in the environment variable PATH using the same algorithm as bash(1). This man page is generated from the file which.texinfo. OPTIONS
--all, -a Print all matching executables in PATH, not just the first. --read-alias, -i Read aliases from stdin, reporting matching ones on stdout. This is useful in combination with using an alias for which itself. For example alias which='alias | which -i'. --skip-alias Ignore option `--read-alias', if any. This is useful to explicity search for normal binaries, while using the `--read-alias' option in an alias or function for which. --read-functions Read shell function definitions from stdin, reporting matching ones on stdout. This is useful in combination with using a shell func- tion for which itself. For example: which() { declare -f | which --read-functions $@ } export -f which --skip-functions Ignore option `--read-functions', if any. This is useful to explicity search for normal binaries, while using the `--read-functions' option in an alias or function for which. --skip-dot Skip directories in PATH that start with a dot. --skip-tilde Skip directories in PATH that start with a tilde and executables which reside in the HOME directory. --show-dot If a directory in PATH starts with a dot and a matching executable was found for that path, then print "./programname" rather than the full path. --show-tilde Output a tilde when a directory matches the HOME directory. This option is ignored when which is invoked as root. --tty-only Stop processing options on the right if not on tty. --version,-v,-V Print version information on standard output then exit successfully. --help Print usage information on standard output then exit successfully. RETURN VALUE
Which returns the number of failed arguments, or -1 when no `programname' was given. EXAMPLE
The recommended way to use this utility is by adding an alias (C shell) or shell function (Bourne shell) for which like the following: [ba]sh: which () { (alias; declare -f) | /usr/bin/which --tty-only --read-alias --read-functions --show-tilde --show-dot $@ } export -f which [t]csh: alias which 'alias | /usr/bin/which --tty-only --read-alias --show-dot --show-tilde' This will print the readable ~/ and ./ when starting which from your prompt, while still printing the full path when used from a script: > which q2 ~/bin/q2 > echo `which q2` /home/carlo/bin/q2 BUGS
The HOME directory is determined by looking for the HOME environment variable, which aborts when this variable doesn't exist. Which will consider two equivalent directories to be different when one of them contains a path with a symbolic link. AUTHOR
Carlo Wood <carlo@gnu.org> SEE ALSO
bash(1) WHICH(1)
All times are GMT -4. The time now is 01:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy