Post stopped due to the following as a result of specifying incorrect SID in the config file. The problem was since corrected but one residual Post queue remains and causes unnecessary alarm:
sp_ctrl (ov00db12:2200)> show log reverse
05/21/07 20:39 Process exited sp_mport (from OV95DB01.opr.test.statefarm.org queue ov95db01) [pid = 2478] - exit(1)
05/21/07 20:39 Cannot connect to export on OV95DB01.opr.test.statefarm.org
05/21/07 20:26 Process exited sp_opst (for o.svcdesk-o.svcdesk queue ov95db01) [pid = 12973] - exit(1)
05/21/07 20:26 Error: 15001 - No such database as "svcdesk" in /etc/oratab [sp_opst (for o.svcdesk-o.svcdesk queue ov95db01)/12973]
05/21/07 20:26 Warning: Failed to set ORACLE_SID/ORACLE_HOME [sp_opst(pdb)/12973]
05/21/07 20:26 Notice: Can't find home for Oracle SID svcdesk [sp_opst(pdb)/12973]
05/21/07 20:26 Process launched: sp_opst (for o.svcdesk-o.svcdesk queue ov95db01) [pid = 12973]
05/21/07 20:26 Logging user command: oracle start post
05/21/07 14:46 Process exited sp_opst (for o.svcdesk-o.svcdesk queue ov95db01) [pid = 2479] - exit(1)
05/21/07 14:46 Error: 15001 - No such database as "svcdesk" in /etc/oratab [sp_opst (for o.svcdesk-o.svcdesk queue ov95db01)/2479]
05/21/07 14:46 Warning: Failed to set ORACLE_SID/ORACLE_HOME [sp_opst(pdb)/2479]
05/21/07 14:46 Notice: Can't find home for Oracle SID svcdesk [sp_opst(pdb)/2479]
05/21/07 14:46 Process launched: sp_opst (for o.svcdesk-o.svcdesk queue ov95db01) [pid = 2479]
05/21/07 14:46 Connected to export on OV95DB01.opr.test.statefarm.org
05/21/07 14:46 Process launched: sp_mport (from OV95DB01.opr.test.statefarm.org queue ov95db01) [pid = 2478] event_log (15/55)
The unwanted Post queue needs to be deleted after shutting down Shareplex and running deleteq command on it as follows (note that the Post queue referencing the SID svcdesk is removed):
$ qview -i
qview> qsetup
qview> list
The following queues exist:
sg00sd02+P+o.svcdesk-o.sdreport
subqueues range from 0 to 99
WRITER +PI+sg00sd02+sp_mport+0x0a281994 (10.40.25.148)
READER +PP+sg00sd02+sp_opst+o.svcdesk-o.sdreport
ov95db01+P+o.svcdesk-o.svcdesk
subqueues range from 0 to 7
WRITER +PI+ov95db01+sp_mport+0x0af83e20 (10.248.62.32)
READER +PP+ov95db01+sp_opst+o.svcdesk-o.svcdesk
qview> deleteq ov95db01+P+o.svcdesk-o.svcdesk
qview> exit
Then login to SQL*Plus on target database and truncate table shareplex_trans owned by Shareplex user before restarting Shareplex.
