Get "Cannot load OCI DLL: C:\Oracle\ora11\bin\oci.dll" error (4263890)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Get "Cannot load OCI DLL: C:\Oracle\ora11\bin\oci.dll" error
Beschreibung

Getting "Cannot load OCI DLL: C:\Oracle\ora11\bin\oci.dll" error for version 7.1 or 7.2
A previous version of SQL Navigator for Oracle works on the same machine.
Ursache

CAUSE 1:
A mismatch between the oracle client version and the SQL Navigator for Oracle version.
In the project manager, the default connection was set to oracle_client 32-bit.
The previous version of SQL Navigator for Oracle 7.0.1 used oracle_client 32-bit.
CAUSE 2:
Both an Oracle Instant Client and Oracle Full Client were installed under the same folder structure. The OCI.dll existed in the 11.2.0 folder (Instant) but not in the 11.2.0\bin (full) folder
Lösung
RESOLUTION 1:
Note: The 32-bit version of SQL Navigator must be used with the 32-bit Oracle client and the 64-bit version of SQL Navigator muste be used with the 64-bit Oracle client.
1. Install oracle_client 64-bit.
2. Install SQL Navigator for Oracle 64-bit.
3. Set oracle_client 64-bit as default connection.
Note:The latest version of SQL Navigator for Oracle can be downloaded at: https://www.quest.com/products/
RESOLUTION 2:
1. With SQL Navigator closed
2. Copy OCI.DLL from the %ORACLEHOME% folder to the %ORACLE HOME%\bin folder
3. Launch SQL Nav and retest

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel