45 liens privés
microdnf install -y openssh openssh-server openssh-clients initscripts wget passwd tar crontabs unzip bzip2
microdnf install -y hostname libaio
microdnf install -y glibc-*.i686 libgcc-*.i686 libstdc++-*.i686
microdnf install -y java
microdnf install -y ed vim sed tar which ncurses
microdnf install -y yum oracle-epel-release-el8
microdnf install -y ncurses-compat-libs
microdnf install -y screen rlwrap
yum config-manager --enable ol8_baseos_latest
yum config-manager --enable ol8_appstream
microdnf install -y oracle-database-preinstall-19c
check /etc/hosts with /etc/hostname: your hostname (like mypeoplesoft) should resolve only IPv4.
For full install of PeopleSoft (so with DB), check if you have more than 1G free RAM... if not, you can do that:
dd bs=1024 count=1M if=/dev/zero of=/swapfile
mkswap /swapfile
swapon /swapfile
Check if you have more than 2 or 3G free space for /tmp, if not ask more to IT.
go to DPK folder and:
cd setup
./psft-dpk-setup.sh # No args for full install
[admcsav@frsu0462 ~]$ cat /etc/sysctl.d/97-oracle-hugepages.conf
vm.nr_hugepages=10310
[admcsav@frsu0462 ~]$ cat /etc/default/grub
GRUB_TIMEOUT=5
GRUB_DISTRIBUTOR="$(sed 's, release .*$,,g' /etc/system-release)"
GRUB_DEFAULT=saved
GRUB_DISABLE_SUBMENU=true
GRUB_TERMINAL_OUTPUT="console"
GRUB_CMDLINE_LINUX="crashkernel=auto spectre_v2=retpoline rd.lvm.lv=sysvg/root rd.lvm.lv=sysvg/swap rd.lvm.lv=sysvg/usr rhgb quiet numa=off transparent_hugepage=never"
GRUB_DISABLE_RECOVERY="true"
Pour la partie : « vm.nr_hugepages=10310 »
Le nombre est déterminé par le script dispo ici :
https://oracle-base.com/articles/linux/configuring-huge-pages-for-oracle-on-linux-64
(attention, le DBA indique de ne SURTOUT pas utiliser grubby comme indiqué dans cette doc)
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
API PL-SQL pour générer des fichiers Excels.
ex : "
begin
as_xlsx.query2sheet( 'select * from dual' );
as_xlsx.save( 'MY_DIR', 'my.xlsx' );
end;
"
How to run the OpenSSH SSHD server on Windows using Cygwin
Install the following Cygwin packages (rerun setup if necessary -- you can add packages after you have already installed Cygwin).
Admin --> cygrunsrv
Net --> openssh
Open a new bash shell window and run the SSH configure stuff.
ssh-host-config -y
This step will create necessary configuration files, a priviledge separation user and necessary directories.
When prompted with "CYGWIN=" type for following:
tty ntsec
That's done.
Last thing to do, type the following:
chmod 400 /etc/ssh_host_ecdsa_key
Now you are ready to start the service.
cygrunsrv -S sshd
Finished
Edit:
sudo nano /etc/apt/sources.list.d/chromeos.list
Add the google Repository:
deb http://dl.google.com/linux/chrome-remote-desktop/deb/ stable main
Install:
sudo apt-get update
sudo apt-get install chrome-remote-desktop
sudo /etc/init.d/chrome-remote-desktop start