PTWEBSERVER password change

 Below are the steps which I followed to change the PTWEBSERVER user password.

Go to target environment and check the following.

1)Login to Target database.

SQL> select name from v$database;

NAME
---------
CRM9TRN

SQL> select oprid,operpswd from psoprdefn where oprid='PTWEBSERVER';

OPRID                          OPERPSWD
------------------------------ --------------------------------
PTWEBSERVER                    u/VLDq8NsyjGZ0ulKObK1VVLAEM=



SQL> select acctlock from psoprdefn where oprid='PTWEBSERVER';

  ACCTLOCK
----------
         0

NOte: Here if the account is locked execute the below commad.

SQL>UPDATE PSOPRDEFN SET ACCTLOCK=0 WHERE OPRID='PTWEBSERVER’;

2)Take the backup of the target environment Webser files.

Go to PShome location and take the backup.
My pshome location: /psoft/TRN/PT/webserv taken webserver domain backup

and also taken confuguration.properties file backup as well.

3)Login to Datamover using sysadm uerid and password execute the below command.

update PSOPRDEFN set OPERPSWD = 'PTWEBSERVER' , ENCRYPTED = 0 where OPRID = 'PTWEBSERVER';
ENCRYPT_PASSWORD PTWEBSERVER;

4)Go the PShome<>webserver<>domainname<>piabin location.

Here will get the PSCipher.sh file and execute the below.

piaadmin@citswebbc01 piabin]$ pwd
/psoft/TRN/PT/webserv/pstrn/piabin

[piaadmin@citswebbc01 piabin]$ ./PSCipher.sh OPERPSWD(PTWEBSERVER)

the output will get new encrypted password.

5)Copy the new  encrypted password in the confuguration.properties and bounce the webserver.