Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Log file for a Script
Top Forums UNIX for Dummies Questions & Answers Log file for a Script Post 302114077 by vr76413 on Thursday 12th of April 2007 10:23:08 AM
Old 04-12-2007
Log file for a Script
Oracle92 on solaris 8.

We have a Truncate Script that runs every night to cleanup certain tables , so new data gets loaded into. This Script is run in Unix Shell script where i set Environment varibles, and things like that..

Now, how do i create a log file of the script , to see weather the script really deleted the data ?

==========================
#!/bin/ksh
ORACLE_BASE=/u10/app/ORACLE
ORACLE_DOC=$ORACLE_BASE/doc
ORACLE_HOME=$ORACLE_BASE/product/9.2.0.1.0
ORACLE_SID=dss
PATH=/usr/bin:/usr/ucb:/usr/sbin:/etc:/usr/inform/PowerMart:/usr/inform/RepServer:/usr/inform/scripts:$ORACLE_HOME/bin:/usr/bin:/bin:/usr/ccs/bin:/usr/ucb:/etc:/usr/openwin/bin:/usr/local/bin:.
TNS_ADMIN=$ORACLE_HOME/network/admin
LD_LIBRARY_PATH=/usr/inform/PowerMart:/usr/inform/RepServer:$ORACLE_HOME/lib32
export PATH PM_HOME ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH TNS_ADMIN
export PARMS=/usr/inform/scripts/WorkFlow/dss_parms
ORADBUSER=`cat $PARMS |grep ORADBUSER|cut -d":" -f2`
ORADBPASSWD=`cat $PARMS |grep ORADBPASSWD|cut -d":" -f2`

$ORACLE_HOME/bin/sqlplus -s << EOF
$ORADBUSER/$ORADBPASSWD
set heading off;
set feedback off;
set echo off;
truncate table current_year;
commit;
=============================

Thanks
Ron
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with script parsing a log file

I have a large log file, which I want to first use grep to get the specific lines then send it to awk to print out the specific column and if the result is zero, don't do anything. What I have so far is: LOGDIR=/usr/local/oracle/Transcription/log ERRDIR=/home/edixftp/errors #I want to be... (3 Replies)
Discussion started by: mevasquez
3 Replies

2. UNIX for Dummies Questions & Answers

Script for parsing details in a log file to a seperate file

Hi Experts, Im a new bee for scripting, I would ned to do the following via linux shell scripting, I have an application which throws a log file, on each action of a particular work with the application, as sson as the action is done, the log file would vanish or stops updating there, the... (2 Replies)
Discussion started by: pingnagan
2 Replies

3. Shell Programming and Scripting

log file script

I have a log which is configured as follows: date time code1 notes: code2 A monthly job is run based on information supplied from this log. The end of each monthly job is clearly indicated by a code within 'code1'. At this time someone is performing a less on the log, moving to the end,... (2 Replies)
Discussion started by: bwatlington
2 Replies

4. Shell Programming and Scripting

Script extract from log file

Hi i new to scripting and am trying to create a script to pull my current of logs from /var/logs/secure and name it securelog-Month-Day-Hour.txt example: grep 'Mar 5 11' /var/logs/secure > /home/(user)/Documents/Logs/mylog-02-1-11 How do i set the targeted strings to be the current... (2 Replies)
Discussion started by: M47H415
2 Replies

5. HP-UX

Script to monitor /var/opt/resmon/log/event.log file

AM in need of some plugin/script that can monitor HP-UX file "/var/opt/resmon/log/event.log" . Have written a scrip in sh shell that is working fine for syslog.log and mail.log as having standard format, have interrogated that to Nagios and is working as I required . But same script failed to... (3 Replies)
Discussion started by: Shirishlnx
3 Replies

6. UNIX for Advanced & Expert Users

Script to read log file

Hi, Im looking for a shell script which will search for a particular string in a log file as below scenario 1. I need to run URL http://localhost/client/update?feedid=200 in shell script at(eg)4:00 PM which will not take more than 15 mins to complete. 2. After 15 mins i need to... (6 Replies)
Discussion started by: Paulwintech
6 Replies

