Home » Server Options » Replication » ORA-26672: timeout occurred while stopping STREAMS process STRMADMIN_APPLY (Windows 2003, Oracle11g )
ORA-26672: timeout occurred while stopping STREAMS process STRMADMIN_APPLY [message #495623] Mon, 21 February 2011 07:14 Go to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

I have setup the replication at table level between two database. It was working fine before. Suddenly I check the replication working and found error below

Apply Local Messages in
Process Source Transaction Error
Name Database ID Error Number Error Message Transaction
---------- ---------- ----------- ------------ -------------------- -----------
STRMADMIN_APPLY VMS 38.32.97719 959 ORA-00959: tablespace 'RFC_INDX' does not exist 1



STRMADMIN_APPLY VMS 88.1.44971 959 ORA-00959: tablespace 'RFC_INDX' does not exist 1


After the I created the same tablespace and tried to stop and start the process as it was apply process is in disabled mode.
When I am trying to start apply process it is throwing below error.

SQL> show user
USER is "STRMADMIN"
SQL> BEGIN
2 DBMS_APPLY_ADM.STOP_APPLY(apply_name => 'STRMADMIN_APPLY');
3 END;
4 /
BEGIN
*
ERROR at line 1:
ORA-26672: timeout occurred while stopping STREAMS process STRMADMIN_APPLY
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 627
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 55
ORA-06512: at line 2

Can Some one help why this error is still coming during start. even I created the tablespace.

Regards

Pradeep
Re: ORA-26672: timeout occurred while stopping STREAMS process STRMADMIN_APPLY [message #495626 is a reply to message #495623] Mon, 21 February 2011 07:22 Go to previous messageGo to next message
Michel Cadot
Messages: 67131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-26672: timeout occurred while stopping STREAMS process %s
 *Cause:  Timeout occurred while waiting for a STREAMS process to shut down.
 *Action: Retry the operation. If the error persists, try stopping the
          process with the FORCE option, or contact Oracle Support Services.

Regards
Michel
Re: ORA-26672: timeout occurred while stopping STREAMS process STRMADMIN_APPLY [message #495628 is a reply to message #495626] Mon, 21 February 2011 07:28 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi Michal,

I am using the below command to stop the stream process forcefully.


DBMS_APPLY_ADM.STOP_APPLY(apply_name => 'STRMADMIN_APPLY', FORCE=>'TRUE');

Is it right or Kindly tell me the command for the forcefully stop.


Regards

Pradeep
Re: ORA-26672: timeout occurred while stopping STREAMS process STRMADMIN_APPLY [message #495632 is a reply to message #495628] Mon, 21 February 2011 07:57 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

Its working fine now after using the below command.


begin
DBMS_APPLY_ADM.STOP_APPLY(apply_name => 'STRMADMIN_APPLY', FORCE=>TRUE);
end;
/


Thanks for your help.

Regards

Pradeep
Re: ORA-26672: timeout occurred while stopping STREAMS process STRMADMIN_APPLY [message #495634 is a reply to message #495632] Mon, 21 February 2011 08:09 Go to previous message
Michel Cadot
Messages: 67131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And thanks for the feedback.

Regards
Michel
Previous Topic: Oracle <-> DB2 Bi-Directional Sync, Master-Master DB setup
Next Topic: problem_in_orcle_net
Goto Forum:
  


Current Time: Sun May 24 18:27:02 CDT 2020