ArcSDE服务启动 No execute privilege for required Oracle builtin package DBMS_PIPE

ArcSDE启动时报如下图所示错误

经排查sde日志（sde_esri_sde.log）发现有如下的错误提示

-------------------------------------------------------
ArcSDE 10.0  for Oracle11g Build 685 Fri May 14 12:05:43  2010
-------------------------------------------------------


ST_Geometry Schema Owner: (SDE) Type Release: 1007
Instance initialized for ((sde)) . . .


Connected to instance . . .
No execute privilege for required Oracle builtin package DBMS_PIPE.
ERROR in checking system stored procedures (-25).

上面日志提到了缺少DBMS_PIPE权限 可能导致了无法执行某些存储过程

在oracle客户端软件 PL/SQL、或者sqlplus中 以sys用户登录 执行下面的语句  

grant execute on dbms_pipe to sde;
grant execute on dbms_lock to sde;

经测试发现执行了上面语句赋予sde用户权限后 ArcSDE服务能够成功启动