Depending on how your PATH environment variable is set, you might need ./test.sh instead of test.sh. Either way, you need to have execute permissions set on test.sh as set by:
Code:
chmod +x test.sh
If you're going to run it from cron, you'll need to specify an absolute pathname to test.sh and every file referenced in test.sh (whether it is a data file or the name of a utility) will need to use an absolute pathname unless you use something to set up the environment of the script to be run in the directory containing your data files and has PATH set appropriately for all of the commands being invoked by your script.
Regarding running SQLPlus via su (which might explain the "does nothing" element of your question), here's an example, substituting values as necessary!:
Code:
[root@ora11 tmp]# cat testScript
su - oracle -c '
ORAENV_ASK=NO
ORACLE_SID=DB1
. oraenv
sqlplus / as sysdba << !
select 33 from dual;
!
'
[root@ora11 tmp]# ./testScript
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 21 01:26:45 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
33
----------
33
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
You likely don't have to use su at all, if you're root, and this won't work if you're not root.
i am able to execute and run with cronjob after declaring my Oracle HOME
and add cronjob as below :
Code:
30 05 * * * nohup /tmp/a.sh >> a.txt &
but no log file generated. please advise
When you use cron to run a job, cron will run it in the background on its own and the cron job will not be stopped whether you are logged in when the script starts or not, whether you log out while the script is running or not, and (in all likelihood) will not run in the directory where you issued the job for cron to run.
Hi,
I am totally a newbie to any programming languages and I just started an entry level job in an IT company. One of my recent tasks is to create a script that is able to show the log file of linux service (i.e. ntpd service)
lets say, if I run my script ./test.sh, the output should be... (3 Replies)
Dear Friends,
Please help me on this
my script name is send.csh
In this i have written the statement like this
set args = ( city state country price )
I want to pass this array to another c shell called receiver.csh. and i want to use it in this c shell
or
how to pass to... (2 Replies)
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist.
diff=$1$2.diff
id=$2 new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk... (2 Replies)
Hi All,
I have new for shell scripting.
Problem : I have one scrip at serv1 and path of server is /apps/dev/provimage/scripts and script name:extract_ancillary.bat.
I need to call this script at server2(my working server) and execute at server2 .
Please let me know how to build the... (5 Replies)
Hi,
I basically have 2 shell scripts.
One is a shell script will get the variable value from the user. The variable is nothing but the IP of the remote system.
Another shell script is a script that does the job of connecting to the remote system using ssh. This uses a expect utility in turn.
... (2 Replies)
i want use ssh on the host01 to execute autoexec.sh on the host02 like following :
host01> ssh host02 autoexec.sh
autoexec.sh include nohup command like follwing :
nohup /home/jack/deletedata.sh &
after i execute ssh host02 autoexec.sh one the host01. i can't found deletedata.sh... (1 Reply)
Hi,
I have an HTML form through which I get some text as input. i need to run a shell script say script.sh inside a perl-cgi script named main_cgi.sh on the form input.
I want to write the contents of the form in a file and then perform some command line operations like grep, cat on the text... (2 Replies)
Hi Perl/UNIX experts,
I have a problem in running a shell script from my perl script (auto.pl).
I run the perl script using
perl auto.pl
from the shell prompt
The shell script picks the files in "input" folder and procesess it.
The shell script blue.sh has this code.
export... (16 Replies)
