11-15-2010
Scottn & Jsmitstl,
Thanks a bunch on your responses and Im thankful for those.
Scottn, You are right in that this is oracle that we are talkin about bu you lost me there on the following and Im not sure as what you mean here.
In your script source your .profile, set ORAENV_ASK to NO, set your ORACLE_SID to that of the database you're planning to connect, and then source "oraenv".
Code:
$ cat my_script
. ~/.profile
ORAENV_ASK=NO
ORAENV=mydb
. oraenv
Now, Im reading something about the Cron and I will certainly need some more time for what you have mentioned in here.
Thanks,
Lee.
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi gurus,
Being a newbie not sure whether iam asking the right question?
can we use oracle commands in unix for ex: to read a count on a table.
if so, what needs to be configured and etc..
any kind of help is appreciated.
Thanks
sish (6 Replies)
Discussion started by: sish78
6 Replies
2. Shell Programming and Scripting
hi,
plz let me know one example in using sql command in shell script
thanks inadvance
-bali. (1 Reply)
Discussion started by: balireddy_77
1 Replies
3. Shell Programming and Scripting
Hi ,
Daily I sneding report to client about the status of State 2 jobs in Control M .
I would like to schedule it via cron . I am using teh following command :
sudo su - <control M server Name>
then reach to the control M server
then run
#isql
<It ask for the password >
... (1 Reply)
Discussion started by: chandancsc
1 Replies
4. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
5. Shell Programming and Scripting
Hi,
I have a directory /home/datasets/ which contains a bunch (720) of subdirectories called hour_1/ hour_2/ etc..etc.. in each of these there is a single text file called (hour_1.txt in hour_1/ , hour_2.txt for hour_2/ etc..etc..) and i would like to do some text processing in them.
Each of... (20 Replies)
Discussion started by: amarn
20 Replies
6. Shell Programming and Scripting
Dear All,
I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File.
The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files.
Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies
7. UNIX for Advanced & Expert Users
Hello,
I'm attempting to open multiple xterms and run a command as an SAP user via sudo using PSSH. So far, I'm able to run PSSH to a file of servers with no check for keys, open every xterm in to the servers in the file list, and SUDO to the SAP(ADM) user, but it won't do anything else... (11 Replies)
Discussion started by: icemanj
11 Replies
8. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT MOJAVE
aa-autodep
AA-AUTODEP(8) AppArmor AA-AUTODEP(8)
NAME
aa-autodep - guess basic AppArmor profile requirements
SYNOPSIS
aa-autodep <executable> [<executable> ...]
DESCRIPTION
aa-autodep is used to generate a minimal AppArmor profile for a set of executables. This program will generate a profile for binary
executable as well as interpreted script programs. At a minimum aa-autodep will provide a base profile containing a base include directive
which includes basic profile entries needed by most programs. The profile is generated by recursively calling ldd(1) on the executables
listed on the command line.
BUGS
This program does not perform full static analysis of executables, so the profiles generated are necessarily incomplete. If you find any
bugs, please report them at <http://https://bugs.launchpad.net/apparmor/+filebug>.
SEE ALSO
apparmor(7), apparmor.d(5), aa-complain(1), aa-enforce(1), aa-disable(1), aa_change_hat(2), and <http://wiki.apparmor.net>.
AppArmor 2.7.103 2012-06-28 AA-AUTODEP(8)