Issue/Symptom/Question

Receiving an error on login regarding the Oracle.dll not available. Error message: "Oracle library OCI.DLL could not be loaded."

Applies To

Penta for Windows - Local Install

Resolution/Fix/Answer

This error generally comes up when Oracle 64-bit is installed on a box after Oracle 32-bit was already installed. The PENTA software can no longer find or open the Oracle 32-bit OCI.DLL file.

Here is what you will likely need to do:

1. Check the value of the tns_admin system variable. To do this:

   1. Open a command prompt, and type “set tns_admin”. You should see the following path returned: c:\oracle\product\<some version>\client_1\network\admin. If not this value, then you will need to set the environment variable to your actual path name.

2. Look at the c;\oracle\product\<version> folder. You should just have a client_1 folder at this level, but I’m guessing that you may also have a client_64 folder, which means that Oracle 64 is also installed. If so:

   1. Go into your system environment variables, and check your PATH variable. The client_64 path will likely be before the client_1 path in the string of paths. You need to move the client_1 entry to be the first entry in the PATH variable.

   2. You will also need to update directory and file permissions so that the folders and files under the client_1 path have read/write opened up on them. The Oracle 64 install changes permissions on the client_1 folder and everything below, closing them off.

3.  Microsoft Visual C++ Redistributable 2015-2022, 2010 x86 needs to be installed as well as x64

Once you do these steps, the user should be good to go again. If not, please log a support ticket and reference this article.