Usually people ask me about downloaded KB Documents from Oracle Support that are not legible. The step to save these documents are: open the document in an new window, then save it and finally remove from the .html file some style code.
Edit the downloaded file, Check for prinPreview() function and remove the entire body: {display: none} code.
I attach an image with an example for this small tip:
Andrés Caro
On Aug 7, 2014. Oracle officially withdraws support for Informix and Sybase database platforms: Tech Update – Oracle Modifies Supported Platforms for PeopleSoft (Doc ID 1915316.1).
The note indicates that:
It further recommends that users in this platforms will need to transition to another database after support ends and the Oracle database should be selected as a replacement.
I know some PeopleSoft customers on Panama that are using Sybase database that will be more than happy to migrate to a better supported database. It is really hard to work for a database platform with a very low customer base, where you usually cannot find a capable DBA to work on it.
Andrés Caro
There is plenty information on Oracle Support to cloning/restoring PeopleSoft DB, also about cloning PeopleSoft Servers and Domains.
But post-restoration activities are personalized for each PeopleSoft client, as different implementations and environments could be implemented. Anyway I post the general activities that I execute after a DB restoration:
From Support Workstation:
1) Run prcsclr.dms – this will cleanup process scheduler tables. (PSPRCSRQST, PSPRCSQUE, PSPRCSPARMS, PS_MESSAGE_LOG etc.)
2) Run rptclr.dms – this will cleanup Report Manager tables. (PS_CDM_LIST, PS_CDM_AUTH etc.)
3) Cleanup messaging tables, run appmsgpurgeall.dms
FROM PIA:
Additional Activities:
If you want to keep previous security information before the DB restoration process, surely you executed the “securityexport.dms” script, this script keeps important PeopleTools security information on objects/tables. In order to restore this data after a DB restoration/clone process you must execute the “securityimport.dms” script.
Some imported objects are:
Users – PSOPRDEFN, PSUSEREMAIL , PSUSERATTR , PSOPRALIAS , PSROLEUSE, PSUSERPRSNLOPTN, PS_ROLEXLATOPR, PS_RTE_CNTL_RUSER.
Roles – PSROLEDEFN, PSROLECLASS, PSROLECANGRANT, PSROLECLASS.
Access Profiles – PSACCESSPRFL
It also imports Permission Lists, Definition Security records, Personalization, etc.
Andrés Caro
On September 18, 2014; Oracle officially withdraws support for Crystal Reports and Business Objects Enterprise (BOE ): Tech Update – Retires Oracle Support for Crystal Reports ( Doc ID 1927865.1 )
The note indicates that PeopleTools 8.54 is the latest version to be certified for Crystal Reports and BOE. It further indicates that PeopleSoft 9.2 applications use the BI Publisher component embedded for publishing reports in Crystal replacement .
This change was expected since SAP (now Crystal Reports owner) asked Oracle some years ago to remove Crystal licenses that were included in the PeopleTools, plus the recent updates / patches on 9.1 applications already replaced several important Crystal reports for BI Publisher report.
Andrés Caro
The PSDEFAULT tablespace is the default for the database owner user “PSADMIN”, when you create a table-record if its definition does not has a custom tablespce then its created on the PSDEFAULT tablespace.
When you create the PeopleSoft Database you execut the script psadmin.sql which creates the PSADMIN user and sets the default tablespace for this user (it also set the default temporary tablespace as pstemp), the default user name and tablespace can be changed when you run this script . The script basically executes the following:
create user &ADMIN identified by &PASSWORD default tablespace &TSPACE
I don´t recommend to create the TAO tables in the PSDEFAULT. As the TAO tables are used for high volume processing task their datafiles could grown very fast, if for some reason the PSDEFAULT tablespace cannot grown any more this problem can affect many applications tables and not just the TAO tables.
You could create a custom XXX_TMP tablespace for the TAO tables and manage their datafiles on different locations to avoid problems when they grow, with a custom _TMP tablespace its an easier way to recognize and administrate them.
Andrés Caro
Customers continuously ask me about Hardware sizing when they implement a new PeopleSoft Application.
Usually hardware support provider and seller has the Architecture sizing specification. They deliver standard forms and questionnaires to calculate the needed requirements.
These are some Hardware vendor links for PeopleSoft Sizing:
– DELL: http://marketing.dell.com/oracle-erp-sizing
– IBM: https://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/techline/PRS264_migrated
– HP: http://www.hporacle.com/ORACLE/SIZING/index.asp?tool=PeopleSoft
As the client usually has an established relationship with a seller, he must ask for support on this topic and send the required forms to the Sizing Engineer representative.
Andrés Caro
An easy way to achieve this:
Using Application Designer Search for a project “PPLTOOLS” (PeopleTools 8.52: PeopleSoft Application Designer Developer’s Guide> Planning Records, Control Tables, and TableSets – Table-Based Systems ). It should contain the complete list of PeopleTools Objects.
There also other projects that has only PeopleTools objects, these are used for Upgrade processes. For example on a new installation you usually import the PPLTLS84CUR and PPLTLS84CURML (Installation Manual for PT 8.52 – Task 7A-16-3: Updating PeopleTools Database Objects) to update the application to the current Tools version used, also when a PeopleTools Patch is installed you import a PATCHXXX or PATCHXXXML projects.
Andrés Caro
Recently a new discussion about this topic was created on Oracle Community forum. This is the experience that I have with PeopleSoft on HT Processors:
1. Administration:
I found that enabling or disabling HT have some repercussions on the platform administration and reading the performance information provided by the Operative System. Think that reading the CPU usage information from a HT enabled system can produce misinterpretation of the actual CPU usage, it also can lead to guess a wrong scalability potential of the system and the actual lifetime. Also consider that HT will not help your system to increase performance when you have a bottleneck on network or I/O devices.
A nice blog created by a DBA about HT and the administration point of views is here:
http://databaseperformance.blogspot.com/2011/07/beware-cpu-threads-are-not-same-as-cpu.html
2. Database:
I found the same information that Dave provided in the previous post. I add the link to the Microsoft document mentioned by Dave:
http://download.microsoft.com/download/E/C/5/EC567749-20C0-4DC5-99B7-FA7C77A097EA/PeopleSoft%20on%20SQL%202008.docx
and other good link about:
http://www.dba-oracle.com/oracle_tips_cpu_count_wrong.htm
3. Application Server/Process Scheduler:
When an instruction needs data from RAM, it will be blocked for a length of time during which the CPU could have run other instructions. Intel tried to address this memory delay problem with a trick called Hyper-Threading. Rather than duplicate the entire circuitry of a CPU, a Hyperthreading processor simply duplicates the registers that hold all the data. The OS thinks that there are two CPUs and it assigns two different threads to them, because all the registers and data needed to run each thread are loaded into the same CPU chip at the same time. This effectively makes the CPU usage to become less idle, but it cannot duplicate the actual CPU power and the percentage power gain level depends of the applications executed.
The Application/Batch Server Domain services are not developed thinking threads, when a services as the PSAPPSRV is processing some request it use just one CPU (real or logical) and there are not benefit from a HT processor. When you have a single Domain Server generating high CPU utilization, Hyper-Threading does not increase performance in this case.
In fact the gain of HT for many other applications is just marginal and not constant, take as example the following documentation from Microsoft:
4. Web Server:
Weblogic is a multi-threaded application server and it manages resource allocation, concurrency, and thread synchronization. These multiple threads can be configured for multiple task, for example you can assign a number of execute threads to act as socket reader threads to improve socket communication and increasing the speed/ability of the server to accept new client requests, also Java’s garbage collection and background JIT compilers work as daemons threads in the JVM. As a Web Server system use extensive use of threads, this could benefit from HT if the JVM detects this configuration to use the required optimizations on this case.
The following url have an Intel test bed using Weblogic on Intel Xeon processors, it has some tuning notes that i have used with some level of success on different architectures and not just the Intel-Xeon:
Click to access 54375_54375.pdf
Conclusion:
Enable HT on DB and WebServer hosts if possible and when they are separated from the other PeopleSoft architecture layers. Tune the Server in each case taking account of the HT feature, even it such case as the different attached documents reveals you´ll only get a small performance increase.
Disable HT for App/Batch Servers specially taking in consideration the point 1 and 3.
Andrés Caro
I just get a nice present from Oracle Community, I´m now an Oracle Pro…
Bad written integration WebServices can block all browsing for a PeopleSoft Application on a bad configured Application Server.
When an Pub/Sub Application server is configured with a timeout equal to zero for the PSAPPSERV service, it can be blocked and not recycling process will happen. Then you can reach a point with not PSAPPSERV available for navigation.
You can check the App server state on tuxedo command line, it shows an integration service event:
A session query on the DB shows a “JavaClient” (Java application used to WebServices test) on the CLIENT_INFO column.
Andrés Caro
PeopleSoft Skilled Professional 