PeopleSoft HR notes

 /opt/lib/COBOLServer6 <- Visual COBOL v 6 installation 

V1005645-01.zip 

/opt/microfocus


dbadmin / hr5809_Prod

PS/PSHRPR0D

ConnectID - people/People_123

Application Server Domain Connection Password : Passw0rd

                   Domain Password : Passw0rd 


PTWEBSERVER/People123

:/usr/opt/app/psoft/pt858/hrtestib_cfg/webserv/hrtestib/piabin>./PSCipher.sh People123

Encrypted text: {V2.1}2ZQk7UFyUA/C/rPSKa4p9iOhnHnRj9ouNQ==



Weblogic - system/Passw0rd

IB gateway  - administrator/People123

Keystore : Passw0rd

Node Passwords PSFT_EP : PSAPPSRV / Zxt4wpTM

Node Passwords PSFT_HR : PSAPPSRV / HR9PROD  HR9PR0DO


Node Passwords PSFT_HR : PSAPPSRV / Zxt4wpTM   <-- changed 2021 Nov 15th ON HRPROD

HR9PROD

NOTHING ON FSTEST 8.56 LISTENING ON FSTEST.TMW.COM  


HRTEST:  PSAPPSRV / Zxt4wpTM

HRDBUG: PSAPPSRV / Zxt4wpTM

FSPROD PSAPPSRV / Zxt4wpTM

fstest PSAPPSRV / Zxt4wpTM

hrdvlp  PSAPPSRV / Zxt4wpTM




Elastic Admin - esadmin/ES70adm

Proxy User - people/People123

psesdevapp602.tmw.com - psoft / bonjour1

psesapp602.tmw.com - psoft / bonjour1

$ES_HOME/config = /usr/opt/app/es7/pt/elasticsearch7.0.0/config

Port: 9200


signin.html  done in prod PIA and SS

header.png   done in prod PIA and SS 

CLASSPATH in setEnv.sh done in IB test and prod 


keeping delivered Tiles but would not convert classic to Tiles


SQL to confirm NODE PASSWORDS:Node Passwords PSFT_EP and PSFT_HR :   People123

FSTEST:

SQL> select MSGNODENAME, LOCALNODE, LOCALDEFAULTFLG, AUTHOPTN, IBPASSWORD from PSMSGNODEDEFN where MSGNODENAME IN ('PSFT_EP','PSFT_HR');


MSGNODENAME                     LOCALNODE L A

------------------------------ ---------- - -

IBPASSWORD

--------------------------------------------------------------------------------

PSFT_EP                                 1 Y P

K8dbKB+6vqprzhdt+D3kdLRfCRObCq7utF8JE5sKru60XwkTmwqu7rRfCRObCq7utF8JE5sKru60XwkTmwqu7g==


PSFT_HR                                 0 N P

K8dbKB+6vqprzhdt+D3kdLRfCRObCq7utF8JE5sKru60XwkTmwqu7rRfCRObCq7utF8JE5sKru60XwkTmwqu7g==


xec JSL -o ./LOGS/stdout -e ./LOGS/stderr -- -n //psfststapp601:39000



HRTEST 19:

SQL>  select MSGNODENAME, LOCALNODE, LOCALDEFAULTFLG, AUTHOPTN, IBPASSWORD from PSMSGNODEDEFN where MSGNODENAME IN ('PSFT_HR','PSFT_EP');


MSGNODENAME                     LOCALNODE L A

------------------------------ ---------- - -

IBPASSWORD

--------------------------------------------------------------------------------

PSFT_EP                                 0 N P

K8dbKB+6vqprzhdt+D3kdLRfCRObCq7utF8JE5sKru60XwkTmwqu7rRfCRObCq7utF8JE5sKru60XwkTmwqu7g==


PSFT_HR                                 1 Y P

K8dbKB+6vqprzhdt+D3kdLRfCRObCq7utF8JE5sKru60XwkTmwqu7rRfCRObCq7utF8JE5sKru60XwkTmwqu7g==


exec JSL -o ./LOGS/stdout -e ./LOGS/stderr -- -n //pshrtstapp601.tmw.com:39321 


pshrlf

sftp tmwapplf01.tmw.com


pgptstadmin

pgpadmin


alter user DRMSTAGADMIN quota unlimited on DRMSTAGDATA;

grant unlimited tablespace to DRMSTAGADMIN;


For Venkat, on new hrtest PeopleTools Options page, should we update to HRTEST and update the search string

From Venkat:

We can but it's not that critical 

as we don't use PSEMHUB to deploy files 

and Search String mostly F1 and App designer 

which not everyone use but better to go ahead and update 

Just to be consistent with web profile help url 


For Venkat: I see two rows in ps.psdbowner, do we need to cleanup ps.psdbowner after upgrade.

SQL> select * from ps.psdbowner;


DBNAME   OWNERID

-------- --------

HRPROD19 DBADMIN

HRPROD   DBADMIN



Bring up HRDBUG:pshrtstapp601

psdev      6922      1  0 Feb26 ?        00:03:36 BBL -C dom=hrdbug_239118 -g 30002 -i 0 -u pshrtstapp601.tmw.com -U /usr/opt/app/psoft/hrdbug/appserv/hrdbug/LOGS/TUXLOG -m 0 -A

psdev      7580      1  0 Feb26 ?        00:07:05 BBL -C dom=hrdbugib_171070 -g 30002 -i 0 -u pshrtstapp601.tmw.com -U /usr/opt/app/psoft/hrdbug/appserv/hrdbugib/LOGS/TUXLOG -m 0 -A



pshrtstapp602:

psdev     13471      1  0 Feb26 ?        00:04:15 BBL -C dom=hrdbug_68332 -g 30002 -i 0 -u pshrtstapp602.tmw.com -U /usr/opt/app/psoft/hrdbug/appserv/hrdbug/LOGS/TUXLOG -m 0 -A

psdev     14125      1  0 Feb26 ?        00:05:28 BBL -C dom=hrdbugib_238340 -g 30002 -i 0 -u pshrtstapp602.tmw.com -U /usr/opt/app/psoft/hrdbug/appserv/hrdbugib/LOGS/TUXLOG -m 0 -A



90 mins for stats in prod



hrprod19 query size , hrdbug 

fsprod tnsnames file need to be updated 

pre / post / rollback - get that to Veda 


Venkat - to do May 20th

- We need three process schedulers for HRPROD, we need an hrprod1 and hrprod2 DONE





set linesize 200

set pagesize 50

col username format a20

col profile format a25

col account_status format a20

select username, profile, account_status from dba_users where account_status <> 'OPEN' order by profile, username;


alter user OAK273 account unlock;

alter user ODMS55 account unlock;

alter user OJGM4  account unlock;

alter user ONCW1  account unlock;

alter user OOD6   account unlock;

alter user ORS424 account unlock;

alter user OSSP14  account unlock;


alter user DBMONTR              account unlock;

alter user DSLOADS              account unlock;

alter user EMPLOYMENT           account unlock;

alter user EPROINTERFACE        account unlock;

alter user ESBUSER              account unlock;

alter user EXPINTERFACE         account unlock;

alter user JABINTERFACE         account unlock;

alter user LASERFICHE           account unlock;

alter user PROBEADMIN           account unlock;

alter user PYGLINTERFACE        account unlock;

alter user SRVNOWADMIN          account unlock;

alter user SYS                  account unlock;

alter user HVRADMIN             account unlock;


alter user DBMONTR              lock;

alter user DSLOADS              lock;

alter user EMPLOYMENT           lock;

alter user EPROINTERFACE        lock;

alter user ESBUSER              lock;

alter user EXPINTERFACE         lock;

alter user JABINTERFACE         lock;

alter user LASERFICHE           lock;

alter user PYGLINTERFACE        lock;

alter user SRVNOWADMIN          lock;

alter user HVRADMIN             lock;

alter user SYS                  lock;

alter user PROBEADMIN           lock;



dbmontr/For_d2n32

dsloads/Znzkm6R9GRgbnXW_t

employment/empl0y_Ment

emrinterface/emr_1Nterface

eprointerface/epro_1Nterface

esbuser/cH4Zaza9   <-- in production 

expinterface/exp_1Nterface  not  exp_1Nterface2

jabinterface/jab_1Nterface

laserfiche/G05hres33_G

probeadmin/M_Z2H4xjm7fv9x8FD

pshydrmstag/usethisJan2018

pyglinterface/pygl_1Nterface

srvnowadmin/s3rv1ce_Pr0d

hvradmin/hvradmiN_1

sys/eHmPj2VyFaP_y

dbsnmp/ax39CCnVmyz6QAr_x

dbadmin/hr5809_Prod

PSBATCH/ Zxt4wpTM

PSAPPSERV / Zxt4wpTM

PTWEBSERVER

PSSEARCH/ People_123  - for HR

PSSEARCH/ PEOPLE123  - for FS

ES_DEPLOY / Depl0y   - for developers to deploy elastic search 



SQL> connect sys/eHmPj2VyFaP_y as sysdba

Connected.

SQL> alter user sys identified by eHmPj2VyFaP_y account unlock;


User altered.


SQL>  alter user sys identified by eHmPj2VyFaP_y account unlock;


User altered.


SQL> select username, profile, account_status from dba_users where account_status <> 'OPEN' order by profile, username;


expdp parfile=/usr/local/oracle/expdp_schema.par

Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:

  /usr/opt/app/dbdump/export/hrprod01.dmp

  /usr/opt/app/dbdump/export/hrprod02.dmp

  /usr/opt/app/dbdump/export/hrprod03.dmp

  /usr/opt/app/dbdump/export/hrprod04.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue May 25 14:16:59 2021 elapsed 0 00:37:25


time to export dbadmin / ps / esbuser = 38 mins 

oracle-pshrdb601.tmw.com::/usr/opt/app/dbdump/export>scp hrprod.2021May20* oracle@pshrdb602:/usr/opt/app/dbdump/export

hrprod.2021May20_225001.dmp                                                               100%   10GB  73.6MB/s   02:20

hrprod.2021May20_225002.dmp                                                               100%   13GB  73.7MB/s   03:03

hrprod.2021May20_225003.dmp                                                               100%   13GB  85.6MB/s   02:39

hrprod.2021May20_225004.dmp                                                               100% 5267MB  79.8MB/s   01:06

hrprod.2021May20_2250.log                                                                 100% 3626KB  44.8MB/s   00:00

                                                                                                                   7 minutes 


Time for RMAN backup = 1 hour 

oracle-pshrdb601.tmw.com::/usr/opt/app/dbdump/hot_backup/hrprod>scp * oracle@pshrtstdb601:/usr/opt/app/dbdump/hot_backup/hrprod

HRPROD_ARC_T20210520_s90684_p1_1073082459.bak                                                                  100%  180MB  27.2MB/s   00:06

HRPROD_ARC_T20210520_s90685_p1_1073082459.bak                                                                  100%  207MB  29.6MB/s   00:07

HRPROD_ARC_T20210521_s90688_p1_1073122226.bak                                                                  100% 1063MB  29.5MB/s   00:36

HRPROD_ARC_T20210521_s90689_p1_1073122226.bak                                                                  100% 1067MB  29.4MB/s   00:36

HRPROD_AutoCTL_c-3413199007-20210520-01.bak                                                                  100%   47MB  29.0MB/s   00:01

HRPROD_AutoCTL_c-3413199007-20210521-00.bak                                                                  100%   47MB  28.9MB/s   00:01

HRPROD_Inc0_T20210520_s90639_p1_1073079076.bak                                                                  100% 9496MB  29.9MB/s   05:18

HRPROD_Inc0_T20210520_s90640_p1_1073079076.bak                                                                  100%   10GB  28.7MB/s   05:59

HRPROD_Inc0_T20210520_s90641_p1_1073079076.bak                                                                  100% 7875MB  28.5MB/s   04:35

HRPROD_Inc0_T20210520_s90642_p1_1073079076.bak                                                                  100%   11GB  29.0MB/s   06:11

HRPROD_Inc0_T20210520_s90643_p1_1073080252.bak                                                                  100%   11GB  29.6MB/s   06:25

HRPROD_Inc0_T20210520_s90644_p1_1073080448.bak                                                                  100% 9607MB  30.0MB/s   05:20

HRPROD_Inc0_T20210520_s90645_p1_1073080448.bak                                                                  100% 8025MB  30.1MB/s   04:26

HRPROD_Inc0_T20210520_s90646_p1_1073080563.bak                                                                  100% 1954MB  30.1MB/s   01:04

HRPROD_Inc0_T20210520_s90647_p1_1073080839.bak                                                                  100% 2176MB  30.0MB/s   01:12

HRPROD_Inc0_T20210520_s90648_p1_1073081184.bak                                                                  100% 2174MB  29.9MB/s   01:12

HRPROD_Inc0_T20210520_s90649_p1_1073081459.bak                                                                  100% 2112MB  30.0MB/s   01:10

HRPROD_Inc0_T20210520_s90650_p1_1073081505.bak                                                                  100% 2117MB  30.2MB/s   01:10

HRPROD_Inc0_T20210520_s90651_p1_1073081700.bak                                                                  100% 1369MB  30.0MB/s   00:45

HRPROD_Inc0_T20210520_s90652_p1_1073081785.bak                                                                  100% 1633MB  30.0MB/s   00:54

HRPROD_Inc0_T20210520_s90653_p1_1073081786.bak                                                                  100% 2179MB  30.3MB/s   01:12

HRPROD_Inc0_T20210520_s90654_p1_1073081872.bak                                                                  100% 1636MB  30.4MB/s   00:53

HRPROD_Inc0_T20210520_s90655_p1_1073081879.bak                                                                  100% 1463MB  30.2MB/s   00:48

HRPROD_Inc0_T20210520_s90656_p1_1073082036.bak                                                                  100% 1213MB  30.0MB/s   00:40

HRPROD_Inc0_T20210520_s90657_p1_1073082101.bak                                                                  100% 1231MB  29.7MB/s   00:41

HRPROD_Inc0_T20210520_s90658_p1_1073082116.bak                                                                  100% 1246MB  28.7MB/s   00:43

HRPROD_Inc0_T20210520_s90659_p1_1073082141.bak                                                                  100% 1440MB  29.2MB/s   00:49

HRPROD_Inc0_T20210520_s90660_p1_1073082207.bak                                                                  100% 1254MB  30.6MB/s   00:41

HRPROD_Inc0_T20210520_s90661_p1_1073082242.bak                                                                  100% 1232MB  30.5MB/s   00:40

HRPROD_Inc0_T20210520_s90662_p1_1073082267.bak                                                                  100%  641MB  30.5MB/s   00:21

HRPROD_Inc0_T20210520_s90663_p1_1073082312.bak                                                                  100%  488MB  30.1MB/s   00:16

HRPROD_Inc0_T20210520_s90664_p1_1073082357.bak                                                                  100%  694MB  30.7MB/s   00:22

HRPROD_Inc0_T20210520_s90665_p1_1073082373.bak                                                                  100%  278MB  29.3MB/s   00:09

HRPROD_Inc0_T20210520_s90666_p1_1073082388.bak                                                                  100%   11MB  28.3MB/s   00:00

HRPROD_Inc0_T20210520_s90667_p1_1073082391.bak                                                                  100% 1616KB  19.6MB/s   00:00

HRPROD_Inc0_T20210520_s90668_p1_1073082391.bak                                                                  100% 1568KB  19.8MB/s   00:00

HRPROD_Inc0_T20210520_s90669_p1_1073082393.bak                                                                  100% 1056KB  17.4MB/s   00:00

HRPROD_Inc0_T20210520_s90670_p1_1073082393.bak                                                                  100% 1064KB  16.8MB/s   00:00

HRPROD_Inc0_T20210520_s90671_p1_1073082394.bak                                                                  100% 1176KB  17.5MB/s   00:00

HRPROD_Inc0_T20210520_s90672_p1_1073082394.bak                                                                  100% 1344KB  19.4MB/s   00:00

HRPROD_Inc0_T20210520_s90673_p1_1073082395.bak                                                                  100% 1888KB  20.2MB/s   00:00

HRPROD_Inc0_T20210520_s90674_p1_1073082396.bak                                                                  100%   12MB  28.4MB/s   00:00

HRPROD_Inc0_T20210520_s90675_p1_1073082397.bak                                                                  100% 6152KB  26.8MB/s   00:00

HRPROD_Inc0_T20210520_s90676_p1_1073082398.bak                                                                  100% 5112KB  25.6MB/s   00:00

HRPROD_Inc0_T20210520_s90677_p1_1073082398.bak                                                                  100% 3208KB  24.0MB/s   00:00

HRPROD_Inc0_T20210520_s90678_p1_1073082399.bak                                                                  100% 1688KB  20.4MB/s   00:00

HRPROD_Inc0_T20210520_s90679_p1_1073082400.bak                                                                  100% 1528KB  18.7MB/s   00:00

HRPROD_Inc0_T20210520_s90680_p1_1073082401.bak                                                                  100% 1072KB  18.4MB/s   00:00

HRPROD_Inc0_T20210520_s90681_p1_1073082401.bak                                                                  100% 2448KB  22.3MB/s   00:00

HRPROD_Inc0_T20210520_s90682_p1_1073082402.bak                                                                  100% 1168KB  16.9MB/s   00:00

HRPROD_Inc0_T20210520_s90683_p1_1073082402.bak                                                                  100% 3248KB  24.1MB/s   00:00

you have mail in /var/spool/mail/oracle

                                                                                                                                        30 mins to transfer these files 



oracle-pshrdb601.tmw.com:hrprod:/usr/opt/app/oracle/orahome>rman target / catalog hrprod/bkup_123@rmprod auxiliary sys/Ysw8PTgJ@hrdbug

Recovery Manager: Release 12.1.0.2.0 - Production on Fri May 21 13:26:24 2021   <--- started 1.26pm

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


oracle-pshrdb601.tmw.com:hrprod:/usr/opt/app/oracle/orahome>ls -lrt /usr/local/oracle/restoreHrdbugMay21st.txt

-rw-r--r-- 1 oracle dba 185849 May 21 18:06 /usr/local/oracle/restoreHrdbugMay21st.txt  <-- completed at 6.06pm

                                                                             time for RMAN restore  7 hours including pre and post work  





08:33:39 SQL> drop user dbadmin cascade;  5 hours

User dropped.

Elapsed: 04:57:25.26




oracle-pshrdb602.tmw.com:hrprod:/usr/local/oracle>impdp parfile=impdp_schema.par

Import: Release 19.0.0.0.0 - Production on Fri May 21 16:36:47 2021                <-- import started at 4.36pm

Version 19.11.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production



                        at Fri May 21 22:00:11 2021 elapsed 0 05:23:21             <-- completed at 10pm

                                                            time for import is 6 hours including pre and post work  




Stats 2 hours 




APP_HOME/src

CUST_HOME


nothing going to PS_CFG_HOME

weblogic - 8.58.09 8.58.11





server name for craig

backups Fong


sshprod - 172.31.102.50

sshrdbug - 172.31.107.35


Kris - 2pm   KN93 is oncall for unix team on go-live



SQL> exec DBMS_STATS.GATHER_SCHEMA_STATS('DBADMIN');  <-- cron job this




create ticket for Liezel  




    https://pshrws601.tmw.com:20743/hc/index.html  to check each webserver bypassing the load balancer, it is showing 2022

SSL password is Passw0rd for tmw.jks

​dba_sys_privs


which file has the port number on webserver. 


On HRDBUG on pshrtstdb601 , need to add that table

QL> select count(*) from dbadmin.PS_GL_EXP_PDVW_TMW;


  COUNT(*)

----------

    200863




psoft-pshrapp601.tmw.com:hrprod19:/usr/opt/app/psoft/psofthome>ps -ef | grep BBL

psoft     13300      1  0 May26 ?        00:03:07 BBL -C dom=HRPROD19_160392 -g 30002 -i 0 -u pshrapp601.tmw.com -U /usr/opt/app/psoft/pt858/hrprod_cfg/appserv/sshrprod/LOGS/TUXLOG -m 0 -A

psoft     60344      1  0 May25 ?        00:03:23 BBL -C dom=HRPROD19_172687 -g 30002 -i 0 -u pshrapp601.tmw.com -U /usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/LOGS/TUXLOG -m 0 -A

psoft     61167      1  0 May25 ?        00:04:41 BBL -C dom=HRPRODIB19_185009 -g 30002 -i 0 -u pshrapp601.tmw.com -U /usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprodib/LOGS/TUXLOG -m 0 -A




psoft-pshrps601.tmw.com:hrprod19:/usr/opt/app/psoft/psofthome>ps -ef | grep BBL

psoft     99340      1  0 May25 ?        00:01:38 BBL -C dom=PSUNX_76110 -g 30002 -i 0 -u pshrps601.tmw.com -U /usr/opt/app/psoft/pt858/hrprod_cfg/appserv/prcs/hrprod/LOGS/TUXLOG -m 0 -A

psoft     99584      1  0 May25 ?        00:01:37 BBL -C dom=PSUNX1_127827 -g 30002 -i 0 -u pshrps601.tmw.com -U /usr/opt/app/psoft/pt858/hrprod_cfg/appserv/prcs/hrprod1/LOGS/TUXLOG -m 0 -A

