Re: [Richard Schwaninger <address@hidden>] monit for AIX

[Oliver Jehle]

Hi Jan-Hendrik

there are ports, but they can be multiplexed ... so you have for example,
3 oracle instances sitting on one listener processes.. not usual, but seen
on
small installations.... the real problem is, that the port is available,
but the database isn't.... thats why i told, try to access to find out if
it works.... you can start a listener without a database, no problem, or
the database crashes, but the listener not... you always get a port is up,
but database not.... it's also possible to work without ports, only over
shared memory...

to really check, if an oracle is up, you have to select something from....

but i think, thats not the problem :-)) to find it out if it works...

i think, it can be a simple shell script... ksh or sh for example .... its
not essential to have perl installed only for that... but i will check it
and come back with a solution....

so... now i will leave for really important things......  :-)



> Oliver Jehle <address@hidden> writes:
>
>> Problem is, oracle has an own process called tnslsnr who spawns the
>> dedicated servers for users ..... there is a middle tier in network
>> communcations like sql-net of sybase ....
>
> I see, but surly there must be ports to check? Anyhow, it seems that the
> tnslsnr process then is the one to monitor and do port checking against?
> (It has been many years since I worked with Oracle and I have forgotten
> most of it. I'm more a Sybase man myself, but unfortunately it has been
> a few years since I worked with Sybase also, now)
>
>> but if you work with the commandline utilities, you can proper check
>> the state.Make first a "tnsping" to check if oracle network listener
>> response, and a simple select like "select sysdate from dual " to get
>> shure the database is responding..
>
> Yep, but psql or what the commandline utility is called for connecting
> to an Oracle server for query will use tcp/ip and connect to a port.
> What I'm trying to say is that monit can connect to this port as well to
> check that the server is up and running and if you care to
> implement the text based protocol used for a query connect (on sybase I
> think this protocol is called tds) you can even implement a protocol
> check like we have done for ftp, http, nntp and so on.
>
>> but i will try to send you a start/stop  wrapper for different
>> proposes...
>>
>> not only for oracle......  writing the process id to a rc file to
>> check and implements periodic checks for the resource....  if not
>> available, go away and let monit do restart...
>>
>> i'm very busy this week, because we celebrate
>> "Fasnacht/Fasching/Karneval" and so, i have to spent more time there
>> with drinking beer than in the office :-)
>
> Of course! It's important to prioritize the essential stuff :-)
>
>> but i will try to send a sample next week... (after learning
>> perl-syntax)...
>
> I used to write Perl programs a couple of years ago and I do not think I
> have forgotten everything and I'll be happy to check it out. I have a
> feeling that Rory also is pretty good with Perl, so together we can
> probably cook up a decent script, or what do you think Rory?
>
> --
> Jan-Henrik Haukeland
>
>
> _______________________________________________
> monit-dev mailing list
> address@hidden
> http://mail.nongnu.org/mailman/listinfo/monit-dev