Query a oracle DB when fail put in in the error log Post: 302493738

Sponsored Content

Top Forums Shell Programming and Scripting Query a oracle DB when fail put in in the error log Post 302493738 by durden_tyler on Thursday 3rd of February 2011 02:29:57 PM

02-03-2011

Registered User

Quote:

Originally Posted by Roadster

That could work.

But the output of the statement is
1
----------------------
1

so when I do a grep on the 1 it will also write to the logfile when the date in that file is the date and time are 10:11:00

Well then don't grep for "1" i.e. do not grep for success; grep for failure.

If there is a "^ORA-" pattern in the outfile, then you are certain that something went wrong.

If not, then everything should've worked fine (note: should've, not must've).

If you do want to test for success as well as failure explicitly, then you may want to provide a column alias like so -

Code:

select 1 my_test_value from dual;

or maybe just fetch a literal string from Oracle -

Code:

select 'my_test_string' x from dual;

and then grep for "my_test_string" otherwise grep for "^ORA-".

tyler_durden

durden_tyler

View Public Profile for durden_tyler

Find all posts by durden_tyler

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

oracle process query !

This query is For HP-UX 11i server. I have certain oracle process that are running on my system as below :- rotmgr 3986 1 0 07:49:33 ? 0:00 oracleedjlive (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) rotmgr 26356 1 0 08:14:32 ? 0:00 oracleedjlive...

2. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the...

3. Shell Programming and Scripting

How to put db2 query result into an array in shell script?

Hello, Can someone please advise me how to put the db2 query reult into an array? For example, the query reults are: string A string B string C Then how do I put them into array=string A array=string B ...

4. Programming

Oracle Database Query

How can i modify the below to search for the things i'm looking for during a certain time frame? select Node, NodeAlias, Summary, Tally, AlertKey, AlertGroup, Manager, Agent from mrtg_alerts where LastOccurrence > '5-Dec-2010' order by Manager desc; In this particular case, this query is...

5. Shell Programming and Scripting

Read value from user and use it in Oracle SQL query

Guys can anyone just tell me whether i can pass a value(from UNIX SCRIPT) as an ARGUMENT in Oracle Query? e.g. echo "enter value" read value insert into tablename where col=$value /*something like this*/

6. Shell Programming and Scripting

PROBLEM WITH ORACLE QUERY IN UNIX SCRIPT

hi Guys, i have a problem with oracle query in my unix script.. I'm getting the following error while executing.. ./logtab.sh: sqlplus -s "pmutv/pmutv1" << EOFSQL^Jset head off^Jinsert into...

7. Shell Programming and Scripting

perl- oracle sql query

Hi, I am new to perl.How to query oracle database with perl??? Thanks

8. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

9. Programming

Oracle query with field filter

Dear community, I have to make a query from a database and apply the following filter: select filed1,field2,field3 from database where (field1 contains only alphanumeric chars and NOT only numbers) Let me explain better what I Need: 21test ==> OK test ==> OK test21 ==> OK te21st ==>...

10. IP Networking

Connection to DB from client server through jdbc:Oracle:Oci8 fail

We tried to use to connect to DB using jdbc:Oracle:Oci8:@<SERVICE-A>. Connection fail / refuse with one DB .But its working with other databases. But through toad, jdbc thin client were able to connect. But this has happen suddenly and were able to connect previously. How to navigate this...

LEARN ABOUT MINIX

zgrep

ZGREP(1)                                                      General Commands Manual                                                     ZGREP(1)

NAME

       zgrep - search possibly compressed files for a regular expression

SYNOPSIS

       zgrep [ grep_options ] [ -e ] pattern filename...

DESCRIPTION

       Zgrep  invokes  grep  on  compressed  or  gzipped  files.   These  grep  options  will  cause  zgrep  to  terminate  with  an  error  code:
       (-[drRzZ]|--di*|--exc*|--inc*|--rec*|--nu*).  All other options specified are passed directly to grep.  If no file is specified,  then  the
       standard input is decompressed if necessary and fed to grep.  Otherwise the given files are uncompressed if necessary and fed to grep.

       If the GREP environment variable is set, zgrep uses it as the grep program to be invoked.

EXIT CODE

       2 - An option that is not supported was specified.

AUTHOR

       Charles Levert (charles@comm.polymtl.ca)

SEE ALSO

       grep(1), gzexe(1), gzip(1), zdiff(1), zforce(1), zmore(1), znew(1)

                                                                                                                                          ZGREP(1)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

oracle process query !

Discussion started by: kpatel786

2. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Discussion started by: balaeswari

3. Shell Programming and Scripting

How to put db2 query result into an array in shell script?

Discussion started by: hanul

4. Programming

Oracle Database Query

Discussion started by: SkySmart