Re: ORA-00604
Date: Tue, 18 Dec 2001 15:41:50 +0300
Message-ID: <3C1F398E.E36309C2_at_mail.ru>
Hello Rick !
Thanks for your answer. I've asked that question on Metalink already. One
of Oracle's consultant
has advised to check the connection string 8-((
There is no any bugfix AFAIK
Rgds, Vadim Grepan
Moscow, Russia
email: kezal(_at_)mail.ru
Rick Wessman wrote:
> Hi, Vadim:
>
> This is an internal error, and thus cannot be fixed. You need to contact
> Oracle support. A fix may already exist for this problem.
>
> Rick
>
> Vadim Grepan <kezal_at_mail.ru> writes:
>
> > Hello All!
> >
> > Sometimes I've got ORA-00604 while do connect from remote application
> > via Net8. I wonder but no any record in alert.log concerning it.
> > I've set event = "604 trace name errorstack level 10"
> > and detected the following lines in alert.log:
> >
> > === cut ===
> > ...
> > ksedmp: internal or fatal error
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-00001: unique constraint (.) violated
> > ORA-00001: unique constraint (CTXSYS.SYS_IOT_TOP_24317) violated
> > ...
> > === cut ===
> >
> > The corresponding .trc-file keeps simplest UPDATE-clause like
> > === cut ===
> > UPDATE tbl_msg SET user_id=1128, msg_pages=284, data_type_id=1,
> > WHERE msg_id=10028501;
> > === cut ===
> >
> > Moreover I can successfully execute that clause from SQL*Plus e.g.
> >
> > Next i've checked constrant
> > === cut ===
> > SQL> select OWNER, TABLE_NAME, TABLE_TYPE from dba_indexes
> > 2 where INDEX_NAME='SYS_IOT_TOP_24317';
> >
> > OWNER TABLE_NAME TABLE_TYPE
> > ------------------------- ------------------------- -----------
> > CTXSYS DR$PENDING TABLE
> > === cut ===
> >
> > AFAIK it's the internal CTXSYS's table. How can I fix that violation?
> >
> >
> > Rgds, Vadim Grepan
> > --------------------
> > Moscow, Russia
> > email: kezal(_at_)mail.ru
> >
> >
>
> --
> Rick Wessman
> Security Assurance Group
> Oracle Corporation
> Rick.Wessman_at_oracle.com
>
> The opinions expressed above are mine and do not necessarily reflect
> those of Oracle Corporation.
Received on Tue Dec 18 2001 - 13:41:50 CET