308 total views, 4 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 

 

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

 

  • 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.

 

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

 

 

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. 

 

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

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply šŸ™‚
govindan Primavera P6 Error: Primavera P6 Error: Connection attempt to database failed with message Cannot find OCI DLL
Connect me
By | 2017-11-10T19:15:27+00:00 November 10th, 2017|Categories: P6|Tags: , , , |1 Comment
  • nilesh megha

    nice document

Like us on Facebook.
Connect!