Re: telnet to listener

Regardless of what you are using, in order to actually determine if the Database instance is up and running you will need a logon id and password for the instance(s) relating to that listener... Your string, to be effective, would need to use SqlPlus and run some query ( or call a SP) to see if it errors out or returns data.If no errors, the database instance is up and running.

If you think you need to do this every few minutes, you need more faith in your DBAs or new DBAs...

( Or maybe they need a new sysadmin)

Rocky <PerlGuRu2b_at_bobotheclown.org> wrote:

>On Wed, 31 Mar 2004 18:57:18 +0200, Sybrand Bakker wrote:
>I am using Whats up gold to monitor my oracle DB's (I am a sysadmin not a
>DBA) and the problem with monitoring the listener or port is that
>sometimes the listener is up, but the DB is down. What's Up Gold has an
>ascii socket interface that I can send a string through. It emulates
>telnet, hence the telnet question. Sorry, perhaps I should have explained
>that to begin with.
>Rocky
>> On Wed, 31 Mar 2004 16:33:32 GMT, Rocky <PerlGuRu2b_at_bobotheclown.org>
>> wrote:
>>
>>>Anyone know what string I can send to an oracle DB while telnetted into
>>>it's listener to first connect then verify that it is alive?
>>> I would like to keep the string inexepensive as I will be sending it
>>>every couple of minutes. Thank you.
>>>Rocky
>>
>> You get exact the same feature when using tnsping.
>> And there is NO NEED WHATSOEVER to do it evey few minutes.
Received on Wed Mar 31 2004 - 13:53:17 CST