E-ORA Advice for the PeopleSoft Oracle DBA
Last updated on MARCH 06, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.50 to 8.55 [Release 8.4]
PeopleSoft Enterprise PT PeopleTools - Version 8.56 to 8.56 [Release 8.4]
Information in this document applies to any platform.
This document is intended the Oracle DBA who seeks a "big picture understanding" regarding how to support a PeopleSoft Application. It is a brief overview that contains advice from PeopleSoft Support Install/Upgrade and CoE teams with links to relevant KM documents.
It is organized as a series of steps starting with comments related to hardware, and working "up" from there, e.g. from hardware, operating systems, database versions and patchsets, initialization settings, statistics, and so on.
This documented was written with the anticipation that the reader is an Oracle DBA that is skilled in the various aspects of implementation, administration, and tuning of the Oracle RDBMS. Additionally, it will be helpful for the reader to be fluent in PeopleSoft technologies and/or have access to PeopleSoft technical staff that can modify settings to meet specific implementation needs.
The information contained in this document applies to Oracle databases used for PeopleSoft Applications built on PeopleTools 8.50+, specifically on Oracle 10g, through 12c.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms