Configuring SAS Shared Services with a clustered Oracle Database


When configuring SAS Shared Services with a clustered Oracle database as the backend data store, you will need to update the webinfpltfm_config.xml file so that it expects a "/" in the JDBC connection URL of database instead of a ":". Below are the steps to configure SAS Shared Services with a clustered Oracle Database:

1. Start the SAS Deployment Wizard and only choose to Install SAS Software.

2. Once the installation is complete, open the $SASHOME$/SASWebInfrastructurePlatform/9.3/Config/webinfpltfm_config.xml file and change the ' webinfpltfm.upwd.url.end' character from a ':' (colon) to a '/' (slash) for the oracle case (see below).

<macrodef name="verifySharedServicesJdbcUrlProperty">
<sequential>
<!-- piece together the url since SDM doesn't provide it correctly -->
<!-- these hardcoded values are required here because of the SDM -->
<condition property="webinfpltfm.upwd.at.sign" value="@" else="//">
<equals arg1="${data.dbms.type}" arg2="oracle" />
</condition>
<if>
<equals arg1="${data.dbms.type}" arg2="oracle" />
<then>
<!--var name="webinfpltfm.upwd.url.end" value=":" /-->
<var name="webinfpltfm.upwd.url.end" value="/" />
</then>
<else>
<if>
<equals arg1="${data.dbms.type}" arg2="sasTransactional" />
<then>
<var name="webinfpltfm.upwd.url.end" value="" />
</then>
<else>
<var name="webinfpltfm.upwd.url.end" value="/" />
</else>
</if>
</else>
</if>
<condition property="webinfpltfm.upwd.dbms.name" value="${dbms.biservmid.name}" else="">
<not><equals arg1="${data.dbms.type}" arg2="sasTransactional" /></not>
</condition>
<var name="webinfpltfm.jdbc.url" value="jdbc:${webinfpltfm.jdbc.protocol}:${webinfpltfm.upwd.at.sign}${dbms.biservmid.host}:${dbms.biservmid.port}${webinfpltfm.upwd.url.end}${webinfpltfm.upwd.dbms.name}" />
</sequential>
</macrodef>

3. Start the SAS Deployment Wizard again and this time choose Configure SAS Software. Enter all the values that you are prompted for regarding the SAS environment as well as the Oracle database connection information.




 *****Internal-Only Information*****

Keywords: #SN47260, shared_services, cluster, clustered, oracle, oracle_database, 

Author notes

Most Recent Author: Tom La

Migration by: Christine Brady