03-14-2001
From UNIX shell, if you would like to connect to sqlplus
and do some processing, you can go about this way by enclosing the following in a shell script
sqlplus -s user_id/passwd << end-it
set pages 0 feedback off echo off
--run the procedure you want to
@proc_name;
exit;
end-it
Run the above script at the shell command prompt
[Edited by seshagiri on 03-14-2001 at 11:21 AM]
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
So I have this script titled "testing.sh"
#!/bin/ksh
#PROGRAM INITIALIZATION
HomeDir=/home/sap/gl/ftp
server=testftp01
userid=ftp_uatollmsgbus
password="f&p53715"
MSGLOG=${HomeDir}/msglog.txt
FTPLogTmp=${HomeDir}/testing.tmp
FTPLogFile=${HomeDir}/testing.log... (1 Reply)
Discussion started by: kdyzsa
1 Replies
2. UNIX for Dummies Questions & Answers
ok, there's a script i'm working on written in shell programming. #!/bin/sh
this script is written to spit out the contents of certain variables inside of it so the output looks something like this:
server01=89 server02=69 server03=89 server04=76
now, when i run this script from the... (4 Replies)
Discussion started by: SkySmart
4 Replies
3. Shell Programming and Scripting
I've written a small script to replace certain words in all the the files in a directory.
#!/bin/sh
#Get list of files to be edited
file_list=`ls -p`
for i in $file_list
do
echo "Processing $i"
alteredi=`echo "$i" | sed -e 's/\//d/'`
if
then
if
then
#actual altering (2 Replies)
Discussion started by: Peetrus
2 Replies
4. Shell Programming and Scripting
Hello here's the first line's of the code
that works perfect on command line
but not as a crontab job ???
crontab:
15 * * * * /root/scripts/checkclamd_mem.shscript:
#!/bin/bash
# Checks Memory of the Clamav-daemon and it's .pid file
# restarts if over the LIMIT. Starts if pid file not... (3 Replies)
Discussion started by: nls mchn
3 Replies
5. Shell Programming and Scripting
Hi Guys,
I have this script which is being called from another script,
sh +x SCRIPTNAME.
Now this script is failing saying the source file is missing. But i was able to see the source file was present. It was renamed and but somehow the source file is removed. There is no remove command in the... (1 Reply)
Discussion started by: mac4rfree
1 Replies
6. Shell Programming and Scripting
Hello,
I am getting an infinite loop from a script in Linux.
Here is the last version of the script in question. As you can see I tried to define everything properly:
#!/bin/ksh
# Script to loop over a series of dates
set -ex
typeset -i start_date=20090701
typeset -i... (2 Replies)
Discussion started by: stavros
2 Replies
7. AIX
here is the one of the scripts:
script1.kshfunction haha
{
print "calling haha"
exit
}
script2.ksh. script1.ksh
haha | tee -a /dev/null
print "i am script 2"
after launching the script2, the result:
---------------------------------------------
calling haha
i am script 2
... (6 Replies)
Discussion started by: getter
6 Replies
8. Shell Programming and Scripting
sqlLogftp_mov=$LOGDIR/logftp_mov_$mydate.log
sqlplus -s $ORAUSER << EOF > $sqlLogftp_mov
SET SERVEROUT ON
@/$SCRIPTDIR/rep_comm_ext_tbl_load.sql
EOF
retorno=0
cnt=`grep -q 'ORA-' $sqlLogftp_mov | wc -l`
if ;
then
retorno=1
echo 'Failure'
sendEmailFalha
exit 1
fi
if ;
then
echo... (8 Replies)
Discussion started by: shyamaladevi
8 Replies
9. Shell Programming and Scripting
This script is giving weird output
#!/bin/bash
NETPATH=(`/bin/traceroute -n 4.2.2.2 | awk '{print $2}'`)
for i in "${NETPATH}"
do
echo $i
done
The output:
to
11.11.11.1
1.1.1.1
99.111.208.2
traceroute_test.sh
traceroute_test.sh (7 Replies)
Discussion started by: thumbs
7 Replies
10. Shell Programming and Scripting
Hi,
So I have a very simple script which loops over 5 times and prints the iterator value.
#!/bin/sh
START=1
END=5
for i in $(eval echo "{$START..$END}")
do
echo "$i"
done
If I save this script in a .sh file and run it in the terminal, the output I get is
{1..5} (4 Replies)
Discussion started by: jamie_123
4 Replies
CHSH(1) User Commands CHSH(1)
NAME
chsh - change login shell
SYNOPSIS
chsh [options] [LOGIN]
DESCRIPTION
The chsh command changes the user login shell. This determines the name of the user's initial login command. A normal user may only change
the login shell for her own account; the superuser may change the login shell for any account.
OPTIONS
The options which apply to the chsh command are:
-h, --help
Display help message and exit.
-R, --root CHROOT_DIR
Apply changes in the CHROOT_DIR directory and use the configuration files from the CHROOT_DIR directory.
-s, --shell SHELL
The name of the user's new login shell. Setting this field to blank causes the system to select the default login shell.
If the -s option is not selected, chsh operates in an interactive fashion, prompting the user with the current login shell. Enter the new
value to change the shell, or leave the line blank to use the current one. The current shell is displayed between a pair of [ ] marks.
NOTE
The only restriction placed on the login shell is that the command name must be listed in /etc/shells, unless the invoker is the superuser,
and then any value may be added. An account with a restricted login shell may not change her login shell. For this reason, placing /bin/rsh
in /etc/shells is discouraged since accidentally changing to a restricted shell would prevent the user from ever changing her login shell
back to its original value.
FILES
/etc/passwd
User account information.
/etc/shells
List of valid login shells.
/etc/login.defs
Shadow password suite configuration.
SEE ALSO
chfn(1), login.defs(5), passwd(5).
shadow-utils 4.5 01/25/2018 CHSH(1)