Re: Oracle Hung during Shutdown

Jim Gregory <jim.gregory_at_DaytonOH.attgis.com> wrote:
>We're having a similar problem occasionally with 7.0 on AT&T 35xx boxes where
>a shutdown immediate hangs. I looked in the dbms_pipe procedures and there's
>a purge function but it requires the actual name of the pipe. How would we
>get the name of the pipe?
>
>This shutdown/hang occurs in a cron process where we shutdown the DB's for
>cold backups. How could we get the pipe names in order to purge them prior to
>issuing the shutdown immediate command?
>
>TIA
>Jim Gregory
>

create and use the following view to look at all dbms_pipes open in sga .  

	CREATE OR REPLACE VIEW OPEN_PIPES (pipename) AS 
        SELECT DISTINCT SUBSTR(kglnaobj,1,128) 
        FROM x$kglob 
        WHERE kglhdnsp = 7 
          AND kglobtyp = 18 
          AND SUBSTR(kglnaobj,1,9) <> 'ORA$ALERT'; 
 

-- 
Ted Alexander (tealexan_at_ca.oracle.com)
Oracle Canada Technical Support