连接sde,报ora 24344，Execute privilege for required Oracle builtin package DBMS_PIPE

转自：https://blog.csdn.net/hzfu007/article/details/24719889

场景：

没有装sde软件，直接把之前的sde用户数据导入到oracle11g中。

数据导完，后在catalog中连接sde时报：

Failed to connect to the specified server. Do you want to continue?

Underlying DBMS error[ORA-24344: 成功, 但出现编译错误
Execute privilege for required Oracle builtin package DBMS_PIPE must be directly granted for the SDE DBA user, granting them a ROLE with execute access is insufficient.

解决方案：

用sys用户登录，在sql命令行下运行：

GRANT EXECUTE ON dbms_pipe TO public;
GRANT EXECUTE ON dbms_lock TO public;