Is This Content Helpful?
We're glad to know this article was helpful.
After database upgrade to 220.127.116.11, 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 18.104.22.168 C-code.
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
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>