06-17-2008
Hi Kamalesh
Kamalesh,
thanks for noticing that error.
I tried the same way as you told but even then I am getting the same error.
./hema.sh[3]: Filename: not found
./hema.sh[4]: Sqlfile: not found
ld.so.1: sqlplus: fatal: libclntsh.so.9.0: open failed: No such file or directory
./hema.sh[5]: 18041 Killed
Thanks,
Hema.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to pass some of the variables in my shell scripts to the sqlplus call and use them as parameters.
For example, I would like to replace the 'SAS', and '20050612' with $var1 and $var2, respectively, how can I do that?
--------------------------------------------------------... (1 Reply)
Discussion started by: Jtrinh
1 Replies
2. Shell Programming and Scripting
if
then
# mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com
echo "FILE does not exist"
exit 1
fi
echo "FILE EXIST"
size=-1
set $(du /export/home/oracle/nas/scott21.dmp.gz)
while
do
echo "Inside the loop"
size=$1
set $(du... (1 Reply)
Discussion started by: sanora600
1 Replies
3. Shell Programming and Scripting
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Discussion started by: praka
6 Replies
4. Shell Programming and Scripting
Hi,
I am using SYBASE database. in my script i am connecting to DB via using isql.
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL
i am taking a ABC.sql file to use the queries written in it and storing the output in... (3 Replies)
Discussion started by: dazdseg
3 Replies
5. UNIX and Linux Applications
using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks
any help would be appreciated
:wall: (1 Reply)
Discussion started by: TRS80
1 Replies
6. Shell Programming and Scripting
Gurus,
The issue I'm having is that my Shell won't accept SQL parameters properly......
Here's they way I'm running it....
applmgr@ga006hds
=> sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR'
The process just hangs not submitting the SQL job...
... (3 Replies)
Discussion started by: WhoDatWhoDer
3 Replies
7. Shell Programming and Scripting
echo "set echo off"; echo "set feedback off"; echo "set linesize 4000"; echo " set pagesize 0"; echo " set sqlprompt ''"; echo " set trimspool on";
Select statement is mentioned below
echo "select res.ti_book_no from disney_ticket_history res where res.ti_status =${STATUS} and... (7 Replies)
Discussion started by: aroragaurav.84
7 Replies
8. Programming
i have file in which i have employee id are there and every time number of employee id are different in file means number of count of employee id in file are every time different.
343535435
365765767
343534543
343543543
i want to pass this file to sqlplus
and sql command is
... (7 Replies)
Discussion started by: pallvi_mahajan
7 Replies
9. Shell Programming and Scripting
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
Discussion started by: reddy298599
4 Replies
10. UNIX for Beginners Questions & Answers
hello friend good morning
I have a problem, how can I take the value that the PROCEDURE returns to me in the variable "CodError", when the connection to the bbdd is closed I lose the value and I need it in the shell
#AIX
cat <<EOF | sqlplus -s ${ORA_LOGIN}/${ORA_PASSWORD} > $logftmp
set... (6 Replies)
Discussion started by: tricampeon81
6 Replies
LEARN ABOUT LINUX
wrap_log_reader
wrap_log_reader(3erl) Erlang Module Definition wrap_log_reader(3erl)
NAME
wrap_log_reader - A function to read internally formatted wrap disk logs
DESCRIPTION
wrap_log_reader is a function to read internally formatted wrap disk logs, refer to disk_log(3erl). wrap_log_reader does not interfere with
disk_log activities; there is however a known bug in this version of the wrap_log_reader , see chapter bugs below.
A wrap disk log file consists of several files, called index files. A log file can be opened and closed. It is also possible to open just
one index file separately. If an non-existent or a non-internally formatted file is opened, an error message is returned. If the file is
corrupt, no attempt to repair it will be done but an error message is returned.
If a log is configured to be distributed, there is a possibility that all items are not loggen on all nodes. wrap_log_reader does only read
the log on the called node, it is entirely up to the user to be sure that all items are read.
EXPORTS
chunk(Continuation)
chunk(Continuation, N) -> {Continuation2, Terms} | {Continuation2, Terms, Badbytes} | {Continuation2, eof} | {error, Reason}
Types Continuation = continuation()
N = int() > 0 | infinity
Continuation2 = continuation()
Terms= [term()]
Badbytes = integer()
This function makes it possible to efficiently read the terms which have been appended to a log. It minimises disk I/O by reading
large 8K chunks from the file.
The first time chunk is called an initial continuation returned from the open/1 , open/2 must be provided.
When chunk/3 is called, N controls the maximum number of terms that are read from the log in each chunk. Default is infinity , which
means that all the terms contained in the 8K chunk are read. If less than N terms are returned, this does not necessarily mean that
end of file is reached.
The chunk function returns a tuple {Continuation2, Terms} , where Terms is a list of terms found in the log. Continuation2 is yet
another continuation which must be passed on into any subsequent calls to chunk . With a series of calls to chunk it is then possi-
ble to extract all terms from a log.
The chunk function returns a tuple {Continuation2, Terms, Badbytes} if the log is opened in read only mode and the read chunk is
corrupt. Badbytes indicates the number of non-Erlang terms found in the chunk. Note also that the log is not repaired.
chunk returns {Continuation2, eof} when the end of the log is reached, and {error, Reason} if an error occurs.
The returned continuation may or may not be valid in the next call to chunk . This is because the log may wrap and delete the file
into which the continuation points. To make sure this does not happen, the log can be blocked during the search.
close(Continuation) -> ok
Types Continuation = continuation()
This function closes a log file properly.
open(Filename) -> OpenRet
open(Filename, N) -> OpenRet
Types File = string() | atom()
N = integer()
OpenRet = {ok, Continuation} | {error, Reason}
Continuation = continuation()
Filename specifies the name of the file which is to be read.
N specifies the index of the file which is to be read. If N is omitted the whole wrap log file will be read; if it is specified only
the specified index file will be read.
The open function returns {ok, Continuation} if the log/index file was successfully opened. The Continuation is to be used when
chunking or closing the file.
The function returns {error, Reason} for all errors.
BUGS
This version of the wrap_log_reader does not detect if the disk_log wraps to a new index file between a wrap_log_reader:open and the first
wrap_log_reader:chunk . In this case the chuck will actually read the last logged items in the log file, because the opened index file was
truncated by the disk_log .
SEE ALSO
disk_log(3erl)
Ericsson AB kernel 2.14.3 wrap_log_reader(3erl)