今天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;