Oracle PeopleSoft PUM and Tools 8.55

Hello and welcome. I have started this blog as a reference for myself and if I can help anyone else out in the process, that's usually a good thing. Without further ado, here is the first post.

I work with Oracle PeopleSoft and today had to download the first ever PUM appliance based on PeopleTools 8.55. With this update, Oracle has changed the way you load/create the PUM database for applying updates. (i.e. Tax updates). In the past all we did was download the Virtual Box image, extract it and import into Virtual Box.

 There are now 2 different options.

  1. Use the new Puppet based DPK's which will install and build a PeopleSoft instance/database on a VM you already have. (for example in your VMware environment)
  2. Run a Powershell or Bash (depending on your Virtual Box Host OS) that will create an Oracle Linux VM in Virtual Box and then run the DPK's to build a PeopleSoft instance/database inside of that Virtual Box VM.
For my purposes I am going to start with option 2 since I already have a Virtual Box host in place  to do this, but I will likely go with option 1 when the next image comes out. In this case I will be downloading and installing HCM image 16. Here are the steps:

  1. Download the 16 or so zip files from My Oracle on the PUM homepage for the HCM image.
  2.  Open the 1st zip file "HCM-920-UPD-016-OVA_1of15.zip" and copy the "setup" folder to the root directory that contains all the zip files.
  3. Open a Powershell window and change directory the setup folder described above.
  4. Run psft-dpk-setup.ps1 file which should find all of your zip files and extract them.
  5. Let the PowerShell prompts create and import the appliance.
After the extract is complete and the prerequisites for import into Virtual Box are met  it will then ask you if you want to import the appliance. The process will import a new VM with the needed components and then install PeopleSoft HCM with image 16 for use has a PUM database. 

Example output:

Comments

  1. TammyBFebruary 10, 2016 at 10:51 AM

    Great info Matt! Thanks for sharing!

    ReplyDelete
  2. MyBlogFebruary 15, 2016 at 12:16 AM

    Hi Matt,
    Thanks a ton for sharing! I tried installing Image 16 on my Windows 10 laptop, but it didn't help. The installation stops midway when running the PS Script, stating that "Linux is not supported with this release"

    Any idea what could be wrong?

    -Mani

    ReplyDelete
    Replies
    1. Techie and bloggerFebruary 15, 2016 at 11:07 AM

      Hi Mani,

      I ran this on a Windows Sever 2012 machine. In theory this should work on Windows 10x64. Can you confirm that you're not on Windows 10 32-bit?

      Delete
  3. MyBlogFebruary 15, 2016 at 12:17 AM

    This is the error that I get and the script exits -
    https://community.oracle.com/servlet/JiveServlet/downloadImage/2-13684577-165228/1600-852/Capture.PNG

    ReplyDelete
  4. MyBlogFebruary 16, 2016 at 7:15 PM

    Hi Matt,
    Thanks a ton for responding! My Windows 10 is a 64-bit version. It appears that there was an issue with the PS Script - on line 82. A trim statement has now been added to the next line for that particular variable being referenced and now, the install proceeds without any issue.

    Here's my post on the VirtualBox installation:

    Hope you post often! :)

    Thanks!
    Mani

    ReplyDelete
  5. MyBlogFebruary 16, 2016 at 7:16 PM

    Oops - missed the link - https://mani2web.wordpress.com/2016/02/17/installing-peopletools-8-55-peoplesoft-hcm-image-16-on-virtualbox-using-dpks-part-1/

    ReplyDelete

Post a Comment

Popular posts from this blog

Active Directory Authentication with an Oracle Database

Image
Wouldn’t it be nice to not have to manage user passwords in your Oracle Databases? Setting up Active Directory aka Kerberos Authentication is a way to avoid having to manage passwords and allows users to authenticate against your Active Directory. Below is a list of useful links and My Oracle references that were used when setting up this example: EDIT - This post gets a lot of hits so I will include some updated information. If you're on 12c you need to add kerberos5pre to your list of services. e.g. SQLNET.AUTHENTICATION_SERVICES= (beq,kerberos5pre,kerberos5) If you are an Oracle Support Customer check out How To Configure Kerberos Authentication In A 12c Database ( Doc ID 1996329.1 ). If not, here is a good 3rd party write up  https://wiki.loopback.org/display/KB/Oracle+Database+12c+Kerberos+Configuration   Master Note For Kerberos Authentication (Doc ID 1375853.1) Configuring ASO Kerberos Authentication with a Microsoft Windows 2008 R2 Active Directory KDC (Doc ...
Read more

Create a custom backup report with BI Publisher for Oracle Enterprise Manager/Cloud Control 13c

Image
Recently I was tasked to build out an OEM 13c instance to manage a few Oracle Database servers and their associated instances. As a part of the setup, I needed to generate a daily email report to confirm the backup status of all databases in the OEM inventory. Unfortunately, it seems Oracle has overlooked this in the default reports, so I had to create a custom report. Here's how this was accomplished. The EM Repository database keeps track of the last database backup timestamp for each database. This is shown on the home page for any database. We can use this information to create a daily report and confirm that each database has been backed up in the last 24 hours. Login the BI publisher site https://oemserver.yourdomain:9851/xmlpserver with your account or sysman. Near the top right corner click “catalog”. In the tree on the left create a new folder under “Shared Folders” called custom reports. Within the custom reports folder create a new folder called “custom d...
Read more

Oracle Enterprise Manager notify when Recovery Area low

Image
I seem to be on the Oracle Enterprise manager kick lately, so why not one more post on it. Recently I hit the 85% mark on the Fast Recovery Area due to archive log bloat and did not see any alerts triggered in OEM. Well as I discovered, part of the reason for this is that according to MOS, "If using Fast Recovery Area (FRA) for the archive destination and the destination is set to USE_DB_RECOVERY_FILE_DEST, then the Archive Area % Used metric will not trigger anymore." Well that is annoying. However, I did find that the alert does trigger, but it is buried and doesn't show up on any main pages. To see it, go to the target database home page. Then navigate to Oracle Database->Monitoring->All Metrics . In the left pane you can scroll down to “ Recovery Area->Recovery Area Free Space ”.  There you will see your alert if active. When viewing the All Metrics page, click on the alerts icon to see active alerts. If you want to see it triggered just temporaril...
Read more