1 Reply Latest reply: Nov 23, 2012 7:02 AM by onedbguru RSS

    Service Issue

    778979
      Hi ,

      We have two node RAC UCHOOSE1 and UCHOOSE2 and we created one service (UCHOOSENEW) with below command with perferred instance is 1(UCHOOSE1) and available is 2 (UCHOOSE2).

      Database version :10.2.0.4 on aix
      =========
      Service command

      srvctl add service -d UCHOOSE -s UCHOOSENEW -r UCHOOSE1 -a UCHOOSE2

      {West_uc_UDBtest01:oradb:UCHOOSE1}/home/oradb $ srvctl config service -d UCHOOSE -s UCHOOSENEW
      UCHOOSENEW PREF: UCHOOSE1 AVAIL: UCHOOSE2
      ==========


      Now we make a connection from sqlplus with this service so it make a connection also on 2 (UCHOOSE2).
      node why ????

      As per my undestanding it make a connection only on node 1 once second node is down then service move it on second node and take a connection?

      Regards