Bug
When upgrading an ArcGIS 10 SP5 geodatabase to ArcGIS 10.1, while connecting with the syntax 'sde:oracle11g:TNSNAME' the upgrade fails with the error 'ERROR: geodatabase schema object install not completed (-522).'
| Bug ID Number | NIM084987 |
|---|---|
| Submitted | September 19, 2012 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.1 |
| Operating System | Windows OS |
| Operating System Version | 2008 R2 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
With the new connection dialog, the best practice is to directly user TNS name or easy connection string for the INSTANCE parameter.Workaround
Modify the sqlnet.ora file on the client machine to enable easy connect:NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)Then connect to the geodatabase with the easy connect string (refer to ArcGIS 10.1 documentation) and upgrade the geodatabase.ORMake a connection to the Oracle geodatabase by typing only the TNSNAME in the 'Instance' textbox and the geodatabase will upgrade successfully.Steps to Reproduce
Bug ID: NIM084987
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App