分享

2015-11-28

環境：

ORACLE 10.2.0.1.0 arcsde9.2 LINUX REDHAT4.7的服務器

用戶現在安裝SDE時，在執行 sdesetup -o install -d ORACLE10G -p sde 命令時，總是提示：

Error: Insufficient permissions (-25). Error: SDE release install not completed. Check SDEHOME/etc/sde_setup.log for more details.

從表面上看，是缺少權限，但是具體缺少哪個權限還不清楚，查看日志，

1:

[Sat Nov 7 00:37:51 2009]

2:

ST_Geometry Schema Owner: () Type Release: 0

3:

[Sat Nov 7 00:37:51 2009] Instance initialized for

((sde)) . . .

4:

[Sat Nov 7 00:37:53 2009] VERSION table created...

5:

[Sat Nov 7 00:37:53 2009] SPATIAL_REFERENCES table being created...

6:

[Sat Nov 7 00:37:53 2009] SPATIAL_REFERENCES table created...

7:

[Sat Nov 7 00:37:53 2009] GEOMETRY_COLUMNS table being created...

8:

[Sat Nov 7 00:37:53 2009] GEOMETRY_COLUMNS table created...

9:

[Sat Nov 7 00:37:53 2009] LAYERS table being created...

10:

[Sat Nov 7 00:37:53 2009] LAYERS table created...

11:

[Sat Nov 7 00:37:53 2009] METADATA table being created...

12:

[Sat Nov 7 00:37:54 2009] METADATA table created...

13:

[Sat Nov 7 00:37:54 2009] RASTER_COLUMNS table being created...

14:

[Sat Nov 7 00:37:54 2009] RASTER_COLUMNS table created...

15:

[Sat Nov 7 00:37:54 2009] TABLE_REGISTRY table being created...

16:

[Sat Nov 7 00:37:54 2009] TABLE_REGISTRY table created...

17:

[Sat Nov 7 00:37:54 2009] COLUMN_REGISTRY table being created...

18:

[Sat Nov 7 00:37:54 2009] COLUMN_REGISTRY table created...

19:

[Sat Nov 7 00:37:54 2009] STATES table being created...

20:

[Sat Nov 7 00:37:54 2009] STATES table created...

21:

[Sat Nov 7 00:37:54 2009] VERSIONS table being created...

22:

[Sat Nov 7 00:37:54 2009] VERSIONS table created...

23:

[Sat Nov 7 00:37:54 2009] MVTABLES_MODIFIED table being created...

24:

[Sat Nov 7 00:37:54 2009] MVTABLES_MODIFIED table created...

25:

[Sat Nov 7 00:37:55 2009] STATE_LINEAGES table being created...

26:

[Sat Nov 7 00:37:56 2009] STATE_LINEAGES table created...

27:

[Sat Nov 7 00:37:56 2009] LOCATORS table being created...

28:

[Sat Nov 7 00:37:56 2009] LOCATORS table created...

29:

[Sat Nov 7 00:37:56 2009] XML tables being created...

30:

[Sat Nov 7 00:37:57 2009] XML tables created...

31:

[Sat Nov 7 00:37:57 2009] Instances tables being created...

32:

[Sat Nov 7 00:37:57 2009] Instances tables created...

33:

[Sat Nov 7 00:37:57 2009] ARCHIVES table being created...

34:

[Sat Nov 7 00:37:57 2009] ARCHIVES table created...

35:

[Sat Nov 7 00:37:58 2009] LOGFILE_POOL tables being created...

36:

[Sat Nov 7 00:37:58 2009] SQL Stmt: 'MINSTANDALONELOGS' >

37:

[Sat Nov 7 00:37:58 2009] SQL Stmt: 'MAXSTANDALONELOGS' >

38:

[Sat Nov 7 00:37:58 2009] SQL Stmt: 'LOGFILEPOOLSIZE' >

39:

[Sat Nov 7 00:37:58 2009] SQL Stmt: 'ALLOWSESSIONLOGFILE' >

40:

[Sat Nov 7 00:37:58 2009] LOGFILE_POOL tables created...

41:

[Sat Nov 7 00:38:00 2009] DBTUNE table being created...

42:

[Sat Nov 7 00:38:00 2009] DBTUNE table created...

43:

[Sat Nov 7 00:38:00 2009] SERVER_CONFIG tables being created...

44:

[Sat Nov 7 00:38:00 2009] SERVER_CONFIG tables created...

45:

[Sat Nov 7 00:38:00 2009] SDENUMTAB type being created...

46:

[Sat Nov 7 00:38:00 2009] SDENUMTAB type created...

47:

[Sat Nov 7 00:38:00 2009] No execute privilege for

required Oracle builtin package DBMS_PIPE.

48:

[Sat Nov 7 00:38:00 2009] SDE schema object

install not completed.

49:

[Sat Nov 7 00:38:00 2009] ERROR installing/upgrading ArcSDE, Error = -25

從日志中看出缺少dbms_pipe包的權限，

給sde或者public用戶賦予dbms_pipe包的執行權限

grant execute on dbms_pipe to public;后OK。

附:

dbms_pipe是oracle自己定義的包對象，可以在不同的session之間傳遞信息。

在ArcSDE中只有PINFO_UTIL這個包使用了dbms_lock，目的是在不同的session中傳遞ID。

文章來源：http://blog.csdn.net/liufeng1980423/article/details/6076817

總結

以上是生活随笔為你收集整理的oracle sde 安装失败,sde无法安装案例的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。