Sometimes it is almost funny how old habits indeed seldom die. At the Customers site where I am working there still seems to be a culture in which it is not that common to use Gui solutions offered by Oracle to do day-to-day jobs. In Dutch there is an expression telling unknown things makes things disliked. Well this week i came across nice behavior of the NETCA tool in an environment where Grid Infrastructure 220.127.116.11 is running and I must say I really liked it.
My environment is a four Node Cluster on Redhat Linux 5.5, my Grid Infra structure is 18.104.22.168.0.
This week i have patched a preproduction environment with latest PSU patch at this moment ( October 2012). Next week will do the same on the production machines In it self this action is not a big issue when applying it to the Grid infra structure and RDBMS, but ACFS is in use on those boxes. Since I hope this will make an interesting note, I have gathered my steps and want to share them with you.
For a customer I have to implement Oracle Warehouse builder on several servers. So it became an interesting session cause during exploring, well actually it was already during installing found out that there are dependencies to other products that need to be present in the database before you can finish the job successfully. But as always Google is your friend so i was very happy in the end to summarise the steps and put them to a blog.
Bottom-line is that the following components need be present in your database before you can start with the Oracle Warehouse builder:
- Java virtual Machine
The remarkable thing was that during exploring i came across the fact that if you create your database via DBCA these components are installed. If you are a diehard and use the command line / scripts for that well then you need to do just a bit extra to be victorious. The environments in this note were set up manually.