01-04-2009
Need to extract specific pattern from logfile
Log File:
Attempting to contact (DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname1.com)(PORT=1521)) )(CONNECT_DATA=(SID=database1)(SRVR=DEDICATED)))
Attempting to contact (DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname2.com)(PORT=1521)) )(CONNECT_DATA=(SID=database2)(SRVR=DEDICATED)))
Attempting to contact (DESCRIPTION_LIST=(DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname 3.com)(PORT=1521)))(CONNECT_DATA=(SID=database3)(SRVR=DEDICATED)))(DESCRIPTION=(SOURCE_ROUTE=OFF)(AD DRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname3.com)(PORT=1522)))(CONNECT_DATA=(SID=database3)(SRV R=DEDICATED))))
Attempting to contact (DESCRIPTION_LIST=(DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname 4.com)(PORT=1521)))(CONNECT_DATA=(SID=database4)(SRVR=DEDICATED)))(DESCRIPTION=(SOURCE_ROUTE=OFF)(AD DRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname4.com)(PORT=1522)))(CONNECT_DATA=(SID=database4)(SRV R=DEDICATED))))
I need output like below: I have tried regular expression /awk -- not able to get expected output (below one)
HoST PORT SID
hostname1.com 1521 database1
hostname2.com 1521 database2
hostname3.com 1522 database3
hostname4.com 1522 database4
Can someone please help me on this?
10 More Discussions You Might Find Interesting
1. HP-UX
Hello,
Below is my input file's content ( in HP-UX platform ):
ABCD120672-B21 1
ABCD142257-002 1
ABCD142257-003 1
ABCD142257-006 1
From the above, I just want to get the field of 13 characters that comes after 'ABCD' i.e '120672-B21'... . Could... (2 Replies)
Discussion started by: jansat
2 Replies
2. Shell Programming and Scripting
Hi All,
I am a newbie to Shell Scripting.
I have a File
The Server Name
XXX002
-------------------------
2.1 LAPD
Iface Id Link MTU Side
ecc_3_1 4 Up 512 User
ecc_3_2 5 Up 512 User
The Server Name
XXX003
-------------------------
2.1 LAPD (4 Replies)
Discussion started by: athreyavc
4 Replies
3. Shell Programming and Scripting
Hi ,
Can someone help me,I am not well versed with scripting,it is very urjent.
Need a script in perl or shell for the following task.
The logfile contains several entries of which one particular string to be searched and that complete line has to be removed and copied to another file to... (25 Replies)
Discussion started by: garryt21@rediff
25 Replies
4. Shell Programming and Scripting
Hi,
I need to extract <APPNUMBER> tag alone, if the <college> haas IIT Chennai value. college tag value will have spaces embedded. Those spaces should not be suppresses.
My Source file
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh suderam</name><college>IIT ... (3 Replies)
Discussion started by: Sekar1
3 Replies
5. Shell Programming and Scripting
Hello everyone,
I am on AIX (6.1). I can only use shell (ksh) script.
I can't do this on my own, so will do my best to explain my needs.I also do not know what is the best idea to make it work, so here is what I am thinking, but I may wrong.
I need help to extract info on... (3 Replies)
Discussion started by: Aswex
3 Replies
6. Shell Programming and Scripting
I have a log file like below.
66.249.73.11 - - "UCiZ7QocVqYAABgwfP8AAHAA" "US" "Mediapartners-Google" "-" www.mahashwetha.com.sg "GET... (2 Replies)
Discussion started by: Tuxidow
2 Replies
7. Shell Programming and Scripting
Any better way to extract the last 10 minutes from logfile?
Dec 18 09:41:18 aaa
Dec 18 09:46:29 aa
Dec 18 09:48:39 vvv
Dec 18 09:48:54 bbb
Dec 18 09:54:47 bbb
Dec 18 09:55:33 fcf
Dec 18 09:55:38 ssdf
Dec 18 09:57:58 sdsds
Dec 18 09:58:10 sdsd
Dec 18 10:00:50 sdsd
Dec 18... (5 Replies)
Discussion started by: timmywong
5 Replies
8. Shell Programming and Scripting
Hi
This is my first post and I'm just a beginner. So please be nice to me.
I have a couple of html files where a pattern beginning with "http://www.site.com" and ending with "/resource.dat" is present on every 241st line. How do I extract this to a new text file?
I have tried sed -n 241,241p... (13 Replies)
Discussion started by: dejavo
13 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have logfile like this..
=== 2014-02-09 15:46:59,936 INFO RequestContext - URL: '/eyisp/sc/skins/EY/images/pickers/comboBoxPicker_Over.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko': Unsupported with Accept-Encoding header
=== 2015-02-09... (8 Replies)
Discussion started by: kishk
8 Replies
10. Shell Programming and Scripting
Hello.
Here is a file contents :
declare -Ax NEW_FORCE_IGNORE_ARRAY=(="§" ="§" ="§" ="§" ="§" .................. ="§"Here is a pattern
=I want to extract 'NEW_FORCE_IGNORE_ARRAY' which is the whole word before the first occurrence of pattern '='
Is there a better solution than mine :... (3 Replies)
Discussion started by: jcdole
3 Replies
LEARN ABOUT DEBIAN
log::agent::file::rotate
File::Rotate(3pm) User Contributed Perl Documentation File::Rotate(3pm)
NAME
Log::Agent::File::Rotate - a rotating logfile set
SYNOPSIS
#
# This class is not user-visible.
#
# It is documented only for programmers wishing to inherit
# from it to further extend its behaviour.
#
require Log::Agent::Driver::File;
require Log::Agent::Rotate;
require Log::Agent::File::Rotate;
my $config = Log::Agent::Rotate->make(...);
my $driver = Log::Agent::Driver::File->make(...);
my $fh = Log::Agent::File::Rotate->make("file", $config, $driver);
DESCRIPTION
This class represents a rotating logfile and is used drivers wishing to rotate their logfiles periodically. From the outside, it exports a
single "print" routine, just like "Log::Agent::File::Native".
Internally, it uses the parameters given by a "Log::Agent::Rotate" object to transparently close the current logfile and cycle the older
logs.
Before rotating the current logfile, the string:
*** LOGFILE ROTATED ON <local date>
is emitted, so that people monitoring the file via "tail -f" know about it and are not surprised by the sudden stop of messages.
Its exported interface is:
make file, config
This is the creation routine. The config object is an instance of "Log::Agent::Rotate".
print args
Prints args to the file. After having printed the data, monitor the file against the thresholds defined in the configuration, and
possibly rotate the logfiles according to the parameters held in the same configuration object.
When the "is_alone" flag is not set in the configuration, the logfile is checked everytime a "print" is issued to see if its inode
changed. Indeed, when several instances of the same program using rotating logfiles are running, each of them may decide to cycle the
logs at some point in time, and therefore our opened handle could point to an already renamed or unlinked file.
AUTHORS
Originally written by Raphael Manfredi <Raphael_Manfredi@pobox.com>, currently maintained by Mark Rogaski <mrogaski@pobox.com>.
SEE ALSO
Log::Agent::Rotate(3), Log::Agent::Driver::File(3).
perl v5.10.0 2002-05-14 File::Rotate(3pm)