Hello all, I am trying to pass or trying to get a variable assinged...but seemed like i am doing something wrong here....
so lets say abc.txt(spool the output out) is my file, where i am doing select * Fro mv$version inside my DB and getting some info.
Code:
[db11g]-/home/oracle/logs >cat abc.txt
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> exit
[db11g]-/home/oracle/logs >
[db11g]-/home/oracle/logs >
[db11g]-/home/oracle/logs >
[db11g]-/home/oracle/logs >cat abc.txt |grep Release|awk '{print $7}'
11.2.0.1.0
[db11g]-/home/oracle/logs >
when i cat abc.txt and grep for relase and pipe that to AWK to get 11.2.0.1.0....i get that...but when i pass that on into a vaiable...it do not work....
so when i pass DB_VERSION is my variable....and i am greppging for Relase and the piping that using AWK for my output....i do not get anything back....when i echo $DB_VERSION....it comes out blank....what am i doing wrong here ???
Code:
DB_VERSION=`sqlplus -s /nolog <<EOF | awk -F= "/^a=/ {print \$2}" |grep Release|awk '{print $7}'
set head off pagesize 0 feedback off linesize 200
whenever sqlerror exit 1
conn / as sysdba
SELECT * FROM V$VERSION;
EOF`
[db11g]-/home/oracle/logs >echo $DB_VERSION
[db11g]-/home/oracle/logs >
Last edited by Scott; 12-14-2010 at 05:02 PM..
Reason: Code tags, please...
:D could any one answer my previous question...
just looked through logg and found no such question that I had asked.. please any input would help \..
:confused: (2 Replies)
linux fedora core2
:) i am trying to write a script to clear, date, pwd and tty a linux termnal or konsole.. when I test the tty against $0 i am, getting a premission denied on the terminal that I am trying to printf to.. I tried using an awk command, test condition, an if then fi clause, but... (6 Replies)
Hi All
Plz guide me in setting ssh on local machine so that password will not be asked.
I have written a script abc.ksh on machineA to execute a script sampletest.ksh available on machineB
Conent of abc.ksh is as follows
ssh -q bali@machineB sh ClaimGenFeed/claim/sampletest.ksh... (1 Reply)
Dear All
i am working on windows plattform and i am interested in Aix so i have done IBM Aix certification, can you please suggest Aix filed is good for my carrier,currently i am working as Desktop admin
edit by bakunin: please understand that the question you raised has nothing to do with the... (1 Reply)
Hi,
Whenever I open my unix box,after providing username and password I get the following message.
Are you authorised to use this computer as detailed above? (Y)es/(N)o : y
Export: Release 10.2.0.2.0 - Production on Mon May 16 16:00:15 2011
Copyright (c) 1982, 2005, Oracle. All rights... (5 Replies)
i have tried to use a sudo command from a user level . but instead of asking for user password it asked for root password . how should i go about it .
james@opensuse:/etc> sudo ifconfig
root's password:
And i wish to ask how should i allow a list of command to be allowed to used for a... (4 Replies)
Hi,
I have an unexpected reboot happening on a Debian 9.9 server.
Yesterday 2019-12-01 at 8:30:34 a reboot happened without me or my team being aware:
/var/log/syslog:Dec 1 08:30:34 xxxx shutdown: shutting down for system reboot
/var/log/syslog:Dec 1 08:30:34 xxxx init: Switching to... (4 Replies)
Discussion started by: chebarbudo
4 Replies
LEARN ABOUT X11R4
receive
RECEIVE(1) General Commands Manual RECEIVE(1)NAME
receive - receive files from the sendfile spool
SYNOPSIS
receive [ -d ] [ -r ] [ -k ] [ -P ] [ -S ] [ -Z spool ] [ -q ] [ -ffrom ] file [...]
receive -n [ -d ] [ -r ] [ -k ] [ -P ] [ -S ] [ -Z spool ] [ -q ] file-number [...]
receive [ -s ] [ -l ] [ -L ] [ -R ] [ -ffrom ]
receive -b user[@host] [ -k ] [ -f"from" ] file [...]
receive -b user[@host] [ -k ] [ -f"from" ] -n file-number [...]
receive -b user[@host] [ -k ] -a
DESCRIPTION
receive files from the sendfile spool which has been sent to you.
If there is already a file with the same name you will be prompted for overwriting or renaming.
Allowed wildcards in file names are: * ? [abc] [^abc]
CAUTION: you have to put wildcards and other special characters in '' quotes to hide them for interpretation by your shell.
OPTIONS -n receive file number(s)
-d delete instead of receive
-a receive (or delete or bounce) all files
-r rename before receiving
-k keep files in spool after receiving
-P pipe files to stdout
-S receive only pgp-signed files
-s list files in short format
-l list files
-L list files and look inside archives, too
-R renumber files in spool
-b bounce (forward) files to another recipient
-q quiet mode: no questions asked
-fuser all actions refer only to files from this user
-Z spool
specify an alternate spool directory
EXAMPLES
receive -L
list all files in long format.
receive 'blubb*'
receive all files starting with string "blubb".
receive -daf microsoft.com
delete all files from microsoft.com sites.
receive -b framstag@bofh '*.jpg'
bounce all *.jpg-files to framstag@bofh.
FILES
/var/spool/sendfile The sendfile spool directory.
/var/spool/sendfile/$USER/log
A log of the last transfers.
/etc/sendfile.deny Users which are not allowed to receive files or messages (set by root).
SEE ALSO sendfile(1).
AUTHOR
Ulli Horlacher - framstag@rus.uni-stuttgart.de
3rd Berkeley DistributionRECEIVE(1)