7. Shell Programming and Scripting

Shell Script to grep Job File name and Log File name from crontab -l

Hello, I am new to shell scripting. I need to write a shell script where i can grep the name of file ie. .sh file and log file from crontab -l. #51 18 * * * /home/oracle/refresh/refresh_ug634.sh > /home/oracle/refresh/refresh_ug634.sh.log 2>&1 #40 17 * * * /home/oracle/refresh/refresh_ux634.sh... (1 Reply)
Discussion started by: guptra
1 Replies

8. Shell Programming and Scripting

Script to read a log file and run 2nd script if the dates match

# cat /tmp/checkdate.log SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 17 22:49:00 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production FIRST_TIME NEXT_TIME... (1 Reply)
Discussion started by: SarwalR
1 Replies

9. UNIX for Beginners Questions & Answers

Monitoring script for Log file

Hi, Iam new to unix , plz help me to write below script. I need to write a script for Monitoring log file when any error occurs it has to send a mail to specified users and it should be always pick latest error not the existing one and the script should be able to send mail all errors (more... (1 Reply)
Discussion started by: vij05
1 Replies

10. Shell Programming and Scripting

Shell Script function to use script name for log file output

Hi Team - I"m very new to Shell Scripting so I have a rather novice question. My forte is Windows Batch Scripting so I was just wondering what the Shell Script equivalent is to the DOS command %~n? %~n is a DOS variable that dispayed the script name. For instance (in DOS): REM... (11 Replies)
Discussion started by: SIMMS7400
11 Replies

LEARN ABOUT SUNOS

cc

cc(1B)						     SunOS/BSD Compatibility Package Commands						    cc(1B)

NAME

       cc - C compiler

SYNOPSIS

       /usr/ucb/cc [options]

DESCRIPTION

       /usr/ucb/cc  is the interface to the BSD Compatibility Package C compiler. It is a script that looks for the link /usr/ccs/bin/ucbcc to the
       C compiler. The /usr/ccs/bin/ucbcc link is available only with the SPROcc package, whose default location is /opt/SUNWspro. The /usr/ucb/cc
       interface  is  identical  to  /usr/ccs/bin/ucbcc, except that BSD headers are used and BSD  libraries are linked before base libraries. The
       /opt/SUNWspro/man/man1/acc.1 man page is available only with the SPROcc package.

OPTIONS

       The /usr/ucb/cc interface accepts the same options as /usr/ccs/bin/ucbcc, with the following exceptions:

       -Idir	       Search dir for included files whose names do not begin with a slash (/) prior  to  searching  the  usual  directories.  The
		       directories for multiple -I options are searched in the order specified. The preprocessor first searches for #include files
		       in the directory containing sourcefile, and then in directories named with -I options (if any), then  /usr/ucbinclude,  and
		       finally, in /usr/include.

       -Ldir	       Add  dir  to the list of directories searched for libraries by /usr/ccs/bin/ucbcc. This option is passed to /usr/ccs/bin/ld
		       and /usr/lib. Directories specified with this option are searched before /usr/ucblib and /usr/lib.

       -Y P, dir       Change the default directory used for finding libraries.

EXIT STATUS

       The following exit values are returned:

       0	       Successful compilation or link edit.

       >0	       An error occurred.

FILES

       /usr/ccs/bin/ld	       link editor

       /usr/lib/libc	       C library

       /usr/ucbinclude	       BSD Compatibility directory for header files

       /usr/ucblib	       BSD Compatibility directory for libraries

       /usr/ucblib/libucb      BSD Compatibility C library

       /usr/lib/libsocket      library containing socket routines

       /usr/lib/libnsl	       library containing network functions

       /usr/lib/libelf	       library containing routines to process ELF object files

       /usr/lib/libaio	       library containing asynchronous I/O routines

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWscpu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       ld(1), a.out(4), attributes(5)

NOTES

       The -Y P, dir option may have unexpected results and should not be used.

SunOS 5.10							    24 Feb 1998 							    cc(1B)
All times are GMT -4. The time now is 07:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy