环境
ArcGIS10.x for Desktop、Oracle11g
问题
使用ArcGIS 10.x for Desktop的Create Enterprise Geodatabase工具创建企业级地理数据库,出现错误:
Executing: EnableEnterpriseGeodatabase "Database Connections\Connection to 10.20.128.230.sde" D:\GIS\authorization_E25C99B4.ecp
Start Time: Wed Dec 03 11:57:19 2014
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
Created geodatabase tables and stored procedures.
The geodatabase system table could not be created.GDB_Items : Error (-51)
See the setup log in the following location for additional error information:
D:\Users\TANGYA~1\AppData\Local\Temp\sde_setup.log
Could not create geodatabase schema.
Failed to execute (EnableEnterpriseGeodatabase).
Failed at Wed Dec 03 12:00:50 2014 (Elapsed Time: 3 minutes 30 seconds)
查看信息提供的sde_setup.log文件提示:
[Tue Dec 16 20:28:03 2014] Error creating GDB_Items table...
[Tue Dec 16 20:28:03 2014] ERROR Creating Geodatabase tables , Error = -511 ,EXT_Error = 29855
,EXT_ERROR1 = ORA-29855: ??? ODCIINDEXCREATE ????????????
ORA-20000: oracle Text ????:
DRG-50857: oracle error in drstldef
DRG-50858: OCI error: OCI_INVALID_HANDLE
DRG-50857: oracle error in get functional cache size
ORA-06512: ?? "CTXSYS.DRUE", line 160
ORA-06512: ?? "CTXSYS.TEXTINDEXMETHODS", line 366
解决方案:详见 积思园
ArcGIS10.x for Desktop、Oracle11g
问题
使用ArcGIS 10.x for Desktop的Create Enterprise Geodatabase工具创建企业级地理数据库,出现错误:
Executing: EnableEnterpriseGeodatabase "Database Connections\Connection to 10.20.128.230.sde" D:\GIS\authorization_E25C99B4.ecp
Start Time: Wed Dec 03 11:57:19 2014
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
Created geodatabase tables and stored procedures.
The geodatabase system table could not be created.GDB_Items : Error (-51)
See the setup log in the following location for additional error information:
D:\Users\TANGYA~1\AppData\Local\Temp\sde_setup.log
Could not create geodatabase schema.
Failed to execute (EnableEnterpriseGeodatabase).
Failed at Wed Dec 03 12:00:50 2014 (Elapsed Time: 3 minutes 30 seconds)
查看信息提供的sde_setup.log文件提示:
[Tue Dec 16 20:28:03 2014] Error creating GDB_Items table...
[Tue Dec 16 20:28:03 2014] ERROR Creating Geodatabase tables , Error = -511 ,EXT_Error = 29855
,EXT_ERROR1 = ORA-29855: ??? ODCIINDEXCREATE ????????????
ORA-20000: oracle Text ????:
DRG-50857: oracle error in drstldef
DRG-50858: OCI error: OCI_INVALID_HANDLE
DRG-50857: oracle error in get functional cache size
ORA-06512: ?? "CTXSYS.DRUE", line 160
ORA-06512: ?? "CTXSYS.TEXTINDEXMETHODS", line 366
解决方案:详见 积思园
遇到使用ArcGIS10.x for Desktop创建企业级地理数据库时,与Oracle11g连接出现问题,导致创建失败。通过分析sde_setup.log文件,发现错误源于ODCIINDEXCREATE函数在数据库实例中遇到问题。解决方案涉及排查数据库权限和功能缓存大小,并最终成功创建地理数据库。
2109

被折叠的 条评论
为什么被折叠?



