I have the following code in my shell script.
. /apps/oracli/xxxxx/xxxx/oraEnv.9.2.0
sqlplus -s $DB_USER/$DB_PWD@$DB_NAME > xx.html <<EOF
I am passing DBuser and DBname from a config file and the password from user.
Config File :
export DB_USER=xxx;
export DB_NAME=xxx;
I am getting... (1 Reply)
Hello Gurus,
I've been tasked with solving a problem at my new job and I'm stumped. We've got a script that dynamically builds an oracle export parameter files and then runs export from the shell. it runs fine when using the shell, but will NOT run (fails in one spot everytime) when entered... (1 Reply)
Hi Folks,
Could you please suggest me how to run a shell script on a solaris env without using crontab. I am actually trying to write a shell script which will grep "WORD" in the logfile andd sends a email.Thanks in advance.
Thanks
Sandeep. (3 Replies)
Hi all,
I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know
1. how to connect to the data base(oracle) using shell script
2. how to retrieve data... (8 Replies)
hello
how to run shell script to excute oracle queries on remote db ?
i have tried as following
sqlplus -s user/password@remote_server "select query;"
but not working
also this one
sqlplus -s user/password@remote_server `select query;`
not working :(
i add this line to run another... (4 Replies)
Hi,
I am trying to connect to oracle database (9.2.0.7.0) through Sun solaris.
But I am unable to do so.
The content of my script is as follows:
Shell Sript:
RESULT=`$ORACLE_HOME/bin/sqlplus schema/'pwd'@db << EOF
set echo on;
set feedback on;
@/home/count/qry.sql`
echo... (10 Replies)
Hi all,
I am a newbie.....am jus trying to connect to oracle thro a script, but not thro giving the username/password@server_name directly like
`$ORACLE_HOME/bin/sqlplus username/password@server_name
In the above line, once it is connected to Oracle, it shud ask me the username and password... (4 Replies)
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies
LEARN ABOUT DEBIAN
bcrontab
bcrontab(1) General Commands Manual bcrontab(1)NAME
bcrontab - Manage users crontab files
SYNOPSIS
bcrontab [ -u user ] file
bcrontab [ -u user ] { -l | -r | -e }
DESCRIPTION
bcrontab interfaces with the bcron-spool daemon to manage crontab files in the privileged spool directory.
OPTIONS -u user
Tell bcron-spool that we are acting on behalf of the named user. bcron-spool will only accept the username if bcrontab is running
as either root or the same user ID as the named user.
-l List the cronab crontab to standard output.
-r Remove the user's crontab.
-e Edit the current crontab.
ENVIRONMENT
VISUAL If this is set, it is used as the editor to invoke to edit a crontab.
EDITOR If $VISUAL is not set and this is, it is used as the editor to invoke to edit a crontab. If neither are set, /bin/vi is used.
BCRON_SOCKET
The path to the named socket used to communicate with bcron-spool. Defaults to /var/run/bcron-spool.
LOGNAME
USER These two variables are used, in order, to determine the user name invoking the program. One must be set if the -u option is not
used.
FILES
bcrontab tries to writes a temporary file into the current directory, and then into /tmp if that fails, in order to edit the current
crontab.
SEE ALSO bcron-spool(8), crontab(5)AUTHOR
Bruce Guenter <bruceg@em.ca>
bcrontab(1)