Re: CPU April 2005 patching madness
A couple of folks have asked about the ORACLE_HOME environment variable.
When working on Win32 boxes with multiple instances of Oracle I always
set ORACLE_HOME to the correct location for the database in use.
The PATH is set to include only the %ORACLE_HOME%\bin for the
database currently in use.
These values are also set in the registry for my session.
( HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Environment )
The ORACLE_HOME always required when using opatch.
The opatch.cmd script pulls it from the environment and passes it to
The patch instructions include setting ORACLE_HOME in the current CMD
Certifiable Oracle DBA and Part Time Perl Evangelist