Saturday, December 27, 2014

PeopleSoft Installation Made Extremely Easy

About 2 years ago, I tried installing PeopleSoft on my laptop thinking it's gonna be an easy ride but proved to be hell lot difficult and took almost 3 months before I could open the PIA login page. To make matter worse, I didn't take help from anyone who have already done the installation but just relied on Online Forums which though are wonderful resources and ultimately made it work for me but not better than if you have someone who can assist you right on your system. It was moment of cheer when I was finally able to open the PeopleSoft Login page as I faced almost every single issue which is anticipated during such a massive installation.

But I am not gonna just sit here and let you go through the same hurdle as I did, I am going to beat this up for you guys and help you install PeopleSoft right on your desktop just as you would have dreamed.
Note that we are going to install PeopleSoft HCM 9.1 with PeopleTools 8.52 but if you are looking to install higher version then don't worry as the steps are gonna be same.

To begin with, though the PeopleSoft Installation Guide provided by Oracle is a great resource which contains very detailed step by step installation guide but for a beginner its like an ocean where if they dive, they are gonna lost. So, for keeping such audience in mind, I have extracted my own experience of PeopleSoft Installation which I did almost recently which was apparently a success.

We will be doing following steps to make it happen:
  1. Download all the necessary Softwares from Oracle E-Delivery and Install them
     PeopleSoft Installation Made Extremely Easy: Part 1
  2. Create and Configure PeopleSoft Database
    PeopleSoft Installation Made Extremely Easy: Part 2
  3. Complete the Database Setup
    PeopleSoft Installation made Extremely Easy: Part 3
  4. Creating and Configuring the Application Server Domain
    PeopleSoft Installation Made Extremely Easy: Part 4
  5. Setting up PeopleSoft Pure Internet Architecture (PIA)
    PeopleSoft Installation Made Extremely Easy: Part 5
Also see:
Connecting and Starting the Database through sqlplus Command Utility
How to Connect to a Database through SQL Developer in MS Window

As you can see the installation have been splitted into 5 parts so lets do them one by one.

The installation we going to do today is on Microsoft Windows based OS and not the UNIX based. For information on how to install PeopleSoft on UNIX based OS please refer the installation guided I mentioned in the beginning.
However, in MS Windows too, I would recommend that this should be installed in a Windows Server like MS Windows Server 2008 R2 because when I tried installing PeopleSoft on Windows 7 two years ago I faced so many issues hence I then had to move to Windows Server 2008.

Now that we have finalized the platform on which this installation is gonna be done, let me also recommend to create a logical n-tier architecture i.e lets try to install everything on this Windows Server 2008 itself so that this process of installation goes smoothly and we don't face issues down the road.

So far so good, we have made the choice on the platform on which we are going to Install the PeopleSoft but many of us would be Windows 7 users and might not have Windows Server 2008 installed. So first we have to build the platform before we go to the next part and there is a very simple solution for that for those who do not already have Windows Server 2008 installed in their Laptop/Desktops.

  1. Download the Oracle Virtual Box for the windows hosts (like Windows 7) and install it on your machine assuming it would be having Windows 7/8
  2. Create a  Virtual Machine
  3. Download Windows Server 2008 R2 from Microsoft and install it on the Virtual Machine

Done..!  Now you have created created the platform to install PeopleSoft. If you find it difficult creating a Virtual Machine for WS 2008 then refer the Oracle Virtual Box documentation.

Go the next article - PeopleSoft Installation Made Extremely Easy: Part 1


  1. Why don't you just download the PeopleSoft HCM virtual image and Oracle Virtual Box? See

    1. hey how do i download Ps financials Copy of Virtual Image... ?? Can u please help me.. my Id

  2. Very detailed - thanks for posting this. Yes, you could download the virtual images, but the learning experience of going through this process is invaluable and worth the time/effort.

  3. Guys how i get the key for download the virtual images. I have this one 1464619.1

  4. While executing psroles.sql scripts am getting the below error. Can you please help on this.

    ORA-01917: user or role 'PSADMIN' does not exist
    ORA-29393: user PSADMIN does not exist or is not logged on
    ORA-06512: at "SYS.DBMS_RMIN", line 33
    ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER_PRIVS", line 110
    ORA-06512: at line 1

    Thanks in advance.