- 错误现象:
将已有的一个ArcGIS数据库的sde用户数据导入到新建的oracle11g中,数据导完后,在catalog中创建连接到新库时报错:
连接到数据库失败。
基础 DBMS 错误[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.
]
- 解决办法:
登录dba用户,执行如下sql命令:
GRANT EXECUTE ON dbms_pipe TO public;
GRANT EXECUTE ON dbms_lock TO public;