broadcast message

[ziad_4]

hello everybody,

I have an Oracle database in a tru64 unix system, users use their PCs to connect to the database ( through SQL*PLUS tool).
How can i send them a message from the server that i want to shutdown the database or making other operations?

[Ralf Puchner]

if using samba there is a smb send command included.

[Hein van den Heuvel]

I don't think Oracle will be able to offer you a 'callback' service. Actitivies a re strictly initiated by the clients, not the servers.

It would be easy enough to display a message for a starting up sqlplus through through glogin.sql. Just select text from a pre-defined centrasl place.

For a long runnning sqlplus you would need a serverside script to query v$session and v$process and then use a non-oracle tool (Like the smb Ralf mentions) to send messages based on the result of the query (smop: perl!).

Good luck,
Hein.

olumn id format 999;
column Local format 99999;
column Remote format 99999;

column Node format a9;
column Local_Program format a20;
column Remote_Program format a24;
set pages 9999;

select pid "Id", spid "Local", process "Remote",
s.machine "Node", SUBSTR(p.program,1,20) "Local Program",
SUBSTR(s.program,1,24) "Remote Program"
from v$process p, v$session s
where addr = paddr
order by machine, spid
/