Home » Server Options » Streams & AQ » Error in streams process.
Error in streams process. [message #118206] Tue, 03 May 2005 11:50 Go to next message
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
Re: Error in streams process. [message #403549 is a reply to message #118206] Sat, 16 May 2009 17:09 Go to previous messageGo to next message
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
Re: Error in streams process. [message #403566 is a reply to message #403549] Sun, 17 May 2009 01:30 Go to previous message
Michel Cadot
Messages: 68625
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
Previous Topic: Streams capture queue
Next Topic: why should we enable Supplemental Logging in streams
Goto Forum:
  


Current Time: Thu Mar 28 11:24:11 CDT 2024