Favorites
Data Server Environment:
4-core, 4 GB memory
Windows server2003
Arcsde9.3
Oracle10.2.0.1
There is a large amount of space data. The data volume of each layer can contain hundreds of thousands of records (up to 100,000 records for one layer)
Symptoms:
When you use ArcMap to Load Layers and perform frequent data operations (zoom in, zoom out, and query), an error is reported on the server. The gsrvr.exe dialog box is displayed.ProgramError. The memory cannot be read or the like. A network I/O error occurs on the client.
View SDE error logs
Sde-esri-sde.log
Db_array_fetch_attrs OCI fetch Error
Load_buffer error-51
Giomgr-esri-sde.log
SDE server went down on system exception 0xc0000005
Solution:
Contact ESRI for technical support and consultation in China and get several solutions:
1. Patch arcsde9.3 with SP1(Non-customers: After my tests, this method is valid and the patch package is downloaded.Arcsdeoracle10g93sp1.rar)
2. Upgrade Oracle to 10.2.0.3 (this version is stable in combination with sde93. It is said that each version of ArcSDE has a corresponding Oracle version and is relatively stable in combination. For specific versions, contact ESRI China)
3. Use arcsde9.2 in combination with a stable Oracle version.
After trying to get a conclusion
Solution 1 does not solve the problem (Non-customers: can solve the problem)
Solution 2 solved the problem, though load_buffer error-51 still exists in the sde-esri-sde.log log, but none of the other symptoms.
Solution:
After repeated attempts, we finally successfully upgraded oracle10.2.0.1 to 10.2.0.3. The following describes how to Upgrade Oracle.
1) To download the update package, you must download the correct update package. It was a waste of time because the update package failed several times. P5337014_10203_winnt.zip is verified by me.
2) reinstall oracle10.2.0.1 to ensure that the original Oracle has been uninstalled before installation, and all Oracle services have been deleted. How to clean and uninstall oracle is described on the Internet, do not install databases during installation.
3. Install the upgrade package p5337014_10203_winnt.zip and select the path db1 of oracle10.2.0.1.
4) use oracle tools to create databases
5) create a listener using Oracle tools
OK! Arcsde9.3 is now working! This is the joy of trying various methods!
this article from the csdn blog, reprinted please indicate the source: http://blog.csdn.net/CodeKeeper/archive/2009/04/18/4090239.aspx