PeopleSoft Commands

Application Server

psadmin –h  ---Display command help and syntax

psadmin –v ---- Displays the PSADMIN version number, as in Version 8.50.

psadmin –env ---Display your current environment variables

Check the server status of the an application server domain (is it up or down):

psadmin -c sstatus -d YOURDOMAIN   -- Displays the Tuxedo processes and PeopleSoft server processes that are currently running in the  application server domain 

psadmin -c cstatus -d YOURDOMAIN  -- Displays the currently connected users in the  application server domain.

psadmin -c qstatus -d YOURDOMAIN  -- Displays status information about the individual queues for each server process in the  application server domain.

psadmin -c boot -d YOURDOMAIN         --It is for starting domain

psadmin -c parallelboot -d YOURDOMAIN --It is for starting domain  using the parallel boot option.

psadmin -c -pslist -d YOURDOMAIN--- Displays the processes that have been booted for the  domain. This includes the system process ID for each process

psadmin -c configure -d YOURDOMAIN ---- Reloads the domain configuration for the domain.

psadmin -c shutdown -d YOURDOMAIN     --It is for shutting down the server

psadmin -c shutdown! -d YOURDOMAIN   --It is for force Shutdown

psadmin -c preload -d YOURDOMAIN --- Preloads the server cache for the  domain. 

psadmin -c purge -d YOURDOMAIN -noarch -log "Manual Cache Purge"

psadmin -c cleanipc -d YOURDOMAIN    --It is for cleaning system resources

1. Boot PUB/SUB Services using tmadmin

  Select option '5' in PSADMINUTILITY i,e tmadmin

   >shutdown -g PUBSUB

   >boot -g PUBSUB 

Process Scheduler

Check the status of a process scheduler database (option 8):

psadmin -p sstatus -d YOURDB  --- Displays the Tuxedo processes and PeopleSoft server processes that are currently running in the domain.

psadmin -p cstatus -d YOURDB  --- Displays the currently connected users/clients.

psadmin -p qstatus -d YOURDB  --- Displays status information about the individual queues for each server process in the application server domain.

psadmin -p start -d YOURDB   --- It is to start the process scheduler

psadmin -p stop -d YOURDB  ----- It is to stop the process scheduler

psadmin -p kill -d YOURDB  ----kills the domain similar to force shutdown

psadmin -p cleanipc -d YOURDB--It is to clean system resources of prcs domain

--------------------------------------------------------------------------------

WebServer 

1

11)  How to find weblogic vesion?

   A.       (a). Go to Environment->servers->select servername and click on Monitoring Tab

                   Here we find weblogic version.

          (b) In config.xml file we can find weblogic version.(/psoft/PT8.51/webserv/DN/config/config.xml)

         © In SetEnv.cmd file we can find weblogic version(/posft/PT8.51/weserv/DN/bin/SetEnv.sh)

         (d) In registry.xml file also we can find weblogic version

Linux Commands

BASIC LINUX COMMANDS

1)      To get the list of files

#ls

2)      To get list of files with the time stamp

#ls –lrt

3)      To remove a file

#rm –r filename

4)      To remove a folder

#rm –rf

5)      To change a file name

#chown –R

6)      To give read and write permissions

#chmod –R 777 /usr

7)      To know the size of the particular directory

#du –sg filename or directoryname (it will display in giga bytes) (or)

#du –sk filename or dirctoryname( it will display In kilobytes)

8)      To know disk space in GB & KB

#df –g     OR      #df -gt

#df –k     OR      #df -k

9)      To know system is 32 bit or 64 bit os

# bootinfo –Y

10)   To display how many processors does my system have

#lscfg | grep proc

11)   How many hard disks does my system have and which one are in use

#lspv or

#lspv –l

#lspv –p

12)   To know information about a specific physical volume or disk

#lspv hdisk1

13)   To know detailed configuration of my system in linux?

#lscfg

#lscfg –v

#lscfg –vl

