how to connect 11gR2 RAC db using sql

Home Forums Real Application Cluster how to connect 11gR2 RAC db using sql

Tagged: 

This topic contains 5 replies, has 0 voices, and was last updated by  bhagirathipatra 7 years ago.

  • Author
    Posts
  • #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

  • #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” ??

  • #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

  • #2105

    bhagirathipatra
    Participant

    apart from this any other way can we define ?

  • #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.

  • #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.

You must be logged in to reply to this topic.