Home » Server Options » RAC & Failsafe » which instance
which instance [message #265765] Fri, 07 September 2007 05:33 Go to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
hello
when connecting to RAC instances that runs on 2 nodes named "A" and "B" lets say
from a client machine supposing that the instance is "orclA" on node A and "orclB" on node B,
how do i connect from a client machine when using net services:
which hostname of which node do i provide ?
which service name " orclA" or "orclB" ?
and which port number
i know its a newbie question
i have read the documentation
but it talks about RAC installation and administration only

thanks
Re: which instance [message #265843 is a reply to message #265765] Fri, 07 September 2007 10:11 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You dont need to Provide the Instance Name you will give the main db name it will automatically connect to the instance wheres load will be low.

eg

let you have 2 instances ORCLa & ORCLb
you will connect like this

sqlplus user/pass@ORCL

It will automatically throw you to the instance where load will low.

In this case your TNSNAMES looks like

UCHOOSE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb01vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb02vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = UCHOOSE)
    )
  )

LISTENERS_UCHOOSE =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb01vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb02vip)(PORT = 1521))
  )

UCHOOSE2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb02vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = UCHOOSE)
      (INSTANCE_NAME = UCHOOSE2)
    )
  )

UCHOOSE1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = udb01vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = UCHOOSE)
      (INSTANCE_NAME = UCHOOSE1)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )


Re: which instance [message #266252 is a reply to message #265843] Mon, 10 September 2007 05:12 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
thanks for your kind help
Re: which instance [message #266344 is a reply to message #266252] Mon, 10 September 2007 10:53 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You welcome!!!
Previous Topic: How do I install RAC 10g on VMWare - Solaris?
Next Topic: Oracle10g RAC installation on Linux AS3 ERROR
Goto Forum:
  


Current Time: Thu Mar 28 10:18:28 CDT 2024