This discussion is archived
7 Replies Latest reply: Aug 29, 2013 10:01 AM by user8715010 RSS

P6 8.3 Professional Typical Install Oracle Driver Problem

user8715010 Newbie
Currently Being Moderated

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 Journeyer
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    32 bit Instant Client solved the problem.

     

    Thanks Daniel.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points