This discussion is archived
1 2 Previous Next 22 Replies Latest reply: Aug 8, 2012 2:19 PM by 954698 RSS

Windows PATH variable

3004 Newbie
Currently Being Moderated
Hi,

We have installed the Instant Client files in the application's directory at c:\Program Files\Product Name\" and added this directory to the front of our PATH environment variable. However when we run our application, we get the following error:

"Initialization error
SQL*NET not properly installed

OracleHomeKey:
OracleHomeDir:"

Does anyone have any ideas as to why this would be?
  • 1. Re: Windows PATH variable
    352290 Newbie
    Currently Being Moderated
    Alex,
    Is there a previous installation of Oracle on the same machine? Are there lingering variables?
  • 2. Re: Windows PATH variable
    3004 Newbie
    Currently Being Moderated
    Hi Toliver,

    The application was installed and working, then the machine was rebuilt and the application re-installed. So there should be no "malingering", but what should I look for to make sure that no additional items were added as part of the standard rebuild?

    Alex
  • 3. Re: Windows PATH variable
    3004 Newbie
    Currently Being Moderated
    Toliver, I have since discovered, if I set ORACLE_HOME to ".", then it works. From reading about this issue in a posting on this forun over a year ago, this was meant to be fixed. I downloaded the latest version and the same behaviour exists. Is there something else I am doing wrong?
  • 4. Re: Windows PATH variable
    487048 Newbie
    Currently Being Moderated
    Did anyone find a solution to this? I'm having this exact same problem, and I haven't found any answers anywhere online. I completely uninstalled and reinstalled Oracle 10g Enterprise Edition. I can connect to the databases with ODBC and the Oracle set up programs, but not in Borland, which gives the exact error message as listed above, except OracleHomeKey is SOFTWARE\ORACLE. OracleHomeDir is still blank. Any help would be appreciated.
  • 5. Re: Windows PATH variable
    352290 Newbie
    Currently Being Moderated
    For Windows, I suspect there may be some cleaning left in the registry, though I am not sure which registry settings they may be. You may want to look there.
  • 6. Re: Windows PATH variable
    238842 Newbie
    Currently Being Moderated
    I have the same problem. I tried reinstalling the client a few times, downloaded a more recent version. This seems to be an uncommon error, because there does not seem to be a lot of references anywhere to this error.
  • 7. Re: Windows PATH variable
    494895 Newbie
    Currently Being Moderated
    I had the same problem. i tried to install Oracle 10g client to conect an Oracle 10g database. I solved the problem completelly removing Oracle client and installing again Oracle 9i Client to connect the same database with my application. It worked for me

    Hope that can help.
  • 8. Re: Windows PATH variable
    504602 Newbie
    Currently Being Moderated
    I had same problem here, and I am using Oracle 10g 64-bits.
  • 9. Re: Windows PATH variable
    LaurenzAlbe Journeyer
    Currently Being Moderated
    The usual tip:
    Run a client trace by setting
    TRACE_LEVEL_CLIENT=SUPPORT and
    TRACE_DIRECTORY_CLIENT=wherever
    in sqlnet.ora and trying again.

    Yours,
    Laurenz Albe
  • 10. Re: Windows PATH variable
    user508774 Newbie
    Currently Being Moderated
    Hello,

    Don't need the trace stuff, I fixed the error by doing the following:
    just go windows/start/run regedit
    find Oracle entry, check All_Homes and HOME0 two entries inside, correct the path and group names.

    Good luck.
  • 11. Re: Windows PATH variable
    user508774 Newbie
    Currently Being Moderated
    Hello,

    Don't need the trace stuff, I fixed the error by doing the following:
    just go windows/start/run regedit HKEY_LOCAL_MACHINE/SOFTWARE
    find Oracle entry, check All_Homes and HOME0 two entries inside, correct the path and group names.

    Good luck.
  • 12. Re: Windows PATH variable
    491831 Newbie
    Currently Being Moderated
    I think if you're using InstantClient, the recommendation is that you don't set ORACLE_HOME any more, so remove/rename it in the registry. If necessary, oracle recommend setting TNS_ADMIN to point to the directory where your tnsnames.ora exists (if you're using one).
    Also recommeded to locate tnsnames.ora separate to the instantclient directory
    eg
    TNS_ADMIN=c:\oracle\config
    PATH=c:\oracle\instantclient10_1
  • 13. Re: Windows PATH variable
    504541 Newbie
    Currently Being Moderated
    We have the same problem for PLSQL Developer. Some old keys these programs try to access are missing from Oracle 10g, so make a reg file like this:

    (replace my installation name ORACLE_HOME with yours):

    [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
    "inst_loc"="C:\\Program Files\\Oracle\\Inventory"
    "API"="D:\\oracle\\product\\10.1.0\\db_1"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES]
    "HOME_COUNTER"="1"
    "DEFAULT_HOME"="HOME0"
    "LAST_HOME"="0"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\ID0]
    "NAME"="Oracle - ORACLE_HOME"
    "PATH"="D:\oracle\product\10.1.0\db_1"
    "NLS_LANG"="NA"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
    "ID"="0"
    "ORACLE_GROUP_NAME"="Oracle - ORACLE_HOME"
    "ORACLE_HOME_NAME"="ORACLE_HOME"
    "ORACLE_HOME"="D:\\oracle\\product\\10.1.0\\db_1"


    Keywords:
    plsql developer oraclehomedir error Oracle 10g
    sql not properly installed toad instant client
  • 14. Re: Windows PATH variable
    559274 Newbie
    Currently Being Moderated
    Thanks this was very helpful - got our issue resolved.

    Message was edited by:
    user556271
1 2 Previous Next