| Batch command to switch between Oracle Homes (9i & 10g) [message #229678] |
Mon, 09 April 2007 12:42  |
suzyque54
Messages: 14
Registered: December 2006
|
Junior Member |
|
|
|
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
