| Bug Number | NIM084987 |
| Submitted | Sep 19, 2012 |
| Modified | Jun 11, 2020 |
| Severity | High |
| Applies To | ArcSDE/Enterprise Geodatabase |
| Version Found | 10.1 |
| Prog Language | N/A |
| Server Platform | Windows 2008 R2 64 Bit |
| Client Platform | Windows 2008 R2 64 Bit |
| Database | Oracle |
| Locale | N/A |
| Status | Not in Current Product Plan |
| Version Fixed | |
| SP Fixed |
Bug NIM084987
Synopsis
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).'
Additional Information
With the new connection dialog, the best practice is to directly user TNS name or easy connection string for the INSTANCE parameter.
Alternate Solution
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.
OR
Make a connection to the Oracle geodatabase by typing only the TNSNAME in the 'Instance' textbox and the geodatabase will upgrade successfully.