11-13-2006
.Thanks for your reply.
They are perfectly valid in my database.
I get the result when I execute the same query in SQL plux..
Intruiging...
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i All
I have scripting question.
I have a file "out.txt"
which is generated by another script
the file contains the following
my_identifier8859574
logout
The number is generated in the script and I have put the my_identifier bit in front of it as a unique identifier
I now have... (7 Replies)
Discussion started by: grahambo2005
7 Replies
2. Shell Programming and Scripting
Hi,
Can anyone tell me how to get all ORA errors between two particular times in an alertlog file using shell script.
Thanks (3 Replies)
Discussion started by: suman_dba1
3 Replies
3. Shell Programming and Scripting
Hi all
im having trouble starting with a shell script, i hope someone here can help me
i have 2 files
file1:
404905.jpg 516167
404906.jpg 516168
404917.psd 516183
404947.pdf 516250
file2:
516250 /tmp/RecyclePoster18241.pdf
516167 /tmp/ReunionCardFINAL.jpg
516168... (7 Replies)
Discussion started by: kenray
7 Replies
4. Shell Programming and Scripting
Hi,
I have a shell script and inside that shell script it calls a local .env file to set the environment for the shell script ,but the thing is that i got a error while running the script like
./myscript.sh it gives DB_NAME=dvcl021: is not an identifier
that DB_Name is accessed from my .env... (6 Replies)
Discussion started by: malickhat
6 Replies
5. Solaris
Hi all,
Am intermittently getting the following errors on one of my databases.
Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302:... (1 Reply)
Discussion started by: newbie_01
1 Replies
6. Shell Programming and Scripting
Hi,
as the title says, I am after a simple script, which will open the Alert log from
an 11.2.0.1 Linux environment and mail the error message and description to a recipient email address.
I can then schedule this job via cron and let it run every 15 minutes.
I have searched online... (16 Replies)
Discussion started by: jnrpeardba
16 Replies
7. Shell Programming and Scripting
Here is the question...
Create a new script, sub2, taking three parameters...
1.) the string to be replaced
2.) the string with which to replace it
3.) the name of the file in which to make the substitution
...that treats the string to be replaced as plain text instead of as a regular... (1 Reply)
Discussion started by: johnhisenburg
1 Replies
8. Shell Programming and Scripting
I have a shell script which select total count from a table and use its value in a if condition like below
connect_string="username/password@tnsname"
tot=`sqlplus -s $connect_string << EOF
set echo off
set feedback off
set head off
select count(*) from test_table;
EOF
`
if
then
echo... (2 Replies)
Discussion started by: vel4ever
2 Replies
9. UNIX for Dummies Questions & Answers
Hello
I am trying to use the following inside a shell script :
S_TAB=$(sqlplus -s / as sysdba <<EOF
set feedback off linesize 132 pages 0 echo off verify off heading off
select created
from v\$database;
select 'hurrah' from dual;
EOF)
Spews out lots of rubbish... (2 Replies)
Discussion started by: d_b
2 Replies
10. UNIX for Dummies Questions & Answers
I've been trying to debug this for 3 hours now. TAB is a table where it contains all the table names. If I try to run it without the filter 'where' it runs fine and outputs the number of rows. But when I put a filter it shows that error. I want to be able to know if the table exists, if it doesn't,... (2 Replies)
Discussion started by: gmatcat
2 Replies
LEARN ABOUT OSF1
uudemon.cleanu
uudemon(4) Kernel Interfaces Manual uudemon(4)
NAME
uudemon.admin, uudemon.cleanu, uudemon.hour, uudemon.poll - Administrative shell scripts for polling remote systems, cleaning up spool
directories, reporting status to the system administrator, and routine invocations of the uuxqt and uusched daemons
SYNOPSIS
These shell scripts reside in the following directory:
/usr/lib/uucp
DESCRIPTION
All the scripts can be run from the command line or can be run automatically by the cron daemon. To automatically run the scripts, remove
the comment character (#) from the beginning of the relevant line in the /var/spool/cron/crontabs/uucp file.
This script reports status to the system administrator. It issues the uustat command to find out the status of uucp jobs. It mails the
results to the uucp login ID. The script may be modified to send mail to any login ID such as the uucp administrative login ID (uucpa) or
root. This script cleans up the /var/spool/uucp and /var/spool/uucppublic directories by running the uucleanup command. The uucleanup com-
mand is run with the following parameters: -C7, -D7, X2, -o2, -W1. This script runs the uusched and uuxqt daemons in the background. This
script polls the systems listed in the /usr/lib/uucp/Poll file. The uudemon.poll script should be scheduled before the uudemon.hour
script. This allows uudemon.poll to create any command files before cron runs the uudemon.hour script.
FILES
Contains the uudemon.admin, uudemon.cleanu, uudemon.hour and uudemon.poll files. Contains the uucp file.
RELATED INFORMATION
Commands: cron(8), uucleanup(8), uusched(8), uuxqt(1)
Files: /usr/lib/uucp delim off
uudemon(4)