Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Format the output from sqlplus while writing to log file.
Top Forums Shell Programming and Scripting Format the output from sqlplus while writing to log file. Post 302474262 by murtymvvs on Tuesday 23rd of November 2010 08:41:58 PM
Old 11-23-2010
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, this is making my log to look odd and weird.
Is there a way to format (add date in front of) these outputs from sqlplus and sqlldr before writing to the log,

Thanks in advance.

Murty.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

File Format issue: Output of sqlplus

Hi, I am using a query like below in my shell script : { { echo "set echo off" echo "set head off" echo "whenever sqlerror exit -1; select NUMBER ||','|| FNAME ||','|| LOC ||','|| ... (2 Replies)
Discussion started by: deepakgang
2 Replies

2. 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

3. Shell Programming and Scripting

Dynamic output file generation using a input text file with predefined output format

Hi, I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format. Example: File.txt AP|{SSHA}VEEg42CNCghUnGhCVg== APVG3|{SSHA}XK|"password" AP3|{SSHA}XK|"This is test" .... etc --------- test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies

4. Shell Programming and Scripting

Log sqlplus output from Shell

UNIX Gods, I'll be running this script from CRON. I need to log the status of each of the six sqlplus calls into a file when this job is kicked off. Any suggestions? Thanks in advance. #!/bin/ksh export USAGE="USAGE: `basename $0` -e <DBUSER> <DBPASSWD> <TNSNAME>" if ; then ... (2 Replies)
Discussion started by: WhoDatWhoDer
2 Replies

5. UNIX and Linux Applications

Please help: Oracle gqsql or sqlplus output format like mysql

On psql select titolo,lingua from titolo where titolo ~* 'brivid'; titolo | lingua ------- + ------ Brivido | 1 On Sqlplus/gqsql SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%'; TITOLO... (6 Replies)
Discussion started by: Linusolaradm1
6 Replies

6. Shell Programming and Scripting

Writing the output of set -x into Log files

Hi Guys, I am using set -x in my script to track the flow of the script. But if i want to write the output of the set -x into a log file, how do i do it? Thanks, Ajay (3 Replies)
Discussion started by: Ajay Venkatesan
3 Replies

7. Shell Programming and Scripting

Sqlplus inside shell script writing to tmp file

Hi, facing an issue while calling sqlplus inside shell script. It for some reason goes to tmp file to write something and i get error as permission denied as i dont have access there. ANy idea why sqlplus writes in /tmp and how to change or stop this ? (2 Replies)
Discussion started by: rushikeshs
2 Replies

8. Shell Programming and Scripting

Writing output to a file in columns

Hi I am trying to write output to a file in columns I have file in the follwoing: # cat file abc def # I am trying to write next output as like # cat file abc 123 def 345 # :mad: (6 Replies)
Discussion started by: Priya Amaresh
6 Replies

9. Shell Programming and Scripting

Getting output with sed without writing to a file

HI I am trying to grep 3 characters from hostname and append a character at the end. I tried as in the following: root@abag3:~# hostname | cut -c1-3 hyu Now I am trying to append "g" at the end of this output as in the following. root@abag3:~# hostname | cut -c1-3 | sed -s... (4 Replies)
Discussion started by: Priya Amaresh
4 Replies

10. Shell Programming and Scripting

Wrong output when writing to file

Hello, I am having problem while redirecting output to a file where as on console output is proper. for dir in */; do printf "%s, " "$dir"; ls -m "$dir"; echo; done > output.txt Output of above command is coming in single line but when i am redirecting output to a file, single line i... (10 Replies)
Discussion started by: Manoj Rajput
10 Replies

LEARN ABOUT SUNOS

ncalogd.conf

ncalogd.conf(4) 						   File Formats 						   ncalogd.conf(4)

NAME

       ncalogd.conf - NCA logging configuration file

SYNOPSIS

       /etc/nca/ncalogd.conf

DESCRIPTION

       The ncalogd.conf is used to configure Solaris Network Cache and Accelerator ("NCA") logging. The file contains two fields, key and value.

       The status key is used to indicate if the user wants to have NCA logging turned on. If the value of status key is enabled, then NCA logging
       will be turned on. If the value of the status key is disabled, then NCA logging will not be invoked. The default value is disabled.

       The logd_path_name key specifies the absolute pathname of the log file. The log file must be a raw device without a filesystem or a file on
       a  local file system. The default value is /var/nca/log. logd_path_name can also contain a whitespace-delimited list of values for multiple
       log files to a maximum of 16. If you specify multiple log files, you must enclose the list in quotation marks ("). With multiple files, NCA
       logging moves to the next file on the list once the file size specified by logd_file_size has been reached. When the last file is full, NCA
       logging rotates back to the first file in the list. A pointer to the current log file is stored in /var/nca/current.

       The logd_file_size key specifies the value of the file size, in bytes, allowed for each log file specified in by  the  logd_path_name  key.
       The default value is 1000000 bytes.

       In order to implement changes to the ncalogd.conf file, you will need to stop and start NCA logging or reboot.

       NCA stores logs in a binary format. Use the ncab2clf(1) utility to convert the log from a binary format to the Common Log File format.

EXAMPLES

       Example 1: A Sample ncalogd.conf File

       The following is a sample ncalogd.conf file that specifies three log files:

       #
       # NCA Log Daemon Configuration File
       #

       status=enabled
       logd_path_name="/var/nca/log1 /var/nca/log2 /var/nca/log3"
       logd_file_size=1000000

       Note that there is no NCA logging daemon. Logging is performed as one of the functions of the NCA software.

FILES

       /etc/nca/ncalogd.conf	       Lists configuration parameters for NCAlogging.

ATTRIBUTES

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

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWncar			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Evolving			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       nca(1), ncab2clf(1), ncakmod(1), dd(1M), door_create(3DOOR), nca.if(4), ncakmod.conf(4), attributes(5)

       System Administration Guide: IP Services

SunOS 5.10							    22 Jan 2002 						   ncalogd.conf(4)
All times are GMT -4. The time now is 10:59 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy