Use diff alias names ( TNS Name ).
Code:
1)
ACC1.World =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ACC)
)
)
2)
ACC2.World =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ACC)
)
)
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Reply With Quote