Re: Oracle9i Listener

Stanley Hopcroft <[email protected]> Wed, 31 Dec 2003 10:20:32 +1100
Newsgroups gmane.network.netsaint.user
Message-ID <[email protected]>
Dear Sir,

I am writing to thank you for your letter and say that you should be
posting to the Netsaint list and not to me _unless_ I explicity invite
you to do so.

The reasons are it is to your advantage to get replies from others to
ensure that you are getting sound and _safe_ advice; also it helps you
the writer be a bit more careful knowing that a whole bunch of people
could be reading what you say.

On Tue, Dec 30, 2003 at 02:50:27PM +0200, Pons wrote:
> I did what 'you said ...
> the hosts.cfg
> service[BSD]=TCP;0;24x7;3;5;1;freebsd-admins;120;24x7;1;1;0;;check_tcp
> in the command.cfg
> 
> command[check_tcp]=$USER1$/check_tcp $HOSTADDRESS$ -p $ARG1$
  .. snip
> command[check_users]=$USER1$/check_users $ARG1$ $ARG2$
> 
> 
> when i run the netsaint it gave me
> 
>      TCP
> 
> 
>      UNKNOWN 12-30-2003 14:46:30 0d 2h 10m 55s 3/3 check_tcp: Unknown
> argument: (null)
> 
> 
> Any suggestion!

I think you are missing the port argument in the service definition - as
suggested by the error message.

Please check the syntax (passing arguments to service checks in the
docco) but IIRC you need

service[BSD]=TCP;0;24x7;3;5;1;freebsd-admins;120;24x7;1;1;0;;check_tcp!1521

(if 1521 is the port your Oracle DB is listening on).

Before you commit the change, please

1 check the docco to make sure I am not talking through my hat

2 run the check_tcp from the command line 

<path_to_Netsaint>/libexec/check_tcp TCP_address -p 1521

Here is what I see for an Oracle host named 'oradev'

tsitc> /usr/local/nagios/libexec/check_tcp oradev -p 1521
TCP OK - 0 second response time on port 1521
tsitc> 

If in doubt, compare the results with what you get from either nmap or
telnet.

The Netsaint docco is good.
It is installed on your computer.
You must use it.

> 
> Thanks
> -Pons
> 
> 

Yours sincerely.

-- 
------------------------------------------------------------------------
Stanley Hopcroft
------------------------------------------------------------------------

'...No man is an island, entire of itself; every man is a piece of the
continent, a part of the main. If a clod be washed away by the sea,
Europe is the less, as well as if a promontory were, as well as if a
manor of thy friend's or of thine own were. Any man's death diminishes
me, because I am involved in mankind; and therefore never send to know
for whom the bell tolls; it tolls for thee...'

from Meditation 17, J Donne.


-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click