February 2009 Archives

If you are trying to track down a problem that only occurs on one system, say between a production system and am integration system, you want to be sure your systems can behave identically before you get into any application analysis work. You can check the basic system configuration with the host operating system diagnosis tools but what about the databases?

Oracle Enterprise Manager has a neat facility for helping with the database comparison. Using the "Deployments" register simple perform a "Compare Database Configuration" specifying the database instances you want to verify. Take a look at the Oracle 10.2 online documentation for details.

Back in September Oracle released the 10.2.0.4 version of Oracle Warehouse Builder for Windows and other platforms. If you go looking for the client download, don't look for a Windows XP client just head directly for the patch on metalink (https://metalink.oracle.com/). The patch-id is 7005587 and you will need the 32 bit client for windows.

Further details are here on the Oracle OWB blog.