Database – PeopleSoft Tutorial

Archive

Category Archives for "Database"

How to monitor connections to PeopleSoft Database

Ever wondered how many users are connected to PeopleSoft database? This is different than users who login into PeopleSoft application via web. You can find users who make direct SQL connection with your PeopleSoft database. This includes anyone using SQL client tool, PeopleSoft development tools and connections made by PeopleSoft server such as application server […]

Continue reading

Change PeopleSoft Access ID & Password in PeopleTools 8.56 & 8.55

PeopleSoft Access ID also known as Owner ID is the owner of PeopleSoft tables. In Oracle, it’s commonly used as ‘SYSADM’  and ‘sa’ for SQL server. All PeopleSoft tables belongs to this user id and this ID is created during the database creation. You may need to change password for PeopleSoft access id /owner id […]

Continue reading
5

Get Count of All PeopleSoft Tables with one SQL

While performing upgrades or applying maintenance to your PeopleSoft applications, you might want to get row count of all your PeopleSoft tables. There are few ways of doing it which we will discuss below and finally the one which I think is the easiest and most efficient way. Option 1: Running UPGCOUNT AE UPGCOUNT is […]

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
1 2 3
>