Re: Messaging all connections through SQL*NET

Simon Spencer (sspencer_at_trl.oz.au) wrote:

: This may be a silly question but...
 

: When we need to take the database down we need a means of notifying all client connections to get off, and that the
: system is going down.
 

: How is this best done, considering that our clients are windows based workstations using a VB client and SQL*Net
: to access a HP server (oracle 7)
 

: Thanks
 

: Simon Spencer

R your HP server running 24 hours or on a scheduled shutdown ? Normally, u can trigger an auto-shutdown of ORACLE after work hours where u r pretty sure there ain't anybody logging on. This would have to work hand-in-hand with your HP downtime. ORACLE has auto startup/ shutdown scripts that can incorporate into your HP's init dir. This way, u need not even worry about messaging.

I don't think SQL*NET can do messaging. Presumably if u r running TCP/IP as the network protocol, u can probly use wall command from unix to notify all logged-in users running VT220 mode.

Cheers.

--
===============================================================================
Jimmy CHEONG Chin Yeow				Education Data Centre
Systems Programmer				Ministry of Education
Telephone	:+65 4713949 (pager 2094375)	Kay Siang Road, S'pore (1024)	
Internet	:eio_at_moe.ac.sg               "Efficiency is not about 
Fax		:+65 4737513        working hard, but good TIME MANAGEMENT!"