Error: Unable to Update a Domain after Upgrading Database to Oracle 11.2.0.4.0

Error Message

After database upgrade to 11.2.0.4, existing domains in the geodatabase cannot be updated. An error similar to the following may be returned:
[O-Image]

Cause

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

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
)
  authid definer
  as external
  name "comt_cb"
  library dr$lib
  with context
  parameters(
    context,
    ownid  ub4,
    oname  OCISTRING,
    idxid  ub4,
    ixpid  ub4,
    rtabnm OCISTRING,
    srcflg ub1,
    smallr ub1
);
/

Note:
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

Software:

Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

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

Error Message

Cause

Solution or Workaround

Discover more on this topic