During the setup process, the installation from the client needs access to the sys.dbma_pipe object in order to succeed. Sometimnes this is locked by a database process, requiring a bounce of the DB resolve. Where we will be installing on a production system, and downtime is hard to negotisate, is theer any way to determine whethjer there is a lock on sys.dbms_pipe prior to installation? If so, is theer any way to clear the connection so the installation of Space Mgr can succeed?
This will tell you if a package is locked:
select
x.sid
from
v$session x, v$sqltext y
where
x.sql_address = y.address
and
y.sql_text like '%DBMS_PIPE%';