DOA and ALL_HOMES

[Tierry]

In our environment, there is only one Home ( HOME1)under Oracle\Software registry key. There is no information at Oracle\Software registry root. Also, it does not contain the ALL_HOMES.

I have tried to run an application using DOA by setting at design time Oracle Home and OCIDLL parameters.

I have also tried it at runtime by setting these parameters:
--
AnsiString OracleHomeName = "sms";
AnsiString OCIDLL = "C:\\ORA32\BIN\\OCI.DLL";
//where sms is the registry value for ORACLE_HOME_NAME key under HOME1
---

I have got an error message saying that SQL*Net is not properly installed.

However if the registry contains ALL_HOMES, it works fine.

My question is: Is there a way to make it work without having ALL_HOMES under Software/Oracle ? O

Thank you in advance for your support.

 

[Marco Kalter]

If your Oracle Home is SOFTWARE\ORACLE\HOME1, then you must also have a SOFTWARE\ORACLE\ALL_HOMES\HOME_COUNTER key, otherwise it will not be found.

You can also set an ORACLE_HOME environment variable though, pointing to the home directory. In this example c:\ora32.

 

[ltd]

One other thing i saw in your example code:

AnsiString OCIDLL = "C:\\ORA32\BIN\\OCI.DLL";

Here is a backslash missing.
It should be "...\\bin..."

Lars

 

[Tierry]

Thank you

I have already correted that ("C:\\ORA32\\BIN\\OCI.DLL") in my source code but it does not solve the problem.

Also, as Marco has suggested, I set ORACLE_HOME to C:\ORA32 in both user variables and system variables under Windows 2000. But the OCI still does not initialize if I do not have ALL_HOMES under Software/Oracle.

Any other idea ?

 

[Marco Kalter]

Are you using 4.0.6? This is required for the ORACLE_HOME environment variable support. It is really a side-effect of the added support for the Oracle10g Instant Client.

 

[Tierry]

I am using 4.0.5.0 which we bought last June (serialnumber 01.20709). We are using Oracle 8i but we plan to move to Oracle 10g maybe next year.

How to update from DOA 4.0.5 to DOA 4.0.6 ?

Thank you

 

[Jens Fudickar]

Try a download from the registered page

 

[Tierry]

I have successfully downloaded and installed the latest version of DOA 4.0.6.2 over the previous version 4.0.5.0 and, with the setting of ORACLE_HOME in the environment variable, everything works now.

Thanks for your support.