I've asked our DBAs if TNSPing is sufficient to tell if the database is up and running, or if an established database connection would be better. Without doing some testing, they can't remember, but think there are a couple possible situations where TNSPing will succeed but the database isn't in a usable state.
Brett Hanson Systems Analyst, Agrium Inc. -----Original Message----- From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Bulinckx Sent: Monday, February 05, 2007 10:50 AM To: Servers Alive Discussion List Subject: [SA-list] Oracle & TNSPing Question for those of you that are using Oracle. Currently Servers Alive is able to do an Oracle check by using the Oracle OLE objects and doing a login to the Oracle db. Do you get situations were doing a login is too much/not accepted and that a TNSPing would be better? Dirk Bulinckx. To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected] If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list. To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected] If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list. IMPORTANT NOTICE ! This E-Mail transmission and any accompanying attachments may contain confidential information intended only for the use of the individual or entity named above. Any dissemination, distribution, copying or action taken in reliance on the contents of this E-Mail by anyone other than the intended recipient is strictly prohibited and is not intended to, in anyway, waive privilege or confidentiality. If you have received this E-Mail in error please immediately delete it and notify sender at the above E-Mail address. Agrium uses state of the art anti-virus technology on all incoming and outgoing E-Mail. We encourage and promote the use of safe E-Mail management practices and recommend you check this, and all other E-Mail and attachments you receive for the presence of viruses. The sender and Agrium accept no liability for any damage caused by a virus or otherwise by the transmittal of this E-Mail. IMPORTANT NOTICE To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected] If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list.
