Unable to update a domain after upgrading database to Oracle - receive ORA-00604, ORA-06550, ORA-00306 errors

Last Published: April 25, 2020

Error Message

After database upgrade to, existing domains in the geodatabase cannot be updated. An error similar to the following may be returned:


This has been found to be an Oracle-related issue (Oracle Doc ID 1586704.1).

The cause of this problem has been analyzed in unpublished Oracle Bug 17501296: Commit callback procedure ctxsys.syncrn is not in sync with C-code.

Solution or Workaround

To resolve the problem apply Patch 17501296 or re-create the ctxsys.syncrn procedure as shown below.

If any problems are encountered with re-creating this procedure, or any questions arise related to this particular issue, please contact Oracle Support Services.


connect / as sysdba

alter session set current_schema=CTXSYS;

create or replace procedure syncrn (
ownid IN binary_integer,
oname IN varchar2,
idxid IN binary_integer,
ixpid IN binary_integer,
rtabnm IN varchar2,
srcflg IN binary_integer,
smallr IN binary_integer
authid definer
as external
name "comt_cb"
library dr$lib
with context
ownid ub4,
idxid ub4,
ixpid ub4,
srcflg ub1,
smallr ub1

Patch notes:

The patch for this issue supplies corrected upgrade and downgrade scripts
such that any new upgrade / downgrade should get the correct definition.

If the upgrade has already been done WITHOUT the patch already in place, the following command must be executed to correct the dictionary.

"@?/sqlpatch/17501296/postinstall.sql" from <Patch17501296>

Article ID:000012183

  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options