Wednesday, 21 July 2021

PeopleSoft PUM - Silent Installation using Linux Containers LXC

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







Starting the PeopleSoft Environment Setup Process: 

Validating User Arguments:                                           [  OK  ]
Validating PeopleSoft Supported Platform:                            [  OK  ]



Validating Oracle Central Inventory:                                 [  OK  ]
Verifying if PeopleSoft Relocatable Puppet Software is installed:    [  OK  ]
Checking if PeopleSoft DPKs are Present:                             [  OK  ]
Checking if the Base Directory has Enough Free Space:                [  OK  ]

Checking if User Home Directory /home is Writable:                   [  OK  ]



Validating the PeopleSoft DPKs in the Linux Host: 
Validating the PeopleSoft Application DPK:                           [  OK  ]
Validating the PeopleSoft PeopleTools Server DPK:                    [  OK  ]
Validating the Oracle Server Database DPK:                           [  OK  ]
Validating the PeopleSoft PeopleTools Client DPK:                    [  OK  ]

Validating the Manifest Information in PeopleSoft DPKs:              [  OK  ]

Extracting the PeopleSoft DPK Archives in the Linux Host: 
Extracting the Oracle Database Server DPK Archive:                   [  OK  ]
                                                                     [  OK  ]
Extracting the PeopleSoft FSCM Application DPK Archives:             [  OK  ]

Extracting the 8.59 PeopleSoft PeopleTools Client DPK Archive:       [  OK  ]
Extracting the 8.58 PeopleSoft PeopleTools Client DPK Archive:       [  OK  ]
Extracting the 8.57 PeopleSoft PeopleTools Client DPK Archive:       [  OK  ]
Extracting the Oracle Database Client DPK Archive:                   [  OK  ]

Setting up Puppet on the Linux Host: 
Generating eYAML Hiera Backend Encryption Keys:                      [  OK  ]
Updating the Puppet Hiera YAML Files in the Linux Host:              [  OK  ]
Updating the Role in Puppet Site File for the Linux Host:            [  OK  ]

Encrypting the Passwords in the User Data:                           [  OK  ]

Updating the Puppet Hiera YAML Files with User Data:                 [  OK  ]
                                                                     [  OK  ]

Starting the Default Initialization of PeopleSoft Environment: 

Setting up System Settings:                                          [  OK  ]
Deploying Application Components:                                    [  OK  ]
Deploying Oracle Database Server:                                    [  OK  ]
Deploying PeopleTools Components:                                    [  OK  ]
Setting up PeopleSoft OS Users Environment:                          [  OK  ]
Setting up PeopleSoft Database:                                      [  OK  ]
Setting up PeopleSoft Application Server Domain:                     [  OK  ]
Setting up PeopleSoft Process Scheduler Domain:                      [  OK  ]
Setting up PeopleSoft PIA Domain:                                    [  OK  ]
Setting up Samba Shares:                                             [  OK  ]
Changing the Passwords for the Environment:                          [  OK  ]
Updating table for PUM Multi-Language Support:                       [  OK  ]
Setting up automated PUM downloads and updates:                      [  OK  ]
Configuring Pre-Boot PeopleSoft Environment:                         [  OK  ]
Configuring components for PUM downloads and updates:                [  OK  ]
Starting PeopleSoft Domains:                                         [  OK  ]
Configuring Post-Boot PeopleSoft Environment:                        [  OK  ]
Setting up Source Details for PeopleTools Client:                    [  OK  ]

The PeopleSoft Environment Setup Process Ended.




Tuesday, 20 July 2021

Adding Multiple interfaces and Bridge network to Linux Containers

 [root@localhost oel7fscm]# cat config

# Template used to create this container: /usr/share/lxc/templates/lxc-oracle

# Parameters passed to the template: --release=7.latest --privileged=rt

# For additional config options, please look at lxc.container.conf(5)

# lxc.network.type = veth

# lxc.network.link = lxcbr0

# lxc.network.flags = up


lxc.network.type = macvlan

lxc.network.macvlan.mode = bridge

lxc.network.flags = up

lxc.network.link = ens32

lxc.network.hwaddr = 00:16:3e:16:00:b5

lxc.rootfs = /container/oel7fscm/rootfs

# Common configuration

lxc.include = /usr/share/lxc/config/oracle.privileged.conf

# Container configuration for Oracle Linux 7.latest

lxc.arch = x86_64

lxc.utsname = oel7fscm

# The following 3 hooks is for dynamic RT management

lxc.hook.pre-start=/usr/share/lxc/hooks/oracle-priv

lxc.hook.mount=/usr/share/lxc/hooks/oracle-priv

lxc.hook.post-stop=/usr/share/lxc/hooks/oracle-priv

# Networking


lxc.network.name = eth0

lxc.network.mtu = 1500


# lxc.network.name = eth1

# lxc.network.name = eth2

# lxc.network.name = eth3


lxc.network.type = veth

lxc.network.link = lxcbr0

lxc.network.flags = up

lxc.network.name = eth1

lxc.network.hwaddr = 00:16:3e:77:68:68


lxc.network.type = veth

lxc.network.link = lxcbr0

lxc.network.flags = up

lxc.network.name = eth2

lxc.network.hwaddr = 00:16:3e:77:68:69

[root@localhost oel7fscm]#


Monday, 19 July 2021

PeopleSoft PUM on Linux Containers

LXC Commands


oel7fscm

=========

lxc-create -n oel7fscm -t oracle -- --release=7.latest --privileged=rt

lxc-start -n oel7fscm -d -o /container/oel7fscm_debug.log -l DEBUG

lxc-console -n oel7fscm

lxc-stop --nokill -n oel7fscm

lxc-destroy -n oel7fscm

lxc-clone -o oel7fscm -n oel7fscm2

lxc-start -n oel7fscm2 -d -o /container/oel7fscm2_debug.log -l DEBUG



 [root@ol7-183 data]# cat 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:          Password123

domain_user:           "%{hiera('psft_runtime_user_name')}"

ps_config_home:        "%{hiera('user_home_dir')}/%{hiera('domain_user')}/psft/pt/8.59"

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:  Password123

pia_gateway_keystore_pwd: Password123

domain_conn_pwd:       Password123

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

Thursday, 8 July 2021

PeopleSoft PUM Deployment on the Native OS

Pre requisites

1) Make sure you have Oracle Enterprise Linux 7.x (7.9). 
If you try installing on any other OS besides OEL, you may see challenges and all other issues that you will not be able to seek support from oracle.

Step 1: 
Download the PUM Image with the patch number that is provided in the Oracle Support Site

Example: 

[root@localhost getMOSPatch-master]# /usr/bin/java -jar getMOSPatch.jar MOSUser=xyz MOSPass=abc platform=226P download=all patch=32356044
  
We're going to download patches for the following Platforms/Languages:
 226P - Platform 226P
Processing patch 32356044 for Platform 226P and applying regexp .* to the filenames:                                                                                                                              1 - FSCM-920-UPD-039-LNX_10of11.zip
2 - FSCM-920-UPD-039-LNX_11of11.zip
3 - FSCM-920-UPD-039-LNX_1of11.zip
4 - FSCM-920-UPD-039-LNX_2of11.zip
5 - FSCM-920-UPD-039-LNX_3of11.zip
6 - FSCM-920-UPD-039-LNX_4of11.zip
7 - FSCM-920-UPD-039-LNX_5of11.zip
8 - FSCM-920-UPD-039-LNX_6of11.zip
9 - FSCM-920-UPD-039-LNX_7of11.zip
10 - FSCM-920-UPD-039-LNX_8of11.zip
11 - FSCM-920-UPD-039-LNX_9of11.zip
 Enter Comma separated files to download: all
 All files will be downloaded because download=all was specified.
Downloading all selected files:
 Downloading FSCM-920-UPD-039-LNX_10of11.zip: 2358MB at average speed of 8837KB/s - DONE!
 Downloading FSCM-920-UPD-039-LNX_11of11.zip: 2063MB at average speed of 8445KB/s - DONE!
 Downloading FSCM-920-UPD-039-LNX_1of11.zip: 219MB at average speed of 8837KB/s - DONE!
 Downloading FSCM-920-UPD-039-LNX_2of11.zip: 1836MB at average speed of 8582KB/s - DONE!
 Downloading FSCM-920-UPD-039-LNX_3of11.zip: 2792MB at average speed of 8685KB/s - DONE!
 Downloading FSCM-920-UPD-039-LNX_4of11.zip: 1312MB at average speed of 8587KB/s - DONE!
 Downloading FSCM-920-UPD-039-LNX_5of11.zip: 1334MB at average speed of 8608KB/s - DONE!
 Downloading FSCM-920-UPD-039-LNX_6of11.zip: 1309MB at average speed of 10528KB/s - DONE!
 Downloading FSCM-920-UPD-039-LNX_7of11.zip: 1346MB at average speed of 8766KB/s - DONE!
 Downloading FSCM-920-UPD-039-LNX_8of11.zip: 4914MB at average speed of 7688KB/s - DONE!
 Downloading FSCM-920-UPD-039-LNX_9of11.zip: 2206MB at average speed of 8665KB/s - DONE!
[root@localhost getMOSPatch-master]#


Step 2 : Installation

[root@ol7-183 setup]# ./psft-dpk-setup.sh 


Starting the PeopleSoft Environment Setup Process: 

Validating User Arguments:                                           [  OK  ]
Validating PeopleSoft Supported Platform:                            [  OK  ]



Verifying if Puppet Software is installed: 

Puppet 5.5.14 is not installed on the Linux Host. If PeopleSoft
environment needs to be set up on this host, Puppet 5.5.14
must be installed.

Do you want to proceed with the Puppet 5.5.14 Installation? [Y|n]: y

Installing Puppet Software on the Linux Host:                        [  OK  ]

Installing eYAML Hiera Backend on the Linux Host:                    [  OK  ]
Checking if PeopleSoft DPKs are Present:                             [  OK  ]

The base directory is used to extract the PeopleSoft DPKs. It is also
used to deploy the PeopleSoft components. This directory should be
accessible on the Linux VM, must have write permission and should
have enough free space.
Enter the full path for the PeopleSoft Base Directory: /u02/fscm038 
Are you happy with your answer? [Y|n|q]: y

Checking if the Base Directory has Enough Free Space:                [  OK  ]


Enter a directory on the Linux VM that is writable [/home]: 
Are you happy with your answer? [Y|n|q]: y

Checking if User Home Directory /home is Writable:                   [  OK  ]



Validating the PeopleSoft DPKs in the Linux VM: 
Validating the PeopleSoft Application DPK:                           [  OK  ]
Validating the PeopleSoft PeopleTools Server DPK:                    [  OK  ]
Validating the Oracle Server Database DPK:                           [  OK  ]
Validating the PeopleSoft PeopleTools Client DPK:                    [  OK  ]

Validating the Manifest Information in PeopleSoft DPKs:              [  OK  ]

Extracting the PeopleSoft DPK Archives in the Linux VM: 
Extracting the Oracle Database Server DPK Archive:                   [  OK  ]
                                                                     [  OK  ]
Extracting the PeopleSoft FSCM Application DPK Archives:             [  OK  ]

Extracting the 8.58 PeopleSoft PeopleTools Client DPK Archive:       [  OK  ]
Extracting the 8.57 PeopleSoft PeopleTools Client DPK Archive:       [  OK  ]
Extracting the 8.56 PeopleSoft PeopleTools Client DPK Archive:       [  OK  ]
Extracting the Oracle Database Client DPK Archive:                   [  OK  ]

Setting up Puppet on the Linux VM: 
Generating eYAML Hiera Backend Encryption Keys:                      [  OK  ]
Updating the Puppet Hiera YAML Files in the Linux VM:                [  OK  ]
Updating the Role in Puppet Site File for the Linux VM:              [  OK  ]

Enter the PeopleSoft installation [PUM or FRESH] type [PUM]: 

Enter a new PeopleSoft database name. Ensure that the database
name starts with a letter, contains only uppercase letters and
numbers and is no more than 8 characters in length [EP92U038]: 

Enter the PeopleSoft database listener port [1521]: 

Enter a new PeopleSoft database admin users [SYS/SYSTEM] password.
Ensure that the password meets the length and complexity 
requirements for your database platform : 
Re-Enter the database admin users password: 

Enter a new PeopleSoft database Connect ID. Ensure that the ID
contains only alphanumeric characters [people]: 

Enter a new PeopleSoft database Connect ID [people] password. 
Ensure that the password meets the length and complexity 
requirements for your database platform : 
Re-Enter the PeopleSoft Connect ID password: 

Enter a new PeopleSoft database Access ID [SYSADM] password. 
Ensure that the password meets the length and complexity 
requirements for your database platform : 
Re-Enter the PeopleSoft Access ID password: 

Enter a new PeopleSoft database Operator ID [VP1] password. 
Ensure that the password is between 1 and 32 characters in length. 
You may include these special characters !@#$%^& : 
Re-Enter the PeopleSoft Operator ID password: 

[Optional] Enter a new Application Server Domain connection password.
Ensure that the password is between 8 and 30 characters in length. 
You may include these special characters !@#$%^& : 

Enter a new WebLogic Server Admin user [system] password. 
Ensure that the password is between 8 and 30 characters in length 
with at least one lowercase letter and one uppercase letter. It must also 
contain one number or one of these special characters !@#$%^& : 
Re-Enter the WebLogic Server Admin user password: 

WebLogic Server Admin user passwords do not match.

Enter a new WebLogic Server Admin user [system] password. 
Ensure that the password is between 8 and 30 characters in length 
with at least one lowercase letter and one uppercase letter. It must also 
contain one number or one of these special characters !@#$%^& : 
Re-Enter the WebLogic Server Admin user password: 

Enter a new PeopleSoft Web Profile user [PTWEBSERVER] password. 
Ensure that the password is between 8 and 32 characters in length. 
You may include these special characters !@#$%^& : 
Re-Enter the PeopleSoft Web Profile user password: 

Enter the PeopleSoft Integration Gateway user [administrator]: 
Enter the PeopleSoft Integration Gateway user [administrator] password. 
Ensure that the password is between 8 and 30 characters in length. 
You may include these special characters !@#$%^& : 
Re-Enter the PeopleSoft Integration Gateway user password: 

Enter the PeopleSoft Integration Gateway Keystore password. 
Ensure that the password is between 8 and 30 characters in length. 
You may include these special characters !@#$%^& : 
Re-Enter the PeopleSoft Integration Gateway Keystore password: 

Are you happy with your answers? [y|n]: y

Encrypting the Passwords in the User Data:                           [  OK  ]

Updating the Puppet Hiera YAML Files with User Data:                 [  OK  ]
                                                                     [  OK  ]

The bootstrap script is ready to deploy and configure the PeopleSoft
environment using the default configuration defined in the Puppet
Hiera YAML files. You can proceed by answering 'y' at the following
prompt. And, if you want to customize the environment by overriding
the default configuration, you can answer 'n'. If you answer 'n', you
should follow the instructions in the PeopleSoft Installation Guide
for creating the Hiera YAML file 'psft_customizations.yaml' and running the
psft_puppet_apply script to continue with the setup of the PeopleSoft
environment.

Do you want to continue with the default initialization process? [y|n]: y

Starting the Default Initialization of PeopleSoft Environment: 

Setting up System Settings:                                          [  OK  ]
Deploying Application Components:                                    [  OK  ]
Deploying Oracle Database Server:                                    [  OK  ]
Deploying PeopleTools Components:                                    [  OK  ]
Setting up PeopleSoft OS Users Environment:                          [  OK  ]
Setting up PeopleSoft Database:                                      [  OK  ]
Setting up PeopleSoft Application Server Domain:                     [  OK  ]
Setting up PeopleSoft Process Scheduler Domain:                      [  OK  ]
Setting up PeopleSoft PIA Domain:                                    [  OK  ]
Setting up Samba Shares:                                             [  OK  ]
Changing the Passwords for the Environment:                          [  OK  ]
Configuring Pre-Boot PeopleSoft Environment:                         [  OK  ]
Starting PeopleSoft Domains:                                         [  OK  ]
Configuring Post-Boot PeopleSoft Environment:                        [  OK  ]
Setting up Source Details for PeopleTools Client:                    [  OK  ]

The PeopleSoft Environment Setup Process Ended.

Monday, 5 July 2021

Installing Oracle 19c on RockyLinux 8

Problem


[WARNING] [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’ 19c on Oracle Linux 8


$ ./runInstaller -silent -responseFile install/response/db_install.rsp
Launching Oracle Database Setup Wizard…
[WARNING] [INS-08101] Unexpected error while executing the action at state: 'supportedOSCheck'
CAUSE: No additional information available.
ACTION: Contact Oracle Support Services or refer to the software manual.
SUMMARY:
- java.lang.NullPointerException

   Solution

# uname -a
Linux localhost.localdomain 4.18.0-305.3.1.el8_4.x86_64 #1 SMP Thu Jun 17 07:52:48 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux

Edit the File: cvu_config

$ vi /u01/app/oracle/product/19.3.0/dbhome_1/cv/admin/cvu_config

Old Value:

#CV_ASSUME_DISTID=OEL

New Value:

CV_ASSUME_DISTID=OEL8

Note: You can install now the Oracle Software.