Archive

Category Archives for "PeopleSoft Administration"
3

How to Install Oracle 32 bit Client on Windows 64 bit and avoid the error INS-30131

You may receive the following error when trying to install the Oracle Client 32-bit and 64-bit on the same Microsoft Windows x64 (64-bit) machine: Installation of Oracle12c Release 1 Client 32-bit Failed: “[INS-30131] Initial Setup Required For The Execution Of Installer Validations Failed. You may receive this error when trying to install the  Oracle Client 32-bit […]

Continue reading

E-ORA SYS.DBMS_STATS has errors ORA-06508: PL/SQL: could not find program unit being called: SYS.DBMS_STATS

While doing PeopleTools upgrade via Change Assistant, you may encounter this error: E-ORA SYS.DBMS_STATS has errors ORA-06508: PL/SQL: could not find program unit being called: SYS.DBMS_STATS The error message is indicative enough to suggest that there are invalid dba_objects. To make sure, run the below command: SQL> select owner, object_name, object_type, status from dba_objects where […]

Continue reading

REL851unDBTSFIX Script Failed – PeopleTools Upgrade Bug

When upgrading database from PeopleTools 8.50 to PeopleTools 8.53.06, you’re likely to see a situation where the step “Updating PeopleTools System Tables” fails. The failure is while running REL851unDBFIX.sql. Subsequently the error is encountered for REL852unDBFIX.sql and REL853unDBFIX.sql as well. The REL851UNDBTSFIX.log will show that all the SQL statements were executed and no errors were […]

Continue reading
1

How to Cleanup PSEMHUB

There are situations when you may have the need to refresh or clean up the Environment Management Hub (PSEMHUB). Interestingly, Oracle recommends that the task to clean up the EMF should be a routine activity. Anway, hardly anyone does clean up of the PSEMHUB on a regular basis and here are some of the situations […]

Continue reading
1

This Oracle 12C Setting Can Jeopardize Your PeopleSoft Installation

Oracle Database 12C is supported with PeopleTools 8.53 but there is one feature in Oracle 12C that can jeopardize your PeopleSoft Installation. Recently while installing PeopleSoft 9.2 with PeopleTools 8.53 using Oracle 12C as database, I was struck at running initial database creation scripts like dbowner.sql and psroles.sql. Scripts weren’t creating users and roles as […]

Continue reading
5

Understanding Oracle Database and PeopleSoft Database

Some of the terms especially when it comes to database are loosely used and may cause confusion when performing a PeopleSoft installation. This post will help you revisit and understand PeopleSoft database concepts when used with Oracle database. When you perform a PeopleSoft installation, you will create these types of PeopleSoft databases: • System (also […]

Continue reading

PeopleSoft Search Framework – Part 1: Introduction

PeopleSoft Search Framework: PeopleSoft Search Framework provides a brand new way for end users to access data and navigate within PeopleSoft applications. First released in PeopleTools 8.52, PeopleSoft Search Framework works only in conjunction with Oracle SES or Oracle Secure Enterprise Search. Verity can not be used for PeopleSoft Search Framework from version 9.2 onwards. […]

Continue reading

Evolution of PS_HOME

1. PTools 8.49 and earlier – A single PS_HOME In PeopleTools 8.49.x and previous versions, there used to be a single home – PS_HOME, which contained the configuration files, source files, executables, customized code and everything else. It was just a single home for all the files delivered by PeopleSoft. With PeopleSoft 8.50.x version, we […]

Continue reading

Purge Runtime Service Operations Monitor Tables

The PeopleSoft system provides a collection of Data Mover scripts that you can run to purge the runtime Service Operations Monitor tables within a database. These scripts reside in the PS_HOME\scripts directory on your file server. There are many reasons or occasions to purge the appmessage tables, especially during an upgrade or other activities life renaming a […]

Continue reading
1

Understanding PeopleSoft Application Server Domain Parameters

This article describes all of the configuration options that are related to an application server domain. Generally, the documentation reflects the order in which the configuration sections appear in the PSADMIN interface or the PSAPPSRV.CFG file. Startup Options This section contains the database sign-in values for the application server domain to connect to the database. […]

Continue reading
1

The program can’t start because MSVCR100.dll is missing from your computer

“The program can’t start because MSVCR100.dll is missing from your computer” is quite common issue when application was writen using C++ dll and not distributed with those dll’s or installation had some issues. When you try to bring up AppDesigner in 2-tier or 3-tier mode, you might see this error. This error has been common especially […]

Continue reading

ORA-01555: snapshot too old

We were doing stress testing in PeopleSoft ELM and ran the Mass Enrollment AppEngine. After running for about 90 minutes, it failed with the error ORA-01555: snapshot too old: rollback segment number 19 with name “_SYSSMU19_1270741541$” too small The ORA-01555 error is caused by Oracle read consistency mechanism and is usually associated with long running […]

Continue reading

Common Database Errors

Common Database Errors Following is a list of known SQL errors, and potential solutions to the problems that they represent. Known Database Error Codes Database Error Code SQL State Message Solution DB2 -803 23505 SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are […]

Continue reading
1 4 5 6 7 8 10