ERROR

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

Last Published: April 25, 2020

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

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