psoft     99979      1  0 May25 ?        00:01:37 BBL -C dom=PSUNX2_73168 -g 30002 -i 0 -u pshrps601.tmw.com -U /usr/opt/app/psoft/pt858/hrprod_cfg/appserv/prcs/hrprod2/LOGS/TUXLOG -m 0 -A


psoft-pshrws601.tmw.com:hrprod858:/usr/opt/app/psoft/psofthome>ps -ef | grep pt858

psoft     18612      1  0 May25 ?        01:30:11 java -server -Xms2048m -Xmx2048m -Dtoplink.xml.platform=oracle.toplink.platform.xml.jaxp.JAXPPlatform -Dcom.sun.xml.namespace.QName.useCompatibleSerialVersionUID=1.0 -Dweblogic.Chunksize=65536 -Djava.util.logging.config.file=/usr/opt/app/psoft/pt858/hrprodib_cfg/webserv/hrprodib/piaconfig/properties/logging.properties -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Dweblogic.Name=PIA -Dps_vault=/usr/opt/app/psoft/pt858/hrprodib_cfg/webserv/hrprodib/piaconfig/properties/psvault -Djavax.net.ssl.trustStore=/usr/opt/app/psoft/pt858/hrprodib_cfg/webserv/hrprodib/security/tmw.jks -Dweblogic.security.SSL.minimumProtocolVersion=TLSv1.2 -Djdk.tls.client.protocols=TLSv1.2 -Dhttps.protocols=TLSv1.2 -Dweblogic.ProductionModeEnabled=true -Djava.security.policy=/usr/opt/app/middleware/weblogic/wlserver/server/lib/weblogic.policy -Dssl.debug=false -Dps_home=/usr/opt/app/psoft/pt858/hrprod_pt85809 weblogic.Server

psoft     18904      1  0 May25 ?        01:35:02 java -server -Xms4096m -Xmx4096m -Dtoplink.xml.platform=oracle.toplink.platform.xml.jaxp.JAXPPlatform -Dcom.sun.xml.namespace.QName.useCompatibleSerialVersionUID=1.0 -Dweblogic.Chunksize=65536 -Djava.util.logging.config.file=/usr/opt/app/psoft/pt858/hrprod_cfg/webserv/hrprod/piaconfig/properties/logging.properties -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Dweblogic.Name=PIA -Dps_vault=/usr/opt/app/psoft/pt858/hrprod_cfg/webserv/hrprod/piaconfig/properties/psvault -Djavax.net.ssl.trustStore=/usr/opt/app/psoft/pt858/hrprod_cfg/webserv/hrprod/security/tmw.jks -Dweblogic.security.SSL.minimumProtocolVersion=TLSv1.2 -Djdk.tls.client.protocols=TLSv1.2 -Dhttps.protocols=TLSv1.2 -Dweblogic.ProductionModeEnabled=true -Djava.security.policy=/usr/opt/app/middleware/weblogic/wlserver/server/lib/weblogic.policy -Dssl.debug=false -Dps_home=/usr/opt/app/psoft/pt858/hrprod_pt85809 weblogic.Server

psoft     47270      1  0 Apr26 ?        03:55:07 java -server -Xms4096m -Xmx4096m -Dtoplink.xml.platform=oracle.toplink.platform.xml.jaxp.JAXPPlatform -Dcom.sun.xml.namespace.QName.useCompatibleSerialVersionUID=1.0 -Dweblogic.Chunksize=65536 -Djava.util.logging.config.file=/usr/opt/app/psoft/pt858/sshrprod_cfg/webserv/sshrprod/piaconfig/properties/logging.properties -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Dweblogic.Name=PIA -Dps_vault=/usr/opt/app/psoft/pt858/sshrprod_cfg/webserv/sshrprod/piaconfig/properties/psvault -Djavax.net.ssl.trustStore=/usr/opt/app/psoft/pt858/sshrprod_cfg/webserv/sshrprod/security/tmw.jks -Dweblogic.security.SSL.minimumProtocolVersion=TLSv1.2 -Djdk.tls.client.protocols=TLSv1.2 -Dhttps.protocols=TLSv1.2 -Dweblogic.ProductionModeEnabled=true -Djava.security.policy=/usr/opt/app/middleware/weblogic/wlserver/server/lib/weblogic.policy -Dssl.debug=false -Dps_home=/usr/opt/app/psoft/pt858/hrprod_pt85809 weblogic.Server



psdev-pshrtstapp601.tmw.com:hrdbug:/usr/opt/app/psoft/psofthome>ps -ef | grep BBL | grep dbug

psdev     27077      1  0 May28 ?        00:03:52 BBL -C dom=hrdbug_102766 -g 30002 -i 0 -u pshrtstapp601.tmw.com -U /usr/opt/app/psoft/hrdbug/appserv/hrdbug/LOGS/TUXLOG -m 0 -A

psdev     94681      1  0 May25 ?        00:07:11 BBL -C dom=hrdbugib_171070 -g 30002 -i 0 -u pshrtstapp601.tmw.com -U /usr/opt/app/psoft/hrdbug/appserv/hrdbugib/LOGS/TUXLOG -m 0 -A



psdev-pshrtstapp602.tmw.com:hrdbug:/usr/opt/app/psoft/psofthome>ps -ef | grep BBL | grep dbug

psdev     36057      1  0 May28 ?        00:04:50 BBL -C dom=hrdbug_189844 -g 30002 -i 0 -u pshrtstapp602.tmw.com -U /usr/opt/app/psoft/hrdbug/appserv/hrdbug/LOGS/TUXLOG -m 0 -A

psdev    125410      1  0 May25 ?        00:07:23 BBL -C dom=hrdbugib_238340 -g 30002 -i 0 -u pshrtstapp602.tmw.com -U /usr/opt/app/psoft/hrdbug/appserv/hrdbugib/LOGS/TUXLOG -m 0 -A

psdev-pshrtstapp602.tmw.com:hrdbug:/usr/opt/app/psoft/psofthome>


psdev-pshrtstps601:hrdbug:/usr/opt/app/psoft/psofthome>ps -ef | grep BBL | grep dbug

psdev    125944      1  0 May25 ?        00:02:36 BBL -C dom=PSUNX_209594 -g 30002 -i 0 -u pshrtstps601 -U /usr/opt/app/psoft/hrdbug/appserv/prcs/hrdbug/LOGS/TUXLOG -m 0 -A



oracle-pshrdb601.tmw.com:hrprod:/usr/local/oracle>sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Thu Jun 10 14:04:33 2021


Copyright (c) 1982, 2014, Oracle.  All rights reserved.



Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production


SQL> @LockAllUsers.sql


13117 rows updated.


SQL> commit;


Commit complete.





alter user DBMONTR             account lock;

alter user DSLOADS             account lock;

alter user EMPLOYMENT          account lock;

alter user EPROINTERFACE       account lock;

alter user ESBUSER             account lock;

alter user EXPINTERFACE        account lock;

alter user JABINTERFACE        account lock;

alter user LASERFICHE          account lock;

alter user PYGLINTERFACE       account lock;

alter user SRVNOWADMIN         account lock;

alter user HVRADMIN            account lock;




16:15:42 SQL> @RowCounts_AfterUserReports_601.sql

table name: RWCNTS_BEFORE_UPGRADE

