Real Application Cluster

AskDBA.org Forum » Real Application Cluster

how to connect 11gR2 RAC db using sql (6 posts)

About This Topic

Tags

  1. bhagirathipatra

    new member
    Joined: Mar '10
    Posts: 3

    offline

    Posted 1 year ago
    #

    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

  2. Saurabh Sood

    admin
    Joined: Jun '08
    Posts: 46

    offline

    Posted 1 year ago
    #

    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" ??

    Saurabh Sood
    Senior Consultant:DBA Services
  3. bhagirathipatra

    new member
    Joined: Mar '10
    Posts: 3

    offline

    Posted 1 year ago
    #

    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

  4. bhagirathipatra

    new member
    Joined: Mar '10
    Posts: 3

    offline

    Posted 1 year ago
    #

    apart from this any other way can we define ?

  5. Saurabh Sood

    admin
    Joined: Jun '08
    Posts: 46

    offline

    Posted 1 year ago
    #

    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.

  6. Anonymous



    Posts: 3

    offline

    Posted 1 year ago
    #

    HI, Looking like a interesting thread going on. Its good that people are actually willing to share their views on this topic.

Reply

You must log in to post.

AskDBA.org Forum » Real Application Cluster
251 posts in 104 topics over 45 months by 63 of 110 members. Latest: xiaoling, Williams29, Agatha