Re: a problem with restarting Oracle AQ propagation

Hel wrote:
> Hello
>
> I've got a problem with restarting AQ propagation messages to remote
> server after losing connection with it.
> And I can repair propagation only if a drop all (queue, queuetable,
> etc.) and recreate it again.
> in case I try only to unshedule and shedule AQ propagation, or any
> other operation, I get a timeout error.
> PLS, can anybody tell me - is it really only one way (like mine) to
> restart propagation ? A think before, that it must be automatically -
> restarting propagation to remote DB after re-establish connect
>
> There is a query result from AQ$_SCHEDULES when it happens
> DESTINATION mybase
> START_TIME 03.05.2007 9:41:35
> DURATION 300
> NEXT_TIME sysdate + 1/1440
> LATENCY 32
> LAST_RUN 08.05.2007 16:46:59
> JOBNO 12301
> FAILURES 1
> DISABLED N
> ERROR_TIME 08.05.2007 17:04:46
> LAST_ERROR_MSG ORA-02068 following severe error from MYBASE
> ORA-03114: not connected to ORACLE
> ORA-03135: lose connection
>
> Thank you,
> Helena

Reposting using a different name is not going to get you an answer. You posted no version information and there are a lot of version specific docs at metalink all referring to patches and this issue.

Do you homework and then if you still have a problem let us know.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org