09-27-2012
grep with date & unique output
alert.log has the entries with
,
HTML Code:
....
Mon Sep 24 15:08:09 2012
WARNING: inbound connection timed out (ORA-3136)
Mon Sep 24 15:08:09 2012
WARNING: inbound connection timed out (ORA-3136)
Mon Sep 24 15:08:09 2012
WARNING: inbound connection timed out (ORA-3136)
Mon Sep 24 15:15:01 2012
Thread 2 advanced to log sequence 17004
Current log# 8 seq# 17004 mem# 0: /dev/rprod_rdo_015
Current log# 8 seq# 17004 mem# 1: /dev/rprod_rdo_016
Mon Sep 24 15:15:04 2012
LNS: Standby redo logfile selected for thread 2 sequence 17004 for destination LOG_ARCHIVE_DEST_2
Mon Sep 24 15:15:04 2012
LNS: Standby redo logfile selected for thread 2 sequence 17004 for destination LOG_ARCHIVE_DEST_3
Mon Sep 24 15:30:02 2012
....
If I do
HTML Code:
grep ORA-3136 alert.log
, then it just gives,
HTML Code:
WARNING: inbound connection timed out (ORA-3136)
WARNING: inbound connection timed out (ORA-3136)
WARNING: inbound connection timed out (ORA-3136)
....
I need to have with the date and time associated with.
The date and time is always right above the error content.
HTML Code:
Mon Sep 24 15:08:09 2012
WARNING: inbound connection timed out (ORA-3136)
The same entries can be there more than one. In that case, I need to pull out the unique output so that I can avoid duplicates.
Please advise.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello all
This is a sample vmstat output ...
$ vmstat 2 2
kthr memory page disk faults cpu
r b w swap free re mf pi po fr de sr hx hx hx hx in sy cs us sy id
1 0 0 23105784 7810488 323 767 1742 5 5 0 0 0 0 0 0 683 780 457 43 ... (9 Replies)
Discussion started by: luft
9 Replies
2. Shell Programming and Scripting
Hello,
In korn-shell, how can I do to have an unique number for a date done.
I want to use it to have the number of days between two dates.
Thanks in advance. (4 Replies)
Discussion started by: madmat
4 Replies
3. Shell Programming and Scripting
I have an archive file that holds a batch of statements. I would like to be able to extract a certain statement based on the unique customer # (ie. 123456). The end for each statement is noted by "ENDSTM".
I can find the line number for the beginning of the statement section with sed.
... (5 Replies)
Discussion started by: andrewsc
5 Replies
4. Shell Programming and Scripting
Hi,
I need to search email files by date & time range in email files.
The timezone is not important.
Can someone plz advise how i can do this ?
For e.g A user can specify only
A single date
A date range
date & time range
Below is part of the email file. (4 Replies)
Discussion started by: coolatt
4 Replies
5. UNIX for Dummies Questions & Answers
Hello, I have a file with a list of car makes and specific information for each make. An example is:
@Audi:Warranty
@Audi:Pricing
@Audi:Colors
@Acura:Warranty
@Acura:Pricing
@Acura:Colors
and so on through a bunch of makes. I need to make a list in a selection box of just one name of... (4 Replies)
Discussion started by: macbb1117
4 Replies
6. Shell Programming and Scripting
Hi Guys,
I have two input files and I want to combine them and get the unique values and differences and put them into one file. See below desired output file.
Inputfile1:
1111111
2222222
3333333
7860068
7860069
7860071
7860072
Inputfile2:
4444444 (4 Replies)
Discussion started by: pinpe
4 Replies
7. UNIX Desktop Questions & Answers
how can i grep a range?
i have a text file with the following text:
result.log.00:2012/01/02 12:00:07.422 LOG STARTED HERE
N6Kashya29MemoryShieldScheduler_AO_IMPLE, pid=8662/8658,
config=(alertThreshold=10,alertLevel=0,killThreshold=7200,coreThreshold=0,full=1),
deltaTime=0,... (1 Reply)
Discussion started by: boaz733
1 Replies
8. Shell Programming and Scripting
Hi All,
Facing an issue with grep & sed
I have logs as below:
gsc_1_20121121.log:2012-11-21 10:09:13,143 INFO - fmsspace.1 ProcessNewOrderSingleRequest: Result - ProcessNewOrderSingleBatchResultDTO - success:true,newOrderSingleBatchResults:ProcessNewOrderSingleResultDTO -... (13 Replies)
Discussion started by: irfanmemon
13 Replies
9. Programming
I can find and replace text when the delimiters are unique. What I cannot do is replace text using two NON-unique delimiters:
Ex.,
"This html code <text blah >contains <garbage blah blah >. All tags must go,<text > but some must be replaced with <garbage blah blah > without erasing other... (5 Replies)
Discussion started by: bedtime
5 Replies
LEARN ABOUT PHP
oci_password_change
OCI_PASSWORD_CHANGE(3) OCI_PASSWORD_CHANGE(3)
oci_password_change - Changes password of Oracle's user
SYNOPSIS
bool oci_password_change (resource $connection, string $username, string $old_password, string $new_password)
DESCRIPTION
resource oci_password_change (string $dbname, string $username, string $old_password, string $new_password)
Changes password for user with $username.
The oci_password_change(3) function is most useful for PHP command-line scripts, or when non-persistent connections are used throughout
the PHP application.
PARAMETERS
o $connection
- An Oracle connection identifier, returned by oci_connect(3) or oci_pconnect(3).
o $username
- The Oracle user name.
o $old_password
- The old password.
o $new_password
- The new password to be set.
o $dbname
- The database name.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
oci_password_change(3) example changing the password of an already connected user
<?php
$dbase = 'localhost/orcl';
$user = 'cj';
$current_pw = 'welcome';
$new_pw = 'geelong';
$c = oci_pconnect($user, $current_pw, $dbase);
oci_password_change($c, $user, $current_pw, $new_pw);
echo "New password is : " . $new_pw . "
";
?>
Example #2
oci_password_change(3) example of connecting and changing the password in one step
<?php
$dbase = 'localhost/orcl';
$user = 'cj';
$current_pw = 'welcome';
$new_pw = 'geelong';
$c = oci_pconnect($user, $current_pw, $dbase);
if (!$c) {
$m = oci_error();
if ($m['code'] == 28001) { // "ORA-28001: the password has expired"
// Login and reset password at the same time
$c = oci_password_change($dbase, $user, $current_pw, $new_pw);
if ($c) {
echo "New password is : " . $new_pw . "
";
}
}
}
if (!$c) { // The original error wasn't 28001, or the password change failed
$m = oci_error();
trigger_error('Could not connect to database: '. $m['message'], E_USER_ERROR);
}
// Use the connection $c
?>
NOTES
Note
Changing the password either with this function or directly in Oracle should be done carefully. This is because PHP applications
may continue to successfully reuse persistent connections by authenticating with the old password. The best practice is to restart
all web servers whenever the user password is changed.
Note
If upgrading the Oracle client libraries or the database from a release prior to 11.2.0.3 to version 11.2.0.3 or higher, oci_pass-
word_change(3) may give the error "ORA-1017: invalid username/password" unless both client and server versions are upgraded at the
same time.
Note
The second oci_password_change(3) syntax is available since OCI8 version 1.1.
Note
In PHP versions before 5.0.0 you must use ocipasswordchange(3) instead. This name still can be used, it was left as alias of
oci_password_change(3) for downwards compatability. This, however, is deprecated and not recommended.
PHP Documentation Group OCI_PASSWORD_CHANGE(3)