sde无法安装案例
环境：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
·
环境：
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。
更多推荐
0
0- 0
已为社区贡献1条内容
所有评论(0)