I believe you will have to stop Instance2, as the client reroute "kicks in"
when the normally identified instance is not available.
As it switched to Instance 2, that one became the "normal " one and should
stay so until it (Instance2) dies and reroute will send the client to
Instance1.
From your question, you are not using HADR functions but just testing
reroute so the client has no clue that it should connect to 1 by preference
over 2 if it was rerouted to 2.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Challenge" <ha********@yahoo.com> a écrit dans le message de news:
11**********************@75g2000cwc.googlegroups.c om...
Hi,
I'm testing automatic reroute on two instances on the same server. The
client can successfully connect to instance 2 after I stop instance 1.
However I don't know how to let client back to instance 1. I start
instance 1. But client still connect to instance 2. Do I have to stop
instance 2 in order to let client switch back to instance 1? Is there
any other way to do it?
Thanks.