PeopleSoft Technical Tips for PS Admins

Issue was resolved by making sure that the webprofile user PTWEBSERVER is reset and encrypted using data mover script (login as sysadm). And making sure that the web profile (e.g. DEV) mentioned in configuration.properties exists in the Database (PIA: Peopletools -> webprofile -> webprofile configuration ->profile name <enter profile name> -> Press Search to find it) Data Mover Script to change password "set log c:\temp\xyz123456.log; update psoprdefn set acctlock=0 where oprid in  ('VP1'); update psoprdefn set OPERPSWD = 'Password1', encrypted = 0, acctlock=0 where oprid = 'VP1'; update psoprdefn set OPERPSWD = 'Password2', encrypted = 0, acctlock=0 where oprid = 'PTWEBSERVER'; encrypt_password *; commit;"

On PeopleSoft PT8.52 After running the AEMINITEST on PSNT process scheduler successfully and it shows as posted, the file actually exists in  E:\psreports as configured in configuration.properties (E:\psreports\FINDEV). Still it did not work. After the checking the "Enable Report Repository" and putting the value "E:\psreports", which is the location of psreports and restarted web server to resolve this issue.

While Install Oracle 12c client Install on Windows 2008 R2, I received error. Problem: While Installing Oracle 12c client 32 bit on Windows 2008 R2 64 bit server, I received the error "msvcr100 dll is missing from your computer". The resolution I found on support.oracle.com was to install/re-install Microsoft Visual C++ 2010 SP1 Redistributable, which I did (64 bit version). But was still getting the same error. The resolution: Install Oracle 12c 64 bit client on Windows 2008 R2 64 bit server. And I am able to successfully tnsping servicename.