Tuesday, March 8, 2011

OBIEE 11g Managing Ports

When performing Vertical Scaling I faced problems with the port when I increased a process to the Oracle BI Server. 

Looking into the logfiles found that the added component was using an already assigned and used port. So had to change the ports and restart the services.

[2011-02-24T15:57:38.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 004bG_5m2nL52jk5Ozg8yd0003EW000000] [tid: 61df4b20]  [nQSError: 12002] Socket communication error at call=bind: (Number=98) Address already in use

When the issue happened I modified the NQSConfig.INI file parameter RPC_SERVICE_OR_PORT and MONITOR_PORT. Later on another restart the changes were overwritten and again the service had a problem. The log files reflected the same messages.

oracle@testas[OBIEE]$ grep -i port NQSConfig.INI
RPC_SERVICE_OR_PORT = "9722";  # default is - This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager
MONITOR_PORT = "9723";  # This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager

The PORTS are controlled by Fusion Middleware Control and not possible to manually update them.
So how to change the ports ? I could not find an option to modify the port for the Oracle BI Server (the second instance which I added ). 

Reading through the admin guide it says
The RPC_SERVICE_OR_PORT parameter is centrally managed by Fusion Middleware Control and cannot be changed by manually editing NQSConfig.INI, unless all configuration through Fusion Middleware Control has been disabled (not recommended). The Port Range From and Port Range To options on the Scalability tab of the Capacity Management page in Fusion Middleware Control override the  RPC_SERVICE_OR_PORT parameter.

I did not have an option to release the port which it was looking for , so had to adjust the port range to a different start and end value. Made sure that the port range are not in use.

Here I modified the start range to 9720 from the default 9700.
Restarted all the services to the BI Components will start to listen from the new ports.

Popular Posts