Re: "Oracle error occurred, but error message could not be retrieved from Oracle" error when restarting application

fvanboven_at_gmail.com wrote:

> Hi,
>
> we're using Oracle 10g, in combination with Delphi (7). Application
> uses Oracle client dll (oraociei10.dll).
>
> Quick explenation about the structure (All files are on the network):
>
> - A launcher application is started by the client. The launcher
> application checks an .ini file for the current application versie
> (.exe filename with a version postfix, e.g. "Application_112.exe"). The
> launcher starts the executable specified in the .ini file. In this way
> we can "release" by putting a new .exe file and updating the .ini file.
>
> The problem:
>
> In our application we've got the functionality to restart the
> application when a new version is available. If the application
> detects there is a new version (by checking the .ini file) the user can
> restart the application. The next thing happens on a restart:
>
> - Application starts the launcher again, the handle of the application
> is passed.
> - Application closes itself
> - Launcher waits until the application handle is gone
> - Launcher restarts application again (new version).
>
> When starting the application again, oracle generated the beautiful:
>
> "Oracle error occurred, but error message could not be retrieved from
> Oracle"
>
> message. Initial thought was that the Oracle client was not unloaded,
> so we made the launcher wait up to 60 seconds after the application was
> closed and before the application is started again. But even then the
> error occurs.
>
> Detail: When not using the oracle client , but the "normal" oracle
> installation, no errors occur and the restart works as planned (and
> programmed ;) )
>
> Hope someone can help,
>
> Frank van Boven

Hi. I suspect that when restarting the application, the shell's environment variable ORACLE_HOME is not set, or set incorrectly. Oracle's native client code looks to that to find the text for error messages, which is stored in external files to the executable.
HTH,
Joe Weinstein at BEA Systems Received on Mon Dec 05 2005 - 11:00:43 CST