FYI: useful oracle 8.1.X utility

Hi Listers,

Platform : Oracle 8.1.X on Unix systems                 

In Oracle 8.1.X, to find IPC resources (shared memory segments,semaphores) used by one or more instances,  there is now a new utility : sysresv
(located in $ORACLE_HOME/bin).

usage : sysresv [-if] [-d <on/off>] [-l sid1 <sid2> ...]

-i : Prompt before removing ipc resources for each sid
-f : Remove ipc resources silently, oevrrides -i option
-d <on/off> : List ipc resources for each sid if on
-l sid1 <sid2> .. : apply sysresv to each sid
Default : sysresv -d on -l $ORACLE_SID
Note : ipc resources will be attempted to be deleted for a

              sid only if there is no currently running instance
              with that sid.

 If you are not running version 8.1.x use svrmgrl  in the following way for each of your instance :

             svrmgr> connect internal
             svrmgr> oradebug ipc

Hope this can help.

Happy new year to all

Gilles Parc
Email : gparc_at_mail.dotcom.fr Received on Thu Dec 28 2000 - 11:53:33 CST