we are about to move some schemas from one database server to another. dbserver1 is the dest, dbserver2 is the source . currently there are external entities pointing to dbserver2 that will need to reference dbserver1 . I can do some forwarding tricks so that external IP and port changes are transparent (i.e., nat forwarding is pointed to new location), and I've managed to configure a listener on a separate port. but ultimat
ely what I'd want is the oracle_sid to be aliased, so that there will be minimal disruption of services with no change required on the remote end . is this possible?
basically, what I want is two listeners on two different ports answering to two different SID's but in reality both are going to the same database
the two listeners on two different ports is easy enough
it's two sid's pointing to the same spot that's troubling me