HiAll
Got a 2 node rac, with a TAF service configured.
Service misasia_taf.compass.org.sg is running on instance(s) server1,server2.
*************
Then we use sqlplus to connect using TNS define entry using the above service.
Sqlplus connects fine and we get connected to server2.
Then we run a query and as the query runs, i stop the server2 Instance with -f option to force
srvctl stop instance -d db1 -i server2 -f
above command DOES not relocate the TAFservice as the sql query then dies and gives the
ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 38988
Session ID: 350 Serial number: 54056
any ideas are appreciated...I know I can relocate it first but this defeats the purpose of the server losing power and dying...