How to get DocuShare to connect to an Oracle SCAN

Prerequisites:

Gather the following information:

·         SCAN name

·         SCAN service name (this is the equivalence of SID on the SCAN server)

·         SCAN database name

·         SCAN port #

Note:  You must be an Administrator to perform this solution.

1.     Stop DocuShare.

2.     Modify JDBCpropertybean.properties file.

To modify the JDBCPropertybean.properties file:

a.     Open a Windows Explorer and browse to the <dshome>\config directory.

Where <dshome> is replaced with the installation path for DocuShare.  Depending on your installation environment this path may vary.  The default installation path is C:\Xerox\Docushare.

b.    Make a copy of the jdbcpropertybean.properties file and rename it jdbcpropertybean.properties.orig

c.     Open the <dshome>\config\jdbcpropertybean.properties file in a text editor.

d.    Search for the url= setting.

e.     Change to the following url=jdbc\:docushare\:oracle\://SCAN_name\: SCAN_port #;ServiceName\=SCAN_service_name

Where SCAN_name is replaced with the your Scan name, SCAN_port is replaced with your scan port number, and SCAN_service_name is replaced with your SCAN service name.

Example:

url=jdbc\:docushare\:oracle\://scanserver.solutions.ca\:1521;ServiceName\=SIS_CRS

f.     Search for the database= setting.

g.    Change to the SCAN database name.

h.     Save the file.

3.     Modify the dw.xml file.

To modify the dw.xml file:

a.     Open a Windows Explorer and browse to the <dshome>\drala\dwe\conf directory.

Where <dshome> is replaced with the installation path for DocuShare.  Depending on your installation environment this path may vary.  The default installation path is C:\Xerox\Docushare.

b.    Make a copy of the dw.xml file and rename it dw.xml.orig

c.     Open the dw.xml file in a text editor.

d.    Search for the following entry:

<driver>oracle.jdbc.driver.OracleDriver</driver>

e.     Change the <URL> section to the following:      

<url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=SCAN name)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SCAN SERVICE NAME)))</url>

Note:  The file may read (CONNECT_DATA=(SID=SERVICE_NAME=SCAN SERVICE NAME)))  If this is the case please remove SID= from the CONNECT_DATA= section.

f.     Save the file.

4.     Start DocuShare.

Solution Published:  February 4th, 2011