Oarcle oracleHomeKey Processing Method

Oracle HomeKey error may occur in two cases.

Error description:

Initialization error

SQL * Net not properly installed

OracleHomeKey: SOFTWARE \ ORACLE

OracleHomeDir:

Solution:

1. An error is reported when you connect to oracle using some auxiliary development tools.

Modify the registry and add a field string value as follows:

Create a new string value ORACLE_HOME in the Registry HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE and write the oracle HOME value. for example, my ORACLE_HOME is D: \ oracle \ product \ 10.2.0 \ db_1. you can find ORACLE_HOME in other directories and copy the required values to the corresponding location.

2. An error is reported when PL/SQL is connected.

In PLSQL Developer, select Tools> Preferences> options or connection> and find the two parameters "Oracle Home" and "OCI Library ". select what you want, for example, mine is. ORACLE_HOME: OraDb10g_home1 OCI Library: D: \ oracle \ product \ 10.2.0 \ db_1 \ bin \ oci. dll.

To do this, restart the PL/SQL tool.