Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Log sqlplus output from Shell
Top Forums Shell Programming and Scripting Log sqlplus output from Shell Post 302530933 by Peasant on Wednesday 15th of June 2011 11:26:02 AM
Old 06-15-2011
Something like :
Code:
runsql () {
sqlplus /nolog << EOF
conn user/pass@$ORACLE_SID
@$1
exit
EOF
}
for i in *.sql # (array, list, whatever)
do
runsql $i | grep ORA-
if [[ $? -gt 0 ]]; then
printf "$i has ORA errors \n" >> rpt.txt
fi
done

This is only a simple example, you can extend it as you wish.

If you require exit codes from sqlplus ($?), you need to code it inside every sql you run.
This User Gave Thanks to Peasant For This Post:
WhoDatWhoDer
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

sqlPlus output with new line character

Hi, I have a script which calls a sqlplus command and i'm saving the output in a variable. Z=`sqlplus -s $TC_ORACLE_USER/$TC_ORACLE_PASSWORD@$TC_CONNECT_STRING <<eof set echo off set head off set serveroutput on; set feedback off; select description from period where trunc(sysdate)... (2 Replies)
Discussion started by: decci_7
2 Replies

2. UNIX for Dummies Questions & Answers

Getting output parameter in sqlplus

I need to get the output parameter from a stored procedure in sql plus using shell script. Can anyone help me please ... (1 Reply)
Discussion started by: risshanth
1 Replies

3. Shell Programming and Scripting

sqlplus error output to different error log file

HELLO, I am using such a command to write oracle sqlplus query result to text file: sqlplus -S xxx/xxx@xxxxxxx @\tmp\2.sql>\tmp\123.txt Is it possible to script that: If command succesfull write in \tmp\log.txt: timestamp and "succeded" and create 123.txt with results else If error... (2 Replies)
Discussion started by: tomasba
2 Replies

4. Shell Programming and Scripting

output arguments from a sqlplus

Hi. I need to output a 4 queries result into another application using result=`sqlplus -s ${3}/${4}@${2} << EOF ... query1 query2 query3 query4 .... echo "$metrics1" and returning those individual values into another app. (query1 and 3compute one value, query 2 and 4 compute 4... (3 Replies)
Discussion started by: shell_zen
3 Replies

5. Shell Programming and Scripting

Format the output from sqlplus while writing to log file.

Hi I have developed bash script to connect to database and execute .sql files. I am logging some statements in to log file using echo. While logging I am adding the date in front of the log statements which makes sense. I am unable to add date in front of output from the sqlplus and sqlldr,... (8 Replies)
Discussion started by: murtymvvs
8 Replies

6. Shell Programming and Scripting

Problems with storing oracle sqlplus query output shell script

Hello everyone, I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected. I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Discussion started by: rockf1bull
3 Replies

7. Solaris

sqlplus output from ksh.

Hi All, I have the below simple script. It runs just fine by itself when I manually invoke it. But once I put it in the crontab with entry: * * * * * /users/myuser/test.ksh >> /users/myuser/log/test.txt" It does NOT print the returned value ($REMAIN) from the DB!? The result in the... (3 Replies)
Discussion started by: steve701
3 Replies

8. Shell Programming and Scripting

Sending sqlplus output to a shell variable

I am trying to import a sqlplus output into a shell variable but it doesnt seem to be working. set -x export DEPENDENT_CR_NO=`sqlplus -s /nolog <<EOF conn username/passwd set heading off select dependency from custom_patches where patch_name='PATCH.zip'; exit; EOF` echo $DEPENDENT_CR_NO ... (2 Replies)
Discussion started by: beginer314
2 Replies

9. Shell Programming and Scripting

Sqlplus function output to bash

Hi, I would like to have the output from an Oracle procedure be captured into a bash variable, then emailed to me when it runs on the cron daily as such: ~~~~~bash script~~~~~~~~~~~ #!/bin/bash shellvar=`sqlplus -s <<EOF execute test(); commit; exit; EOF` echo $shellvar mail -s "email... (1 Reply)
Discussion started by: inlinesidekick
1 Replies

10. Shell Programming and Scripting

Passing sqlplus output to shell variable

Hi , I am using below code : for i in `ps -ef|grep pmon|awk {' print $8 '}|cut -f3 -d'_'|grep -v '^grep'` do ORACLE_SID=$i export ORACLE_SID; dest=`sqlplus "/ as sysdba" <<EOF set heading off feedback on verify off select DESTINATION from v\\$archive_dest where target in... (5 Replies)
Discussion started by: admin_db
5 Replies

LEARN ABOUT DEBIAN

cmannotifyd

cmannotifyd(8)						     CMAN Notification Daemon						    cmannotifyd(8)

NAME

       cmannotifyd - CMAN Notification Daemon

SYNOPSIS

       cmannotifyd [-f] [-d]

DESCRIPTION

       The cmannotifyd daemon talks to CMAN and provides a mechanism to notify external entities about cluster changes.

       CMAN dispatches 3 kind of notifications:

       - CMAN_REASON_TRY_SHUTDOWN when cman requests to all clients if it is allowed to shutdown.

       - CMAN_REASON_STATECHANGE when cman detects a node joining or leaving the cluster.

       - CMAN_REASON_CONFIG_UPDATE when a configuration change event has been detected/requested.

       These notifications are then dispatched to the shell script cman_notify in the environment variable CMAN_NOTIFICATION.

       cman_notify will then execute all the scripts in the configured notification directory (default: /etc/cluster/cman-notify.d) passing a very
       minimal set of envvars including, of course, the CMAN_NOTIFICATION= type.  The execution order is set by the filename as shown by "LC_ALL=C
       ls -las".

       cmannotifyd logs are stored in the default log file (/var/log/cluster/cmannotifyd.log).

       cman_notify  logs are stored in the default log file (/var/log/cluster/cman_notify.log). By default the output from the scripts executed by
       cman_notify is redirected to /dev/null.	Users can either set CMAN_NOTIFICATION_DEBUG=1 in their environment or set proper debug configura-
       tion in cluster.conf to redirect scripts output to the cman_notify log file.

NOTES

       cmannotifyd does not block on cman_notify nor check the exit status of the script.

       Notifications are dispatched in the same order as they arrive, one by one.

       CMAN_REASON_TRY_SHUTDOWN  is  passed  to  scripts  for information only, they can not influence cman's decsion about whether or not to shut
       down.

       CMAN_REASON_STATECHANGE also implies CMAN_NOTIFICATION_QUORUM exported in the environment. CMAN_NOTIFICATION_QUORUM will be set to 1  (when
       the node is part of a quorate cluster) or 0 (otherwise).

       A template for cman_notify scripts can be found in the doc/ directory.

OPTIONS

       -f     Run in the foreground (do not fork / daemonize).

       -d     Enable debug output.

								   November 2008						    cmannotifyd(8)
All times are GMT -4. The time now is 07:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy