PeopleSoft FSCM PUM Installation

sh psft-dpk-setup.sh --silent --response_file=/tmp/response.txt --customization_file=/tmp/psft_customizations.yaml

PeopleSoft PUM Database response file: response.txt
install_type=FRESH [or PUM]
psft_base_dir=/u02/fsc040
user_home_dir=/home/
db_type=DEMO
db_platform=ORACLE
db_name=EP92U040
db_service_name=EP92U040
db_port=1521
connect_id=people
connect_pwd=people
opr_id=VP1
opr_pwd=VP1
admin_pwd=Tiger123
access_id=SYSADM
access_pwd=SYSADM
weblogic_admin_pwd=Tiger123
webprofile_user_id=PTWEBSERVER
webprofile_user_pwd=PTWEBSERVER
gw_user_id=administrator
gw_user_pwd=Tiger123
gw_keystore_pwd=Tiger123

YAML File: psft_customizations.yaml

db_name: EP92U040
db_user: VP1
db_user_pwd: VP1
db_connect_id: people
db_connect_pwd: people
change_password: false
access_id: SYSADM
access_pwd: SYSADM
db_admin_pwd: Tiger123
domain_user: "%{hiera('psft_runtime_user_name')}"
ps_config_home: "%{hiera('user_home_dir')}/%{hiera('domain_user')}/psft/pt/8.58"
appserver_template: small
appserver_domain_name: EP92U040
prcs_domain_name: EP92U040
prcs_domain_id: "PRCS%{::rand}"
report_node_name: "%{hiera('prcs_domain_id')}"
pia_domain_name: peoplesoft
pia_site_name: ps
pia_http_port: 8022
pia_https_port: 8455
jolt_port: 9055
wsl_port: 8001
db_port: 1521
pia_gateway_user: administrator
pia_gateway_user_pwd: Tiger123
pia_gateway_keystore_pwd: Tiger123
domain_conn_pwd: Tiger123
peoplesoft_base: /u02/fsc040
dpk_location: "%{hiera('peoplesoft_base')}/dpk"
archive_location: "%{hiera('dpk_location')}/archives"
pt_location: "%{hiera('peoplesoft_base')}/pt"
db_location: "%{hiera('peoplesoft_base')}/db"
psft_runtime_group_name: psft
psft_app_install_group_name: appinst
oracle_install_group_name: oinstall
oracle_runtime_group_name: dba

groups:
psft_runtime_group:
name: "%{hiera('psft_runtime_group_name')}"
app_install_group:
name: "%{hiera('psft_app_install_group_name')}"
oracle_install_group:
name: "%{hiera('oracle_install_group_name')}"
remove: false
oracle_runtime_group:
name: "%{hiera('oracle_runtime_group_name')}"
remove: false

psft_user_pwd: 0radmin
oracle_user_pwd: oracle
user_home_dir: /u02
psft_install_user_name: psadm11
psft_runtime_user_name: psadm22
psft_app_install_user_name: psadm33
oracle_user_name: oracle22
psft_es_user_name: esadm11
psft_es_esadmin_name: esadmin
psft_es_espeople_name: people
setup_samba: false
setup_sysctl: false
setup_services: true

alter session set NLS_TERRITORY='FRANCE';
alter session set NLS_LENGTH_SEMANTICS='CHAR';
alter session set NLS_NUMERIC_CHARACTERS='.,';
alter session set NLS_DATE_FORMAT='DD/MM/YYYY';
alter session set NLS_TIMESTAMP_FORMAT='DD/MM/YYYY HH24:MI:SS';

set feedback off
set sqlformat insert
-- set sqlformat csv
spool /path/to/your/file.sql
select * from t;
spool off
set feedback on

HOST=127.0.0.1
for((port=1;port<=65535;++port));do echo -en "$port ";if echo -en "open $HOST $port\nlogout\quit" | telnet 2>/dev/null | grep 'Connected to' > /dev/null;then echo -en "\n\nport $port/tcp is open\n\n";fi;done

In case somehow, you got duplicate mails in a maildir, like me, maybe this is helpful to you:
?
1

find /var/mail/user -type d -name cur -print0 | xargs -0 /usr/bin/fdupes -n | less

Of course you need fdupes installed. On debian:
?
1

apt-get install fdupes

The above command is the dry run, showing you the duplicates.

Then to delete the duplicates, leaving only the first found file:
?
1

find /var/mail/user -type d -name cur -print0 | xargs -0 /usr/bin/fdupes -ndN | less

Use the same thing again with “new” instead of “cur” if you have duplicate unread mails. This only looks at duplicates within the same folder, so you can also safely run it on /var/mail for all users.

Vérif CSR :
openssl req -in mycsr.csr -noout -text

Commande rpm intéressante :

rpm -q --changelog sudo

Si datapump en erreur => CTRL-C

stop_job=immediate # peut être long, à tester sans le "immediate"

Faire les alter nécessaires.

Pour reprendre, vérifier les jobs datapump :
SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs;

Puis lancer le datapump :

impdp attach=SYS_IMPORT_FULL_01 # job_name

Dans datapump, si job_mode est "NOT RUNNING" :
start_job # ajouter =SKIP_CURRENT si c'est vraiment nécessaire.

Puis, pour faire l'équivalent d'un "fg" :
continue_client

wmic memphysical get MaxCapacity, MemoryDevices

$ mkdir -p config work logs
$ certbot certonly --config-dir config/ --work-dir work/ --logs-dir logs/ \
--server https://acme-v02.api.letsencrypt.org/directory --manual \
-d '*.monsite.fr'

To fix this, I found the following steps worked:
sudo apt-get install --reinstall ca-certificates
to ensure you have the latest certificates by your distribution – this might help you, but it didn’t assist me 🙁

So I downloaded the Let’s Encrypt root certificates and forced a rebuild of the certificate store:

sudo curl https://letsencrypt.org/certs/isrgrootx1.pem.txt -o /usr/local/share/ca-certificates/isrgrootx1.crt
sudo curl https://letsencrypt.org/certs/letsencryptauthorityx1.pem.txt -o /usr/local/share/ca-certificates/letsencryptauthorityx1.crt
sudo curl https://letsencrypt.org/certs/letsencryptauthorityx2.pem.txt -o /usr/local/share/ca-certificates/letsencryptauthorityx2.crt
sudo curl https://letsencrypt.org/certs/lets-encrypt-x1-cross-signed.pem.txt -o /usr/local/share/ca-certificates/letsencryptx1.crt
sudo curl https://letsencrypt.org/certs/lets-encrypt-x2-cross-signed.pem.txt -o /usr/local/share/ca-certificates/letsencryptx2.crt
sudo curl https://letsencrypt.org/certs/lets-encrypt-x3-cross-signed.pem.txt -o /usr/local/share/ca-certificates/letsencryptx3.crt
sudo curl https://letsencrypt.org/certs/lets-encrypt-x4-cross-signed.pem.txt -o /usr/local/share/ca-certificates/letsencryptx4.crt
sudo dpkg-reconfigure ca-certificates

and everything worked!

If you are running Java, you may need to also add the certificates to the Java Keytool:
keytool -trustcacerts -keystore $JAVA_HOME/jre/lib/security/cacerts -storepass changeit -noprompt -importcert -file /usr/local/share/ca-certificates/isrgrootx1.crt
keytool -trustcacerts -keystore $JAVA_HOME/jre/lib/security/cacerts -storepass changeit -noprompt -importcert -file /usr/local/share/ca-certificates/letsencryptauthorityx1.crt
(change the storepass password [default of “changeme”] to whatever is relevant to you)

$ ./rda.pl -T ora600:/u01/app/oracle/product/10.2.0/db_1/bdump/racdb1_pz99_8329.trc

Typing vagrant from the command line will display a list of all available commands.

Be sure that you are in the same directory as the Vagrantfile when running these commands!
Creating a VM

vagrant init -- Initialize Vagrant with a Vagrantfile and ./.vagrant directory, using no specified base image. Before you can do vagrant up, you'll need to specify a base image in the Vagrantfile.
vagrant init <boxpath> -- Initialize Vagrant with a specific box. To find a box, go to the public Vagrant box catalog. When you find one you like, just replace it's name with boxpath. For example, vagrant init ubuntu/trusty64.

Starting a VM

vagrant up -- starts vagrant environment (also provisions only on the FIRST vagrant up)
vagrant resume -- resume a suspended machine (vagrant up works just fine for this as well)
vagrant provision -- forces reprovisioning of the vagrant machine
vagrant reload -- restarts vagrant machine, loads new Vagrantfile configuration
vagrant reload --provision -- restart the virtual machine and force provisioning

Getting into a VM

vagrant ssh -- connects to machine via SSH
vagrant ssh <boxname> -- If you give your box a name in your Vagrantfile, you can ssh into it with boxname. Works from any directory.

Stopping a VM

vagrant halt -- stops the vagrant machine
vagrant suspend -- suspends a virtual machine (remembers state)

Cleaning Up a VM

vagrant destroy -- stops and deletes all traces of the vagrant machine
vagrant destroy -f -- same as above, without confirmation

Boxes

vagrant box list -- see a list of all installed boxes on your computer
vagrant box add <name> <url> -- download a box image to your computer
vagrant box outdated -- check for updates vagrant box update
vagrant boxes remove <name> -- deletes a box from the machine
vagrant package -- packages a running virtualbox env in a reusable box

Saving Progress

-vagrant snapshot save [options] [vm-name] <name> -- vm-name is often default. Allows us to save so that we can rollback at a later time
Tips

vagrant -v -- get the vagrant version
vagrant status -- outputs status of the vagrant machine
vagrant global-status -- outputs status of all vagrant machines
vagrant global-status --prune -- same as above, but prunes invalid entries
vagrant provision --debug -- use the debug flag to increase the verbosity of the output
vagrant push -- yes, vagrant can be configured to deploy code!
vagrant up --provision | tee provision.log -- Runs vagrant up, forces provisioning and logs all output to a file

Plugins

vagrant-hostsupdater : $ vagrant plugin install vagrant-hostsupdater to update your /etc/hosts file automatically each time you start/stop your vagrant box.

Shrink TEMP Tablespace using alter tablespace command
SQL> ALTER TABLESPACE temp SHRINK SPACE KEEP 50M;.

Shrink TEMPFILE using alter tablespace command
SQL> ALTER TABLESPACE temp SHRINK TEMPFILE '/u01/app/oracle/oradata/TEST11G/temp01.dbf' KEEP 40M;

Shrink TEMP Tablespace to the smallest possible size:
SQL> ALTER TABLESPACE temp SHRINK SPACE;

SELECT pid FROM v$process
WHERE addr =
(
SELECT paddr FROM v$bgprocess
WHERE name = 'SMON'
);

ORADEBUG WAKEUP 6