Change Ports for SAW, SAS and Scheduler component

Sometime there is requirement to change the default ports for Oracle Analytics Web server, Analytics Server and Scheduler component. Some company even has a security policy not to use the default ports for the application.

In order to change the default port for Oracle Analytics Server (SAS), open the NQSConfig.INI file from /oraclebi/product/OracleBI/server/Config in vi or any other editor. Change the value of RPC_SERVICE_OR_PORT parameter. Default value is 9703. For example

RPC_SERVICE_OR_PORT = 10073;

Once you change the SAS Server port, make sure to modify the AnalyticWeb ODBC connection in odbc.ini file in /oraclebi/product/OracleBI/setup folder. This ODBC connection is used by SAW Server so it also need to be changed to reflect the correct port.

[AnalyticsWeb]
Driver=/oraclebi/product/OracleBI/server/Bin/libnqsodbc.so
Description=Oracle BI Server
ServerMachine=local
Repository=
Catalog=
UID=
PWD=
Port=10073


In order to change the default port for Oracle Analytics Web Server (SAW), open the instanceconfig.xml file from /oraclebi/product/OracleBIData/web/config in vi or any other editor. Add the name-value pair Listener, attribute port within ServerInstance tag. Default value is 9710. For example

<Listener port="10076"/>

Once you change the SAW Server port, also make sure to change the configuration file of SAW Plug-in. SAW plug-in need to know where the SAW Server is running. In case of Oracle Application J2EE Server, update the web.xml file of the Analytics application in the ias/product/asmt_10131/j2ee/bianalytics/applications/analytics/analytics/WEB-INF folder.

<servlet>
<servlet-name>SAWBridge</servlet-name>
<servlet-class>com.siebel.analytics.web.SAWBridge</servlet-class>
<init-param>
<param-name>oracle.bi.presentation.sawserver.Host</param-name>
<param-value>localhost</param-value>
</init-param>
<init-param>
<param-name>oracle.bi.presentation.sawserver.Port</param-name>
<param-value>10076</param-value>
</init-param>
</servlet>


In order to change the default port for Oracle Analytics Scheduler component, you need to configure the Scheduler configuration using schconfig utility on Unix platform or via Job Manager on Windows. Launch the schconfig utility

$pwd
/oraclebi/product/OracleBI/setup
$. ./user.sh
$. ./sa-init.sh
$schconfig

Select Option 1- Configure Scheduler and then Option 2-General. Change the port number in option 4. Default port is 9705.