Q
Problem solve Get help with specific problems with your technologies, process and projects.

Temporarily renaming files for testing purposes

Am I at risk if I temporarily rename the /etc/oraInst.loc file so I can put up a separate Oracle home for upgrade testing purposes? I can't fool with the "real" test/dev/prod instances which all are on the same set of executables.

Am I at risk if I temporarily rename the /etc/oraInst.loc file so I can put up a separate Oracle home for upgrade testing purposes? I can't fool with the "real" test/dev/prod instances which all are on the same set of executables.
If I understand your situation correctly, it sounds like both non-production and production databases reside on the same server. You would like to test a database upgrade without affecting the existing binaries and databases.

The preferred option is to separate your non-production database from production databases so they reside on separate servers. This, then, makes it possible for you to test database upgrades and patches without affecting your production systems. But I will assume that this is not a viable option, so, in theory, you could rename the oraInst.loc file or change the value in it. You would probably also want to rename the oraInventory directory so that it is not overwritten.

Before installing and patching the new binaries, be sure that you define a new ORACLE_HOME so that the existing binaries are not overwritten. A big word of caution here: before you attempt to upgrade or patch the existing binaries (or install any new Oracle components), you will have to change the oraInst.loc file back to what it was and also restore the previous oraInventory directory. Note that this approach is not supported by Oracle and I do not recommend it either as it is quite risky. Oracle supports only one central inventory per server. In the long run, it would be best to separate your environments.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close