Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've got two (2) nodes in an Oracle RAC 11g in Windows Server 2008. Oracle software is installed in C:\app.

I realized that the ORACLE_HOME path has not been set.. In System Properties-> Advanced -> Environment Variables, I see that ORACLE_HOME is empty, and I need it in order to run some Oracle patch.

  • Which path would be the ORACLE_HOME: C:\app\bd\product\11.2.0\dbhome_1
  • Do I have to setup the same in both nodes?
share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Set the ORACLE_HOME to the directory which contains bin subdirectory with the Oracle binaries (utilities) you want to use. So in effect, e.g. sqlplus should be accessible as %ORACLE_HOME%\bin\sqlplus.exe.

Set your PATH correspondingly (include the same %ORACLE_HOME%\bin subdirectory).

It would be best to have the same ORACLE_HOME on all RAC nodes to avoid confusion, and this is the default. But it is not mandatory.

By the way, theoretically you can have a separate installation of Oracle binaries, and then you can change the ORACLE_HOME to point to them and run a separate Oracle instance using these separate binaries.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.