Labels

Friday, June 1, 2018

stream proces check in oracle

--Check the process status
 strmc status -d

--found the process is aborted
ORUXAX      CAP_DR_STORE_FOR_ORUXAX          ABORTED    0             Process DOWN

--Start the process by below command
 strmc start -d -n

 strmc start -d ORUXAX -n CAP_DR_STORE_FOR_ORUXAX

-Check again the stream process to make sure it is in enable state
 strmc status -d ORUXAX

-To check the que apply status
select APPLY_NAME,QUEUE_NAME,QUEUE_OWNER,STATUS from dba_apply; 

select CAPTURE_NAME,QUEUE_NAME,QUEUE_OWNER,STATUS from dba_capture; 

No comments:

Post a Comment