连接sde问题

场景：

没有装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;