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.
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>