By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,278 Members | 1,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,278 IT Pros & Developers. It's quick & easy.

Batch Command to Switch between two Oracle Homes

P: 1
I have two Oracle Homes (9iR2 & 10g R2) installed on Windows Server 2003. I have jobs running on my 9i database for backup and they are now failing because the default home is now10g as that was installed last. I need a command which will switch my Oracle Home to 9i so I can run these jobs. I can use the Universal Installer to change homes, but I need a batch command so I do not need to do so manually. I have tried ohsel -switch "Oracle Home Name" but it returns the message, “only one home installed". I have also tried SET ORACLE_SID=SID and input the SID for my 9i home, and while it does not return an error message I find I am still in the 10g home. Anyone know how to resolve?
Apr 9 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.