Thursday, August 11, 2011

Quick thoughts - Primavera p6 v7 on W2K8 Server x64/Citrix XenApp 5

Oracle's documentation on installing Primavera in a x64 terminal server environment doesn't quite get us all the way there...


Some items I have found that should be better documented for installing on a Citrix server:


1 - You must install a x86 Oracle client - Primavera does not have a x64 client in this version.  This also means you have to configure ODBC from c:\windows\sysWOW64\odbcad32.exe.
2 - On a Windows 2008 x64 server, I had to allow PM.exe and dbconfig.exe within DEP (data execution prevention).  I have not had to do this for any other of the many applications installed on the server.
3 - Since this is a x86 client, it does not seem to like being installed in "Program Files (x86)".  Install it in a folder without the (x86) designation.


Edit:  After figuring these items out, the Primavera installer would still fail when attempting to run dbconfig.exe.  I received the following message:


"Bad public user name or password. Database Server Error: OCI version 11.2.0.1.0 Production is not supported;"


A case was opened with Oracle and they provided 3 dll's that needed to be replaced.  The issue is due to a bug in the installer for V24733 (P6v7 w/SP3) in combination with the 11gR2 client (32-bit).  This has solved the issue.

6 comments:

  1. Tom, This is the same issue I have, what 3 dll's did Oracle provide?

    ReplyDelete
  2. @Jesse

    The names of the dll's are: dbexpoda30.dll DbExpPrC.dll dbexpsda30.dll If you have a support contract with Oracle, they should be able to provide these to you. I would mention that this issue has been reported as part of a bug with installing media pack V24733 (P6v7 w/SP3) in combination with the 11gR2 client (32-bit). Hope this helps

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Turning off DEP for PM.exe worked for us. Windows 2008 R2 TS with Oracle 10g 32 bit client.

    Note: Any application (including Primavera) that is installed in c:\program files (x86) with the 10g 32 bit client requires a short path (c:\program~2\oracle\primav~1\pm.exe) to work with the Oracle client. You can get around this by installing Primavera to a path with an 8.3 naming convention.

    ReplyDelete
  5. This Fabricio Campos (Pelosi´s Mini Me) from Rio de Janeiro Brazil, Here is a tip: if you install P6 Client (flat) and just after the SP3 the problem is solved by itsself.

    ReplyDelete
  6. ineed ur help for installing p6 v7 in my pc

    ReplyDelete