Hi All,
I have to make the following changes in shell script:
When the data file is being created, an “ORA” error occurs in it. I have to remove this ORA error from data file and put it in log file.
I am “ -n grip command” to find the ORA error and get the line number,
How do I delete it... (1 Reply)
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)
Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command?
In following "grep" command I want to exclude "ORA-01653" error
grep -i ORA alert.log >>/tmp/ora_errors.txt
... (7 Replies)
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)
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)
Hi Guys,
I wanted to create an Unix Shell Script that should fetch a particular string from a text file on a particular date.
We all know Oracle generates alert logs for each and every day for every actions in the database.
I have an alert log file now where it contains for about a months... (4 Replies)
I want to check for "errors" or "ORA-" in Y.if there is an error then exit
Y=`sqlplus -s user/passwd<< EOF
exec test_Proc;
exit;
EOF`
if ; then
exit 1
fi
but this doesnt work (6 Replies)
Discussion started by: haadiya
6 Replies
LEARN ABOUT OSF1
time_lock_es
time_lock_es(3) Library Functions Manual time_lock_es(3)NAME
time_lock_es - Check time-of-day locking (Enhanced Security)
LIBRARY
Security Library (libsecurity.so)
SYNOPSIS
#include <sys/types.h> #include <sys/security.h> #include <prot.h>
int time_lock_es ( struct es_passwd *prpwd );
PARAMETERS
Specifies a protected password entry structure.
DESCRIPTION
The time_lock_es() function performs time-of-day lock checking for the current date and time against the time-of-day specification in the
fd_tod string of the prpwd parameter. The function returns 1 if the time lock is on and 0 if there is no lock.
The fd_tod specification is like that found in the UUCP Systems file. The specification is a comma-separated list of entries. If the cur-
rent time matches an entry in the specification, the time lock is not on. The entries are scanned until a match is found. If no match can
be found, the time lock is on. Each entry appears as follows:
<day><start_time-end_time>
The day is one of the following: Matches any day of the week. Matches Monday through Friday. Sunday Monday Tuesday Wednesday Thursday
Friday Saturday
The times are military time, for example, 9:15 am is 0915, 6:00 pm is 1800, and 12:42 am is 0042. When start_time is less than end_time,
the range of times contains valid times in which to log in that day. When the times are equal or there is only one time (including no time
at all), the entire day is valid. When start_time is later than end_time, times outside the range are valid. For instance, if start_time
is 04:15 and end_time is 02:00, then any time that falls outside the range of 02:00 to 04:15 is a valid time.
NOTES
Programs using this function must be compiled with -lsecurity.
In order to quickstart a program, the program must be linked as follows:
-lsecurity -ldb -laud -lm
See the shared library discussion in the Programmer's Guide for more information about using the quickstarting feature. delim off
time_lock_es(3)