09-25-2013
Thanks for your reply.
I just need to check whether i am able to log in or not.
It should log in without any error messages which start with "ORA" / "ERROR"
So script should check these keywords in login message.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi
I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this.
1. Opened a cursor to a table in DB2 databse.
2. Fetching individual rows with the help of cursor.
3. Each row has 4 fields.
I want each of the field in individual shell... (1 Reply)
Discussion started by: skyineyes
1 Replies
2. 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
3. UNIX for Dummies Questions & Answers
I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful. (3 Replies)
Discussion started by: nathanvaithi
3 Replies
4. UNIX for Advanced & Expert Users
Hi,
I have basic knowledge on how to write pl/sql code inside shell script.
I am looking for more advance thing. Is there any book for that which can just talk about how to write more advance plsql code inside shell script.
Please help
Thanks!!!!!! (1 Reply)
Discussion started by: diehard
1 Replies
5. UNIX for Dummies Questions & Answers
I need to compare a R$Timestamp field sql within a Unix Shell Script.
In straight SQL the following code works fine:
Table Name: LL_UNIT_TRANSACTION UT
Field: R$Timestamp
Where TRUNC(UT.R$Timestamp) >= TRUNC(SYSDATE -7)
the following returns no data within the Unix Shell Script... (2 Replies)
Discussion started by: Dapconsult
2 Replies
6. Shell Programming and Scripting
Hi all
I am writing a shell script which will run a select query from a table . If the ouput is not 500 - then send a email to the team saying there is a error . But i am not sure how to redirect this output of the select query to the log file -
#!/bin/ksh
sqlplus /nolog
conect... (1 Reply)
Discussion started by: honey26
1 Replies
7. Shell Programming and Scripting
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
8. Shell Programming and Scripting
How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX? :confused: (1 Reply)
Discussion started by: 24ajay
1 Replies
9. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
10. Shell Programming and Scripting
I know this question is out there in many forums, but I tried all the combinations in vain.
I'm basically trying to call a sql script from a shell script.
Below is my sql script (plsql.sql)
DELCARE
v_empno NUMBER := '&empno';
BEGIN
select ename,sal from emp where empno = v_empno;... (3 Replies)
Discussion started by: FName_LName
3 Replies
strerr(1M) strerr(1M)
NAME
strerr - receive error messages from the STREAMS log driver
SYNOPSIS
sys_admin_mail_name] logdir]
DESCRIPTION
receives error messages from the STREAMS log driver (strlog(7)) for addition to the STREAMS error log files mm-dd) in the STREAMS error
logger directory by default). When first called, creates the log file This is a daily log file, where mm indicates the month and dd indi-
cates the day of the logged messages. then appends error messages to the log file as they are received from the STREAMS log driver.
STREAMS error log messages have the following format:
seq time tick pri ind mod sub text
Components are interpreted as follows:
seq Error event sequence number.
time Time the message was sent expressed in hh:mm:ss.
tick Time the message was sent expressed in machine ticks since the last boot.
pri Error priority level as defined by the STREAMS driver or module that originates the messages.
ind Can be any combination of the following three message indicators:
The message has also been saved in the trace log.
The message signaled a fatal error.
The message has also been mailed to the system administrator.
mod Module identification number of the error message source.
sub Subidentification number of the error message source.
text Error message text.
runs continuously until terminated by the user.
Options
recognizes the following options and command-line arguments:
Specify the user's mail name for sending mail messages.
Mail is sent to the system administrator by default.
Specify the directory to contain the error log file.
Default is
WARNINGS
Only one process can open the STREAMS log driver at a time. This restriction is intended to maximize performance.
The STREAMS error logging mechanism works best when it is not overused. can degrade STREAMS performance by affecting the response,
throughput, and other behaviors of the drivers and modules that invoke it. also fails to capture messages if drivers and modules generate
messages at a higher rate than its optimum read rate. If there are missing sequence numbers among the messages in a log file, messages
have been lost.
FILES
NLS catalog for
error log file or files on which operates
SEE ALSO
strace(1M), strlog(7).
strerr(1M)