14)   To know system information

#nmon

15)   To check CPU performance in linux and AIX

#top        ( in liunx)

#topas     ( in AIX)

16)   To know ip address of amachine in windows and linux

#ifconfig  -a      (in linux)

#ipconfig –a      ( in windows)

17)   To know network status

#netstat

18)   To display the name of the current system I,e linux or unix

#uname

19)   Report virtual memory statistics

#vmstat

20)   Get the s/m uptime, s/m load average

#uptime

21)   To set environment variables

#setenv

22)   Print last few lines in a file

#tail

23)   To change ownership change file/directory  owner

#chown newowner filename      ----------Change file/directory owner

#chgrp new group filename       -----------Change file/directory group

#chown newowner.newgroup filename

24)   To create a group

#mk group groupname  -----------To create group

#rm group groupname   -----------To remove group name

25)   To know current user

#whoami    It displays current user

#who           Displays details of all users currently logged in

#who –b     Displays system reboot time

#uptime     Displays number of users logged in time, since last time reboot and mach load avg

#lsuser all        Displays list of all user datails

#lsuser root    List details of all users

#w                     It shows what logged users are doing

----------------------------------------------------------------------------------------------------------------------------

Scheduling Scripts using crontab:

#crontab  –l                      (It Lists out crontab entrys)
#crontab  –e                      (Using this we can create or Edit crontab entries)
#crontab  –l>filename             (O/P crontab entrys to a file)
#crontab filename                 (Enter a crontab from a file)
#crontab  –r                      ( Removes all crontab entries)
#crontab  –v                      ( Display crontab submission true)


oracle@nabdcdb/home/oracle#crontab -l
## Cronjob runs on every Sunday at 5AM morning and gather stats of NABADM schema ##
0 5 * * 0 /home/oracle/working/scripts/NABADM_Gather_Stats.sh

Ex: This script will run 0-zeroth minute, 5-at 5 AM, *-every day,*-every month,0-every sunday(This will run on every sunday at 5 AM)

## Crontab runs every day at 11PM and delete Archive log older than 5 days ##
0 23 * * * /home/oracle/working/scripts/Del_Archivelog.sh

Ex:This script will run 0-zeroth minute, 23-at 11 PM, *-every day,*-every month,*-every week

Easy to remember format:
---------------------------------------

* * * * * command to be executed
- - - - -
| | | | |
| | | | ----- Day of week (0 - 7) (Sunday=0 or 7)
| | | ------- Month (1 - 12)
| | --------- Day of month (1 - 31)
| ----------- Hour (0 - 23)
------------- Minute (0 - 59)

Note: If you wished to have a script named /home/oracle/working/scripts/Del_Archivelog.sh 

run every day at 11 PM, your crontab entry would look like as follows. First, install your cronjob by running the following command:

# crontab -e

Append the following entry:

0 23 * * * /home/oracle/working/scripts/Del_Archivelog.sh 

-----------------------------------------------------------------------------------

Vi commands 

#vi filename    --------To  open filename

          Esc  i                             for insert

          Esc r                             for replace

          Esc x                               for delete

          Esc dd                            for  deleting entire line

          :q                                    for  quit without saving

          :wq                                 for saving the file

  To dispaly current using port  numbers in the server

Netstat:Its a command prompt command used to display very detailed information about how your computer is communicating with other computers or network devices.
The netstat command displays information regarding traffic on the configured network interfaces such as following:
(a) The address of any protocol control blocks associated with the sockets and the state of all sockets.
(b) The number of packets received,transmitted, and dropped in the communications susbsystems.
(c) Cumulative statistics per interface
(d) Routes and their status

            #netstat -ant
            #netstat -an |pg              ----To display current port numbers page wise
            #netstat -y                     ----It displays tree commands of netstat

To find files larger than 100MB:

find . -type f -size +100M

35 Practical Examples of Linux Find Command:

1. Find Files Using Name in Current Directory
Find all the files whose name is tecmint.txt in a current working directory.
# find . -name tecmint.txt
./tecmint.txt
2. Find Files Under Home Directory
Find all the files under /home directory with name tecmint.txt.
# find /home -name tecmint.txt
/home/tecmint.txt
3. Find Files Using Name and Ignoring Case
Find all the files whose name is tecmint.txt and contains both capital and small letters in /home directory.
# find /home -iname tecmint.txt
./tecmint.txt
./Tecmint.txt
4. Find Directories Using Name
Find all directories whose name is Tecmint in / directory.
# find / -type d -name Tecmint
/Tecmint
5. Find PHP Files Using Name
Find all php files whose name is tecmint.php in a current working directory.
# find . -type f -name tecmint.php
./tecmint.php
6. Find all PHP Files in Directory
Find all php files in a directory.
# find . -type f -name "*.php"
./tecmint.php
./login.php
./index.php
Part II – Find Files Based on their Permissions:

7. Find Files With 777 Permissions
Find all the files whose permissions are 777.
# find . -type f -perm 0777 -print
8. Find Files Without 777 Permissions
Find all the files without permission 777.
# find / -type f ! -perm 777
9. Find SGID Files with 644 Permissions
Find all the SGID bit files whose permissions set to 644.
# find / -perm 2644
10. Find Sticky Bit Files with 551 Permissions
Find all the Sticky Bit set files whose permission are 551.
# find / -perm 1551
11. Find SUID Files
Find all SUID set files.
# find / -perm /u=s
12. Find SGID Files
Find all SGID set files.
# find / -perm /g+s
13. Find Read Only Files
Find all Read Only files.
# find / -perm /u=r
14. Find Executable Files
Find all Executable files.
# find / -perm /a=x
15. Find Files with 777 Permissions and Chmod to 644
Find all 777 permission files and use chmod command to set permissions to 644.
# find / -type f -perm 0777 -print -exec chmod 644 {} \;
16. Find Directories with 777 Permissions and Chmod to 755
Find all 777 permission directories and use chmod command to set permissions to 755.
# find / -type d -perm 777 -print -exec chmod 755 {} \;
17. Find and remove single File
To find a single file called tecmint.txt and remove it.
# find . -type f -name "tecmint.txt" -exec rm -f {} \;
18. Find and remove Multiple File
To find and remove multiple files such as .mp3 or .txt, then use.
# find . -type f -name "*.txt" -exec rm -f {} \;

OR

# find . -type f -name "*.mp3" -exec rm -f {} \;
19. Find all Empty Files
To file all empty files under certain path.
# find /tmp -type f -empty
20. Find all Empty Directories
To file all empty directories under certain path.
# find /tmp -type d -empty
21. File all Hidden Files
To find all hidden files, use below command.
# find /tmp -type f -name ".*"
Part III – Search Files Based On Owners and Groups
22. Find Single File Based on User
To find all or single file called tecmint.txt under / root directory of owner root.
# find / -user root -name tecmint.txt
23. Find all Files Based on User
To find all files that belongs to user Tecmint under /home directory.
# find /home -user tecmint
24. Find all Files Based on Group
To find all files that belongs to group Developer under /home directory.
# find /home -group developer
25. Find Particular Files of User
To find all .txt files of user Tecmint under /home directory.
# find /home -user tecmint -iname "*.txt"
Part IV – Find Files and Directories Based on Date and Time
26. Find Last 50 Days Modified Files
To find all the files which are modified 50 days back.
# find / -mtime 50
27. Find Last 50 Days Accessed Files
To find all the files which are accessed 50 days back.
# find / -atime 50
28. Find Last 50-100 Days Modified Files
To find all the files which are modified more than 50 days back and less than 100 days.
# find / -mtime +50 –mtime -100
29. Find Changed Files in Last 1 Hour
To find all the files which are changed in last 1 hour.
# find / -cmin -60
30. Find Modified Files in Last 1 Hour
To find all the files which are modified in last 1 hour.
# find / -mmin -60
31. Find Accessed Files in Last 1 Hour
To find all the files which are accessed in last 1 hour.
# find / -amin -60
Part V – Find Files and Directories Based on Size
32. Find 50MB Files
To find all 50MB files, use.
# find / -size 50M
33. Find Size between 50MB – 100MB
To find all the files which are greater than 50MB and less than 100MB.
# find / -size +50M -size -100M
34. Find and Delete 100MB Files
To find all 100MB files and delete them using one single command.
# find / -size +100M -exec rm -rf {} \;
35. Find Specific Files and Delete
Find all .mp3 files with more than 10MB and delete them using one single command.

