Forum Stats

  • 3,759,454 Users
  • 2,251,545 Discussions
  • 7,870,648 Comments

Discussions

Question RE: Configuring ORDS for RAC

Joe Upshaw
Joe Upshaw Member Posts: 821 Silver Badge

During the configuration of the ORDS War file at initial setup, we're prompted for a Host Name and a Database Name. However, if the database containing the APEX installation is on a RAC, what should we supply here?

I mean, on an 8 node RAC for example, we have 8 hosts for one database. We don't want to simply pick one of them, e.g. Node 1, because that sort of defeats the main reasons to have a RAC in the first place,  fail over.

Hopefully, the answer isn't obvious but, if so, please let me know.

Thanks,

-Joe

kamreddy

Best Answer

  • Joe Upshaw
    Joe Upshaw Member Posts: 821 Silver Badge
    Accepted Answer

    Not sure that anyone actually monitors this community at all. Almost all of the answers I see here are those where the poster, eventually, finds the answer for himself and posts it...including this one.

    To connect to a RAC, you simply specify the SCAN Listener's "host" name. Although this is a virtual host, ORDS has no problem connecting to it and making use of it.

    If you have older style RAC configurations, i.e. lacking SCAN listeners, then you can use the TNS Alias version:

    Create file with these entries:

    db.connectionType=tns

    db.tnsAliasName=mydb

    db.tnsDirectory=d:/oracle/mydb/network/admin

    db.hostname=

    db.port=

    db.servicename=

    Assuming the file you created was named ords_db_properties.txt, you would load this into ORDS with the following command:

    java -jar ords.war set-properties d:\ords_db_properties.txt

    *sigh*

    -Joe

    kamreddy

Answers

  • Joe Upshaw
    Joe Upshaw Member Posts: 821 Silver Badge
    Accepted Answer

    Not sure that anyone actually monitors this community at all. Almost all of the answers I see here are those where the poster, eventually, finds the answer for himself and posts it...including this one.

    To connect to a RAC, you simply specify the SCAN Listener's "host" name. Although this is a virtual host, ORDS has no problem connecting to it and making use of it.

    If you have older style RAC configurations, i.e. lacking SCAN listeners, then you can use the TNS Alias version:

    Create file with these entries:

    db.connectionType=tns

    db.tnsAliasName=mydb

    db.tnsDirectory=d:/oracle/mydb/network/admin

    db.hostname=

    db.port=

    db.servicename=

    Assuming the file you created was named ords_db_properties.txt, you would load this into ORDS with the following command:

    java -jar ords.war set-properties d:\ords_db_properties.txt

    *sigh*

    -Joe

    kamreddy
This discussion has been closed.