连接sde报Execute privilege for required Oracle builtin package DBMS_PIPE must be directly granted for。。

场景：

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

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

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

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;

问题解决。