how to connect 11gR2 RAC db using sql

Tagged: 11gR2

This topic is empty.

Viewing 5 reply threads

Author

Posts
- 20 March, 2010 at 3:17 am #1920
  
  bhagirathipatra
  Participant
  
  Hi,
  
  Our product support 11gR2 DB or higher.in my installation of the product my product installer need DB configuration parameter. i have a 11gR2 RAC setup. when my prod ask for db, i choose the RAC config and next screen it ask “provide RAC db in host1:port1:sid1,host2:port2:sid2″.
  
  Is it the right behavior of the installer or it should ask the SCAN parameter ?
  
  plz suggest
- 23 March, 2010 at 9:42 am #2103
  
  Saurabh Sood
  Member
  
  If you have configured SCAN while setting up RAC then you should give the SCAN name to connect to DB.
  
  What do you mean by following line:
  
  “when my prod ask for db” ??
- 23 March, 2010 at 12:47 pm #2104
  
  bhagirathipatra
  Participant
  
  Thanks Saurabh,
  
  “when my prod ask for db” ?? means, the Installer has a screen where we have to provide DB credential. if its a rac then what would be be format ?
  
  ie scan-name:port:sid or servicename
- 23 March, 2010 at 12:48 pm #2105
  
  bhagirathipatra
  Participant
  
  apart from this any other way can we define ?
- 25 March, 2010 at 7:22 am #2106
  
  Saurabh Sood
  Member
  
  I am not aware of the installer you are talking about, but you can use service name to connect to the rac instance if the service name is mapped in the tnsnames.ora file.
- 12 June, 2010 at 11:06 am #2107
  
  Amit Bansal
  Keymaster
  
  HI, Looking like a interesting thread going on. Its good that people are actually willing to share their views on this topic.
Author

Posts