7 Replies Latest reply: Aug 29, 2013 12:01 PM by user8715010 RSS

    P6 8.3 Professional Typical Install Oracle Driver Problem

    user8715010

      Hello,

       

      I have installed P6 8.3 EPPM on a machine on top of Oracle 11g database. Now I just want to see how P6 Professional interface looks like so I am trying to do P6 Typical Install.

       

      After selecting "Typical" in installation screen, it asks for

      1. Oracle Connection String

      2. UserName and Password (Database Alias is readonly and set to PMDB)

       

      I have database with SID orcl running on port 1521, my question is what should I give for connection string and username and password. Also I didn't get significance of PMDB alias.

      I tried orcl and //machine:1521/orcl in connection string and in username/password I tried PUBUSER (a schema present in oracle database) and its password, but get this error

      Bad public user name or password. Cannot load OCI DLL: oci.dll;

       

      Can someone help here?

       

      regards, Prasad

        • 1. Re: P6 8.3 Professional Typical Install Oracle Driver Problem
          gCubed

          Install the Oracle Instant Client for your database version.

           

          Make sure that it is in your path so P6 Professional can load it.

           

          V/r,

          Gene

          • 2. Re: P6 8.3 Professional Typical Install Oracle Driver Problem
            algibson

            Hi Prasad,

             

            If you are using a 64bit install of Oracle you will also need to install P6 into a path that does no contain brackets (i.e. don't put it in the (x86) folder) so C:\Oracle\Primavera P6\ is pretty common.

             

            FYI the significance of PMDB stands for Project Management Database.

             

            Regards

            Alex

            • 3. Re: P6 8.3 Professional Typical Install Oracle Driver Problem
              gCubed

              Good catch, I just ran into that the other day.

               

              V/r,

              Gene

              • 4. Re: P6 8.3 Professional Typical Install Oracle Driver Problem
                user8715010

                I unzipped appropriate oracle instant client in a folder E:\instantclient_11_2 and added this to my PATH environment variable. To counter "(x86)" path name issue(I am installing it on a 64 bit OS), I selected Advanced option and manually gave a different path.

                Error still remains the same.

                After this, I even created tnsnames.ora file in E:\instantclient_11_2 directory and set TNS_ADMIN environment variable to point to this directory and started using TNSNAME of the db in the connection string. But still no luck, I get the same error.

                 

                On your recommendation I installed instant client, but actually I have Oracle database (hosting EPPM schemas) installed on the same machine and directory E:\app\Administrator\product\11.2.0\dbhome_1\BIN already contains OCI.dll and this directory is already in the PATH environment variable.

                 

                Any clues, what might be going wrong?

                 

                regards, Prasad

                • 5. Re: P6 8.3 Professional Typical Install Oracle Driver Problem
                  daxmacher

                  Hi Prasad,

                   

                  first the P6 professional client (PPM or EPPM) uses the DBExpress in behind. So it will only work with an Oracle 32-bit client. So you can choose to use the full client or the instant client like it was mentioned above by yourself.

                   

                  So if using:

                   

                  a) Oracle Client (32bit)

                  Ensure in a console that the tnsnames.ora is used. This is easily working with tnsping <instancename>

                  If you have the Oracle 11g DB on the same maschine then the probem is that it tries to take the 64bit oci.dll from the database => I won't use the a 32bit Oracle client on the same maschine with a 64bit Oracle install under Windows. The reason is that the first one in the path is taken an I had some trouble then with the startup of the listener.

                   

                  b) Instant Client

                  Unzip the instant client under a path like <drive>:\oracle\Instantclient11_2, Put the path in front of your Path environt variable, Set a new environment variable TNS_Admin also on the instantclient-path, Put your tnsnames.ora and sqlnet.ora in that folder. Then this should work (maybe check the registry if there is a TNS_Admin key set; if yes then remove it)

                   

                  If your Database is also using EZConnect then you could also use the Connection string in ez notation //<host>:<port>/<Service> instead of tnsname.

                   

                  Regards,

                  Daniel

                  • 6. Re: P6 8.3 Professional Typical Install Oracle Driver Problem
                    user8715010

                    Hello Daniel,

                     

                    this is how my Path=E:\instantclient_11_2;...... variable looks like. I have put tnsnames.ora and sqlnet.ora in E:\instantclient_11_2 and this is how

                    TNS_ADMIN=E:\instantclient_11_2 looks like.

                     

                    Contents of tnsnames.ora

                    # tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora

                    # Generated by Oracle configuration tools.

                     

                     

                    ORACLR_CONNECTION_DATA =

                      (DESCRIPTION =

                        (ADDRESS_LIST =

                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                        )

                        (CONNECT_DATA =

                          (SID = CLRExtProc)

                          (PRESENTATION = RO)

                        )

                      )

                     

                     

                    ORCL =

                      (DESCRIPTION =

                        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.27)(PORT = 1521))

                        (CONNECT_DATA =

                          (SERVER = DEDICATED)

                          (SERVICE_NAME = orcl)

                        )

                      )

                     

                    Contents of sqlnet.ora

                    # sqlnet.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

                    # Generated by Oracle configuration tools.

                     

                     

                    # This file is actually generated by netca. But if customers choose to

                    # install "Software Only", this file wont exist and without the native

                    # authentication, they will not be able to connect to the database on NT.

                     

                     

                    SQLNET.AUTHENTICATION_SERVICES= (NTS)

                     

                     

                    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

                     

                    still the same error

                    Database connection failed: Error Message:

                    Bad public user name or password. Cannot load OCI DLL: oci.dll;

                     

                    I tried both ORCL and //172.16.3.27:1521/ORCL as connection strings.

                     

                    should instant client used be 32 bit as well?

                     

                    regards, Prasad

                    • 7. Re: P6 8.3 Professional Typical Install Oracle Driver Problem
                      user8715010

                      32 bit Instant Client solved the problem.

                       

                      Thanks Daniel.