Home » RDBMS Server » Enterprise Manager » Batch command to switch between Oracle Homes (9i & 10g)
Batch command to switch between Oracle Homes (9i & 10g) [message #229678] Mon, 09 April 2007 12:42 Go to next message
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?
Re: Batch command to switch between Oracle Homes (9i & 10g) [message #229770 is a reply to message #229678] Tue, 10 April 2007 00:16 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Before you batch job export ORACLE_HOME/set ORACLE_HOME.

Regards
Taj
Previous Topic: OEM Error
Next Topic: Help in installing
Goto Forum:
  


Current Time: Thu Mar 28 11:09:33 CDT 2024