Database Technologies...!

I am planning to post a set of articles covering various DR options provided by Oracle, DB2 and Progress OpenEdge database. This will include setup guides for Oracle DataGuard, DB2 HADR and OpenEdge Fathom Replication. Series will be started with basic setup of each of these technologies, and then these will be reconfigured, changed as per the requirements to demonstrate different recovery scenarios. First I will setup a simple HADR system using Virtualbox. At the start only basic setup will be configured and will be changed/ reconfigured when testing different DR situations. Virtualbox Setup Install OS and db2 (I am using Oracle linux 5.6 (32) and db2 10.1 (32)) into single VM. Clone or manually create another duplicate server.  Make sure to configure network connectivity between two machines. Use different hosts names. In this example my primary would be "db21" and standby is "db22" DB2 Setup step 1 – Create two db2 instances ...

DB - Oracle 11gR2 OS - Oracle Linux 5.6 Sometimes it is required to install Oracle without the GUI. Oracle provides silent install capability for this, where installation is totally controlled by a response file. Response files can be generated while performing a GUI installation using OUI by starting the   runInstaller with –record and –destinationFile options as below, ./runInstaller -record -destinationFile <Path_to_Create_Response_File> This will record whatever the options selected on GUI installation and store them in response file in given path. Also you can use sample response file and edit them. I have attached the response file used for this example. The options on the file are self-explanatory so you can edit them to match your environment. Once you have a proper response file silent installation is straight forward task. Also oracle provides some runInstaller options to manage the setup as well. So using the attached response fi...