How does DOA choose which Oracle client to use?

[cjmoore]

I have Oracle 8i, 9i and 10g clients installed, how does DOA choose which to use as 8 and 9 can be found in ALL_HOMES but 10's details are stored separately in the registry?

Thanks
Cary

 

[Marco Kalter]

Direct Oracle Access uses the Primary Oracle Home by default. This his the home that is listed first in the PATH environment variable.

 

[cjmoore]

Thanks Marco, does this mean DOA searches the PATH until it finds something matching the homes listed in the registry?

 

[Marco Kalter]

Yes, that is correct.