Recommended Book for Oracle GoldenGate 11g Implementers

Replication has been a major requirement now-a-days as the business requirements are growing. Oracle had Streams but they wanted to have a robust replication tool and it is GoldenGate which they acquired to enhance their replication strategy.

Oracle GoldenGate is the best replication software which is very easy to configure and implement in a large scale. It is widely know to support as a replication tool or a data warehousing tool or a disaster recovery solution.

Those who are looking to start with Golden Gate I would recommend Oracle GoldenGate 11g Implementers Guide from PACKT.

The book details about GoldenGate evolution , technology overview and architecture for beginners. It leverages Installation of GoldenGate with the Prerequisites and Hardware Requirement. Then the books details through various process of configuration and implementing GoldenGate effectively. Overall a complete guide and a better understanding of GoldenGate.

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 0.0.0.0:9703 - This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager
# MONITOR_PORT = ;
MONITOR_PORT = "9723";  # This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager
oracle@testas[OBIEE]$

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.