# find / -type f -name *.mp3 -size +10M -exec ls -l {} \;

Check DB is unicode or non-unicode

To check the database supports unicode or non unicode
-----------------------------------------------------------
SQL> SELECT TNAME FROM TAB;

SQL> SELECT TNAME FROM TAB WHERE TNAME LIKE '%NLS%'

SQL> DESC NLS_DATABASE_PARAMETERS;
 Name                                      Null?                             Type
 ---------------                     --------                   ----------------------------
 PARAMETER                  NOT NULL                   VARCHAR2(30)
 VALUE                                                                   VARCHAR2(160)

SQL> SELECT PARAMETER,VALUE FROM NLS_DATABASE_PARAMETERS;

SQL> SET LINES 300 PAGES 300
SQL> /

PARAMETER                                                                        VALUE
-------------------------------------              --------------------------------------------------------
NLS_LANGUAGE                                                        AMERICAN
NLS_NCHAR_CHARACTERSET                               UTF8
NLS_TERRITORY                                                       AMERICA
NLS_CURRENCY                                                           $
NLS_ISO_CURRENCY                                              AMERICA
NLS_NUMERIC_CHARACTERS                                       .,
NLS_CHARACTERSET                                            AL32UTF8  ------------------------This AL32UTF8 SEARCH IN GOOGLE AND IT SHOWS THAT IT SUPPORTS ASIAN LANGUAGES
NLS_CALENDAR                                                     GREGORIAN
NLS_DATE_FORMAT                                               DD-MON-RR
NLS_DATE_LANGUAGE                                         AMERICAN
NLS_SORT                                                                BINARY
NLS_TIME_FORMAT                                              HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT                                 DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT                                        HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT                           DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY                                            $
NLS_COMP                                                             BINARY
NLS_LENGTH_SEMANTICS                                 BYTE
NLS_NCHAR_CONV_EXCP                                 FALSE
NLS_RDBMS_VERSION                                       11.2.0.2.0

20 rows selected.

Inc/Dec Mount Points in linux

Increasing/Decreasing the size of the mounts or Directories in Unix:
----------------------------------------------------------------
Login with root user:

(a)    Chfs –a  size=+5G /psoft
(b)    Chfs –a  size=-1G /psoft ( From this query it will decrease the 1gb space from /psoft folder)

Ex: nabdcbkp#chfs –a size=+5G /psoft (In this it will increase additional 5 GB Space)
     nabdcbkp#chfs -a size=20G /psoft (If it was having 18 gb then from this query it will come assign to 20    GB space)

Explain plan and how to take AWR,ASH,ADDM Reports in Oracle

Explain paln for long running query and how to take AWRRPT,ADDMRRPT,ASHRPT.sql to know the performance of the DB
----------------------------------------------------------------------------------------------------------------
Taking AWR,ADDM,ADR Reports in oracle db to know the status or performance of DB.

