PeopleSoft Technical Tips for PS Admins

Hello World, I am writing scripts to shutdown PeopleSoft Components (Application Server, Process Scheduler & Web Server). The script will run on a particular Linux Server and will shutdown/start these components on remote servers. There is a configuration file which contains details about each component, one line for each component. Here is how it works. The script rapsststp.ksh runs on a Linux server, let us call this as server04. There is a config file rapsststp.cfg which has one line for each component, e.g. PSEnv:HCTSND:psadm:server05:HCTSND1:AS:/u01/app/psoft/pt/tools:psconfig.sh:1 PSEnv:HCTSND:psadm:server05:HCTSND:PS:/u01/app/psoft/pt/tools:psconfig_hctsnd.sh:1 Field 1 - Fixed with value PSEnv Field 2 - Name of the environment, e.g. it could be "Sand Box" Field 3 - The Linux/Unix user name Field 4 - The Server (remote server where component reside) Field 5 - Domain Name Field 6 - Directory where psconfig.sh file exists Field 7 - psconfig.sh file...

JRE Location is either invalid or not specified while Installation of Tuxedo 12 on Oracle Enterprise Linux 7.2 on Virtual Box 5.2 In the oraparam.ini  JRE_LOCATION is specified but it does not exist. Resolution: Provide correct JAVA_HOME and add to the .bashrc or your profile file. In my case I did "which java" , resulted in "/usr/bin/java" and "java -version" to confirm my java installation. Added "JAVA_HOME=/usr" to the .bashrc file and relogged into ssh ran "./runinstaller.sh"  (I got error running ./runInstaller)

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.