[Latest - Step by Step Guide - Install, Setup and Configure Oracle Primavera P6 Professional R22.12 on Windows 10/11 - 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.
There are 5 major components for installation:
- .NET framework (comes bundled with 4.0)
- Java Runtime Environment (JRE) 7.0 or later (comes bundled with 7.0)
- DHTML component
- Oracle Database XE Edition, and of course,
- Primavera P6 Professional 8.3.x software (Client side)
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, subscribe to this blog (on top right corner of this blog) and send a mail, from your gmail id to managementyogi@gmail.com.
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:
- Setting up your Industry type from Admin Preferences.
- Getting the option to choose last project, all projects, global data etc when Primavera P6 starts up, which will be from User Preferences.
- Setting the currency option
- Setting the Time Units
- Setting up Dates
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 R22.12 on Windows 10/11 - Link]
Sir while running sql> prompt its showing error
ReplyDeleteGRANT EXECUTE ON sys.DBMS_REPUTIL TO SYSTEM with grant option
ERROR at line 1:
ORA-01031: insufficient privileges
You need to have the necessary permissions to execute as noted in the document.
DeleteWhat command did you give at the SQL prompt?
Dear Sir,
ReplyDeleteDuring 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
A common problem as seen. Here are the possible things you can try:
DeleteFirst 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.
This comment has been removed by the author.
ReplyDeleteI 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 .
ReplyDelete1 ) 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
can i set 2 or more currency in one EPS
ReplyDeletemind to ask pls....
ReplyDeletecan i set 2 or more currecny in EPS
Been frustrated for 2 days now. This is MY Windows 8.1 PC and I have Administrator rights. I followeded the instructions. HELP!!!!!
ReplyDeletePage 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>
Search for cmd.exe from start screen or button. Select and right click. Then use menu option - Run as administrator.
ReplyDeleteRan the command prompt using adminstrator but still keeps showing the same error
DeleteError at line 1:
ORA-01031: insufficient privileges
Need help..
There are other causes where it may happen. Try some of the tips given here(& related threads):
Deletehttps://community.oracle.com/thread/642253?start=15&tstart=0
Sir, You link provided in the You tube is not working or it is not available there. please provide the correct downloadable file
ReplyDeleteI have not shared any link for Primavera in youtube.
DeleteHello. After the configuration options, Error in Run SQL Script orppm_create_users.sql : DatabaseToolException (ORA-00922: missing or invalid option). Suggestions please?
ReplyDeleteThis is was my problem. After searching for hours, the problem was in my password!!!
DeleteI've used a password like this Admin@123. So the @ is not recognized by oracle. Change your password and its should work fine.
Thanks you for these Information....MMTI
ReplyDeleteFortunately my problem is not related to installation.
ReplyDeleteI 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
why am i being showed this msg "unable to install OracleXEUniv.exe" ?
ReplyDeleteAmazing tips, very pleased to find something that useful.
ReplyDelete