23 total views, 23 views today

Primavera P6 Error: Primavera P6 Error: Connection attempt to database failed with message Cannot find OCI DLL

The following error appears when connecting to Primavera P6 Professional on Oracle database. The reason is P6 DB connection wizard failed to find the below file.

Bad public user name or password. PRM DBAccess Error: Connection attempt to database failed with message Cannot find OCI DLL

Fix:

The Oracle DB client ships with the all of the required files needed for P6 Professional to connect with Oracle database. OCI.dll is one file among them and present under the ORACLE_CLIENT\bin directory similar to below 

• If you are installed the Primavera P6 Professional less than Version 8 then install the Oracle Database 32 bit client ( Oracle 12.1.0.1 OR Oracle 11.2.0.4 ) because those P6 professionals are only 32-bit versions

(Or)

• The later versions of P6 Professional support both 32 and 64-bit version. You selected either 32/64 bit during the installation similar to below image. So If you installed 32 bit Professional then install 32 bit Oracle client, if you installed 64-bit P6 professional then install 64 bit Oracle client and try again.

Additional Notes:

1. Make sure the oci.dll is present in your SYSTEM path

2. Make sure you have read access to the OCI.dll file

3.Read the Tested config of the P6 professional to install the correct version of Oracle DB client. As of P6 17.7, the Oracle DB version, 12.1.0.1 and 11.2.0.4 are supported.