Hi everybody,
I have a Windows 2008 Server with an Oracle 11g R2 (11.2.0.3, Standard, 64-bit) database. I need to install an additional database (11.2.0.3, Standard, 64-bit) for tests on the same server. These tests target database patches, which shall first be applied on the new database before applying these patches on the existing database, to evaluate potential problems after patching.
I am used to install, configure and manage Oracle databases as stand-alone, RAC or as physical standby via DataGuard since 9i - as long as I am in a Un*x / linux (Red Hat Enterprise Linux, CEntOs, Oracle Enterprise Linux, etc.) environment. Setting up multiple instances in a single home or multiple homes has never been an issue for me until now.
I have searched google, oracle.com, and other related forums already. But I could not find any results regarding installing two or more Oracle homes on Windows. I have found guidelines on copying / cloning an instance into a new home, but if i recall correctly it is meant for copying / cloning onto other servers and not on the same server. Since the existing database is installed on Windows, I am afraid that I may damage the existing install by running the setup wizard again, changing Windows registry values and running the database as service.
Is it possible to have multiple homes of the same Oracle database, with same the version, edition and archiecture (11.2.0.3, Standard, 64-bit)?
If yes, how can I achieve it?
Best regards,
Crazy Bytes