Awr:  It contain the whole performance of the db(Automatic workload Repository.
Addm: It will verify or gives about AWR Report performance.(Automatic DB Diagnostic monitor)
Adr:  ADR is the diagnostic repository which is meant for storage of the error related information , useful for debugging and troubleshooting.(Automatic Diagnostic Repository)
Login to system:
oracle@nabdcdb/#cd $ORACLE_HOME
oracle@nabdcdb/oracle/orahome#cd rdbms/admin/ls awr*
Go to sql prompt with sysdba and run the script as follows:

Sql>@/oracle/orahome/rdbms/admin/awrrpt.sql
Sql>@/oracle/orahome/rdbms/admin/addmrrpt.sql
Sql>@/oracle/orahome/rdbms/admin/ashrpt.sql

After running this scripts it will ask :
Report Name:rajutodaydate
Start date:12118
End date:13191       Ex: select for one day.O/P will store in the below path

D:\app\oracle\product\11.2.0\dbhome_1\RDBMS\Admin\ ------------In windows
/oracle/orahome/rdbms/admin/  ---------------------------------In linux
---------------------------------------------------------------------------------------
Checking the performance of long running queries using explain
--------------------------------------------------------------------------------------

Sql>explain plan for (copy the long running query and press enter)
Sql>@/oracle/orahome/rdbms/admin/utlxpls.sql;  (It will display the performance of the query)
SQL> @E:\ORACLE\product\11.2.0\dbhome_1\RDBMS\ADMIN\utlxpls.sql(this in windows)

Enable Archive log mode in Oracle DB

How to enable archive log mode in oracle 10g or 11g
--------------------------------------------------------------
This is how to enable archiving:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Productio
With the Partitioning, OLAP and Data Mining options

SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 26
Current log sequence 28

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 96469696 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database archivelog;                           For no archive log mode: sql>alter database noarchivelog;

Database altered.                                                                 Database altered.

SQL> alter database open;                                                         sql> alter database open;

Database altered.                                                                 Database altered

Set Environment Variables

List all environment variables and set env variables from command line in windows?
--------------------------------------------------------------------------------------------------------------
In command prompt give the command as set
Ex:     C:\>set  or   C:/ set | more

To set oracle path,home path or any path in windows
     c:\> set ORACLE_HOME=c:/orale/product/11.2.0/db_1/bin

To see the environment variable what we have setted
     c:\>echo %oracle_sid%

To create/set a variable permanently, use setx varname "value":
     C:\>setx FunnyCatPictures "C:\Users\Daniel\Pictures\Funny Cat Pictures"
              [Restart CMD]
    C:\>echo %FunnyCatPictures%
    C:\Users\Daniel\Pictures\Funny Cat Pictures

List all environment variables and set env variables from command line in Linux?
--------------------------------------------------------------------------------------------------------------------------
To list the current values of all environment variables, issue the command>
  root@nabdcbkp/#env      or     root@nabdcbkp/#env | more

To set oracle path,home path or any path in windows
   root@nabdcbkp/#export PWD=nagarau   or
   root@nabdcbkp/#export ORACLE_HOME=/app/oracle/product/10.2.0/bin
  root@nabdcbkp/#export ORACLE_SID=NABPROD
To see the environment variable what we have setted
   root@nabdcbkp/#echo $LOCPATH    OR  echo $oracle_sid   or echo $oracle_home
   /usr/lib/nls/loc

DDDAUDIT & SYSAUDIT REPORTS

DDDAUDIT - The Database Audit Report (DDDAUDIT.SQR) finds inconsistencies between PeopleTools record and index definitions and the database objects. This SQR consists of nine queries: four on tables, two on views, and three on indexes.
------------------------------------------------------------------------------------
This is the DDDAUDIT report ran from process monitor
Report Name : DDDAUDIT APPLICATION DESIGNER/DATABASE AUDIT
Database Name: TEST
Platform : UNIX DBType: Oracle
-----------------------------------------------------------------------------------

(TABLE-1) SQL Table Names defined in the Application Designer that are not blank and not the same as the Record Name:
(TABLE-2) SQL Table defined in the Application Designer and not found in the Database:
(TABLE-3) SQL Table defined in the Database and not found in the Application Designer:
(TABLE-4) Tablespace not defined for SQL Table in the Application Designer:
(TABLE-5) Table Contains More Than 500 Fields :
(VIEWS-1) Views defined in the Application Designer and not found in the Database:
(VIEWS-2) Views defined in the Database and not found in the Application Designer:
(INDEX-1) Index defined in the Application Designer and not found in the Database:
(TRIGGER-1) Trigger defined in the Application Designer and not found in the Database:

===========================================================
SYSAUDIT - The purpose of PeopleSoft’s System Audit (SYSAUDIT.SQR) is to identify “orphaned” PeopleSoft objects and other inconsistencies within your system. An example of an orphaned object would be a module of People Code that exists, but which does not relate to any other objects in the system.
--------------------------------------------------------------------------------------
This is the SYSAUDIT report ran from process monitor
Report Name : SYSAUDIT
Database Name: TEST
Platform : UNIX DBType: Oracle
---------------------------------------------------------------------------------
Application Engine Audits Result: Exception(s) Found
(AE-01) AE programs without any sections:

Clear List Audits Result: OK
Electronic Commerce Audit Result: OK
Field Definition Audit Result: OK
Menu Definition Audit Result: Exception(s) Found
(MENU-03) The Menu Item table contains Component that does not exist in the Component Definition table:

Security Audits Result: Exception(s) Found
(SEC-07) Role references a Permission List that does not exist:
(SEC-08) PSROLEUSER references a User that does not exist in PSOPRDEFN
(SEC-18) User named in a User-Role relationship does not exist in the User Definition table:
(SEC-21) Permission List named in a Role-Permission List relationship does not exist in the Permission List Definition table:

Page Definition Audit Result: Exception(s) Found
(PAGE-06) PageField table Record/Field does not exist in the RecordField table:
(PAGE-08) A Page Group contains a Page Name that does not exist in Page Definition table:
(PAGE-10) Page Group Definition contains Search Record Name that does not exist in Record Definition table:
(PAGE-11) Page Group Definition contains an Add Search Record Name that does not exist in the Record Definition table:

PeopleCode Definition Audit Result: OK

Process Scheduler Audit Result: OK

Query Definition Audit Result: Exception(s) Found
(QUERY-04) Query Definition Record name does not exist in the Record Definition table:
(QUERY-07) Query Field Record name does not exist in the Record Definition table:
(QUERY-08) Query Definition Field name does not exist in the Field Definition table:
(QUERY-22) Following Queries Were Created Without PUBLIC Access
(QUERY-26) Following Queries Have Unions But They Select Unequal Number of Fields

Record Definition Audit Result: Exception(s) Found
(RECORD-11)INFORMATIONAL ONLY-RECORDS WITH MORE THAN 2 LONGS DEFINED

Language Definition Audit Result: Exception(s) Found
(SYSLANG-08) The Following Rel Lang Records are effective dated but do not have an EFFDT field defined
(SYSLANG-13) The Following Related Language Record(s) Have More Than One Base Record Defined

SQL Audits Result: Exception(s) Found
(SQL-05) AE SQL without SQL definitions:
(SQL-06) AE SQL that's not referenced:
(SQL-07) Record Views/Dynamic Views without SQL definitions:

Tree Definition Audit Result: Exception(s) Found
(TREE-17) Tree Definition Node count does not match record count in Tree Node table:

Version Check Audits Result: OK

XLATT Definition Audit Result: Exception(s) Found
(XLATT-3) Translate field(s) do not have associated translate values defined:

Analytic Audit Result: OK

XML Publisher Audit Result: Exception(s) Found
(XMLP-01) Query Data Source does not exist in Query Definition table:

Integration Broker Audits Result: OK

Style Sheet Definition Audit Result: OK

Connected Query Audit Result: OK

Feed Audits Result: OK
=========================================================================
Alter Audit is a process that identifies any records that require SQL Alter process. i.e. if the Data Designer definition doesn’t match Database definition. All records that are flagged should be Altered.

SQL Alter - The primary purpose of the Application Designer’s “SQL Alter” function is to bring SQL tables into accordance with PeopleTools record definitions. You can run SQL Alter in an “audit-only” mode that alerts you to discrepancies between your record definitions and SQL tables, but that doesn’t actually perform an alter.

APPLYING PATCH BY RAJU

Applying PATCH

1)    Before Applying we have to shut down all servers I,e App,prcs,Webserver and PSEMAGENT server and take the backup  of  PT8.49 Folder.

