Thursday, 20 November 2014

PeopleSoft Update Manager complete Guide-Part 2

Configure PUM and Usability of PUM for Change packages

In the previous post I had configured the CA and now I will show the Update manager usability online.

Login into the PeopleSoft Image environment and follow the shown path and select "Define Package"















select the target environment and click 'next'











give the name of the change package to be created, and click 'next'













On this page the Update manager offers wide choice to create the specific change packages,
















click on the radio button as suitable.

All updates not yet installed:-- This basically will create a CP with  all the updates from the Image
                                                    for the target environment.

Specific Updates:--                 This option allows to create a CP with particular bugs one want to fix.



















Updates by Critera:--             This option further gives options to create a CP based on following
                                                 options   shown. Please go ahead and experiment with the options
























Updates by object name:--        This options allows to create CP related to bugs of certain
                                                   PeopleSoft objects.For example lets select  object type Page and
                                                   a page name,it will   list  all the bugs related to that page.
                                                   The highlighted portion details shows the changes made in that
                                                  object specific to bug.




















After the specific updates have been selected the change package is create, you can also review the
Change Package.

















Coming back to the CA the change package created will be there in the drop down.Select it and click
'Apply Change Package'. The CA will start creating the customized Change.Change Package





After the change package is created, the CA asks for the Initial Upgrade and MTP options.
Click 'next' after selecting one of the option.














The CA will check for prerequisites and will show the summary then click 'Finish'.
After that the CA will up in action applying the CP in hard old fashioned way as it always does.


























All your comments and queries are welcome.
Keep experimenting.

PeopleSoft Update Manager complete Guide-Part 1

Hi everyone,

Since the release of 9.2 PeopleSoft applications,Oracle has completely changed the conventional process of patching for PeopleSoft. It has introduced a whole new concept of PeopleSoft Update Manager (PUM) which is indeed terrific. Couple of Pros of PUM:--
  • PUM provides very extensive and deep level of control to Administrators to create the Change packages.
  • No more search,download for patches from Oracle support site.
  • Every PeopleSoft image is coming as a cumulative set of all the bugs.
Lets concentrate on how to configure the PUM and how does it look.
I will be taking the PeopleSoft HCM image release 9.2.05 into consideration,and will divide this writeup into two parts

Download and Install PeopleSoft Image and install Change Assistant
Configure PUM and Usability of PUM for Change packages.

Download and Install PeopleSoft Image and install Change Assistant 

From Oracle support go to the following Document




Download the latest Peoplesoft Image from the support site





Once downloaded you will have files of .ova format,you have to concatenate all the files into one file using the following command

copy /b HCMDB-85309-PI005_OVA_1of5+HCMDB-85309-PI005_OVA_2of5+HCMDB-85309-PI005_OVA_3of5+HCMDB-85309-PI005_OVA_4of5+HCMDB-85309-PI005_OVA_5of5 85309d.ova

The result will be like this and the highlighted file is the concatenate one.








Download the Oracle VirtualBox software from https://www.virtualbox.org/ and install it.
Open VirtualBox, go to File>Import appliance and give the path of the concatenate file.

Click Next and then Import with 'reinitialise MAC settings' ,the PeopleSoft demo instance will be 
created in 15-20 minutes.

Configuring Change Assistant
 For installing Change Assistant, copy the setup folder from the tools client supplied in the Peoplesoft image.

go to run and type in //<ip_address of image> and the shared folders will be accessible.

after the CA is installed click on the icon to open it.

The first screen will be like:--














Click 'next',Check the 'Update Manager' button and click next,



 it will go to the "general" options where you need to fill out the necessary directory details.
The PUM directory is the pi_home directory of the shared folders of the image.
Either you can map it or copy the contents 
to your local desktop and give the location here
as shown below and click 'next'

















The CA will ask for the HUB ip and the port information,Here I have already made the
 necessary configurations for PSEMAgent and PSEMHub 
to communicate with each other. Make sure the ping returns OK as shown.
you can also click view to see all the environments registered with your HUB.Click 'next'














Skip the additional options page,click 'next'












The CA will now ask for the target database details as shown.Click the radio button.








Once the environment is selected the CA asks for the target Database details.

After filling in all the details do check for the successful connection as shown.Click 'next'



Click next after CA has picked up all the target database details.




















Now the CA will as for the Source database details (PeopleSoft Image that I installed).

So after filling in the database name the details page prompts and fill in the details
 as shown and check for successful connection



Click on the confirmation page, then fill in the URL of the PeopleSoft Image installed 
as shown and click next.The CA will start uploading the target database details to the Image.


















Now click on the 'Open Browser and Connect to PI datbase' which will open the Image PIA.













Please move to Part 2 "Configure PUM and Usability of PUM for Change packages"

Monday, 3 November 2014

UBBGEN encountered an error while configuring!

This error is a pestering one, encountered when you are creating any Application server domain.
In the latest tools versions 8.53 oracle has removed some of its executables from the setup folder.

like you had  vcredist_x64 in earlier tools versions which fixed the missing dlls files required for peoplesoft in Windows.

This error in my case was specifically due to missing dll and because of  unavailability of vcredist_x64  in 8.53 PS_HOME, its difficult to get it resolved.

** don't download any dll and copy it in the system32 folder it will not work, instead go to

http://www.microsoft.com/en-us/download/confirmation.aspx?id=13523

You can download vcredist_x64 and fix the issue.

Please look into the following SR too (Doc ID 1541589.1)

Keep experimenting!!


Wednesday, 15 October 2014

DBLINK creation in Oracle RDS instnaces(cloud databases)

As the new world of Cloud databases converges we have to adapt to new ways of using the database concepts.
In Oracle RDS instances  each instance is a indigenous machine in itself to setup a communication between various Oracle RDS instances through DBLINK can be done through:--


  1. Logon to Source RDS database "TEST" ( from where data is needed)
  2. Check whether this Table exists in source.
    1. SELECT * FROM PS_JOB
  3. If it exists, check whether any user is assigned to it.
    1. SELECT * FROM DBA_TAB_PRIVS WHERE TABLE_NAME ='PS_JOB';
  4. If not, we need to Create a user using following
    1. CREATE USER Username  IDENTIFIED BY Password;
    2. GRANT CREATE SESSION TO Username;
  5. Give select privilege to Username.
    1. GRANT SELECT ON PS_JOB TO Username

Following are the steps in Target:
  1. Logon to Target RDS database
  2. Create a DBLINK (here we have the change)
    1. CREATE PUBLIC DATABASE LINK ABC CONNECT TO Username IDENTIFIED BY "Password" USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = sss-rds.sfggee44.xxxxx.rds.amazonaws.com)(PORT = 1521)) )(CONNECT_DATA =(SERVICE_NAME = TEST)))''
So we mention the complete connection string as can be found in the local tnsnames.ora.

  1. Check whether DB link is created.
    1. SELECT * FROM DBA_DB_LINKS
  2. Try to access data using dblink
    1. SELECT COUNT(*) FROM SYSADM.PS_JOB@ABC

Keep experimenting!!

Monday, 13 October 2014

ORA-00600: internal error code, arguments: [qespcNpSC:objnotfound], in data mover

ORA-600 that's scary stuff, As its a Oracle internal error, so always recommended to raise a ticket.

I did something else due to shortage of time:--

In my environments scenario this error came when I tried to run the database setup from data mover and it failed at 






As i was under time pressure,instead of following up with Oracle I did the following steps.

As it failed while inserting into the PSDBOWNER table , there must be something fishy with the way PSDBOWNER table was created, So I created the DDL of PSDBOWNER table


SQL> select dbms_metadata.get_ddl('TABLE','PSDBOWNER','PS') from dual;

