Thursday, November 27, 2014

Step by Step Guide - How to Install, Setup and Configure Oracle Primavera P6 Professional R8.3 on Windows 7/8






[Latest - Step by Step Guide - Install, Setup and Configure Oracle Primavera P6 Professional R15.2 on Windows 7/8 - Link]

Content Summary: During a recent program on Oracle Primavera P6, few participants found it difficult to install, setup and configure P6 Professional edition. They faced either some scripting issues or certain permission issues. Later on came to know, many face those issues. In this post, I'll elaborate a complete step by step installation, set up and post set-up configuration for Primavera P6 Professional Release 8.3 in Windows 7. 



Primavera P6, the EPPM tool from Oracle, is widely used in certain sectors, such as construction, aerospace, manufacturing - in Project and Portfolio Management. However, people come up with issues during installation. In fact, it is not at all difficult to install and configure, if you understand what are the needed components for the installation. More importantly, if the components are already available (installed), then the installer will skip them. 

There are 5 major components for installation:
  1. .NET framework (comes bundled with 4.0)
  2. Java Runtime Environment (JRE) 7.0 or later (comes bundled with 7.0)
  3. DHTML component
  4. Oracle Database XE Edition, and of course, 
  5. Primavera P6 Professional 8.3.x software (Client side)
If you have Java, .NET, DHTML and Oracle XE installed, you just need to install the 5th component. However, Primavera P6 software media pack comes bundled with all the above components. So irrespective of installation of those components, the installer application will check their availability and based on that, the installer apps will do the necessary operations.  

However, there few issues found while executing certain scripts post installation. This is during the DB Connection creation for the user, which ultimately boils down to permission issue. The error that you may get is shown below:


To fix the issue, you have to simply set the permission and execute the script. The script in question is: "manual_script_before_install.sql". It is detailed in the below installation document shared via GDrive. The document covers in detail explanation of all the steps involved to set up Primavera P6 Professional R8.3.x (8.3.2 is used here) in Windows 7 along with issues that you might face.  The steps will remain same for Windows 8.

For complete step-by-step instructions,send a mail (from your GMail id) to managementyogi@gmail.com. With it, you will also be subscribed to ManagementYogi’s mailing list.




The document is available for viewing in PDF format - Link.



Note:
Post installation, I always suggest participants to perform some basic configuration for the usage of Primavera P6, like:
  1. Setting up your Industry type from Admin Preferences.
  2. Getting the option to choose last project, all projects, global data etc when Primavera P6 starts up, which will be from User Preferences.
  3. Setting the currency option
  4. Setting the Time Units
  5. Setting up Dates 
There are also certain other post set-up configuration needed, however, for this post I'll limit to these few.


Note: A course covering Project Management Professional (PMP) certification with Oracle Primavera P6 (and its certification) is available. This has been used by professionals worldwide. For details, check:

You may also like:

[Latest - Step by Step Guide - Install, Setup and Configure Oracle Primavera P6 Professional R15.2 on Windows 7/8 - Link]


18 comments:

  1. Sir while running sql> prompt its showing error

    GRANT EXECUTE ON sys.DBMS_REPUTIL TO SYSTEM with grant option

    ERROR at line 1:
    ORA-01031: insufficient privileges

    ReplyDelete
    Replies
    1. You need to have the necessary permissions to execute as noted in the document.

      What command did you give at the SQL prompt?

      Delete
  2. Dear Sir,

    During installation set up file i got the following error : plz suggest me :

    ERROR: " Oracle XE P6 Professional database Creation failed. Please see the log file at C:\ users \Administrator for details."

    bcs of this error i again re-install my windows7 and re-install primavera p6 but it still not solved. plz help me

    My laptop : Windows 7 ultimate / 6GB RAM / NVIDIA graphics version - 350 /

    Regards ,

    Mohammad Ariful Islam

    DUBAI, UAE

    ReplyDelete
    Replies
    1. A common problem as seen. Here are the possible things you can try:
      First check if you have correct file that you have downloaded. Many download something else. This article is for Primavera P6 Professional Project Management R8.3 (and its media pack).

      Now:
      Uninstall the files installed for Primavera.
      1. Unzip into a folder as noted in the instruction (pdf file shared in this blog) in place of directly double clicking the executable inside the archive
      2. Use setup.exe (not the .msi file).

      If still does not work, then try installing Oracle XE separately. Primavera comes with bundled ones - DHTML, Java, .NET and OracleXE. The exe file for Oracle XE is "OracleXEUniv.exe". Try to install in a created directly in your C:\ drive. Later on you can connect Primavera P6 to Oracle XE.

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

    ReplyDelete
  4. I have lost my MENUBAR ( File, View, Tools, Admin, Project, help ).....Nothing is showing there... Just show Activites on the top bar....I tried to solve this issue by searching internet...i got two solutions but it's not work for me .

    1 ) Right click on the top bar, then navigate which bar i require. but not solved
    2 ) press ( Alt +V ) and do it 27 times but it not solved my issue.

    So, you are requested to show me a solution sothat i can restore all my toolbars

    ReplyDelete
  5. can i set 2 or more currency in one EPS

    ReplyDelete
  6. mind to ask pls....
    can i set 2 or more currecny in EPS

    ReplyDelete
  7. Been frustrated for 2 days now. This is MY Windows 8.1 PC and I have Administrator rights. I followeded the instructions. HELP!!!!!

    Page 14 of 26 #28 a. Provide the needed permission through security to this folder. (Went into Properties, Security tab and gave Full Control and turn off Read only but when I go back Read Only keep being checked). Cannot seem to do anything about the Read Only option under General tab, but Full Control is selected under Permissions. I open the cmd prompt. Again, I am the administrator/owner of PC. If there is a special way to open command prompt with administrative rights I have not found it researching for Windows 8.1. I go on to Step #29 and #30. After #30 I get the following with most extra blank lines excluded:

    SQL*Plus: Release 10.2.0.1.0 ....
    Copyright (c) ....
    ERROR:
    ORA-01031: insufficient privileges

    Enter user-name: system (username was a guess being this possible error and step not given in instructions)
    Enter password:

    Connected to:
    Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
    SQL> @C:\database\scripts\install\PPM_08_03_00\manual_script_before_install.sql
    GRANT EXECUTE ON sys.DBMS_REPUTIL TO SYSTEM with grant option
    *
    ERROR at line 1:
    ORA-01031: insufficient privileges

    GRANT SELECT ON sys.DBA_EXTENTS TO SYSTEM with grant option

    ERROR at line 1:
    ORA-01031: insufficient privileges

    SQL>

    ReplyDelete
  8. Search for cmd.exe from start screen or button. Select and right click. Then use menu option - Run as administrator.

    ReplyDelete
    Replies
    1. Ran the command prompt using adminstrator but still keeps showing the same error

      Error at line 1:
      ORA-01031: insufficient privileges
      Need help..

      Delete
    2. There are other causes where it may happen. Try some of the tips given here(& related threads):
      https://community.oracle.com/thread/642253?start=15&tstart=0

      Delete
  9. Sir, You link provided in the You tube is not working or it is not available there. please provide the correct downloadable file

    ReplyDelete
    Replies
    1. I have not shared any link for Primavera in youtube.

      Delete
  10. Hello. After the configuration options, Error in Run SQL Script orppm_create_users.sql : DatabaseToolException (ORA-00922: missing or invalid option). Suggestions please?

    ReplyDelete
    Replies
    1. This is was my problem. After searching for hours, the problem was in my password!!!
      I've used a password like this Admin@123. So the @ is not recognized by oracle. Change your password and its should work fine.

      Delete
  11. Thanks you for these Information....MMTI

    ReplyDelete
  12. Fortunately my problem is not related to installation.

    I have used wrong password and answered yes to re-configure and as a result unable to log in
    Anybody can help please?

    Regards
    Razmik Aslanian

    ReplyDelete

Any comment is welcome - comments, review or criticism. But off-topic, abusive, defamatory comments will be moderated or may be removed.