PeopleSoft for the Oracle DBA
PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz's book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment. You’ll learn abou...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York :
Apress
2012.
|
| Edición: | 2nd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628365406719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Contents at a Glance; Table of Contents; Author's Preface to the Second Edition; Foreword to the First Edition; About the Author; About the Technical Reviewers; Acknowledgments; Introduction; Who Should Read This Book?; What Does This Book Cover?; Software Versions; Other Resources; Online Resources for This Book; Contacting the Author; CHAPTER 1 An Overview; What Is PeopleSoft?; Components of a PeopleSoft System; The Database; Tuxedo Application Server; PeopleTools; Evolution of the PeopleSoft Architecture; Single-Tier Monolithic Mainframe Architecture
- Two-Tier Client/Server ArchitectureThree-Tier Application Server Architecture; Four-Tier Internet Architecture; Release History; Component Connectivity; Developing and Administering PeopleSoft Systems; The Developer; The DBA; Relationship Between the Developer and DBA; Summary; CHAPTER 2 BEA Tuxedo: PeopleSoft'sApplication Server Technology; What Is Tuxedo?; The Simple Application Server; The Simple Client; The Simple Server; The Simple Tuxedo Domain; Anatomy of the Application Server; Processes, Memory, and Messages; IPC Resources; tmadmin and ipcs; PIA Servlets; Integration Broker; Summary
- CHAPTER 3 Database ConnectivityPeopleSoft Database versus Oracle Database; Oracle Database Users; Owner ID (SYSADM); Connect ID (PEOPLE); PS Schema; Oracle Database Roles; PSUSER Role; PSADMIN Role; Signing On to a PeopleSoft 8 Database; Making the Initial Connection; Using Direct Shared Memory Connections (UseLocalOracleDB); Determining the PeopleSoft Schema; Checking the PeopleTools Release; Checking the Operator Password; Obtaining the Access Password; Reconnecting as Access ID; Using PeopleSoft Access Profiles and Oracle Resource Profiles; PeopleSoft Support for Oracle Active Data Guard
- Connecting Third-Party ApplicationsCrystal Reports; SQR Reports; Changing Database Passwords; Connect ID Password; Owner ID Password; Summary; CHAPTER 4 PeopleSoft Database Structure: ATale of Two Data Dictionaries; Application and PeopleTools Tables; Two Data Dictionaries; PSRECDEFN: Record Definition; The USEEDIT Field; PSRECFIELD: Record Field Definition; PSDBFIELD: Field Definition; Field Types and Lengths; Unicode in PeopleSoft; Unicode from PeopleTools 8.48 and Application Version 9; Unicode in Application Version 8.x; PSSQLDEFN: Definition of SQL Objects; PSSQLTEXTDEFN
- PSINDEXDEFN: Index DefinitionPSKEYDEFN: Index definition; Recursive PeopleTools SQL; Version Numbers and Caching; Component Definition; Search Record; Case-Insensitive Searching; Component Pages; Component PeopleCode; Page Definition; Page Fields; Record Definition; Field Definitions; Subrecords; Field Labels; Record DDL; Subrecord Definition; Application SQL; Data Dictionary Synchronization; DDL Changes; Column Difference Audit Script; Summary; CHAPTER 5 Keys and Indexing; What Is the Purpose of an Index?; What Is a Constraint?; What Is the Purpose of a Unique Constraint?
- Record Field Key Attributes
