Format the output from sqlplus while writing to log file. Post: 302474272

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

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

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

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

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 ?

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:

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

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

LEARN ABOUT DEBIAN

bootlogd

BOOTLOGD(8)						Linux System Administrator's Manual					       BOOTLOGD(8)

NAME

       bootlogd - record boot messages

SYNOPSIS

       /sbin/bootlogd [-c] [-d] [-r] [-s] [-v] [ -l logfile ] [ -p pidfile ]

DESCRIPTION

       Bootlogd  runs in the background and copies all strings sent to the /dev/console device to a logfile. If the logfile is not accessible, the
       messages will be kept in memory until it is.

OPTIONS

       -d     Do not fork and run in the background.

       -c     Attempt to write to the logfile even if it does not yet exist.  Without this option, bootlogd will wait for the  logfile	to  appear
	      before attempting to write to it.  This behavior prevents bootlogd from creating logfiles under mount points.

       -r     If there is an existing logfile called logfile rename it to logfile~ unless logfile~ already exists.

       -s     Ensure  that the data is written to the file after each line by calling fdatasync(3).  This will slow down a fsck(8) process running
	      in parallel.

       -v     Show version.

       -l logfile
	      Log to this logfile. The default is /var/log/boot.

       -p pidfile
	      Put process-id in this file. The default is no pidfile.

BUGS

       Bootlogd works by redirecting the console output from the console device.  (Consequently bootlogd requires PTY support in the  kernel  con-
       figuration.)   It  copies that output to the real console device and to a log file.  There is no standard way of ascertaining the real con-
       sole device if you have a new-style /dev/console device (major 5, minor 1) so bootlogd parses the kernel  command  line	looking  for  con-
       sole=... lines and deduces the real console device from that.  If that syntax is ever changed by the kernel, or a console type is used that
       bootlogd does not know about then bootlogd will not work.

AUTHOR

       Miquel van Smoorenburg, miquels@cistron.nl

SEE ALSO

       dmesg(8),fdatasync(3).

								   Jul 21, 2003 						       BOOTLOGD(8)