Geodatabase schema object install not completed (-522)

Last Published: September 2, 2020

Error Message

Using a full Oracle client to upgrade an Oracle geodatabase with the syntax ‘sde: oracle11g:TNSNAME’ returns the following error message:

“Cannot upgrade a user schema geodatabase when the master schema geodatabase is at a previous release. The master schema geodatabase must be upgraded first.

ERROR: Geodatabase schema object install not completed (-522)."
The error is returned in the sde_setup.log file (path: C:\Users\<username>\AppData\Local\Temp).


This is a known issue.

Solution or Workaround

Change the connection syntax from ‘sde:oracle11g:TNSNAME’ to the Transparent Network Substrate (TNS) name in the Instance text box:

  • Type the TNS name in the Instance text box, as shown in the figure below.


  • Modify the sqlnet.ora file on the client machine to connect to the geodatabase with the Easy Connect string, and upgrade the geodatabase.

Article ID:000012196

  • ArcMap 10 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic