Installing the Peoplesoft Exalogic OVM Template

Want to get PeopleSoft installed and running on Exalogic and Exadata? In this blog I provide an overview guide on how to implement the PeopleSoft Exalogic OVM template.

PeopleSoft PeopleTools VM templates allow fast deployment of a PeopleTools environment on Exalogic. The purpose of this VM template is to allow you to skip the manual steps associated with the following:

- Gathering the necessary installation programs
- Installing, configuring and patching the OS
- Installation and patching of FMW products such as Tuxedo and WebLogic
- Installing PeopleTools
- Configuring the PeopleTools domains

 The latest PeopleSoft PeopleTools Template includes:

- Oracle Linux 5.8 64 bit
- PeopleTools Application Server 8.53.11
- PeopleSoft Pure Internet Architecture (PIA) 8.53.11
- Oracle Tuxedo 11gR1 PS2
- Oracle Database client 11.2.0.3
- Verity Development Kit
- Oracle WebLogic 10.3.6

Note: This template and does not include a PeopleSoft application or database; I have added those steps to this guide. It is highly recommended to install the PeopleSoft database on Exadata but you can install a PeopleSoft development DB on Exalogic as a short term option.

The following instructions assume you have PeopleSoft installation knowledge and can navigate Exadata, Exalogic Control and the ZFS Storage BUI (Browser User Interface).

This overview does not include every step or detailed explanations; please refer to the following documentation for more information:

Using OVM Templates for PeopleSoft on Exalogic

http://docs.oracle.com/cd/E52547_01/psft/acrobat/Using_Oracle_VM_Template_for_PeopleSoft_on_Exalogic_02_2014.pdf

Exalogic Elastic Cloud Administration

http://docs.oracle.com/cd/E18476_01/doc.220/e25258/toc.htm

PeopleTools 8.53 Installation Guide for Oracle

http://docs.oracle.com/cd/E38921_01/psft/acrobat/PeopleTools_8.53_Installation_for_Oracle.pdf

Step 1: Download PeopleTools Exalogic OVM Template (4 zip files) from Oracle Support. Click on the Patches & Updates tab and perform the following search to obtain the latest template release (8.53.11 as of this blog).

Step 2: Unzip the 4 template zip files and combine them into one file using the following command depending on your OS:

MS Windows (no space, copy /b file1+file2+file3+file4 file.tgz):

copy /b OVM_EL5U8_X86_64_EXALOGIC_TOOLS8_53_11_PVM.tgz1of4+

OVM_EL5U8_X86_64_EXALOGIC_TOOLS8_53_11_PVM.tgz2of4+

OVM_EL5U8_X86_64_EXALOGIC_TOOLS8_53_11_PVM.tgz3of4+

OVM_EL5U8_X86_64_EXALOGIC_TOOLS8_53_11_PVM.tgz4of4

OVM_EL5U8_X86_64_EXALOGIC_TOOLS8_53_11_PVM.tgz

UNIX / Linux:

cat OVM_EL5U8_X86_64_EXALOGIC_TOOLS8_53_11_PVM.tgz1of4 OVM_EL5U8_X86_64_EXALOGIC_TOOLS8_53_11_PVM.tgz2of4 OVM_EL5U8_X86_64_EXALOGIC_TOOLS8_53_11_PVM.tgz3of4 OVM_EL5U8_X86_64_EXALOGIC_TOOLS8_53_11_PVM.tgz4of4 > OVM_EL5U8_X86_64_EXALOGIC_TOOLS8_53_11_PVM.tgz

Step 3: Upload template to Exalogic.

Login to the ZFS Storage Server. Create a new share. In this scenario, a share named upload was chosen.

Select Protocols. Enable Read only for the upload share. Hit Apply.

Select Access. Make sure the minimum access is Read and eXecute for Other. Hit Apply

       NFS mount the share onto an existing vServer. scp the combined tgz file from above to the mounted NFS share. (No screen shot).

# scp OVM_EL5U8_X86_64_EXALOGIC_TOOLS8_53_11_PVM.tgz vServer1:/upload

In Exalogic Control, select a Cloud Account that will own the template (AppsExa in this example). A cloud user must be assigned to the account and the account must have enough resources (CPU, Memory, Storage to create vServers and have access to the available networks).

Select the Server Templates tab. Click on the upload template icon shown below.

  Name the template. Select Next.

  Select URL. Type in the path to the URL. NOTE: Use the internal 172.17.0.x IPoIB IP address for the ZFS Storage Server. This address can be obtained by going to Configuration > Network in the Storage Server BUI.  Click Next.

  Review the Summary. Click Upload.

  A Job will be created. It will take several minutes to complete. Once finished, the Job will turn green.

  Once imported, the template will show up on the Server Templates tab.

Step 4: Create vServer from template

Navigate to vDC Management > vDCs > MyCloud. Right click and select Create vServer Type

Give the vServer Type a name. Hit Next. Select the Storage, Memory, and the vCPU sizes. For a PeopleSoft environment with all middle tier components enabled select 22GB RAM, 28GB Storage and 6 vCPUs (per PeopleSoft OVM template instructions). These numbers can be reduced if components that are not needed are turned off. Select Next and Finish.

Navigate to vDC Management > vDCs > MyCloud > Accounts. Select the Account created earlier. Right click and select Create vServer.

Name the vServer. Click Next.


Select the template uploaded previously.


Select the vServer Type created above.


Highlight the relevant networks by control selecting them. NOTE: the default network is assigned automatically to all vServers; do not select it. Click Next.


Select Next.


Review the Summary. Click Finish. Make sure your vServer is running once completed.


Step 5: Download the latest PeopleSoft Application from E-Delivery (http://edelivery.oracle.com) that you want to install. HCM, Financials & Supply Chain (FSCM), CRM or ELM. Only download the application zip.

Step 6: Transfer the PeopleSoft application zip file to the vServer created on Exalogic and install it. You can install it in PS_HOME or decide to install it in PS_APP_HOME. To login to the OVM template use the following IDs. Each user has different access as defined below:

Step 7: Download the same PeopleTools version as the Exalogic OVM template from E-Delivery and the same patch version of PeopleTools from Oracle Support. Here that is PeopleTools 8.53 from E-delivery and 8.53.11 patch from Oracle Support. These two files need to be copied along with the PeopleSoft Application file from Step 5 over to Exadata.

Step 8: Ensure that the Exadata is installed and patched with all the required software and that the IB networking is configured between Exadata and Exalogic.

Step 9: Install PeopleTools, the PeopleTools patch and the PeopleSoft application (in that order) downloaded in Steps 5 & 7 onto Exadata. Select all options during the install to ensure you have all the files:

Step 10: Now it is time to create the PeopleSoft database on Exadata. You have two options: single node database or a RAC database on Exadata. If you decide on a single node DB you can use the Database Configuration Wizard (non-Unicode only) to make the create database and Data Mover import process easier. If you decide on a RAC database or single node Unicode DB you cannot use the Database Configuration Wizard and must create the database manually and then run the PeopleSoft Data Mover to import the database. Make sure to read and follow Chapter 6B in the PeopleTools 8.53 Installation Guide. An Exadata DBA may be needed if you want to create a RAC database and to configure and start the DB listener. Make note of the name of the database and listener port number for configuring the Application Server (Tuxedo).

If you decide to install a database on Exalogic in the vServer you will need to download the Oracle 11gR2 database software for Linux x86-64, install it and then follow Chapter 6B in the installation guide. This option should only be used as a temporary environment.

Step 11: Once the PeopleSoft DB is created and the Exadata SDP listener is up and running you need to ensure SQL connectivity from the vServer on Exalogic. ssh into the vServer and add an entry into tnsnames.ora. Here is a sample for DB SID=HCM92 on a Half Rack Exadata with a 4 node RAC cluster:

HCM92 =
(DESCRIPTION =
    (ADDRESS_LIST =
    (LOAD_BALANCE = ON)
        (ADDRESS = (PROTOCOL = SDP)(HOST = exa4db01-ibvip)(PORT = 1522))
        (ADDRESS = (PROTOCOL = SDP)(HOST = exa4db02-ibvip)(PORT = 1522)) 
        (ADDRESS = (PROTOCOL = SDP)(HOST = exa4db03-ibvip)(PORT = 1522))
        (ADDRESS = (PROTOCOL = SDP)(HOST = exa4db04-ibvip)(PORT = 1522)))
    (CONNECT_DATA = (SERVICE_NAME = HCM92))
  )

Ping each of the Exadata nodes to check if the hostname resolves. If you are unable to ping the hostname then add entries into the /etc/hosts file.

Run sqlplus SYSADM/{SYSADM password)@HCM92 and sqlplus people/peop1e@HCM92 to ensure you can connect using the PeopleSoft ACCESSID and CONNECT ID.

Step 12: Now it is time to configure the PeopleSoft vServer. First you need to edit the /etc/resolv.conf and the /etc/sysconfig/network files with the appropriate DNS entry and hostname values.

Next you need to configure the PeopleSoft Application Server, Process Scheduler and PIA. This process is made easier by launching the delivered PeopleSoft configuration script located here:

/opt/oracle/psft/vm/oraclevm-template.sh

Follow the instructions in the "Using OVM Templates for PeopleSoft on Exalogic" (posted at the beginning of this blog) to run the script.

Ensure that the Application Server and PIA are running and note the HTTP port number and website name.

Step 13: Verify that you can log in to PeopleSoft. Start a browser on your PC and sign on to the PeopleSoft application with the following URL. You may need to add a host entry on your PC in the c:\Windows\System32\etc\drivers\hosts file with the vServer IP.

http://<vserver hostname>/<HTTP port number>/<website name>/signon.html

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Phil Wang-Oracle

Search

Categories
Archives
« May 2015
SunMonTueWedThuFriSat
     
1
2
3
4
5
6
7
8
9
10
11
12
13
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
      
Today