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)
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)
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)
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)
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)
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)
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)
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)
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)
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 DEBIAN
glance-cache-cleaner
GLANCE-CACHE-CLEANER(1) Glance GLANCE-CACHE-CLEANER(1)NAME
glance-cache-cleaner - Glance Cache Cleaner
GLANCE IMAGE CACHE INVALID CACHE ENTRY AND STALLED IMAGE CLEANER
Author glance@lists.launchpad.net
Date 2012-01-03
Copyright
OpenStack LLC
Version
2012.1-dev
Manual section
1
Manual group
cloud computing
SYNOPSIS
glance-cache-cleaner [options]
DESCRIPTION
This is meant to be run as a periodic task from cron.
If something goes wrong while we're caching an image (for example the fetch times out, or an exception is raised), we create an 'invalid'
entry. These entires are left around for debugging purposes. However, after some period of time, we want to clean these up.
Also, if an incomplete image hangs around past the image_cache_stall_time period, we automatically sweep it up.
OPTIONS
--version
show program's version number and exit
-h, --help
show this help message and exit
--config-file=PATH
Path to a config file to use. Multiple config files can be specified, with values in later files taking precedence. The default
files used are: []
-d, --debug
Print debugging output
--nodebug
Do not print debugging output
-v, --verbose
Print more verbose output
--noverbose
Do not print verbose output
--log-config=PATH
If this option is specified, the logging configuration file specified is used and overrides any other logging options specified.
Please see the Python logging module documentation for details on logging configuration files.
--log-format=FORMAT
A logging.Formatter log message format string which may use any of the available logging.LogRecord attributes. Default: none
--log-date-format=DATE_FORMAT
Format string for %(asctime)s in log records. Default: none
--log-file=PATH
(Optional) Name of log file to output to. If not set, logging will go to stdout.
--log-dir=LOG_DIR
(Optional) The directory to keep log files in (will be prepended to --logfile)
--use-syslog
Use syslog for logging.
--nouse-syslog
Do not use syslog for logging.
--syslog-log-facility=SYSLOG_LOG_FACILITY
syslog facility to receive log lines
SEE ALSO
o OpenStack Glance
BUGS
o Glance is sourced in Launchpad so you can view current bugs at OpenStack Glance
AUTHOR
OpenStack
COPYRIGHT
2010-present, OpenStack, LLC.
2012.1.1 March 14, 2013 GLANCE-CACHE-CLEANER(1)