Renaming/adding named export or post queue name (4270213)

To rename or add the export queue or post queue name

Changing the export / post queue name configurations

Here are the steps to renaming export / post queue. There is a need to modify your current active configuration to modify(add) the name queue.

1) quiet the source database ( no user activity on replicated tables)
2) Issue flush at the source
sp_ctrl> flush o.$ORACLE_SID
This is your oracle sid. If the oracle sid is quest for example:
sp_ctrl> flush o.quest

3) once the post for that target stop due to flush there should not be any messages in the Shareplex queues.
check this with
sp_ctrl> qstatus on both source and target.

4) Create new configuration for new post queue name
sp_ctrl> copy config originalconfig to newpostqueconfig
edit the newpostqueconfig
For example the active configfilename is originalconfig and new active filename is newpostque

You need to modify the newpostque config with the new post queue name and remove the old ones if renaming the name or if adding just add the new export or post queue name to configuration
.
Once check the syntax then you could activate this

For examples: this is the table with old queue name entry in this config
=====================================
Option 1: One export to post queue mapping.
=====================================
mani.for51 mani.tfor51 targethostname:postquename@o.hd920
Change this entry to
mani.for51 mani.tfor51 targethostname:newpost@o.hd920

Option one is one export can post to many post queues on the same or different target.

======================================
Option 2: export queue and name post queue:
======================================
This is one to one mapping or export to corresponding post queue name. The export queue name and post queue name on target will be the same on this configurations.

This is export queue one to one to post queue. This will create equivalent post queue name at the target with the same name
mani.for51 mani.tfor51 sourcehostname:expqoldname*targethostname@o.hd920
change to or add:
mani.for51 mani.tfor51 sourcehostname:expnewname*targethostname@o.hd920

For more information on syntax of post queue naming refer to system admin guide look for post queue name on index section.

5) activate the configuration

sp_ctrl> activate config newpostqueconfig

6) Note for adding name queue you could skip this step number 6
delete old post queues (For this part you could call back support to guide you through delete the queues)
A) shutdown Shareplex on both source and target
On Source:
B)
qview -i
qview> qsetup
qview> list
qview> deleteq x
Will prompt you for the queue and choose the oldqueue name to be deleted
qview> exit

On target:
qview> qsetup
qview> list
qview> deleteq p
Will prompt you for the queue and choose the oldqueue name to be deleted
qview> exit

7) at target truncate Shareplex_Trans table
login to Oracle as the splex user
sqlplus> truncate table Shareplex_Trans;
sqlplus> exit

8) start Shareplex at source and target

9) start user activity at source

10) start post