This discussion is archived
1 Reply Latest reply: Nov 23, 2012 5:02 AM by onedbguru RSS

Service Issue

778979 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points