The output was :

  CREATE TABLE "PS"."PSDBOWNER"
   (    "DBNAME" VARCHAR2(8) NOT NULL ENABLE,
        "OWNERID" VARCHAR2(8) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  TABLESPACE "PSDEFAULT"
Then I dropped the table PSDBOWNER, and recreated the table using the above output

I reran the insert, and ORA-600 vanished.

Respond for any doubts, and keep experimenting!!


Tuesday, 23 September 2014

to change hostname in Linux

TO change the hostname in Linux operating systems

type:-- vi /etc/sysconfig/network 

Output will be something like this:--

NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=localhost.localdomain


Now change the hostname to  something.anydomain.com and reboot the system.

once the system comes up type

# hostname
something.anydomain.com




Tuesday, 27 May 2014

Manual configuration of DHCP in Peoplesoft Image installation

With 9.2 release of PeopleSoft applications, the image installations have  become an important part of any PeopleSoft system on 9.2 releases.

All who have done the PeopleSoft image installations through Oracle VirtualBox  will see one step in the image installation



I have selected 'n' to manually configure the DHCP settings as this will give you better understanding of the network adapter settings in Virtual box and how it behaves.

Before this make sure you have following settings for network in Oracle Virtualbox

This will automatically select the network adapter configured on the machine.


 Find the network configurations of the host machine where the image is going to be installed.

Open the command prompt and fire ipconfig -all
 It will show all the possible network configurations of the machine, now find the network adapter name as shown in bridged adapter setting in Virtual box.

it should have the following parameters configured







Now coming back to DHCP settings of th Virtual box ,first it will ask for Static IP.




Enter any vacant IP in the network consulting the network administrator. then it asks

enter this referring to Subnet Mask in ipconfig. then

enter this referring to Default Gateway in ipconfig.then


enter this referring to DNS Servers in ipconfig.

After all these entries the eth0 will restart with the mentioned settings, all should be OK 

Then enter the hostname at your own discretion.after this it will ask for confirmation of all the manual settings.










On pressing Y the virtual box will try to establish connection with the DNS server as mentioned this should be OK 




The DHCP settings are complete for your Image.

Wait for more updates!!

Regards,
Rohan

Tuesday, 15 April 2014

To find the exact details about any port on LINUX

We have always faced issues in UNIX flavours regarding the ports which are used in PeopleSoft system like the HTTP port .JSL port,JSH etc etc.
to find out each and every details about any port fire this command:--

lsof -nP -i :1521
COMMAND   PID  USER   FD   TYPE   DEVICE   SIZE   NODE        NAME
PSAPPSRV  26856 psoft    5u  IPv4     262797            TCP           2.2.2.2:13333->3.3.3.3:1521 (ESTABLISHED)

on sxecuting the above command on Application server for 1521 port which is the default DB listen port for Oracle. the following output gives detailed information.

COMMAND:-- this the process which is using the port 1521

PID:-- everybody knows whats that :-)

USER:-- which user is running that process.

FD:-- (File Descriptor):-- this is important as it shows the important parameter. Below is the explanation how to interpret the output of FD.


# - The number in front of flag(s) is the file descriptor number of used by the process to associated with the file
u - File open with Read and Write permission
r - File open with Read permission
w - File open with Write permission
W - File open with Write permission and with Write Lock on entire file
mem - Memory mapped file, usually for share library

So 5u will mean that PSAPPSRV has FD 5 associated with read write permission.

TYPE:-- this can be of different  types like FIFO,dir. Here PSAPPSRV is a process having connection to database through .IPV4.

NAME:-- this shows the established connection between the two servers through 1521 port.






Wednesday, 2 April 2014

Kernel parameter changes for PeopleSoft in UNIX flavours

During all these years of my work on PeopleSoft on various flavours of UNIX (RHEL,AIX,SUSE,Solaris)
There are specific modifications which are needed to be made in the various kernel parameters on the application/Web servers for proper functioning of Server Processes.

The below given details are absolutely based on my work,so please exercise the changes judiciously considering the implications of these parameters.

The following 2 are the most important parameters with respect to PeopleSoft which need to be taken care of;--

1.) msgmni:--
This parameter takes care of the number of message queues.By default this parameter is 16 in all Unix OS's.
IF this parameter is not changed to required value, the most likely error one will face is:--

Cannot create error process - fork() 
while booting up the application server, for which when Tuxlog is checked you will find the following error entries:--

System init function failed, Uunixerr = : msgget: No space left on device

 Please make sure the msgmni is set to 1024 in /etc/systctl.conf.
////////////////////

2.) fs.file.max :--
This parameter is for the no. of open files, this is denoted by -n when you pass ulimit-a 





set this to 65536 in /proc/sys/fs/file-max.

A typical sysctl.conf for peoplesoft application server should be like this:--


kernel.msgmnb = 65536 ---> Controls the maximum size of a message, in bytes
kernel.msgmax = 65536---> Controls the default maximum size of a message queue
kernel.shmmax = 1073741824--->Controls the maximum shared segment size, in bytes
kernel.shmall = 2097152--->Controls the maximum number of shared memory segments, in pages
fs.file-max = 65536
kernel.msgmni = 1024





Saturday, 29 March 2014

RUNNING SQR on Linux/Unix OS installed on Cloud

During my recent PeopleSoft Installation on Cloud, I have experienced lot of latency issues while communicating to the database hosted on AWS from my local machine.

For Example dddaudit.sqr ran for almost 2 hours and it completed just 10 percent.

Sp it is best advisable to run all the application engines,SQR reports from the console by taking putty or SSH session of the database server..

below is the command for running the SQR:--

[/pshome] sqr $PS_HOME/sqr/setspace.sqr sysadm/XXXXXX@TESTDB -o$PS_HOME/setspace.out -i$PS_HOME/sqr/ -ZIF$PS_HOME/sqr/pssqr.unx "-f$PS_HOME/setspace.pdf" -printer:pd ORACLEDB 689 PS 

-o--> the output of the SQR file
-i--> the input directory where SQR is kept.
-ZIF--> the sqr initialization parameter file
-f--> ther eport output in the pdf format


Wednesday, 26 March 2014

BYPASS SIGNON implementation in PeopleSoft

This requirement generally arises normally  in HCM when Candidate gateway is being implemented.

The purpose of this configuration is to directly land any user over the internet to peoplesoft system, for example applying for a job posting page.

Below are the steps for bypass signon implementation:--

>> the first step is to create a new site with a different http port.

>> Go to configuration.properties of that web server domain and make the following changes:--

byPassSignOn = True

defaultUserId = <UserId>


defautltPWD = <UserPwd>

>> Login into the application and make the public access enabled for the user mentioned in the  configuration.properties.

>> Bounce the web server domains.

>> Now you use the port mentioned in the new site in the URL and you will not be asked for authentication.

Integration Broker--Domain status not purging completely

ISSUE:--Domain status not purging completely, the dispatcher handlers were not getting active even though the PUB/SUB services were up and when trying to update the domain status "Page inconsistent error was coming up"


Solution:--
>>do the ctrl+j and drill down to the page of the domain status page

>>then check the following tables PSAPMSGDOMSTAT,PSAPMSGDSPSTAT and PSAPMSGQUESTAT
the following are the core tables form where the entries of that page is coming up

>>create the script for taking the backup of these tables from datamover using PeopleSoft ID

>> Go to app designer build the following tables and also create the indexes for these tables

>> run the appmessagepurgeall.dms

>> bring down the app server and web server domain and clear the cache

>> bring up the domains with PUB/SUB services , and check the domain status page and refresh .

Monday, 24 February 2014

Various modifications and observations on Oracle VM box installations

> There are 4 users used for the whole setup of PeopleSoft environment psadm1,psadm2,psadm3 and oracle.

> The TNSNAMES.ora gets configured on port 1522, 1523 ports.

> Listener by default is not running and needs to be configured on 1521.

> The tns entry has to be modified by setting SERVICE_NAME by combining the parameters DB_NAME.DB_DOMAIN.

> Make sure to check the host name from /etc/hosts.

> Make TNS_ADMIN entry in the bash_profiles of all the users (psadm1,psadm2,psadm3,oracle)

> Blank out all the entries of listener in the parameters.

> Add the psadm2 user to the dba group for booting up the appserver domains.