host: pshrdb601

owner: dbadmin

Elapsed: 00:09:42.26

16:25:32 SQL> select count(*) from RWCNTS_BEFORE_UPGRADE;


  COUNT(*)

----------

     46973


10    DATABASE LINK

1    FUNCTION

57493    INDEX

3603    LOB

6    MATERIALIZED VIEW

98    SYNONYM

46974    TABLE

6    TRIGGER

26470    VIEW




From pshrdb601:

Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:

  /usr/opt/app/dbdump/export/hrprod01.dmp

  /usr/opt/app/dbdump/export/hrprod02.dmp

  /usr/opt/app/dbdump/export/hrprod03.dmp

  /usr/opt/app/dbdump/export/hrprod04.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Thu Jun 10 16:51:22 2021 elapsed 0 00:37:30



rw-r----- 1 oracle dba 12404502528 Jun 10 16:51 hrprod02.dmp

-rw-r----- 1 oracle dba 10854572032 Jun 10 16:51 hrprod01.dmp

-rw-r----- 1 oracle dba  7954669568 Jun 10 16:51 hrprod04.dmp

-rw-r----- 1 oracle dba 13639634944 Jun 10 16:51 hrprod03.dmp

-rw-r--r-- 1 oracle dba     3713380 Jun 10 16:51 hrprod.log



  select count(*), object_type from dba_objects  where owner = 'DBADMIN'  group by object_type;

  

  

  HRDBUG RMAN duplication completed at 11.05pm

  

  sysman

  oms_l0ginit

Web URL: https://oem13db601.tmw.com:7803/em/faces/logon/core-uifwk-console-login




SQL> @/usr/local/oracle/RowCounts_AfterImport_602.sql

SQL> set time on

01:13:15 SQL> set timing on

01:13:15 SQL> create table RWCNTS_AFTER_IMPORT as select /*+ NO_INDEX */ table_name, get_rows( user||'.'||table_name) row_count from user_tables order by table_name;

table name: RWCNTS_AFTER_IMPORT

host: pshrdb602

owner: dbadmin

Elapsed: 00:24:16.07

01:37:31 SQL> select count(*) from RWCNTS_AFTER_IMPORT;


  COUNT(*)

----------

     46974


The following is for snapshot backup:

SQL> alter system switch logfile;


System altered.


SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0



https://sshrtest.tmw.com/psp/sshrtest/?cmd=login&languageCd=ENG&



snapshot at 2.53pm on Friday  AfterPTUpgrade


hrprodib  172.31.102.43:21843 


>nslookup 172.31.102.43

pshrws601.tmw.com


>nslookup 172.31.102.44

pshrws602.tmw.com.


./psoft/domain/webserv/domain/applications/peoplesoft/PORTAL.war/lb-ping.html


sshrprod --> sshrprod92.tmw.com (172.31.102.50)


port 80 on LB should route traffic to 21980 on pool members

port 443 on LB should route traffic to 21943 on pool members



hrprod   --> hrprod92.tmw.com (172.31.102.45)

port 80 on LB should route traffic to 21780 on pool members

port 443 on LB should route traffic to 21743 on pool members


 

hrprodib --> hrprod92ib.tmw.com (172.31.102.46

port 80 on LB should route traffic to 21880 on pool members

port 443 on LB should route traffic to 21843 on pool members


 


Name:   pshrws601.tmw.com

Address: 172.31.102.43


 


 


Name:   pshrws602.tmw.com

Address: 172.31.102.44



 SSH authentication methods available: publickey

* Using SSH public key file '/usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/sshkeys/public/id_rsa.pub'

* Using SSH private key file '/usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/sshkeys/private/id_rsa'

* SSH public key authentication failed: Unable to open public key file

* Authentication failure


psoft-pshrapp601.tmw.com:hrprod:/usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/LOGS>ls -lrt /usr/opt/app/psoft/hrprod/appserv/hrprod/sshkeys/public/

total 8

-rw-r----- 1 psoft staff 397 Jan 30  2018 id_rsa.pub

-rw-r----- 1 psoft staff 406 Jul 12  2018 lf_id_rsa.pub


psoft-pshrapp601.tmw.com:hrprod:/usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/LOGS>ls -lrt /usr/opt/app/psoft/hrprod/appserv/hrprod/sshkeys/private

total 8

-rw------- 1 psoft staff 1675 Jan 30  2018 id_rsa

-rw------- 1 psoft staff 1671 Jul 12  2018 lf_id_rsa



* Using SSH public key file '/usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/sshkeys/public/id_rsa.pub'

* Using SSH private key file '/usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/sshkeys/private/id_rsa'


psoft-pshrapp601.tmw.com:hrprod:/usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/LOGS>ls -lrt /usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/sshkeys/public/id_rsa.pub

-rw-r----- 1 psoft staff 397 Jun 15 08:47 /usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/sshkeys/public/id_rsa.pub

psoft-pshrapp601.tmw.com:hrprod:/usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/LOGS>ls -lrt /usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/sshkeys/private/id_rsa

-rw------- 1 psoft staff 1675 Jun 15 08:47 /usr/opt/app/psoft/pt858/hrprod_cfg/appserv/hrprod/sshkeys/private/id_rsa




---------------------------------------------

PeopleSoft PIA Administration - Create Domain

---------------------------------------------


  PIA Home:   /usr/opt/app/psoft/pt858/hrdvlp_cfg


  1)  Domain name                   :[hrdvlp]

  2)  Web server                    :[weblogic]

  3)  Web server root directory     :[/usr/opt/app/middleware/weblogic]

  4)  Web server login id           :[system]

  5)  Web server password           :[*****]

  6)  Website name                  :[hrdvlp]

  7)  Application server            :[pshrtstapp602]

  8)  JSL Port                      :[69700]

  9)  HTTP Port                     :[21080]

  10) HTTPS Port                    :[21043]

  11) Authentication Token Domain   :[.tmw.com]

  12) Web profile                   :[TEST]

  13) Web profile user id           :[PTWEBSERVER]

  14) Web profile password          :[*****]

  15) Integration Gateway Id        :[administrator]

  16) Integration Gateway Password  :[*****]

  17) AppServer Connection Password :[*****]

  18) SSL Keystore Password         :[*****]

  19) PeopleSoft reports directory  :[/usr/opt/app/psoft/psreports]


  c) Create the domain as shown

  q) Quit




oracle-pshrtstapp602.tmw.com:client:/usr/opt/app/oracle/orahome>ps -ef | grep BBL | grep -i hrdvlp

psdev     12405      1  0 Feb26 ?        00:38:10 BBL -C dom=hrdvlpib_100387 -g 30002 -i 0 -u pshrtstapp602.tmw.com -U /usr/opt/app/psoft/hrdvlp/appserv/hrdvlpib/LOGS/TUXLOG -m 0 -A

psdev     31648      1  0 Apr08 ?        00:21:08 BBL -C dom=hrdvlp_98163 -g 30002 -i 0 -u pshrtstapp602.tmw.com -U /usr/opt/app/psoft/hrdvlp/appserv/hrdvlp/LOGS/TUXLOG -m 0 -A


psdev-pshrtstps601:hrdvlp858:/usr/opt/app/psoft/pt858/hrdvlpcust/sqr>ps -ef | grep BBL | grep -i hrdvlp