(a)  The below page shows before applying patch I,e it displays: PeopleTools 8.49

2)   Shut down Application Server:

(a)  Select Option 1 to shutdown Application server

(b)  Select Option 1 

 ©  Selct option 2 to shutdown Application server

(d)  Select option 1 to shut down Application normally

 

(e)  Select option q to quit

 

 (f)   Select option 2 to shut down process scheduler.

 

 (g)  Select option 2

 

(h)  Select option q to quit

 

 3)    Shut down Webserver from Services.msc

 

 (a)   Selcet Webserver service and right click on that and select stop .

4)    Go to PT8.49\PSEMAgent\StopAgent.bat  à this is to stop PSEMAgent Server.

5)    Take the backup of PT8.49 folder and paste it any folder:

Copy all files and folders

                                                                 

         

6)        Download the Patch

6.1.     Create an Empty folder named pt84924 on your system. 

6.2.     Download the patch file from the FTP site into the pt84924 folder, and extract the contents of the self-extracting archive file into this same folder.

3.2.1.  ftp://ftp.oracle.com/peoplesoft/outgoing/ptools/84924/84924.exe

3.2.2.  The password to extract 84924.exe:

RichieRich

7)       Install Patch Files

7.1.     For Windows:

(a)   .  Run \pt84924\cd84924\Disk1\setup.exe

