Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Issue with running multiple commands withing su command
Top Forums Shell Programming and Scripting Issue with running multiple commands withing su command Post 302894330 by Chubler_XL on Monday 24th of March 2014 11:16:34 PM
Old 03-25-2014
The problem I think is that some of your $ variables are being expanded before the su command is run, try escaping them like this, I don't really like $11 either, can I suggest ${1}1 for more readability:

Code:
# cat test3.sh
su - oracle -c "export ORACLE_SID=${1}1;export ORACLE_HOME=/oracle/product/oracle/11.2.0;export PATH=\$PATH:\$ORACLE_HOME/bin
sqlplus -s / as sysdba <<EOF
spool /home/oracle/SCRIPTS/Clone/mytestSQL.log
set echo off
set heading off

select sysdate from dual;
shutdown immediate;
select name, open_mode from v$database;
exit
EOF
ps -ef | grep pmon|grep -v source ; srvctl start database -d $1"
#

This User Gave Thanks to Chubler_XL For This Post:
omega3
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

running a simple script file with multiple commands

I'm trying to run a script file with multiple commands that I would normally type into the command line. The commands are: #!/bin/bash diff Test1.o0 /usr3/ronelso4/Desktop/verificationKPC/Test1.o0 > differences2 diff Test1a.o0 /usr3/ronelso4/Desktop/verificationKPC/Test1a.o0 >> differences2... (1 Reply)
Discussion started by: knelson
1 Replies

2. Shell Programming and Scripting

Running multiple unix commands in a single script

Hi, I would like to write a script with include more than 6 unix commands. my script like below: echo " script started" ls -ld bdf | grep "rama" tail -10 log.txt ... .. ... now, i want to run above unix commands one by one. example: first the ls -ld command will be... (3 Replies)
Discussion started by: koti_rama
3 Replies

3. Shell Programming and Scripting

awk splits file in to multiple - how to get filenames in variables withing ksh?

Hi all, I'm using awk in a .ksh script to split one file by line prefix into different files (up to 4). The files are named after the prefix in the line, and a sequence no. Is there any way to get the filenames in to variables too? I need _ftpfile1, _ftpfile2, _ftpfile3 and _ftpfile4 which are... (2 Replies)
Discussion started by: spidermike
2 Replies

4. UNIX and Linux Applications

Running oracle commands Directly from Command Line

In mysql, I can get what I want from a database without having to log into mysql. works great for me and it is perfect. now, i want to be able to do the same in oracle but I dont know how to. For example, if i want to retrieve information from the mysql database from the command line, i issue... (4 Replies)
Discussion started by: SkySmart
4 Replies

5. Programming

Running Multiple Unix commands in qx

Hi All, Is there anything wrong with below syntax? qx {perldoc -v ModuleName.pm | grep -i Description } BTW, this question is related to Perl. Thanks. (3 Replies)
Discussion started by: jal_capri
3 Replies

6. Shell Programming and Scripting

Running multiple commands stored as a semi-colon separated string

Hi, Is there a way in Korn Shell that I can run multiple commands stored as a semi-colon separated string, e.g., # vs="echo a; echo b;" # $vs a; echo b; I want to be able to store commands in a variable, then run all of it once and pipe the whole output to another program without using... (2 Replies)
Discussion started by: svhyd
2 Replies

7. Shell Programming and Scripting

Issue with running commands from shell script

I'm trying to copy files from a remote windows server to Unix server. I was successfully able to copy files from windows server using command prompt but when I run these commands from a script it's not working as expected. commands used: sftp user@remoteserver.com lcd local_dir cd... (3 Replies)
Discussion started by: naresh7590
3 Replies

8. Shell Programming and Scripting

Issue with quotes when running SQL command from within su -c

RHEL 6.2/Bash shell root user will be executing the below script. It switches to oracle user logs in using sqlplus and tries to run the below UPDATE statement. All the commands after su -c are enclosed in a single quote delimited by semicolon. The execution has failed because the quotes... (3 Replies)
Discussion started by: omega3
3 Replies

9. Shell Programming and Scripting

Perl script running multiple commands at once

Hi All, I have put a perl script together to go and collect some information from multiple nodes/endpoints. The script works absolutly fine however I want to make it quicker. You will see in the below that my script calls an expect script called ssh_run_cmd2.exp followed by the IP of... (7 Replies)
Discussion started by: mutley2202
7 Replies

10. Shell Programming and Scripting

Check status of long running multiple curl commands in shell script

I am working on script. it reads a file which contains multiple lines Ex; curl --write-out %{http_code} --silent --output /dev/null http://hostname:port/input=1 curl --write-out %{http_code} --silent --output /dev/null http://hostname:port/input=2 curl --write-out %{http_code} --silent ... (2 Replies)
Discussion started by: oraclermanpt
2 Replies

LEARN ABOUT BSD

ching

CHING(6)							   Games Manual 							  CHING(6)

NAME

       ching - the book of changes and other cookies

SYNOPSIS

       /usr/games/ching [ hexagram ]

DESCRIPTION

       The I Ching or Book of Changes is an ancient Chinese oracle that has been in use for centuries as a source of wisdom and advice.

       The  text  of  the  oracle  (as it is sometimes known) consists of sixty-four hexagrams, each symbolized by a particular arrangement of six
       straight (---) and broken (- -) lines.  These lines have values ranging from six through nine, with the even values indicating  the  broken
       lines.

       Each  hexagram  consists  of  two major sections.  The Judgement relates specifically to the matter at hand (E.g., "It furthers one to have
       somewhere to go.") while the Image describes the general attributes of the hexagram and how they apply to one's own life ("Thus	the  supe-
       rior man makes himself strong and untiring.").

       When  any  of  the lines have the values six or nine, they are moving lines; for each there is an appended judgement which becomes signifi-
       cant.  Furthermore, the moving lines are inherently unstable and change into their opposites; a second hexagram	(and  thus  an	additional
       judgement) is formed.

       Normally,  one  consults  the  oracle  by  fixing  the  desired	question  firmly  in  mind and then casting a set of changes (lines) using
       yarrow-stalks or tossed coins.  The resulting hexagram will be the answer to the question.

       Using an algorithm suggested by S. C. Johnson, the UNIX oracle simply reads a question from the standard input (up to an  EOF)  and  hashes
       the  individual	characters in combination with the time of day, process id and any other magic numbers which happen to be lying around the
       system.	The resulting value is used as the seed of a random number generator which drives a simulated coin-toss divination.  The answer is
       then piped through nroff for formatting and will appear on the standard output.

       For  those  who wish to remain steadfast in the old traditions, the oracle will also accept the results of a personal divination using, for
       example, coins.	To do this, cast the change and then type the resulting line values as an argument.

       The impatient modern may prefer to settle for Chinese cookies; try fortune(6).

SEE ALSO

       It furthers one to see the great man.

DIAGNOSTICS

       The great prince issues commands,
       Founds states, vests families with fiefs.
       Inferior people should not be employed.

BUGS

       Waiting in the mud
       Brings about the arrival of the enemy.

       If one is not extremely careful,
       Somebody may come up from behind and strike him.
       Misfortune.

7th Edition							   May 20, 1985 							  CHING(6)
All times are GMT -4. The time now is 08:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy