Using Linux VIP
We have three machines running Linux (M1,M2, M3). We are using Oracle streams to keep M2 in sync with M1. We are
using M2 as a standby for M1.
M1 and M2 are using Linux Virtual IP Address (VIP). When VIP is activated om M1, all request to VIP will be routed
to M1. When VIP is activated om M2, all request to VIP will be routed to M2
M1 and M2 have tables that are accessed from M3 using synonyms.
My questions:
- Can I use the VIP to setup synonyms from M3 to M1 tables?
- If M1 machine goes down and VIP is activated on M2, do I need to recreate the synonyms from M3 to M2 or Oracle