This is patch software from oracle support:

(b)   Select setup.bat file shown in the below:

© Select Existing folder of PT8.49

(c)   End of installation of patch 8.49.24 and click on finish button.

(8) After installing patch the below window shows version as: People Tools 8.49.24

9.       Update Your Database with Patch Version Information 

(a).     Using PeopleTools 8.49.24 launch Data Mover and logon to your database as a PeopleSoft User.

(b).     Run the script <PS_HOME>\scripts\PTPATCH.DMS (Note: This script can only be run once per database per patch.  If you reapply this patch to the same database, do not run this script again.)

Loin into DataMover: As Peoplesoft User I,e VP1

© Select ptpatch.dms Script

(d)   Run the ptpatch.dms Script from DataMover. Click on Run Button

(e) End of script ptpatch.dms

10.       Install Database Changes Included in this Patch

(a).     Using PeopleTools 8.49.24, launch Application Designer, and sign on to the database as a PeopleSoft User.

(b).     Select <Tools>, <Copy Project>, <From File>

©.     Enter <PS_HOME>\projects and select PATCH849 from the list of projects.

(d).     Select <Options> and highlight the languages <Common> and <English> ONLY.

(d).     Select <Copy> to begin copying updated PeopleTools objects to your database.

(a)

(b)   Select <Tools>, <Copy Project>, <From File>

© Enter <PS_HOME>\projects and select PATCH849 from the list of projects

(c)   Select (.) File and  press OK button.

(d)   After that the below window will be displayed: Select Copy button

(e)   Select Compare Options Tab and Select Compare Languages as : Common and English

(f)    Select Copy Options Tab and select Copy Languages: Common and English

(g)   Select All in Defination Type and select Copy Button:

(h)   This is the end of the Copying of the PATCH8.49 Project:

 In Output window it displays the start and end time and date of Project.

11.       Load PeopleTools Messages and Data Project

(a).     Logon to Data Mover in bootstrap mode as the database owner using PT 8.49.24

(b).     Run <PS_HOME>\scripts\MSGTLSUPG.DMS to load the updated messages into your database.

7.2.1.  Note: If message catalog changes have not been made in PT 8.49 by the time this patch is released, the MSGTLSUPG.DMS script may not exist in the <PS_HOME>\scripts folder and this entire step can be skipped.

       ©.     Close Data Mover

Logon to DataMover

(a)    Logon to Data Mover in bootstrap mode as the database owner using PT 8.49.24

(b)     Run <PS_HOME>\scripts\MSGTLSUPG.DMS to load the updated messages into your database.

( c ) Select Run button

( d) End of the script and script ran successfully as shown in the below:

12.       Completing Installation and configuring this PeopleTools Patch

                (a) .     Reinstall any products in use from the following folders:

( b) .  Change Assistant:  <PS_HOME>\setup\PsCA

To install change Assistant we goto  PT8.49\setup\PsCA\Setup.exe à Double click on setup.exe

Note: Change Assistant is optional if we want to install we can or otherwise leave it.

( c) Click Next

( d ) Click Next

(e)   Click Next

(f)    Select yes and select next button.

(g)Select oracle and select next button because the database we are using is : Oracle

(g)   Install path will take default no need to change:I,e C:\PeopleSoft\Change Impact Analyser

(h)   End of PS Change Impact Analyser click on finish button.

13.  PeopleSoft Internet Architecture (PIA): <PS_HOME>\setup\ PsMpPIAInstall

(a).  Websphere customers: Choose 'Redeploy PeopleSoft Internet Architecture' when prompted

(b).  WebLogic customers: Choose 'Re-create WebLogic domain and redeploy PeopleSoft Internet Architecture' when prompted.

(c).  Warning: The entire WebLogic and PIA configuration in the specified WebLogic domain is deleted when you select this option.  It is highly recommended that you make a copy of the PIA Domain directory to preserve any existing configuration settings and customizations.  You can then refer to the configuration files in the copied directory when reconfiguring the newly recreated domain.  Please refer to the patch notes at the bottom of this document for further information (ref: 1786758000).

(A)   We have to recreate PeopleSoft Internet Architecture.

(1)   For this we can recreate domain and redeploy PeopleSoft internet Architecture.

(2)   OR We delete the Webserver folder and install PIA.

(3)   In this I am redeploying PIA. Goto: PT8.49\setup\PsMpPIAInstall and select setup.exe

(B)   Select Next

© Select PSHOME Folder and click Next.

(E) Select BEAWeblogic server and click Next.

(F) Give bea path previously where we installed Weblogic and click Next.

(G) Give        Login ID        : system

                   Password        : password1

          Re-type password    : password1--------------------àIn this it will ask atleast one number.

(H) Select Existing Weblogic Domain and select Recreate Weblogic domain and redeploy PIA and select Next.

(I)             Select Single Server Domain and Select Next.

(J) Give existing website name: Previously it has fsprdsb and we have to give the same website name.

(K) Give Appserver name  : Machine name

              JSL Port               : 9000-------------Check in psappsrv.cfg file

             HTTP Port             : 8055

             HTTPS Port          : 443--------------It is a default port and click Next

(L) Give default web profile name like:DEV,KIOSK,TEST,PROD, userid and password should be same and click Next

(M) Select Install button

(N) End of Installation click on Finish button

13.     Purge all App Server and Web Server cache.  (Knowledge Management document ID <Document:753215.1> has more details on purging if needed.)

14.     Re-start your Application server(s), Batch server(s), Web Server(s), and EM Agents.

15    Finally Login to PIA and check some default reports.

16.   We can  know the patch version in different ways:

(A)    IN TOAD GIVE QUERY: SELECT * FROM PS_MAINTENANCE_LOG;

(B)    Top of  the Application Designer we can able to see patch version.

(C)    Top of the Data Mover window we can able to see patch version.

(D)    After login to Application Designer Goto:Help->About PeopleTools-àhere we can find patch version

(E)    In PIA page press CTRL+J    here also we can find patch version.