- 3,723,268 Users
- 2,244,521 Discussions
- 7,850,383 Comments
Forum Stats
Discussions
Categories
- 16 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 2.1K Databases
- 607 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 32 Multilingual Engine
- 497 MySQL Community Space
- 7 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 421 SQLcl
- 61 SQL Developer Data Modeler
- 185.1K SQL & PL/SQL
- 21.1K SQL Developer
- 2.4K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.6K Development Tools
- 12 DevOps
- 3K QA/Testing
- 334 Java
- 10 Java Learning Subscription
- 12 Database Connectivity
- 71 Java Community Process
- 2 Java 25
- 11 Java APIs
- 141.2K Java Development Tools
- 8 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 16 Java SE
- 13.8K Java Security
- 4 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 147 LiveLabs
- 34 Workshops
- 10 Software
- 4 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 4 Deutsche Oracle Community
- 16 Español
- 1.9K Japanese
- 3 Portuguese
Question RE: Configuring ORDS for RAC

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
Best 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
Answers
-
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