ORA-12801 15154 Oracle 10g Logical Standby

今天Oracle 10g Logical Standby 无法同步,检查Alert Log apply进程可正常开启,但随后马上关闭并报ORA-

ORA-12801: error signaled in parallel query server P007
ORA-12154: TNS:could not resolve the connect identifier specified

参考Meta Link:

ID 1178284.1

1>select XIDUSN, XIDSLT, XIDSQN , status , event from dba_logstdby_events order by event_time;

2>exec dbms_logstdby.skip_transaction (5,22,1826); or add TNS in TNSNAME.ora

3>alter database stop logical standby apply;

4>alter database start logical standby apply immediate;