Considerations for Shareplex when doing applications upgrade. (4300350)

Considerations for Shareplex when doing applications upgrade.

Considerations for Shareplex when doing applications upgrade.

General information.

Non-Shareplex applications upgrade usually involve DDL changes. For this reason it requires additional considerations.

Here are the ways to do it:

A. If done in a one-way replication environment:

1. Turn off DDL replication for replicating objects  by setting SP_OCT_REPLICATE_DDL to 0 as well as for non-replicating objects by setting SP_OCT_REPLICATE_ALL_DDL to 0 on source sp_ctrl:

sp_ctrl>set param SP_OCT_REPLICATE_DDL 0

sp_ctrl>set param SP_OCT_REPLICATE_ALL_DDL 0

1. Issue flush from source sp_ctrl:

sp_ctrl>flush o.SID      (where SID refers to the Oracle SID on source)

1. Shutdown Shareplex and do the application upgrade on source, and then restart Shareplex on source.
2. Turn on the DDL replication to the state it was prior to application upgrade. For example, if the parameters SP_OCT_REPLICATE_DDL and SP_OCT_REPLICATE_ALL_DDL were originally set to 3 and 0 respectively (which usually are the default settings), then set them as below:

sp_ctrl>set param SP_OCT_REPLICATE_DDL 3

sp_ctrl>set param SP_OCT_REPLICATE_ALL_DDL 0

1. On taraget , once Post stops due to flush, shutdown Shareplex and do the application upgrade and then restart Shareplex and Post. To start Post:

sp_ctrl>start post

An alternate way to do this is to set  SP_OCT_GEN_STOP to 0x03 on source (which directs Capture to stop gathering changes from the source database) for the duration of patch upgrade but may involve some caution as doing it wrongly can result in data loss. Hence this approach is not documented here.

B. Doing it in a peer to peer environment involves additional steps.  They are outlined below:

1. Turn off DDL replication for replicating objects  by setting SP_OCT_REPLICATE_DDL to 0 as well as for non-replicating objects by setting SP_OCT_REPLICATE_ALL_DDL to 0 (on both nodes)
2. Issue flush from  sp_ctrl on both nodes
3. Once Post stops on both nodes, shutdown Shareplex on both nodes and do the application upgrade, and then restart Shareplex on both nodes and restart Post on these.
4. Turn on the DDL replication to the state it was prior to application upgrade.

For details on the parameters SP_OCT_REPLICATE_DDL and SP_OCT_REPLICATE_ALL_DDL as well as on flush, please refer to Shareplex Reference Guide which lists out the Shareplex user configurable parameters as well as various commands including "flush" command.