RE: Checking DB Status in NT env.
> select 'PING' from dual; How very clever Mark. ;) Jared "Mark Leith" ls.co.uk>cc: Sent by: Subject: RE: Checking DB Status in NT env. [EMAIL PROTECTED] om 11/28/01 01:40 AM Please respond to ORACLE-L connect scott/tiger@sid select 'PING' from dual; If you receive an output from the database you can pretty much say it's up and running don't you think? If you get an error anywhere along this path - you have a problem.. Mark -Original Message- Sent: 27 November 2001 19:55 To: Multiple recipients of list ORACLE-L Hi Is there any easy way for our operator to check db status on NT env. any clue? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Checking DB Status in NT env.
How about oem using the dbupdown predefined event. [EMAIL PROTECTED] wrote: >connect scott/tiger@sid > >select 'PING' from dual; > >If you receive an output from the database you can pretty much say it's up >and running don't you think? If you get an error anywhere along this path - >you have a problem.. > >Mark > >-Original Message- >Sent: 27 November 2001 19:55 >To: Multiple recipients of list ORACLE-L > > >Hi > >Is there any easy way for our operator to check db status on NT env. any >clue? > > >Mitchell > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: mitchell > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Checking DB Status in NT env.
connect scott/tiger@sid select 'PING' from dual; If you receive an output from the database you can pretty much say it's up and running don't you think? If you get an error anywhere along this path - you have a problem.. Mark -Original Message- Sent: 27 November 2001 19:55 To: Multiple recipients of list ORACLE-L Hi Is there any easy way for our operator to check db status on NT env. any clue? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Checking DB Status in NT env.
Title: RE: Checking DB Status in NT env. Yea. Connect to the database. If you can connect quickly, you can be sure that most everything is OK. Lisa Koivu Oracle Database Monkey Mama with the Big Wide Booty. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: mitchell [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 2:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: Checking DB Status in NT env. Hi Is there any easy way for our operator to check db status on NT env. any clue? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Checking DB Status in NT env.
Hi Is there any easy way for our operator to check db status on NT env. any clue? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