psdev     13222      1  0 Feb26 ?        00:18:05 BBL -C dom=PSUNX_192066 -g 30002 -i 0 -u pshrtstps601 -U /usr/opt/app/psoft/hrdvlp/appserv/prcs/hrdvlp/LOGS/TUXLOG -m 0 -A

psdev     13574      1  0 Feb26 ?        00:18:04 BBL -C dom=PSUNX2_135634 -g 30002 -i 0 -u pshrtstps601 -U /usr/opt/app/psoft/hrdvlp/appserv/prcs/hrdvlp2/LOGS/TUXLOG -m 0 -A




psdev-pshrtstapp601.tmw.com:hrdvlp858:/usr/opt/app/psoft/pt858/hrdvlpcust>ps -ef | grep BBL | grep -i hrdvlp

psdev      6290      1  0 Feb26 ?        00:42:00 BBL -C dom=hrdvlpib_81189 -g 30002 -i 0 -u pshrtstapp601.tmw.com -U /usr/opt/app/psoft/hrdvlp/appserv/hrdvlpib/LOGS/TUXLOG -m 0 -A

psdev     57153      1  0 Apr08 ?        00:23:10 BBL -C dom=hrdvlp_195021 -g 30002 -i 0 -u pshrtstapp601.tmw.com -U /usr/opt/app/psoft/hrdvlp/appserv/hrdvlp/LOGS/TUXLOG -m 0 -A

psdev-pshrtstapp601.tmw.com:hrdvlp858:/usr/opt/app/psoft/pt858/hrdvlpcust>




Passw0rd

PSAPPSRV passwords for HCM : HR9PROD    but on HRPROD it is Zxt4wpTM

FSCM : Zxt4wpTM

Domain Connection Password : Passw0rd

both HCM and FSCM

Gateway Administrator : People123

[1/22 12:59 PM] Murugappan, Gillian  (GM15)

    i am in the console and on the KEYSTORE tab

​[1/22 12:59 PM] Murugappan, Gillian  (GM15)

    do I need to give it a passphrase?

​[1/22 12:59 PM] Gorantla, Naveen  (NG91)

    yes

​[1/22 12:59 PM] Murugappan, Gillian  (GM15)

    oh

​[1/22 12:59 PM] Gorantla, Naveen  (NG91)

    can you share your screen

​[1/22 12:59 PM] Gorantla, Naveen  (NG91)

    ?

​[1/22 12:59 PM] Murugappan, Gillian  (GM15)

    yes

​[1/22 1:03 PM] Gorantla, Naveen  (NG91)

    Passw0rd


https://pshrws601.tmw.com:20743/hc/index.html



O:\hrdvlp\Config  for citrix BAT scripts 



people / People_123


1 user

why named user


People_123  hrtest hrdbug hdrvlp hrprod - 



$DB_NAME

htest19_ py hrtest19_ bn hrtest19_tl  hrtest19_resume   hrtest19_bnmgr  hrtest19_hrmgr hrtest19_applicant  hrtest19_ats  

hrtest19_msp  hrtest19_pymgr  unix_migration


modify unix_migration for  hrtest19


tmwsqltst109  KABA test sqlserver database

tmwsqldb702 - Laserfiche , no test server

lasrfiche appserver - tmwappLF01, hrtest_py hrtest_hr/ hrprod_py hrprod_hr


Taleo - UC4 jobs on regular intervals , every 15 mins or so  applicant tracking Nathan / Nitti


DRM database / Karen or Rick from Madhav's team to verify the database


employee feed to various applications to active omni / DOM / KABA  - alias name or hostname


pshrtstdbprmy - hostname , change alias 

Senthil will discuss with active omni re testing


dumps 


HRTEST 

sys - cZQwV3EqQy9K_M

system - EM22sdEnxkhA_B


HRDVLP

sys - cZQwV3EqQy9K_M

system - EM22sdEnxkhA_B


HRDBUG

sys - cZQwV3EqQy9K_M

system - EM22sdEnxkhA_B



ConnectID - people/People_123

Application Server Domain Connection Password : Passw0rd

PTWEBSERVER/People123

Weblogic - system/Passw0rd

IB gateway  - administrator/People123

Keystore : Passw0rd


Elastic Admin - esadmin/ES70adm

Proxy User - people/People123



HRDBUG  IB gateway  - administrator/password





HRDBUG:

lrwxrwxrwx 1 oracle dba   28 May  1  2018 temp01 -> /rd301/oradata/hrdbug/temp01

lrwxrwxrwx 1 oracle dba   28 May  1  2018 undo01 -> /rd301/oradata/hrdbug/undo01

lrwxrwxrwx 1 oracle dba   28 May  1  2018 redo01 -> /rd301/oradata/hrdbug/redo01

lrwxrwxrwx 1 oracle dba   26 May  1  2018 arch -> /rd410/oradata/hrdbug/arch

lrwxrwxrwx 1 oracle dba   29 May  1  2018 flash01 -> /rd410/oradata/hrdbug/flash01

lrwxrwxrwx 1 oracle dba   27 May  1  2018 ext01 -> /rd410/oradata/hrdbug/ext01

lrwxrwxrwx 1 oracle dba   25 May  1  2018 xdb_wallet -> /rd410/oradata/hrdbug/xdb

lrwxrwxrwx 1 oracle dba   37 May  1  2018 rman_dir -> /usr/opt/app/dbdump/hot_backup/hrdbug

drwxr-xr-x 2 oracle dba   20 May  1  2018 dpdump

drwxr-xr-x 2 oracle dba 4096 May  1  2018 scripts

lrwxrwxrwx 1 oracle dba   28 May  3  2018 data01 -> /rd100/oradata/hrdbug/data01

lrwxrwxrwx 1 oracle dba   30 Jul  8  2018 system01 -> /rd400/oradata/hrdbug/system01

lrwxrwxrwx 1 oracle dba   27 Aug 24  2018 ndx01 -> /rd200/oradata/hrdbug/ndx01

drwxr-xr-x 2 oracle dba   52 Dec  4  2020 pfile

drwxr-xr-x 2 oracle dba 4096 Jul  7 12:45 adump

oracle-pshrtstdb601::/usr/opt/app/oracle/admin/hrdbug>







pshrtstdb601 oracle 12

/rd910

/rd110

/rd210

/rd120

/rd220 

/rd302   

/rd420   


12CPU --> 4 CPU

96GB  --> 48 GB  RMAN

      3228GB = 3.2TB

      

      

pshrdb601  oracle 12



2021 Nov 3rd 

hrdbugib    http://pshrtstws601.tmw.com:20680 

          https://pshrtstws601.tmw.com:20643 

          https://pshrtstws602.tmw.com:20643/ 

          http://pshrtstws602.tmw.com:20680/ 



https://pshrtstws601.tmw.com:21043/   <-- hrdvlp 



URL for HRDVLP:


https://pshrtstws601.tmw.com:21043

Node Passwords PSFT_HR : PSAPPSRV / HR9PROD  on hrdvlp 



https://pshrtstws602.tmw.com:20643/PSIGW/PeopleSoftListeningConnector  on hrdbug on 2022 Oct 21st

administrator/password for gateway properties


