Error Checking System St_geometry Type 1
Error (100, retrieving bind info for query) ogg目标端重新同步表 logdump查找 更多文章>> 日志正文 sde Geodatabase tool to upgrade system tables 2013-01-29 16:12 阅读(?)评论(0)编辑删除 http://blog.sina.com.cn/s/blog_681b9c910100q5cc.html http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n000000p8000000.htm http://forums.arcgis.com/threads/1197-Beta-10-Geodatabase-upgrade-feedback Win7+ArcSDE10 +Oracle11g,均为64位。安装了sde10 的sp1补丁后发现SDE连接无法启动,查看日志,提示信息:-------------------------------------------------------ArcSDE 10.0 for Oracle11g Build 775 Fri Sep 1711:45:27 2010-------------------------------------------------------ST_Geometry Schema Owner: (SDE) Type Release: 1007Instance initialized for ((sde)) . . .Connected to instance . . .ERROR in checking system st_geometry type (1).Error checking the existence of system tables. Runthe Upgrade Geodatabase tool to install/upgrade system tables(-450).Refer ArcSDE installation guide for instructions. 好像是需要升级系统表,提示用Upgrade Geodatabase tool ,于是打开GP工具 Update Geodatabase运行,选择连接时发现,sde没有启动,sde连接文件打不开,GP运行失败!怎么办??看服务Oracle正常启动没有问题,那就用Oracle 直连!正常连接!再运行GP工具Update Geodatabase ,选择这个直连连接,执行。。。OK。。。再次启动SDE服务,正常!Upgrading an ArcSDE geodatabase in OracleResource Center Beginning withArcGIS 10, geodatabases are upgraded using the Upgrade Geodatabasegeoprocessing tool or Python script. Therefore, you must have thecurrent version of ArcGIS Desktop, ArcGIS Engine, or ArcGIS Serverinstalled on the computer from which you will run the upgrade becausethese applications can run the geoprocessing tool or Python script.Caution: If you havegeodatabases in the schemas of users other than the sde user, you mustfirst upgrade the sde master geodatabase, then upgrade each of thegeodatabases in the other users' schemas. Each geodatabase is upgradedsepa
for Developers Tools to build location-aware apps ArcGIS Solutions Free template maps and apps for your industry ArcGIS Marketplace Get apps and data for your organization Documentation Pricing Support Esri Sign In user My Profile Sign Out Go Help HomeGet StartedMapAnalyzeManage DataToolsMore... Use a Python script to create the ST_Geometry type in Oracle You can add the ST_Geometry type, subtype, and functions to your Oracle database using a Python script that calls the CreateSpatialType ArcPy function.When you do, a user named sde http://orax.blog.sohu.com/253932195.html is added to the database. The sde user owns the ST_Geometry type, subtypes, functions, and tables.The following steps explain how to create the ST_Geometry type in an Oracle database using a Python script:Copy the libst_shapelib (st_shapelib for Windows) library from the DatabaseSupport directory in the ArcGIS client installation location and move it to a location on the Oracle server.Be http://desktop.arcgis.com/en/arcmap/10.3/manage-data/databases/script-stgeometry-creation-oracle.htm sure to use the library appropriate for your Oracle server operating system.The directory on the server where you place the library must be accessible from the client machine from which you will run the Create Spatial Type tool or script. If placing the library on a UNIX or Linux machine, be sure the database administrator has read access to the folder and execute privileges on the library file.
Create a text file on the ArcGIS client machine, and copy the following script into the file. """ Name: create_spatial_type.py Description: Provide connection information to an Oracle or PostgreSQL database and create spatial type in the database. Type create_spatial_type.py -h or create_spatial_type.py --help for usage Author: Esri """ # Import system modules import arcpy, os, optparse, sys # Define usage and version parser = optparse.OptionParser(usage = "usage: %prog [Options]", version="%prog 1.0 for " + arcpy鏈嶅姟鏃跺嚭鐜伴敊璇紝鏌ョ湅鏃ュ織 D:\Program Files\ArcGIS\ArcSDE\ora10gexe\etc\sde_esri_sde.log http://m.blog.csdn.net/article/details?id=16985127 ------------------------------------------------------- ArcSDE 10.0 for Oracle10g Build 775 Fri Sep 17 11:45:27 2010 ------------------------------------------------------- ST_Geometry Schema Owner: (SDE) Type Release: 1007 Instance initialized for ((sde)) . . . error checking Connected to instance . . . ERROR in checking system st_geometry type (1). Error checking the existence of system tables. Run the Upgrade Geodatabase tool to install/upgrade system error checking system tables (-450). Refer ArcSDE installation guide for instructions. 浜х敓鍘熷洜锛 1. 瀹夎 ArcSDE 10.0 鍚庨渶瑕佹墦琛ヤ竵鎵嶅彲浠ヤ娇鐢ㄣ傛娆℃槸瀹夎 ArcSDE 10.0 鍚庣洿鎺 post锛宲ost 杩囩▼涓垱寤轰簡鍦扮悊鏁版嵁搴擄紝瀵艰嚧鍚庨潰鎵撹ˉ涓佷篃娌℃湁鏁堟灉銆 瑙e喅鏂规锛 1. 姝g‘鐨勫畨瑁呴『搴忔槸锛氬畨瑁 ArcSDE -> 瀹夎 sp5 (鏈鏂拌ˉ涓侊紝sp1 搴旇涔熷彲浠) -> Post銆 鐭ヨ瘑鎷撳睍锛 1. 濡備綍灏 ArcSDE 9.3 鍗囩骇涓 10.0銆 鍙傝冿細 http://support.esri.com/en/downloads/patches-servicepacks/view/productid/66/metaid/1877#install-UpgradeGDB http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_quick_tour_of_ArcSDE_geodatabase_upgrades/002n0000005n000000/ 涓婁竴绡 涓嬩竴绡 鏆傛棤璇勮锛屾垜鍘诲彂琛▇ 璇勮锛2锛 oracle,32浣,arcgis,esri 鎴戠殑鐑棬鏂囩珷 鈥滄湭鑳芥壘鍒板厓鏁版嵁鏂囦欢鈥濋棶棰樼殑澶勭悊 c# winform 鍒╃敤 windows media player 寰幆鎾斁瑙嗛 HRESULT:0X800736FD 闂鐨勮В鍐 ora-12514 TNS 鏃犵洃鍚▼搴 ArcSde Service(esri_sde) 鏈嶅姟鍚姩鍚庡張鍋滄浜 鐩稿叧鍗氭枃 鏈櫥褰 •棣栭〉 •绉诲姩寮鍙 •Web鍓嶇 •鏋舵瀯璁捐 •缂栫▼璇█ •浜掕仈缃 •鏁版嵁搴 •绯荤粺杩愮淮 •浜戣绠 •鐮斿彂绠$悊 •缁煎悎 0 0 2 鍒嗕韩 寰俊鍒嗕韩鏂版氮寰崥QQ濂藉弸QQ绌洪棿 鍙 娑