OraFAQ Forum: Replication » ORA-26672: timeout occurred while stopping STREAMS process STRMADMIN

Home » Server Options » Replication » ORA-26672: timeout occurred while stopping STREAMS process STRMADMIN_APPLY (Windows 2003, Oracle11g )

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

ORA-26672: timeout occurred while stopping STREAMS process STRMADMIN_APPLY [message #495623]

Mon, 21 February 2011 07:14

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

Report message to a moderator

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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And thanks for the feedback.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 14:31:20 CST 2025