Error: Unable to update a domain after upgrading database to Oracle 11.2.0.4.0 - receive ORA-00604, ORA-06550, ORA-00306 errors
【相关信息】
Article ID: 43127
Software:
ArcSDE 10, 10.1, 10.2, 10.2.1, 10.2.2
Platforms: N/A
【错误信息】
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:
【错误原因】
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.
Article ID: 43127
Software:
ArcSDE 10, 10.1, 10.2, 10.2.1, 10.2.2
Platforms: N/A
【错误信息】
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:
【错误原因】
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.
1 个回复
易智瑞技术支持
赞同来自:
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
parameters(
context,
ownid ub4,
oname OCISTRING,
idxid ub4,
ixpid ub4,
rtabnm OCISTRING,
srcflg ub1,
smallr ub1
);
/
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>
【创建及修改时间】
Created: 9/17/2014
Last Modified: 11/19/2014
【原文链接】
http://support.esri.com/en/kno ... 43127
要回复问题请先登录或注册