How can we stream from one database to two targets when the two targets are on different servers but share the instance name?
We stream from a Windows Oracle RAC to AIX Oracle Reporting Server. Our set up is as follows:
Oracle two node RAC on Windows
Servers: RACSRVPROD1 & RACSRVPROD2
Instances: RACPROD1 & RACPROD2
Oracle single instance on AIX
Server Name: RPTPRODSRV
This has been working fine.
We created a 3rd server (aix) which will become our new production server called RPTNEWSRV.
We want to keep the same Instance name of RPTPROD on the new server. We used RMAN to duplicate the RPTPROD instance to the new server so all target stuff is set up the same.
Now we want to add this new instance to the streaming environment.
Obviously we want to make sure the Source database can distinguish between the RPTPROD instances on each server but aren't entirely sure how to do this.
Here are the tnsnames.ora entries in the source server to the two reporting instances:
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!