When does the Oracle library for st_shapelib.dll need to be changed?
Oracle for to The be dll does when
2023-09-14 09:01:05 时间
The library is the path for Oracle to locate the external .dll file used by st_geometry functions an
The library is the path for Oracle to locate the external .dll file used by st_geometry functions and operators with Oracles external process.
To identify the st_shapelib librarys current location in Oracle, execute the following SQL statement, as the SDE user, in SQL*Plus:
If for any reason the path to the library must be changed, for example, the administrator moves the file location for SDEHOME or an Oracle export file is being imported from another instance where the path to the st_shapelib.dll is different, then the library specification must be updated to match the correct location of the st_shapelib.dll. A possible indicator as to when the library location may need to be updated is when the following error message is encountered when executing a st_geometry function or operator (the error is an indicator that the value for the specified library location may be invalid).
To fix the problem, update the library path in SQL*Plus, as the SDE user, by setting the file directory to the location where the st_shapelib.dll resides.
The library is the path for Oracle to locate the external .dll file used by st_geometry functions and operators with Oracles external process.
To identify the st_shapelib librarys current location in Oracle, execute the following SQL statement, as the SDE user, in SQL*Plus:
SQL SELECT library_name, file_spec FROM user_libraries; LIBRARY_NAME FILE_SPEC ------------ -------------------------------------------- ST_SHAPELIB D:\ESRI\ArcSDE\ora10gexe\bin\st_shapelib.dllThe value for file_spec must match the st_shapelib.dlls physical file location on the server. If it does not match, st_geometry operators and functions fail to execute.
If for any reason the path to the library must be changed, for example, the administrator moves the file location for SDEHOME or an Oracle export file is being imported from another instance where the path to the st_shapelib.dll is different, then the library specification must be updated to match the correct location of the st_shapelib.dll. A possible indicator as to when the library location may need to be updated is when the following error message is encountered when executing a st_geometry function or operator (the error is an indicator that the value for the specified library location may be invalid).
SQL SELECT sde.st_astext(shape) FROM sewers WHERE objectid = 10; ERROR: ORA-06520: PL/SQL: Error loading external library ORA-06522: Unable to load DLL ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 70 ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 68
To fix the problem, update the library path in SQL*Plus, as the SDE user, by setting the file directory to the location where the st_shapelib.dll resides.
SQL CREATE OR REPLACE LIBRARY st_shapelib 2 AS C:\Program Files\ESRI\ArcSDE\ora11gexe\bin\st_shapelib.dll; Library created.Creating the library causes dependent objects to become invalid. Oracle best practices recommend all objects should be compiled and valid. To ensure all objects are valid in the SDE schema, execute the following command as the SDE user:
EXECUTE sys.utl_recomp.recomp_serial(SDE); PL/SQL procedure successfully completed.
Verify all objects are valid.
SQL SELECT object_name FROM user_objects WHERE status = INVALID; no rows selected
相关文章
- ORA-23477: unable to alter propagation mode for object group “string”.”string” ORACLE 报错 故障修复 远程处理
- ORA-27167: Attempt to determine if Oracle binary image is stored on remote server failed ORACLE 报错 故障修复 远程处理
- ORA-39092: unable to set SCN metadata for object “string.string” of type string ORACLE 报错 故障修复 远程处理
- ORA-47261: Realm Authorization to string for Realm string not found ORACLE 报错 故障修复 远程处理
- ORA-09960: Unable to establish signal handler for termination signal ORACLE 报错 故障修复 远程处理
- ORA-13039: failed to update spatial index for element string.string.string ORACLE 报错 故障修复 远程处理
- ORA-13283: failure to get new geometry object for conversion in place ORACLE 报错 故障修复 远程处理
- ORA-13523: unable to allocate required space for return type ORACLE 报错 故障修复 远程处理
- ORA-17621: failed to register the memory with Oracle Disk Manager library ORACLE 报错 故障修复 远程处理
- Oracle 视图 USER_ENCRYPTED_COLUMNS 官方解释,作用,如何使用详细说明
- Oracle管理:更高效的系统运行(oracle管理系统)
- Oracle操作的必备工具:一次性解决多个问题(oracle操作工具)
- 探索Oracle中大小比较函数的应用(oracle大小比较函数)
- 深入理解Oracle触发器类型(oracle触发器类型)
- Ensuring Data Protection: A Guide to Oracle Guard for Businesses(oracleguard)
- How to Easily Establish an Oracle Database Connection with These Simple Connection Statements(oracle连接语句)
- Efficient and Effective: Mastering Oracle Batch Updates for Streamlined Data Management(oracle批量更新)
- 探索Oracle的Scott账户:了解其历史、作用和特点(oracle的scott)
- Oracle让合计列变得更简单(oracle合计列)
- Oracle记录体育运动员成绩的字段研究(oracle体育成绩字段)
- Oracle在中国的发展形势(oracle中国现状)
- 利用Oracle TO函数实现数据转换(oracle to_函数)
- Oracle HS空前振兴,获得圆满成功(oracle hs=ok)