Hi. I need to trace on Unix level number of connections to an Oracle database. The listener runs on port 1521.
The following is run:
I need to append these values into a text file every 5 mins through cron. That part works. The problem I am having is getting rid of the "IPv4" string. I just need number of connections and nothing else:
87
88
87
How do I change the statement so it only returns the numbers?
Thanks.
Last edited by vbe; 03-24-2011 at 05:54 AM..
Reason: Please use code tags
I've got a diff command running in a shell script that writes the ouput to a new file. In the new file there is a ">" at the beginning of each line. The output file is going to be used by another program and that character makes the file useless.
What I'm getting in the new file:
> 2007-09-27... (5 Replies)
Hi every1
Well i have a list of numbers e.g
12304
13450
01234
00123
14567
what i want is a command to check if the number is starting from 0 and then delete the 0 without doing anything else!!!!
any help wud b appreciated!!!!!!!!:( (4 Replies)
Hi
how to replace un wanted new line characters.
my file contains data like.
ramu,sony,"raju \n ravi \n ramya" \n
ravi,sarah,"sowmya \n sorry s\ sangam" \n
i want replace new line characters in between double coats with single space.
for example
$ cat input_file
ramu,sony,"raju... (3 Replies)
Hi All,
I wanted to delete all the unwanted characters in the string. ie, to delete all the characters which are not alpha numeric values.
var1="a./bc"
var2='abc/\."123'
like to get the output as
print var1
abc
print var2
abc123
Could you guys help me out pls.
Your help is... (3 Replies)
i have a file like this
1111_2222#$#$dudgfdk
11111111_343434#$#$334
1111_22222#43445667
i want to remove all those charachetrs from #
how can i do this
Thank in advance
Saravanan (4 Replies)
Hi all,
i am just a beginner in shell. Need some code for my problem.
SCENARIO
I have 2 directories. Let A,B.
Everyday files from directory A are compressed and moved to B.(already got the script).
In directory A
abc.doc
def.exe
ghi.c
jkl.pl
In directory B
abc.tar.gz... (1 Reply)
Hi,
I have a file that has data in the following manner,
tt_0.00001.dat 123.000
tt_0.00002.dat 124.000
tt_0.00002.dat 125.000
This is consistent for all the entries in the file. I want to delete the 'tt_' and '.dat' from each line. Could anyone please guide me how to do this using awk or... (2 Replies)
so i have strings such as this:
'postfix/local#2,5#|CRON.*12062.*root.*CMD#2,5#|roice.*NQN1#1,2#|toysprc#1,4#'
i need to get rid of the "#" and the numbers between them for each of the strings above. so the desired output should be:
... (1 Reply)
I wrote myself a small little shell script to clean up a file I have issues with. In particular, I am stripping down a fully qualified host/domain name to just the hostname itself. The script works, but from a performance standpoint, it's not very fast and I will be working with large data sets.
... (4 Replies)
My sed is not working on deleting the entire special characters and leaving what is necessary.grep connections_per a|sed -e 's/\<\!\-\-//g'
INPUT:
<!-- <connections_per_instance>1</connections_per_instance> -->
<method>HALF</method>
<!--... (10 Replies)
Discussion started by: kenshinhimura
10 Replies
LEARN ABOUT DEBIAN
netstat-nat
netstat-nat(1) General Commands Manual netstat-nat(1)NAME
netstat-nat - Show the natted connections on a linux iptable firewall
SYNOPSIS
netstat-nat [options]
DESCRIPTION
netstat-nat Displays NAT connections managed by netfilter/iptables which comes with the > 2.4.x linux kernels.
The program reads its information from '/proc/net/ip_conntrack' or '/proc/net/nf_conntrack', which is the temporary conntrack-storage of
netfilter.
OPTIONS -h displays help
-n don't resolve IPs/portnumbers to host/portnames
-p <protocol>
display NAT connections with protocol selection (see /etc/protocols)
-s <source host>
display connections by source IP/hostname
-d <destination host>
display connections by destination IP/hostname
-S display SNAT connections
-D display DNAT connections
-L display only connections to NAT box self (doesn't show SNAT & DNAT)
-R display only connections routed through the NAT box (doesn't show SNAT & DNAT)
-x extended view of hostnames
-r <src|dst|src-port|dst-port|state>
sort connections
-o no output header
-N display NAT box connection information (only valid with SNAT & DNAT)
-v prints version
FILES
/proc/net/ip_conntrack or /proc/net/nf_conntrack
SEE ALSO
http://www.tweegy.nl/projects/netstat-nat/
http://www.netfilter.org/
AUTHOR
netstat-nat has been written by D.Wijsman danny@tweegy.nl
The manual page has been written by marceln@xs4all.nl
July 2002 netstat-nat(1)