You are missing something in your environment varaibles, this will show what the problem is:
Read the log for the error. Why did you use set `command` if there is nothing else in the script? That is, instead of just a here doc. Plus the syntax is "set - `command` ", if I understand what you are doing.
Hi ,
i have created an .sh file that has the following code:
#!/bin/ksh
sqlplus -s p1istuat/p1istuat@CWS_IST6 @Procedure_Execute.sql &
sqlplus -s p1istuat/p1istuat@CWS_IST6 << EOF
exit
EOF
The mentioned Procedure_Execute.sql file inside has the following code:
exec TEST;
... (5 Replies)
Hi Guys,
I am trying to tun a oracle proedure throgh unix shell script but it is not running i dont know why ? i have tested this procedure in sqlplus and it was working fine.
can you see the script and sql file and let me know where is my mistake.
script:bm_chart_table_loading.sh
... (3 Replies)
Hi All.
I created a cronjob entry and for some reason it is not executing. The script that it is suppose to call sends me an email when it is done. When I run the job manually it executes fine. This how my cron entry looks:
00 14 * * * /home/oracle/scripts/bin/free_space/free_space.sh 2>$1... (5 Replies)
Hello,
I created a sql file to create a Procedure, and it was successfully created.
I created a sql file to execute the procedure, and it did without any errors, but i dont see the data been updated.
The Execute procedure.sql script is:
BEGIN
set serveroutput on size 1000000
execute... (5 Replies)
Hi,
I want to have a automted script to exceute 20 procedures one by one.
Suppose below is one procedure once it get executed script will write
"PL/SQL procedure successfully completed." to a log
for ex-
exec dbms_stats.gather_table_stats();
Now later procedure starts executing... (1 Reply)
HI All ,
I am new to oracle procedures. Please help me for the approach to satify the requirement.
I need to create procedures. with parameters passed ( say report,type,identities,country )
It should also call sql query within the procedures and passed parameters should be used in where clause... (2 Replies)
Hi all,
My oracle procedure returns more than one value.
i need to get one value at a time upto ending value ina shell script.
Please help me..... (9 Replies)
hi all,
i have a unix script where i am calling a database procedure from it. while executing the procedure i am getting an error:
but when i tried to call the same procedure manually then it ran successfully, i goggled this issue and found timezone.dat file missing at... (0 Replies)
below code is not executing the stored procedure,not sure what the issue.Even sqllog is blank.please help me its very urgent.
sqlplus -s $connect_str@$DB_ORACLE_SID >> ${SQL_LOG_FILE} << EOF
set serverout on
set feed off
set head off
set pages 0
set colsep ,
set tab off
set lin 150... (3 Replies)
Discussion started by: katakamvivek
3 Replies
LEARN ABOUT OSX
opiesu
OPIESU(1) General Commands Manual OPIESU(1)NAME
opiesu - Replacement su(1) program that uses OPIE challenges
SYNOPSIS
opiesu [ -f ] [ -c ] [ user_name ]
DESCRIPTION
opiesu is a replacement for the su(1) program that issues OPIE challenges and uses OPIE responses. It is downward compatible with keysu(1)
from the Bellcore S/Key Version 1 distribution and the su(1) program from the 4.3BSD Net/2 distribution.
OPTIONS -f If the invoked shell is csh(1), this option prevents it from reading the ``.cshrc'' file. (The [f] option may be passed as a shell
argument after the login name, so this option is redundant and obsolescent.)
-c Set console mode where the user is expected to have secure access to the system. In console mode, you will be asked to input your
password directly instead of having to use an OPIE calculator. If you do not have secure access to the system (i.e., you are not on
the system's console), you are volunteering your password to attackers by using this mode.
user_name
The name of the user to become. The default is root.
EXAMPLE
wintermute$ opiesu kebe
otp-md5 498 wi910502
(OTP response required)
kebe's password: (echo on)
kebe's password: RARE GLEN HUGH BOYD NECK MOLL
wintermute#
FILES
/etc/opiekeys database of information for OPIE system.
SEE ALSO su(1), opie(4), opiekey(1), opieinfo(1), opiesu(1), opielogin(1), opieftpd(8), opiekeys(5), opieaccess(5)AUTHOR
Bellcore's S/Key was written by Phil Karn, Neil M. Haller, and John S. Walden of Bellcore. OPIE was created at NRL by Randall Atkinson, Dan
McDonald, and Craig Metz.
S/Key is a trademark of Bell Communications Research (Bellcore).
CONTACT
OPIE is discussed on the Bellcore "S/Key Users" mailing list. To join, send an email request to:
skey-users-request@thumper.bellcore.com
7th Edition January 10, 1995 OPIESU(1)