This is the third and final part of our series of blogs to get you up and running with your own Primavera P6 EPPM testing environment. If you need part one visit here, if you are looking for part two visit here.
Primavera P6 is one of the leading planning tools used by enterprise organisations, and as with every activity, the only way to be good at it is to practice. Whilst Primavera P6 PPM and other tools are easy to install, EPPM unfortunately, can be difficult to install. This blog aims to get anybody up and running with an EPPM environment of their own.
I wont bore you today with the usual disclaimer, however, there is one and you should have read it before continuing.
This blog is going to focus on getting everything working together. We have installed the operating system, the application server (WebLogic), the database (Oracle XE) and the application (Primvavera P6 EPPM).
As this is the third blog and you will be familiar with some of the processes (such as launching a terminal window, and changing directory within it, this should be a shorter and more to the point blog. If you need a reminder of any of these processes, simply refer to the previous blogs.
Run Oracle Pre Install Script
1. Prior to installing the Primavera P6 EPPM database we need to execute a preinstall script, which will assign the necessary permissions to the install user.
2. Login into your server, using the credentials you specified in part one.
3. In the "Applications" menu, hover over "Other" and select "Run SQL Command Line"
4. When launched you will see a terminal window with an SQL> prompt. To connect to your database enter the command "connect sys/password@XE as sysdba" replacing password with the memorable password you set on installation
5. Run the script by entering "@/home/username/Downloads/P6_R162/p6suite/database/scripts/install/PM_16_02_00/manual_scripts_before_install.sql" replacing username with your username and noting that depending on the version downloaded the full path may vary.
6. Edit the global profile to include Oracle XE. "sudo nano /etc/profile.d/oracle.sh" and add the following ". /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh" followed by CTRL-X, 'Y' and "Enter".
Primavera P6 EPPM database
1. Login into your server, using the credentials you specified on part one.
2. Launch a terminal window.
3. Change directory to the p6 directory within the install directory you specified in the P6 installation step of blog two. In my case this is "cd /home/wraithsolutions/P6EPPM_1/p6"
4. Assign execute permissions to eppmconfig.sh. "chmod +x eppmconfig.sh".
5. Launch the P6 EPPM Configuration wizard. "./eppmconfig.sh"
6. On the welcome page click "Next"
7. On the "Database Configuration" page ensure "Create a new P6 EPPM database" is selected, and if you wish to install the sample projects ensure the "Install Sample Projects" check box is checked. Click "Next".
8. On the "Database Type & Connection" page, ensure "Oracle" is selected and enter the information below
- Database Host Address : localhost
- Database Host Port : 1521
- DBA Username : system
- DBA Password : The memorable password set in blog two.
- Database Name : XE
9. You will now be presented with a list of users to create. Set each password to be the same as the username for the purposes on this development system and set the admin password to a memorable password. Once you have filled this is click "Next".
10. On the "P6 Configuration Settings" page click "Next".
11. On the next few pages, ensure they are not selected and click "Next" until you are prompted to click "OK". Click this and then on the next pop up click "Yes"
12. This step may take some time depending on the performance of your machine. This is an ideal time for a cup of Earl Grey tea, hot.
13. Once complete, click "Next" and "Finish".
14. Congratulations, you have a P6 EPPM database.
15. To ensure the service starts correctly we need to add a line to the rc.local configuration. "sudo nano /etc/rc.local" and add a line at the bottom that reads /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh &".
1. WebLogic will provide the ability to access the application (at this stage, if you had the Professional Client you could already, albeit with some functionality, such as the ability to create/update baselines unavailable)
2. Open a Terminal.
3. Launch the WebLogic configuration application by running the command "/home/username/Oracle/Middleware/Oracle_Home/wlserver/common/bin/config.sh".
4. On the first pane, ensure "Create a new domain" is selected and make a note of the Domain Location. Click "Next".
5. Accept the defaults on the next page and select "Next".
6. Enter a memorable password, ensuring it meets complexity requirements (8 alphanumeric characters, with at least 1 number or special character), confirm it in the next box and click "Next".
7. Accept the defaults on the next page and click "Next", then "Next" and finally "Create".
8. To set the WebLogic instance to start we need to edit a configuration file. Enter the following command "sudo nano /etc/rc.local" entering your password if required.
9. At the bottom of this file enter the line "/home/username/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain_startWeblogic.sh &". Remember that you can press "Tab" to autocomplete names.
10. Press CTRL-X, then 'Y' and then "Enter" to save your changes.
11. To ensure this is allowed to run enter the command "sudo chmod a+x /etc/rc.local"
12. To launch the WebLogic server without a reboot for now, enter the same command you entered into rc.local "/home/username/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain_startWeblogic.sh &"
13. The Nodemanager controls the servers we are about to set up on the WebLogic server. We first need to edit the properties of the nodemanager, then set it to automatically start
14. Edit the properties by running the command "nano /home/username/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/nodemanager/nodemanager.properties"
15. Edit the file so that SecureListener=false and CrashRecoveryEnabled=true, press CTRL-X and 'Y' followed by "Enter" to save the changes.
16. Edit rc.local again to add Nodemanager to the autostart. "sudo nano /etc/rc.local" adding the line /home/wraithsolutions/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/bin/startNodemanager.sh &".
17. Rather than reboot, we can simply run the command added to rc.local in the same terminal window that you have open.
1. Now that you have a WebLogic domain configured you now need to add a server with a configuration for P6.
2. Open up Firefox and navigate to http://localhost:7001/console.
3. Enter the username and password set up in the previous section.
4. In the right hand pane, expand "Environment" and select "Machines".
5. In the machines table click "New".
6. Enter the machine name of localhost and click "Next". Change the Nodemanager Type to Plain and click "Finish".
7. In the right hand pane, expand "Environment" and select "Servers".
8. In the servers table click "New"
9. Enter the server name as "P601" and change the "Server Listen Port" to 7010 and click "Finish".
10. In the servers table click on the newly created server to access the configuration.
11. Change the machine to be localhost and click "Save".
12. Select the "Server Start" tab.
13. Enter a Java Home of "/usr/java/latest"
14. In the Arguments text box enter the following
15. Go back to the "Environment -> Servers" pane and select the "Control" tab. Check the box next to the newly created server and click "Start". This can take some time, so whilst waiting occassionally go back and check while we continue with adding the application.
16. Select the "Deployments" entry in the left hand pane.
17. Click "Install".
18. Using the "Current Location:" list navigate to /home/username/P6EPPM_1/p6. Select the radio button next to the "p6.ear" entry and click "Next".
19. On the "Choose targeting style" page, ensure "Install this deployment as an application" is selected and click "Next".
20. Check the box next to P601 and click "Next".
21. Click "Finish". This may take a while to complete.
22. When complete, switch back to the "Servers" page and check that the server started successfully. You can tell this from the "State" field in the servers table and it should read "RUNNING".
23. Switch back to deployments, check the box next to the P6 application and click "Start".
24. Open up a web browser and navigate to http://localhost:7010/p6 and you should now be able to log in using the admin account set up during the p6 install process.
Unfortunately, in the recent releases of Firefox the ability to launch Java applications has been removed, this is the same with Google Chrome. You can either download another browser from within your server (outside the scope of this blog) or connect to it using Internet explorer. To allow your desktop to access your server take the steps below.
1. By default VirtualBox will set up your network to tunnel through to the internet using NAT. To allow your desktop to access it this needs to be changed to either Bridged or Host Only (this one will prevent internet access though).
2. If you select Machine->Settings from the top menu of your server window (remember to press Right CTRL to release your cursor from the server itself).
3. In the left pane select Network.
4. In the "Attached to" menu select bridged and click "OK".
5. In a terminal window back on the server enter the command "ifconfig".
6. This will list you network connections and you should have one named enp0s3. If you do not look at the name of the first one listed, or the one with a 10.0.2.x address as the inet address within the information following the interface name.
7. Enter the command "sudo ifdown enp0s3" followed by "sudo ifup enp0s3" entering your password if required. Run the command "ifconfig" again and make a note of the IP address in the interface. It should now read something similar to 192.168.1.x depending on your Internet Provider.
8. Disable the firewall (not normally recommended, but it is out of the scope of this blog to configure the firewall). Run the command "sudo systemctl disable firewalld".
8. Release your cursor from the server again and launch Internet Explorer on your desktop.
9. Navigate to http://yourIP:7010/p6 (e.g. http://192.168.1.1:7010/p6).