WebCenter Interaction and RAC

Thursday, April 16, 2009

I recently had to help a client decipher some older G6 documentation about using the Plumtree/ALUI/WCI portal with RAC and thought it might be useful to post the distilled instructions here.

A. Create a tnsnames.ora file in your PT_HOME/settings directory that contains something similar to the text below. Note replace the HOST and SERVICE_NAME entries with values that make sense for your system.

RAC = 
  (DESCRIPTION = 
(ADDRESS_LIST= 
  (FAILOVER = ON) // Connection-Time Failover 
  (LOAD_BALANCE = ON) // Client Load x 
  (ADDRESS= (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521)) 
  (ADDRESS= (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521)) 
) 
(CONNECT_DATA= 
  (SERVICE_NAME = PLUM10.plumtree.com) 
) 
  ) 
 

B. Open the file configuration.xml in a text editor, look for the line:

    <component name="opendb:DBConnection/oracle" type="http://www.plumtree.com/config/component/types/opendb">

Under this line, insert the following entries:

<setting name="database-connection:rac-tnsnames-file">
<value xsi:type="xsd:string">C:/alui65/settings/tnsnames.ora</value>
</setting>
<setting name="database-connection:rac-tnsnames-data-source">
<value xsi:type="xsd:string">RAC</value>
</setting>

Obviously replace my hard code C:/alui65/settings/tnsnames.ora with your value. Note the data-source value used above, RAC, must match what is tnsnames.ora (the RAC= at the beginning)

C. Repeat step B for the following lines in configuration.xml:

 
<component name="aluidirectory:openjdbc" type="http://www.plumtree.com/config/component/types/opendb">
<component name="activityservice:persistence" type="http://www.plumtree.com/config/component/types/opendb">

D. Just do a search of the file for your database SID to make sure no other spots were missed.

Posted by Gerald Nunn at 8:57 AM | Categories: WCI | Permalink