What about the bug 4938674 can it be about it it looks similar On 3/19/07, Edward Lewis <eglewis@xxxxxxxxxxx> wrote:
On Mon, 19 Mar 2007 04:28:18 -0700, "Edward Lewis" <eglewis@xxxxxxxxxxx> said: > Hello, > I'm having a problem with the apply process on > the logical standby. Here are the errors I receive > when starting the apply process: > > LOGSTDBY Apply process P004 pid=22 OS id=3245 stopped > ORA-12801: error signaled in parallel query server P004 > ORA-00942: table or view does not exist > > > "LOGSTDBY stmt: GRANT SELECT ON SYS.qt403019_BUFFER TO "SYSMAN". > > Some background on this. From what I understand, the SYSMAN > schema was added to the primary, through the install of OEM. > The archive logs are being delivered to the standby. Once the apply > process starts, it appears to have problems with the new objects > created in SYSMAN. > > I've been in contact with Oracle support, but so far a resolution > has not been found. They have recommended running several variations > of the DBMS_LOGSTDBY command. > > exec dbms_logstdby.skip_error('GRANT OBJECT', null, null, null); > > exec dbms_logstdby.skip_transaction(7,13,107377); > > EXECUTE DBMS_LOGSTDBY.SKIP(stmt => 'COMMENT TABLE' , schema_name => > 'SYSMAN' , object_name => > null); > Has anyone experienced this ? Any recommendations ? > > thanks. > ed > > environment : sun 10, oracle 10.2.0.2 > -- > Edward Lewis > eglewis@xxxxxxxxxxx > > -- > http://www.fastmail.fm - Email service worth paying for. Try it for free > -- Edward Lewis eglewis@xxxxxxxxxxx -- http://www.fastmail.fm - mmm... Fastmail... -- //www.freelists.org/webpage/oracle-l
-- A. Coskan GUNDOGAR Oracle DBA http://coskan.wordpress.com