What is a guideline for Shareplex when you install an Oracle patch?
Here is a guideline for shareplex when you install an Oracle patch on source and/or target database:
1. Stop all accesses to the source database.
2. sp_ctrl> flush o.sourcesid on source.
3. When you see all queues are empty, shutdown shareplex on source and/or target.
4. Install the Oracle patch on source and/or target database.
5. Relink the library in /var/adm/.splex directory on source and/or target server.
6. Start up databases on source and/or target
7. Start up sp_cop on source and/or target.
8. Start post on target.
9. Do a simple test to verify if replication works. You can use the flush command to do this conveniently without having to do any DML on a table.
10. Allow all accesses to the source database.
Note: This is just a guideline based on assumption that the ORACLE_HOME will not be changed and only single Shareplex instance is running on the server. Otherwise, the procedure can be different. If you have multiple sharepelx instances running against the same database which will be affected by the patch installation, then all shareplex instances should be shutdown as described in step 1 to 3 before installing the patch. We suggest that you review it as a reference and modify it as necessary to your requirement.
