Full Error Text : Bad public user name or password. PRM DBAccess Error: Connection attempt to database failed with message Cannot load OCI DLL : D:\app\Admin\product\12.2.0\client_1\BIN\oci.dll;
I will show the solution of the error that occurs when you try to connect a database from Primavera application.
You will get this error when the database and Oracle database client versions are different. You must install the correct client to access the database. Otherwise this error occurs and Primavera cannot connect to database.
Firstly, you must check your database’s version. You can check that like below ;
SQL> select version from v$instance; VERSION ----------------- 12.2.0.1.0
Then go to this website and find the same client version with the database. Also, be sure the architecture of the client is same with your operating system’s architecture (32/64 bit).
https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
After you download and install the client correctly , this error won’t be happen.
You can find the Oracle database client installation steps at this article :
https://ittutorial.org/2019/03/29/step-by-step-installation-of-the-oracle-12c-client-for-windows/
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/
As for the connection to the database, I use salesforce odbc driver.