//psfststapp601.tmw.com:21245   before I changed to //psfststapp602:49000 on hrdbug on PeopleSoft Node Configuration page 


2023 Feb 20th 

Elastic Admin - esadmin/Es710adm

Proxy User - people/People123

pseshrdevapp602.tmw.com - psoft / b0nsoir123

$ES_HOME/config = /usr/opt/app/es7/pt/elasticsearch7.10.0/config

ES Port: 9200

http://pseshrdevapp602.tmw.com:9200


$KB_HOME/config = /usr/opt/app/es7/pt/Kibana7.10.0/config

KB Port: 5601

http://pseshrdevapp602.tmw.com:5601   <-- but only works through PIA 






psoft-pshrps601.tmw.com:hrprod:/usr/opt/app/psoft/pt858/hrprod_cfg/appserv/prcs/hrprod/sshkeys/private>sftp -i id_rsa psftptiv10@tfsuxp02.adp.com

Use your assigned file naming convention for uploading files

Connected to tfsuxp02.adp.com.

sftp> ls

DONE      ERROR     INBOUND   OUTBOUND

sftp> ls -lrt

drw-------   1 0        0           16384 Feb 28  2020 DONE

drw-------   1 0        0           16384 Feb 28  2020 ERROR

drw-------   1 0        0           16384 Mar 06 12:30 OUTBOUND

drw-------   1 0        0           16384 Mar 06 12:32 INBOUND

sftp> cd OUTBOUND

sftp> ls

tiv103012023.grn.pgp   tiv103032023.grn.pgp

sftp> ls -lrt

-rw-------   1 0        0            1658 Mar 01 15:29 tiv103012023.grn.pgp

-rw-------   1 0        0            1321 Mar 03 10:08 tiv103032023.grn.pgp

sftp> cd ..

sftp> cd INBOUND

sftp> ls -lrt

sftp> exit





Tools 8.60.04

HRCNV1 URL:

https://pshrtstws602.tmw.com:21443/


IB  screenshots to get 

Citrix

put the menu back - document how to change the menu  DONE 


sigin.html - change lowercase to  uppercase

get an SVG file to upload OracleLogo.svg

branding is delivered and get use to it


unix migration 





Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.16.0.0.0

[oracle2@pshrpum601 ~]$ expdp "sys/HR92U045g#@HR92U045" directory=data_pump_dir_tmw dumpfile=sysadm.dmp schemas=sysadm


Export: Release 19.0.0.0.0 - Production on Tue Mar 21 17:32:49 2023

Version 19.16.0.0.0


Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


UDE-28009: operation generated ORACLE error 28009

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER


