If you use Oracle RAC as TADDM primary storage server
or TADDM domain database, these steps are required to complete the
database setup. TADDM installer does not directly support Oracle RAC
configuration.
Complete the following steps before you install TADDM secondary
storage server so that RAC configuration is automatically loaded to
TADDM secondary storage server. If TADDM secondary storage server
is already installed, you must configure the server the way you configure
Oracle RAC in the collation.properties file.
- Stop TADDM primary storage server or TADDM domain database.
- Go to the $COLLATION_HOME/etc/ directory
and edit the collation.properties file. Replace
the RAC node configuration, which is used for installation purpose
and contains all available nodes with the new configuration as shown
in the examples.
Examples:
- RAC node configuration, which is used for installation purpose.
#com.collation.db.url=jdbc:oracle:thin:@<node1_ip>:<node1_port>:<node1_sid>
com.collation.db.url=jdbc:oracle:thin:@10.10.10.1:1521:RAC1
#com.collation.db.archive.url=jdbc:oracle:thin:@<node1_ip>:<node1_port>:<node1_sid>
com.collation.db.archive.url=jdbc:oracle:thin:@10.10.10.1:1521:RAC1
- Oracle RAC configuration. In this example, two nodes are used,
but the number of nodes can be increased if needed.
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=node1) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=node2) (PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=service)))
The jdbc url
must be formatted inline and included for both com.collation.db.url and com.collation.db.archive.url.#com.collation.db.url=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=node1_ip)(PORT=node1_port))(ADDRESS=(PROTOCOL=TCP)(HOST=node2_ip)(PORT=node2_port))(CONNECT_DATA=(SERVICE_NAME=rac_service)))
com.collation.db.url=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=rac.localdomain)))
#com.collation.db.archive.url=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=node1_ip)(PORT=node1_port))(ADDRESS=(PROTOCOL=TCP)(HOST=node2_ip)(PORT=node2_port))(CONNECT_DATA=(SERVICE_NAME=rac_service)))
com.collation.db.archive.url=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=rac.localdomain)))