Quoting Orlando Andico <[EMAIL PROTECTED]>: > On Thu, 24 Jul 2003, Ako Ito wrote: > .. > > thanks.. also planning of doing it by the port checking by tcp.. but > > sometimes it may happen specially on an oracle database systems that the > > port is listening but the actual instance or database is down. dont know > > if this is applicable on a sybase database.. thanks for the quick > > response guys.. > > well for Oracle it's better to connect to the DB via a perl script, do a > simple "SELECT SYSDATE FROM DUAL" that way if the instance is down, you > will know even if the listener is running. > make sure you install the Oracle client software (Net8 or equivalent).
----------------------------------------------- William Emmanuel S. Yu Ateneo Campus Network Group (AteneoCNG) email : wyu at ateneo dot edu web : http://CNG.ateneo.net/cng/wyu/ phone : +63(2)4266001-4186 GPG : http://CNG.ateneo.net/cng/wyu/wyy.pgp -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