Username: sys/HR92U045g#@HR92U045 as sysdba


Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Starting "SYS"."SYS_EXPORT_SCHEMA_01":  sys/********@HR92U045 AS SYSDBA directory=data_pump_dir_tmw dumpfile=sysadm.dmp schemas=sysadm

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA






For Mobile email approval, we have to continue to use IMAP4/993 port per SR 3-32439928721

PIA account with email address to conect with Azure

EOAWEMC app engine 



From Oracle.

While Okta is a supported OAUTH2 provider, MS Azure is the only OAUTH2 provider currently supporting email.

Azure app name: PeopleSoft Email Retrieval-Test

userid: psmobilehrtest@tmw.com  / x7h9'\VZ"EA%2q:&     

Port 995 to confirm with Terry


PSFT_EMC_GETMAIL Node being used

MCF_MAIL MCF Server 

PEOPLESOFT EMAIL RETREIVAL-TEST  - name of app in Azure 


application name: PeopleSoft Email Retrieval-Test

application ID:   4e24aa68-496e-48d6-bc16-8396f5b62463   <-- this is also Client ID

Tenant ID aac81192-f6f6-4e8a-9f5e-a663e2d41612

Secret Value = Q5I8Q~_F1u0.B4Uh__5ZanBkcYbEFriDwX-5lasH   <-- this is also Client Secret

Secret ID = eab0cd84-9f92-42bc-84dd-60a0756dcafc

psmobilehrtest/

PSMOBILEHRTEST@tmw.com



https://portal.azure.com/#home  


https://portal.azure.com/#home   



PSTEAM@TMW.COM

http://tmwappkabats701.tmw.com:8080/IHTTPLCE/INTEXTRECEIVE



2023 May 4th

host: pshrtstapp602  compress some files to same space

/usr/opt/app/psoft/pt860/hrdpk/dpk

tar cf archives.tar archives

gzip -9 archives.tar


psoft-psesdevapp602.tmw.com:NONE:/usr/opt/app/es7/pt/elasticsearch7.0.0/bin>ps -ef | grep elast

psoft     10096      1  0 Jan20 ?        16:00:19 /usr/opt/app/es7/pt/es_jre1.8.0_271/bin/java -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=75 -XX:+UseCMSInitiatingOccupancyOnly -Des.networkaddress.cache.ttl=60 -Des.networkaddress.cache.negative.ttl=10 -XX:+AlwaysPreTouch -Xss1m -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djna.nosys=true -XX:-OmitStackTraceInFastThrow -Dio.netty.noUnsafe=true -Dio.netty.noKeySetOptimization=true -Dio.netty.recycler.maxCapacityPerThread=0 -Dlog4j.shutdownHookEnabled=false -Dlog4j2.disable.jmx=true -Djava.io.tmpdir=/tmp/elasticsearch-6096294225698555085 -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=data -XX:ErrorFile=logs/hs_err_pid%p.log -XX:+PrintGCDetails -XX:+PrintGCDateStamps -XX:+PrintTenuringDistribution -XX:+PrintGCApplicationStoppedTime -Xloggc:logs/gc.log -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=32 -XX:GCLogFileSize=64m -Xms8g -Xmx8g -Dio.netty.allocator.type=pooled -Des.path.home=/usr/opt/app/es7/pt/elasticsearch7.0.0 -Des.path.conf=/usr/opt/app/es7/pt/elasticsearch7.0.0/config -Des.distribution.flavor=oss -Des.distribution.type=tar -Des.bundled_jdk=true -cp /usr/opt/app/es7/pt/elasticsearch7.0.0/lib/* org.elasticsearch.bootstrap.Elasticsearch

psoft     95298  94627  0 17:09 pts/0    00:00:00 grep --color=auto elast

psoft-psesdevapp602.tmw.com:NONE:/usr/opt/app/es7/pt/elasticsearch7.0.0/bin>nohup ./elasticsearch &

psoft-psesdevapp602.tmw.com:NONE:/usr/opt/app/es7/pt/elasticsearch7.0.0/bin>kill -9 10096

psoft-psesdevapp602.tmw.com:NONE:/usr/opt/app/es7/pt/elasticsearch7.0.0/bin>ps -ef | grep elast

psoft     95417  94627  0 17:10 pts/0    00:00:00 grep --color=auto elast

psoft-psesdevapp602.tmw.com:NONE:/usr/opt/app/es7/pt/elasticsearch7.0.0/bin>rm nohup.out

psoft-psesdevapp602.tmw.com:NONE:/usr/opt/app/es7/pt/elasticsearch7.0.0/bin>nohup ./elasticsearch &

[1]     95451

psoft-psesdevapp602.tmw.com:NONE:/usr/opt/app/es7/pt/elasticsearch7.0.0/bin>nohup: ignoring input and appending output to ‘nohup.out’





2023 May 12th

HRCNV2


SQL> alter user system identified by EM22sdEnxkhA_B;

SQL> alter user sys identified by cZQwV3EqQy9K_M;



get statuses on 

citrix server

elastic search





To start COBOL:  

Steps to Solve:


1) Sign in as root.

2) Please run /var/microfocuslicensing/bin/mfcesdchk to check if the license daemon is running.

3) If it is not running, please start the license daemon via  /var/microfocuslicensing/bin/startmfcesd.sh


Or you can use restartmfcesd.sh - restarts the license daemon.


(Aside: restartboth.sh - restarts both the license server and the daemon)


4) Test cobol program compile via $PS_HOME/setup/pscbl.mak



this is on pshrtstapp601 and pshrtstapp602:  ./var/microfocuslicensing/bin/mfcesd



SSHKEYS  for hrprod needs to be relocated for Tools upgrade ALWAYS:


./pt858/hrprod_cfg/appserv/prcs/hrprod/sshkeys/public/id_rsa.pub

./pt858/hrprod_cfg/appserv/prcs/hrprod/sshkeys/private/id_rsa

./pt858/hrprod_cfg/appserv/prcs/hrprod2/sshkeys/public/id_rsa.pub

./pt858/hrprod_cfg/appserv/prcs/hrprod2/sshkeys/private/id_rsa

./pt858/hrprod_cfg/appserv/prcs/hrprod1/sshkeys/public/id_rsa.pub

./pt858/hrprod_cfg/appserv/prcs/hrprod1/sshkeys/private/id_rsa



psdev-pshrtstps601:hrcnv1:/usr/opt/app/psoft>find . -name *id_rsa*

./psofthome/.ssh/id_rsa.pub

./psofthome/.ssh/public/id_rsa.pub

./psofthome/.ssh/private/id_rsa

./sshkeys/public/id_rsa.pub

find: ‘./pt858/hrtest_cfg/appserv/prcs/hrtest/.adm’: Permission denied

./pt858/hrtest_cfg/appserv/prcs/hrtest/sshkeys/public/id_rsa.pub

./pt858/hrtest_cfg/appserv/prcs/hrtest/sshkeys/private/id_rsa

find: ‘./pt860/ptdpk/dpk/puppet/secure/keys’: Permission denied



2023 July 18th

HRCNV2 triggers

Ticket for Chris Kira access for developers


Export to Excel






There were 15 failed login attempts since the last successful login.

[root@pshrtstps601 ~]# cd /usr/opt/app/psoft/psofthome/.ssh

[root@pshrtstps601 .ssh]# ls -lrt

total 24

-rw-r--r-- 1 pstest psoft   609 Dec 15  2017 id_dsa.pub

-rw------- 1 pstest psoft   668 Dec 15  2017 id_dsa

-rw-r----- 1 pstest psoft   405 Mar  6  2019 id_rsa.pub

drwxrwx--- 2 psdev  psoft    19 Aug  4  2020 private

drwxr-xr-x 2 psdev  psoft    23 Aug  4  2020 public

-rwxrwxrwx 1 psoft  psoft 10913 Aug 21 09:08 known_hosts

[root@pshrtstps601 .ssh]# pwd

/usr/opt/app/psoft/psofthome/.ssh

[root@pshrtstps601 .ssh]# chown




[11:08 AM] Do-Capoy, Olivia (OD6)

G: please add this step to your list copy PS_ACTN_REASON_TBL to PS_ACTN_REASON_TBL_TMW

before the Tools upgrade



HRCNV1 listening connector for Kaba to test:  http://pshrtstws602.tmw.com:21480/PSIGW/HttpListeningConnector

http://hrprodib.tmw.com/PSIGW/HttpListenerConnector

http://hrprod92ib.tmw.com/PSIGW/HttpListeningConnector




Name:   pshrws601.tmw.com

Address: 172.31.102.43


Name:   pshrws602.tmw.com

Address: 172.31.102.44


VIPs: 

Name:   hrprod92.tmw.com

Address: 172.31.102.45

Port:  21743 / 21780


Name:   hrprod92ib.tmw.com

Address: 172.31.102.46


Name:   sshrprod92.tmw.com

Address: 172.31.102.50

Port:   21943 / 21980



Previous cipher on Tools 8.58

!EXPORT:!DH:RSA+RC4:RSA+AES:RSA+DES:RSA+3DES:ECDHE+AES:ECDHE+3DES:@SPEED





Server: sftp.benefitharbor.com

*use SFTP – SSH File Transfer Protocol

Port 9022

UserId: tailoredbrands

Passwd: pfp4Z6

Once connected you will see 2 folders:

“dropoff” – for files that they are sending to BH

“pickup” – for files that BH is sending to them

Each of these has a subfolder \OLD.  When we retrieve a file from the “dropoff” folder, we then move the files into the \OLD subfolder. That way we know that someone has retrieved and worked the files.

Please let me know if you have any issues accessing the SFTP.






when you have time, can you please try this sftp command for me  on hrtest:

USERNAME : tailoredbrands-sandbox
SERVERNM : sftp.eightfold.ai
REMOTEDIR: outbound
LOCALDIR : /interfaces2/tmw/hrtest_ats/Inbound/Eightfold/
FILENAME : *.pgp
PORT : 22
SSHKEYDIR: /usr/opt/app/psoft/pt860/hrtest_cfg/appserv/prcs/hrtest/sshkeys/private/id_rsa

sftp -i /usr/opt/app/psoft/pt860/hrtest_cfg/appserv/prcs/hrtest/sshkeys/private/id_rsa -P 22 tailoredbrands-sandbox@sftp.eightfold.ai:outbound

 

sandbox is the userid you are connecting as?

 

user = tailoredbrands-sandbox

SFTP server: sftp.eightfold.ai

Remote Directory: outbound

 

Comments

Post a Comment

Popular posts from this blog

Oracle: To clean up WRI$_ADV_OBJECTS

 set linesize 200; select segment_name, segment_type, bytes from dba_segments where tablespace_name='SYSAUX' order by bytes asc; COL OCCUPANT_NAME FORMAT A30 SELECT OCCUPANT_NAME,SPACE_USAGE_KBYTES FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC; COL SEGMENT_NAME FORMAT A30 COL OWNER FORMAT A10 COL TABLESPACE_NAME FORMAT A10 COL SEGMENT_TYPE FORMAT A15 SELECT * FROM (SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,BYTES/1024/1024 "SIZE(MB)",SEGMENT_TYPE FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='SYSAUX' ORDER BY BYTES DESC) WHERE ROWNUM<=10; 1.  automatic clean-up default 31 days           SELECT dbms_stats.get_stats_history_availability from Dual; 2. modify retention policy        exec  dbms_stats.alter_stats_history_retention (14); 3. a manual cleaning  exec dbms_stats.purge_stats (sysdate-14);   ALTER TABLE WRI$_ADV_OBJECTS MOVE; ALTER INDEX WRI$_ADV_OBJECTS_IDX_01 REBUILD; ALTER INDEX WRI$_ADV_OBJECTS_IDX_02 R...
Read more