一次shareplex的处理 Import: Error opening output queue que

Error opening output queue que"/>

一次shareplex的处理 Import: Error opening output queue que

今天在测试环境遇到一个错误：

Info     2013-09-02 08:02:48.784502 11807 645580544 Import exited with code=1, pid = 3495  (importing from source-vip.aaa queue aaqueue)
Error    2013-09-02 08:02:48.770039 3495 3490219776 Import: sp_mport: failure writing to queues - exiting  (importing from source-vip.aaa queue aaqueue) [module imp]
Notice   2013-09-02 08:02:48.765947 3495 3490219776 Import: Error opening output queue que_ERR: Non specific error que_open(-,aaqueue+P+o.SSSS-o.TTTT,0x0afc08c0+PI+aaqueue+sp_mport+0x0afc05e4)  (importing from source-vip.aaa queue aaqueue) [module rim]
Error    2013-09-02 08:02:48.752672 3495 3490219776 Import: No such file or directory que_open.open_fd  (importing from source-vip.aaa queue aaqueue) [module que]
Info     2013-09-02 08:02:48.740393 3495 3490219776 Import connected to export on source-vip.aaa

网上找了一下，ora_cleaup即可。果然。

官方文档如下：

Knowledge Article 42304

• Title

  clean_vardir.sh was run on target while Shareplex was up resulting in errors "Error opening outpu

• Description

  The utility clean_vardir.sh was run on target while Shareplex was running. Later, the event log showed the following messages indicating queue corruption whereby the queue messages from source did not flow to the target and the Export remained in "idle" state and would not connect to Import:

  04/23/08 22:02 Process launched: sp_mport (from trmdessu queue trmdessu) [pid =29880]
  04/23/08 22:02 Connected to export on trmdessu
  04/23/08 22:02 System call error: No such file or directory que_open.open_fd [sp_mport(que)/29880]
  04/23/08 22:02 Notice: Error opening output queue que_ERR: Non specific error que_open(-,trmdessu+P+o.EUUAT9I-o.splex45,0xa27cc8ad+PI+trmdessu+sp_mport+0xa9a3bf48) [sp_mport(rim)/29880]
  04/23/08 22:02 Error: sp_mport: failure writing to queues - exiting [sp_mport/29880]
  04/23/08 22:02 Error: sp_mport: failure writing to queues - exiting [sp_mport/29694]
  04/23/08 22:02 Process exited sp_mport (from trmdessu queue trmdessu) [pid=
  29694] - exit(1)

• Resolution

  The utility clean_vardir.sh is run to clean up the existing variable directory which typically includes the queue files, cache files and log files, among others. It should be run when Shareplex is shutdown. Not doing so can cause some synchronization problems between the queue files, the Shareplex internal tables, etc. The simplest way to get out of this situation is to shutdown Shareplex on target (this is where it was mistakenly run while Shareplex was up), run ora_cleansp and restart Shareplex. On restart Post may complain about missing object cache file which can easily be resolved (see solution # SOL2459for details or call Support if encountering the error). The ora_cleansp would get rid of the contents of variable directory as well as clean up the Shareplex internal tables on target database putting all speculation about sync problems between to rest. One would not lose activation as a result of this since it went on at the target side. At the most there may be out of sync issues. If this was done on source, it would result in the loss of current activation.