Skip to main content

"cmdtux_cat 1685 error" PeopleSoft PT8.52

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;"

Comments

Post a Comment

Popular posts from this blog

PeopleSoft Components Startup & Shutdown Scripts - Linux/Unix

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...
Post a Comment
Read more

JRE Location is either invalid or not specified while Installation of Tuxedo 12 on Oracle Enterprise Linux 7.2

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)
Post a Comment
Read more

"msvcr100 dll is missing from your computer" when running tnsping

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.
Post a Comment
Read more