07-24-2019
i have tried one test
z=`ssh remote host export ORACLE_HOME=/my_home_location; export PATH=$ORACLE_HOME/bin:$PATH; srvctl config database -d DB | awk -F: '/^Database role/ {match ($0, /[A-Za-z_]*PRIMARY[A-Za-z_]*/); print substr ($0, RSTART, RLENGTH)}'`
echo $z
PRIMARY
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
In a ksh script on an AIX box running a jillion oracle database processes, I'm setting a variable to one of two possible arguments, depending on cmd line arguments.
FINDIT="ps -ef | grep oracle | grep DBexport | grep rshrc"
-or-
FINDIT="ps -ef | grep oracle | grep prod | grep runback"
I... (3 Replies)
Discussion started by: zedmelon
3 Replies
2. UNIX for Dummies Questions & Answers
Just a quick question. If I have a script that calls another script while running, is it possible for the second script to reference a variable in the first script and if so, how. Is it scriptname.sh:$VARIABLE for a global variable and can you do scriptname.sh:function $VARIABLE or am I off my... (1 Reply)
Discussion started by: kirkm76
1 Replies
3. Shell Programming and Scripting
Hi All,
I have declared a variable in script1 and assign a value for it. In script2 i'll call script1 and then I want the value of variables set in script1.
I have tried with export, but in vain.
How can I achive this?
Below is the two scripts.
--script1
#!/usr/bin/ksh
echo $1... (1 Reply)
Discussion started by: javaDev
1 Replies
4. UNIX for Dummies Questions & Answers
Hey all,
I'm wondering how you pass variable's that are defined in one script to another script that's been called by that first script.....
Best regards,
Jaz (1 Reply)
Discussion started by: Jazmania
1 Replies
5. Shell Programming and Scripting
Hi all.
I need to pass a value from a script that runs in a sub-shell, back into the calling shell like below (or into script 2 directly):
outer_script
export param=value1
script1 $param
(in script1: export param=value2)
script2 $param
($param is now value1, not value2... (4 Replies)
Discussion started by: bbergstrom74
4 Replies
6. Shell Programming and Scripting
Friends,
I am using ksh under SunoS. This is what I have
In file1.sh
NOW=$(date +"%b-%d-%y")
LOGFILE="./log-$NOW.log"
I will be using this file through file1.sh as log file.
I have another script file2.sh which is being called inside my file1.sh. I would like to use the same log... (6 Replies)
Discussion started by: dahlia84
6 Replies
7. UNIX for Advanced & Expert Users
Hello Everyone,
I want to know how can we make the variables of one script available for the other script?
for example i have three scripts variable_availability.sh,first.sh,second.sh and a file containing variables called common
----------------------------------
cat variable_availability.sh... (2 Replies)
Discussion started by: Kesavan
2 Replies
8. Shell Programming and Scripting
Hello everyone.
I'm trying to create a conf file with variables that my other scripts will use.
I have several scripts that use the same variables, and since I don't know how to read them from an external file, i define them in each script (and then if i want to change one's value i need to... (4 Replies)
Discussion started by: moshe88
4 Replies
9. Shell Programming and Scripting
I have written a program for some data analysis. It is gettin long. I would like to restructure it so that i can have a master file which controls multiple subscripts in order to make it easier to understand.
I need to be able to define variables in the master script which are used by all three... (2 Replies)
Discussion started by: carlr
2 Replies
10. Shell Programming and Scripting
Hello, I have two bash scripts like the following:
script 1:
#!/bin/bash
var=WORLD
bash path/to/second/script/script2.bash
script 2:
#!/bin/bash
echo "HELLO $var"
I expected the output to be "HELLO WORLD" but instead, I get "HELLO". I understand that when I envoke another bash... (2 Replies)
Discussion started by: jl487
2 Replies
LEARN ABOUT CENTOS
dbd::gofer::transport::stream
DBD::Gofer::Transport::stream(3) User Contributed Perl Documentation DBD::Gofer::Transport::stream(3)
NAME
DBD::Gofer::Transport::stream - DBD::Gofer transport for stdio streaming
SYNOPSIS
DBI->connect('dbi:Gofer:transport=stream;url=ssh:username@host.example.com;dsn=dbi:...',...)
or, enable by setting the DBI_AUTOPROXY environment variable:
export DBI_AUTOPROXY='dbi:Gofer:transport=stream;url=ssh:username@host.example.com'
DESCRIPTION
Without the "url=" parameter it launches a subprocess as
perl -MDBI::Gofer::Transport::stream -e run_stdio_hex
and feeds requests into it and reads responses from it. But that's not very useful.
With a "url=ssh:username@host.example.com" parameter it uses ssh to launch the subprocess on a remote system. That's much more useful!
It gives you secure remote access to DBI databases on any system you can login to. Using ssh also gives you optional compression and many
other features (see the ssh manual for how to configure that and many other options via ~/.ssh/config file).
The actual command invoked is something like:
ssh -xq ssh:username@host.example.com bash -c $setup $run
where $run is the command shown above, and $command is
. .bash_profile 2>/dev/null || . .bash_login 2>/dev/null || . .profile 2>/dev/null; exec "$@"
which is trying (in a limited and fairly unportable way) to setup the environment (PATH, PERL5LIB etc) as it would be if you had logged in
to that system.
The ""perl"" used in the command will default to the value of $^X when not using ssh. On most systems that's the full path to the perl
that's currently executing.
PERSISTENCE
Currently gofer stream connections persist (remain connected) after all database handles have been disconnected. This makes later
connections in the same process very fast.
Currently up to 5 different gofer stream connections (based on url) can persist. If more than 5 are in the cache when a new connection is
made then the cache is cleared before adding the new connection. Simple but effective.
TO DO
Document go_perl attribute
Automatically reconnect (within reason) if there's a transport error.
Decide on default for persistent connection - on or off? limits? ttl?
AUTHOR
Tim Bunce, <http://www.tim.bunce.name>
LICENCE AND COPYRIGHT
Copyright (c) 2007, Tim Bunce, Ireland. All rights reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic.
SEE ALSO
DBD::Gofer::Transport::Base
DBD::Gofer
perl v5.16.3 2013-04-04 DBD::Gofer::Transport::stream(3)