Oracle Listener status

From: Clifford Buetikofer <clifford_buetikofer_at_merck.com>
Date: Mon, 28 Jun 1999 11:47:04 -0400
Message-ID: <377798F8.E1C690D5_at_merck.com>

[Quoted] [Quoted] Sorry for the cross-posting but I think it's appropriate in this case.

I'm running Oracle 7.3.2 on an Alpha box running OpenVMS 7.1. We're trying to think of a way to verify that the listener is up and running. The current "solutions" on the table are:

1 - Run a comfile redirecting the sys$output of LSNRTCL STATUS and then searching through the output for TNS errors.

2 - Somehow see if the process is communicating through the VMS port.

3 - Do a select on some data dictionary table to get the listener's status. ( I don't believe this data exists )

Any other ideas that we're missing ?

TIA,
Cliff

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.

Received on Mon Jun 28 1999 - 17:47:04 CEST