Multiple Net Service alias for single instance
We are in the process of consolidating multiple DB into different schema in one DB. Different web application has been using these DB and now all application will point to the same DB.
I would like to know if its possible to has multiple alias for the same DB Servcice so the websites still connect using the old DB SID - in this way we can avoid making new build and couple of other custom data load process also does not have to be updated.
I looked at configuring multiple service name for the same DB using Net Manager with no success - I might be doing it wrong or might be totally doing it at the wrong place
Please get me pointer on how to achieve this and other suggestion also welcome
Thanks for your time and help in advance
-Srini