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


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:
Then connect to the geodatabase with the easy connect string (refer to ArcGIS 10.1 documentation) and upgrade the geodatabase.
Make a connection to the Oracle geodatabase by typing only the TNSNAME in the 'Instance' textbox and the geodatabase will upgrade successfully.