OraFAQ Forum: Streams & AQ » Error in streams process.

Home » Server Options » Streams & AQ » Error in streams process.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error in streams process. [message #118206]

Tue, 03 May 2005 11:50

m_scandroglio
Messages: 26
Registered: March 2005

Junior Member

Hi all!
That is my trace file...
what happened????

any idea?
I have "only" did a stress test on the db....
before the streams worked fine!!

*** SESSION ID:(17.28) 2005-04-27 10:32:40.311
bq: kwqppscbk: Add PSE: qid: 8901, dest: SCSINCUS
*** 2005-05-03 13:08:42.108
error 4068 in STREAMS process
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "SYS.DBMS_AQADM_SYS" has been invalidated
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "SYS.DBMS_AQADM_SYS" has been invalidated
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

thanks
milena

Report message to a moderator

Re: Error in streams process. [message #403549 is a reply to message #118206]

Sat, 16 May 2009 17:09

sumang24
Messages: 10
Registered: July 2005

Junior Member

milena

I also got the streams exception in our production environment today.

error 4068 in STREAMS process
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "SYS.DBMS_AQADM_SYS" has been invalidated
ORA-04065: not executed, altered or dropped package body "SYS.DBMS_AQADM_SYS"
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at line 1
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "SYS.DBMS_AQADM_SYS" has been invalidated
ORA-04065: not executed, altered or dropped package body "SYS.DBMS_AQADM_SYS"
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at line 1

Were you able to resolve this error? How? I am not getting any info on this error on Metalink.

Thank You
Suman

Report message to a moderator

Re: Error in streams process. [message #403566 is a reply to message #403549]

Sun, 17 May 2009 01:30

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-04068: existing state of packages%s%s%s has been discarded
 *Cause:  One of errors 4060 - 4067 when attempt to execute a stored
          procedure.
 *Action: Try again after proper re-initialization of any application's
          state.

ORA-04061: existing state of %s has been invalidated
 *Cause:  Attempt to resume the execution of a stored procedure using the
          existing state which has become invalid or inconsistent
          with the stored procedure because the procedure has been altered
          or dropped.
 *Action: Try again; this error should have caused the existing state of
          all packages to be re-initialized.

ORA-04065: not executed, altered or dropped %s
 *Cause:  Attempt to execute a stored procedure that has
          been altered or dropped thus making it not callable from the
          calling procedure.
 *Action: Recompile its dependents.

Regards
Michel

Report message to a moderator

Previous Topic:	Streams capture queue
Next Topic:	why should we enable Supplemental Logging in streams

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 16:11:51 CDT 2023