How to Easily Create a Demo Database from a PUM Database
The topic of this article may be misleading and may make sense only to those who have found a need to create a Demo from a PUM environment. Hence, for the benefit of every one else, let elaborate first. Gone are the days when you used to create a PeopleSoft Demo database by downloading software from […]
Continue reading
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 readingChange 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
11
How to Resolve TNS-03505: Failed to resolve name
Every now and then when I created a new Oracle database in an existing Oracle base (be it 11g or 12c) – I get the error “TNS-03505: Failed to resolve name” whenever I try to do tnsping on a new database. You may receive this error even when not doing tnsping. For example, you may see […]
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