Renew Expired GPG key. GitHub Gist: instantly share code, notes, and snippets.

read -p "User: " user
wget https://www.dwservice.net/download/dwagent.sh
DISPLAY="" sudo bash dwagent.sh
sudo systemctl stop dwagent.service
sudo systemctl disable dwagent.service
cd ~
mkdir -p .config/systemd/user
cd .config/systemd/user/
sudo mv /etc/systemd/system/dwagent.service .
sudo chown $user:$user dwagent.service
sed -i 's/WantedBy=multi-user.target/WantedBy=default.target/' ~/.config/systemd/user/dwagent.service
sudo chown -R $user:$user/opt/dwagent
sudo loginctl enable-linger $user
systemctl --user enable dwagent
systemctl --user start dwagent
systemctl --user status dwagent

1. Get the current control_file location

SQL> show parameter control_files

NAME TYPE VALUE

control_files string /u01/oracle/dbaclass/control01.ctl

2. Set the new location of controfile:

SQL> alter system set control_files='/u03/oracle/dbaclass/control01.ctl' scope=spfile;

System altered.

3. start the database in nomount stage:

shutdown immediate;
startup nomount

4. Restore controlfile to new location:

RMAN> restore controlfile from '/u01/oracle/dbaclass/control01.ctl';

Starting restore at 13-JAN-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2201 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=/u03/oracle/dbaclass/control01.ctl
Finished restore at 13-JAN-19

5. restart the database:

alter database mount;
alter database open;

6. Check the control_file again:

SQL> show parameter control_files

NAME TYPE VALUE

control_files string /u03/oracle/dbaclass/control01.ctl

Create a Dockerfile like this:

FROM your_image as initial
FROM your_image_base
COPY --from=initial / /

your_image_base should be something like 'alpine' - so the smallest image from which your image and its parents descend from.

Now build the image and check the history and size:

docker build -t your-image:2.0 .
docker image history your-image:2.0
docker image ls

./wlst.sh
You will get WLST prompt in offline mode, invoke the following command

wls:/offline> domain = "/opt/apps/user_projects/domains/domain_name"
Note: change the domain path if necessary

wls:/offline> service = weblogic.security.internal.SerializedSystemIni.getEncryptionService(domain)
wls:/offline> encryption = weblogic.security.internal.encryption.ClearOrEncryptedService(service)
wls:/offline> print encryption.decrypt("{AES}WDhZb5/IP95P4eM8jwYITiZs01kawSeliV59aFog1jE=")
weblogic123
wls:/offline>

Pour eliminer le Privacy Protection executer les étapes suivantes :

1°)taskkill.exe /F /IM privacy.exe
2°)Telechargement de trojan-killer.net
3°)Executer un Scan trojan Killer

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

Lancer cmd en tant qu'admin.

takeown /F X:\FULL_PATH_TO_FOLDER
takeown /F X:\FULL_PATH_TO_FOLDER /r /d y
icacls X:\FULL_PATH_TO_FOLDER /grant Administrateurs:F
icacls X:\FULL_PATH_TO_FOLDER /grant Administrateurs:F /t

1. Download patches

2. backup precheck
   cd precheck
   ps -ef |grep pmon > current_instance.txt
   ps -ef |grep tns > current_tns.txt
   cat /etc/oratab > current_oratab.txt
   $ORACLE_HOME/OPatch/opatch lsinventory > before_current_lsinventory.txt

3. Check conflicts
   export PATH=$ORACLE_HOME/OPatch:$PATH
   opatch version
   unzip <patch.zip> && cd <path folder>
   opatch prereq CheckConflictAgainstOHWithDetail -ph ./

4. Stop oracle database and listeners

5. Check
   ps -ef|grep pmon
   ps -ef|grep tns
   ps -ef|grep exp
   ps -ef|grep rman

6. Apply patch
   opatch apply

7. Check
   opatch lsinventory > after_current_lsinventory.txt

8. Start only oracle database (not the listener)

9. Patch data
   datapatch -verbose

10. Check
    sqlplus / as sysdba
    SET LINESIZE 400
    COLUMN action_time FORMAT A20
    COLUMN action FORMAT A10
    COLUMN status FORMAT A10
    COLUMN description FORMAT A40
    COLUMN version FORMAT A10
    COLUMN bundle_series FORMAT A10

SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,action,status,description,patch_id FROM sys.dba_registry_sqlpatch ORDER by action_time;

10. Check stop and start
    sqlplus / as sysdba
    shutdown immediate
    startup
    select name,open_mode from v$database;

11. Start the listener

Open "psappsrv.ubx" file and navigate to the bottom and locate the section with environment settings (it begins with *PS_ENVFILE)

Add the following environment variable:
LLE_DEPRECATION_WARN_LEVEL=NONE

0 - My Oracle Support patch 6880880 (OPatch) : https://updates.oracle.com/download/6880880.html
1 - Download the Patch from oracle support
2 - Copy patches to folder where oracle dba user has access
3 - For 6880880, zip old OPatch folder in $ORACLE_HOME
4 - Shutdown oracle database server and listener
5 - For other patch, go to $ORACLE_HOME and run command : ./opatch apply <path where the patch is>/patch.zip
6 - Startup oracle database server and listener
7 - ./datapatch -verbose
8 - In sqlplus (/ as sysdba) run : @?/rdbms/admin/utlrp.sql
9 - In sqlplus, check remaining INVALID objects : select owner, count(*) count from all_objects where status = ‘INVALID’ group by owner;

apt-get install -y libaio1 alien
# Change version based on https://www.oracle.com/de/database/technologies/instant-client/linux-x86-64-downloads.html
# Example alternative: http://yum.oracle.com/repo/OracleLinux/OL7/oracle/instantclient/x86_64/getPackage/oracle-instantclient19.5-basiclite-19.5.0.0.0-1.x86_64.rpm
wget http://yum.oracle.com/repo/OracleLinux/OL7/oracle/instantclient/x86_64/getPackage/oracle-instantclient19.6-basic-19.6.0.0.0-1.x86_64.rpm
sudo alien -i --scripts oracle-instantclient*.rpm
rm -f oracle-instantclient*.rpm

# Optionally install SQLPlus
wget http://yum.oracle.com/repo/OracleLinux/OL7/oracle/instantclient/x86_64/getPackage/oracle-instantclient19.6-sqlplus-19.6.0.0.0-1.x86_64.rpm
sudo alien -i --scripts oracle-instantclient*.rpm
rm -f oracle-instantclient*.rpm

lsof | egrep "deleted|COMMAND"
-> note PID and FD number
file /proc/<PID>/fd/<FD number>
-> "broken symbolic link to ..."
echo > /proc/<PID>/fd/<FD number>

If datafiles of an INDEX tablespace, do not forget to check integrity :
select 'alter index "||index_name||' validate structure;' from dba_indexes where tablespace_name='PSINDEX';

Note to take :
lvdisplay => note PV Path and note VG Name to extend (for LV Path/Name choosed), for example "system".
vgdisplay => confirm format (lvm2)

After adding disk or resize VDI :
fdisk -l
fdisk /dev/sda => add new primary or logical volume, for example "sda3"
pvscan or pvdisplay or pvs => does NOT show new partition
pvcreate /dev/sda3
pvscan or pvdisplay or pvs => show new partition
vgextend system /dev/sda3 (where system is VG Name)
lvextend -l +100%FREE /dev/system/root (where /dev/system/root is the PV Path noted before)
resize2fs /dev/system/root

It's done.
Confirm with df -h command

\n# [ $LOGNAME@\h:$PWD [\t] [ohvers SID:${ORACLE_SID:-"no sid"}] ]\n#

Thanks !
Here for Oracle SQL :

create table continents (
code varchar2(2) not null,
name varchar2(255),
primary key (code)
);

set scan off;
insert into continents values ('AF', 'Africa');
insert into continents values ('AS', 'Asia');
insert into continents values ('EU', 'Europe');
insert into continents values ('NA', 'North America');
insert into continents values ('SA', 'South America');
insert into continents values ('OC', 'Oceania');
insert into continents values ('AN', 'Antarctica');
commit;

create table countries (
code varchar2(2) not null,
name varchar2(255) not null,
full_name varchar2(255) not null,
iso3 varchar2(3) not null,
nbr varchar2(3),
continent_code varchar2(2),
primary key (code),
foreign key(continent_code) references continents(code)
);

set scan off;
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AF', 'AS', 'Afghanistan', 'AFG', '004', 'Islamic Republic of Afghanistan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AX', 'EU', 'Åland Islands', 'ALA', '248', 'Åland Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AL', 'EU', 'Albania', 'ALB', '008', 'Republic of Albania');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('DZ', 'AF', 'Algeria', 'DZA', '012', 'People''s Democratic Republic of Algeria');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AS', 'OC', 'American Samoa', 'ASM', '016', 'American Samoa');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AD', 'EU', 'Andorra', 'AND', '020', 'Principality of Andorra');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AO', 'AF', 'Angola', 'AGO', '024', 'Republic of Angola');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AI', 'NA', 'Anguilla', 'AIA', '660', 'Anguilla');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AQ', 'AN', 'Antarctica', 'ATA', '010', 'Antarctica (the territory South of 60 deg S)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AG', 'NA', 'Antigua and Barbuda', 'ATG', '028', 'Antigua and Barbuda');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AR', 'SA', 'Argentina', 'ARG', '032', 'Argentine Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AM', 'AS', 'Armenia', 'ARM', '051', 'Republic of Armenia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AW', 'NA', 'Aruba', 'ABW', '533', 'Aruba');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AU', 'OC', 'Australia', 'AUS', '036', 'Commonwealth of Australia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AT', 'EU', 'Austria', 'AUT', '040', 'Republic of Austria');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AZ', 'AS', 'Azerbaijan', 'AZE', '031', 'Republic of Azerbaijan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BS', 'NA', 'Bahamas', 'BHS', '044', 'Commonwealth of the Bahamas');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BH', 'AS', 'Bahrain', 'BHR', '048', 'Kingdom of Bahrain');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BD', 'AS', 'Bangladesh', 'BGD', '050', 'People''s Republic of Bangladesh');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BB', 'NA', 'Barbados', 'BRB', '052', 'Barbados');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BY', 'EU', 'Belarus', 'BLR', '112', 'Republic of Belarus');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BE', 'EU', 'Belgium', 'BEL', '056', 'Kingdom of Belgium');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BZ', 'NA', 'Belize', 'BLZ', '084', 'Belize');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BJ', 'AF', 'Benin', 'BEN', '204', 'Republic of Benin');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BM', 'NA', 'Bermuda', 'BMU', '060', 'Bermuda');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BT', 'AS', 'Bhutan', 'BTN', '064', 'Kingdom of Bhutan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BO', 'SA', 'Bolivia', 'BOL', '068', 'Plurinational State of Bolivia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BQ', 'NA', 'Bonaire, Sint Eustatius and Saba', 'BES', '535', 'Bonaire, Sint Eustatius and Saba');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BA', 'EU', 'Bosnia and Herzegovina', 'BIH', '070', 'Bosnia and Herzegovina');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BW', 'AF', 'Botswana', 'BWA', '072', 'Republic of Botswana');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BV', 'AN', 'Bouvet Island (Bouvetøya)', 'BVT', '074', 'Bouvet Island (Bouvetøya)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BR', 'SA', 'Brazil', 'BRA', '076', 'Federative Republic of Brazil');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IO', 'AS', 'British Indian Ocean Territory (Chagos Archipelago)', 'IOT', '086', 'British Indian Ocean Territory (Chagos Archipelago)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VG', 'NA', 'British Virgin Islands', 'VGB', '092', 'British Virgin Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BN', 'AS', 'Brunei Darussalam', 'BRN', '096', 'Brunei Darussalam');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BG', 'EU', 'Bulgaria', 'BGR', '100', 'Republic of Bulgaria');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BF', 'AF', 'Burkina Faso', 'BFA', '854', 'Burkina Faso');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BI', 'AF', 'Burundi', 'BDI', '108', 'Republic of Burundi');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KH', 'AS', 'Cambodia', 'KHM', '116', 'Kingdom of Cambodia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CM', 'AF', 'Cameroon', 'CMR', '120', 'Republic of Cameroon');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CA', 'NA', 'Canada', 'CAN', '124', 'Canada');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CV', 'AF', 'Cabo Verde', 'CPV', '132', 'Republic of Cabo Verde');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KY', 'NA', 'Cayman Islands', 'CYM', '136', 'Cayman Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CF', 'AF', 'Central African Republic', 'CAF', '140', 'Central African Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TD', 'AF', 'Chad', 'TCD', '148', 'Republic of Chad');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CL', 'SA', 'Chile', 'CHL', '152', 'Republic of Chile');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CN', 'AS', 'China', 'CHN', '156', 'People''s Republic of China');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CX', 'AS', 'Christmas Island', 'CXR', '162', 'Christmas Island');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CC', 'AS', 'Cocos (Keeling) Islands', 'CCK', '166', 'Cocos (Keeling) Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CO', 'SA', 'Colombia', 'COL', '170', 'Republic of Colombia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KM', 'AF', 'Comoros', 'COM', '174', 'Union of the Comoros');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CD', 'AF', 'Congo', 'COD', '180', 'Democratic Republic of the Congo');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CG', 'AF', 'Congo', 'COG', '178', 'Republic of the Congo');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CK', 'OC', 'Cook Islands', 'COK', '184', 'Cook Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CR', 'NA', 'Costa Rica', 'CRI', '188', 'Republic of Costa Rica');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CI', 'AF', 'Cote d''Ivoire', 'CIV', '384', 'Republic of Cote d''Ivoire');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('HR', 'EU', 'Croatia', 'HRV', '191', 'Republic of Croatia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CU', 'NA', 'Cuba', 'CUB', '192', 'Republic of Cuba');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CW', 'NA', 'Curaçao', 'CUW', '531', 'Curaçao');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CY', 'AS', 'Cyprus', 'CYP', '196', 'Republic of Cyprus');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CZ', 'EU', 'Czechia', 'CZE', '203', 'Czech Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('DK', 'EU', 'Denmark', 'DNK', '208', 'Kingdom of Denmark');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('DJ', 'AF', 'Djibouti', 'DJI', '262', 'Republic of Djibouti');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('DM', 'NA', 'Dominica', 'DMA', '212', 'Commonwealth of Dominica');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('DO', 'NA', 'Dominican Republic', 'DOM', '214', 'Dominican Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('EC', 'SA', 'Ecuador', 'ECU', '218', 'Republic of Ecuador');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('EG', 'AF', 'Egypt', 'EGY', '818', 'Arab Republic of Egypt');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SV', 'NA', 'El Salvador', 'SLV', '222', 'Republic of El Salvador');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GQ', 'AF', 'Equatorial Guinea', 'GNQ', '226', 'Republic of Equatorial Guinea');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ER', 'AF', 'Eritrea', 'ERI', '232', 'State of Eritrea');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('EE', 'EU', 'Estonia', 'EST', '233', 'Republic of Estonia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ET', 'AF', 'Ethiopia', 'ETH', '231', 'Federal Democratic Republic of Ethiopia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('FO', 'EU', 'Faroe Islands', 'FRO', '234', 'Faroe Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('FK', 'SA', 'Falkland Islands (Malvinas)', 'FLK', '238', 'Falkland Islands (Malvinas)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('FJ', 'OC', 'Fiji', 'FJI', '242', 'Republic of Fiji');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('FI', 'EU', 'Finland', 'FIN', '246', 'Republic of Finland');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('FR', 'EU', 'France', 'FRA', '250', 'French Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GF', 'SA', 'French Guiana', 'GUF', '254', 'French Guiana');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PF', 'OC', 'French Polynesia', 'PYF', '258', 'French Polynesia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TF', 'AN', 'French Southern Territories', 'ATF', '260', 'French Southern Territories');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GA', 'AF', 'Gabon', 'GAB', '266', 'Gabonese Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GM', 'AF', 'Gambia', 'GMB', '270', 'Republic of the Gambia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GE', 'AS', 'Georgia', 'GEO', '268', 'Georgia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('DE', 'EU', 'Germany', 'DEU', '276', 'Federal Republic of Germany');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GH', 'AF', 'Ghana', 'GHA', '288', 'Republic of Ghana');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GI', 'EU', 'Gibraltar', 'GIB', '292', 'Gibraltar');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GR', 'EU', 'Greece', 'GRC', '300', 'Hellenic Republic of Greece');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GL', 'NA', 'Greenland', 'GRL', '304', 'Greenland');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GD', 'NA', 'Grenada', 'GRD', '308', 'Grenada');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GP', 'NA', 'Guadeloupe', 'GLP', '312', 'Guadeloupe');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GU', 'OC', 'Guam', 'GUM', '316', 'Guam');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GT', 'NA', 'Guatemala', 'GTM', '320', 'Republic of Guatemala');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GG', 'EU', 'Guernsey', 'GGY', '831', 'Bailiwick of Guernsey');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GN', 'AF', 'Guinea', 'GIN', '324', 'Republic of Guinea');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GW', 'AF', 'Guinea-Bissau', 'GNB', '624', 'Republic of Guinea-Bissau');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GY', 'SA', 'Guyana', 'GUY', '328', 'Co-operative Republic of Guyana');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('HT', 'NA', 'Haiti', 'HTI', '332', 'Republic of Haiti');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('HM', 'AN', 'Heard Island and McDonald Islands', 'HMD', '334', 'Heard Island and McDonald Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VA', 'EU', 'Holy See (Vatican City State)', 'VAT', '336', 'Holy See (Vatican City State)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('HN', 'NA', 'Honduras', 'HND', '340', 'Republic of Honduras');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('HK', 'AS', 'Hong Kong', 'HKG', '344', 'Hong Kong Special Administrative Region of China');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('HU', 'EU', 'Hungary', 'HUN', '348', 'Hungary');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IS', 'EU', 'Iceland', 'ISL', '352', 'Iceland');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IN', 'AS', 'India', 'IND', '356', 'Republic of India');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ID', 'AS', 'Indonesia', 'IDN', '360', 'Republic of Indonesia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IR', 'AS', 'Iran', 'IRN', '364', 'Islamic Republic of Iran');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IQ', 'AS', 'Iraq', 'IRQ', '368', 'Republic of Iraq');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IE', 'EU', 'Ireland', 'IRL', '372', 'Ireland');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IM', 'EU', 'Isle of Man', 'IMN', '833', 'Isle of Man');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IL', 'AS', 'Israel', 'ISR', '376', 'State of Israel');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('IT', 'EU', 'Italy', 'ITA', '380', 'Republic of Italy');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('JM', 'NA', 'Jamaica', 'JAM', '388', 'Jamaica');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('JP', 'AS', 'Japan', 'JPN', '392', 'Japan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('JE', 'EU', 'Jersey', 'JEY', '832', 'Bailiwick of Jersey');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('JO', 'AS', 'Jordan', 'JOR', '400', 'Hashemite Kingdom of Jordan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KZ', 'AS', 'Kazakhstan', 'KAZ', '398', 'Republic of Kazakhstan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KE', 'AF', 'Kenya', 'KEN', '404', 'Republic of Kenya');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KI', 'OC', 'Kiribati', 'KIR', '296', 'Republic of Kiribati');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KP', 'AS', 'Korea', 'PRK', '408', 'Democratic People''s Republic of Korea');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KR', 'AS', 'Korea', 'KOR', '410', 'Republic of Korea');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KW', 'AS', 'Kuwait', 'KWT', '414', 'State of Kuwait');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KG', 'AS', 'Kyrgyz Republic', 'KGZ', '417', 'Kyrgyz Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LA', 'AS', 'Lao People''s Democratic Republic', 'LAO', '418', 'Lao People''s Democratic Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LV', 'EU', 'Latvia', 'LVA', '428', 'Republic of Latvia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LB', 'AS', 'Lebanon', 'LBN', '422', 'Lebanese Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LS', 'AF', 'Lesotho', 'LSO', '426', 'Kingdom of Lesotho');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LR', 'AF', 'Liberia', 'LBR', '430', 'Republic of Liberia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LY', 'AF', 'Libya', 'LBY', '434', 'State of Libya');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LI', 'EU', 'Liechtenstein', 'LIE', '438', 'Principality of Liechtenstein');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LT', 'EU', 'Lithuania', 'LTU', '440', 'Republic of Lithuania');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LU', 'EU', 'Luxembourg', 'LUX', '442', 'Grand Duchy of Luxembourg');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MO', 'AS', 'Macao', 'MAC', '446', 'Macao Special Administrative Region of China');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MG', 'AF', 'Madagascar', 'MDG', '450', 'Republic of Madagascar');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MW', 'AF', 'Malawi', 'MWI', '454', 'Republic of Malawi');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MY', 'AS', 'Malaysia', 'MYS', '458', 'Malaysia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MV', 'AS', 'Maldives', 'MDV', '462', 'Republic of Maldives');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ML', 'AF', 'Mali', 'MLI', '466', 'Republic of Mali');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MT', 'EU', 'Malta', 'MLT', '470', 'Republic of Malta');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MH', 'OC', 'Marshall Islands', 'MHL', '584', 'Republic of the Marshall Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MQ', 'NA', 'Martinique', 'MTQ', '474', 'Martinique');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MR', 'AF', 'Mauritania', 'MRT', '478', 'Islamic Republic of Mauritania');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MU', 'AF', 'Mauritius', 'MUS', '480', 'Republic of Mauritius');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('YT', 'AF', 'Mayotte', 'MYT', '175', 'Mayotte');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MX', 'NA', 'Mexico', 'MEX', '484', 'United Mexican States');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('FM', 'OC', 'Micronesia', 'FSM', '583', 'Federated States of Micronesia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MD', 'EU', 'Moldova', 'MDA', '498', 'Republic of Moldova');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MC', 'EU', 'Monaco', 'MCO', '492', 'Principality of Monaco');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MN', 'AS', 'Mongolia', 'MNG', '496', 'Mongolia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ME', 'EU', 'Montenegro', 'MNE', '499', 'Montenegro');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MS', 'NA', 'Montserrat', 'MSR', '500', 'Montserrat');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MA', 'AF', 'Morocco', 'MAR', '504', 'Kingdom of Morocco');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MZ', 'AF', 'Mozambique', 'MOZ', '508', 'Republic of Mozambique');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MM', 'AS', 'Myanmar', 'MMR', '104', 'Republic of the Union of Myanmar');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NA', 'AF', 'Namibia', 'NAM', '516', 'Republic of Namibia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NR', 'OC', 'Nauru', 'NRU', '520', 'Republic of Nauru');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NP', 'AS', 'Nepal', 'NPL', '524', 'Nepal');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NL', 'EU', 'Netherlands', 'NLD', '528', 'Kingdom of the Netherlands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NC', 'OC', 'New Caledonia', 'NCL', '540', 'New Caledonia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NZ', 'OC', 'New Zealand', 'NZL', '554', 'New Zealand');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NI', 'NA', 'Nicaragua', 'NIC', '558', 'Republic of Nicaragua');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NE', 'AF', 'Niger', 'NER', '562', 'Republic of Niger');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NG', 'AF', 'Nigeria', 'NGA', '566', 'Federal Republic of Nigeria');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NU', 'OC', 'Niue', 'NIU', '570', 'Niue');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NF', 'OC', 'Norfolk Island', 'NFK', '574', 'Norfolk Island');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MK', 'EU', 'North Macedonia', 'MKD', '807', 'Republic of North Macedonia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MP', 'OC', 'Northern Mariana Islands', 'MNP', '580', 'Commonwealth of the Northern Mariana Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('NO', 'EU', 'Norway', 'NOR', '578', 'Kingdom of Norway');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('OM', 'AS', 'Oman', 'OMN', '512', 'Sultanate of Oman');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PK', 'AS', 'Pakistan', 'PAK', '586', 'Islamic Republic of Pakistan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PW', 'OC', 'Palau', 'PLW', '585', 'Republic of Palau');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PS', 'AS', 'Palestine', 'PSE', '275', 'State of Palestine');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PA', 'NA', 'Panama', 'PAN', '591', 'Republic of Panama');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PG', 'OC', 'Papua New Guinea', 'PNG', '598', 'Independent State of Papua New Guinea');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PY', 'SA', 'Paraguay', 'PRY', '600', 'Republic of Paraguay');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PE', 'SA', 'Peru', 'PER', '604', 'Republic of Peru');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PH', 'AS', 'Philippines', 'PHL', '608', 'Republic of the Philippines');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PN', 'OC', 'Pitcairn Islands', 'PCN', '612', 'Pitcairn Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PL', 'EU', 'Poland', 'POL', '616', 'Republic of Poland');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PT', 'EU', 'Portugal', 'PRT', '620', 'Portuguese Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PR', 'NA', 'Puerto Rico', 'PRI', '630', 'Commonwealth of Puerto Rico');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('QA', 'AS', 'Qatar', 'QAT', '634', 'State of Qatar');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('RE', 'AF', 'Réunion', 'REU', '638', 'Réunion');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('RO', 'EU', 'Romania', 'ROU', '642', 'Romania');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('RU', 'EU', 'Russian Federation', 'RUS', '643', 'Russian Federation');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('RW', 'AF', 'Rwanda', 'RWA', '646', 'Republic of Rwanda');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('BL', 'NA', 'Saint Barthélemy', 'BLM', '652', 'Saint Barthélemy');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SH', 'AF', 'Saint Helena, Ascension and Tristan da Cunha', 'SHN', '654', 'Saint Helena, Ascension and Tristan da Cunha');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('KN', 'NA', 'Saint Kitts and Nevis', 'KNA', '659', 'Federation of Saint Kitts and Nevis');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LC', 'NA', 'Saint Lucia', 'LCA', '662', 'Saint Lucia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('MF', 'NA', 'Saint Martin', 'MAF', '663', 'Saint Martin (French part)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('PM', 'NA', 'Saint Pierre and Miquelon', 'SPM', '666', 'Saint Pierre and Miquelon');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VC', 'NA', 'Saint Vincent and the Grenadines', 'VCT', '670', 'Saint Vincent and the Grenadines');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('WS', 'OC', 'Samoa', 'WSM', '882', 'Independent State of Samoa');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SM', 'EU', 'San Marino', 'SMR', '674', 'Republic of San Marino');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ST', 'AF', 'Sao Tome and Principe', 'STP', '678', 'Democratic Republic of Sao Tome and Principe');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SA', 'AS', 'Saudi Arabia', 'SAU', '682', 'Kingdom of Saudi Arabia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SN', 'AF', 'Senegal', 'SEN', '686', 'Republic of Senegal');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('RS', 'EU', 'Serbia', 'SRB', '688', 'Republic of Serbia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SC', 'AF', 'Seychelles', 'SYC', '690', 'Republic of Seychelles');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SL', 'AF', 'Sierra Leone', 'SLE', '694', 'Republic of Sierra Leone');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SG', 'AS', 'Singapore', 'SGP', '702', 'Republic of Singapore');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SX', 'NA', 'Sint Maarten (Dutch part)', 'SXM', '534', 'Sint Maarten (Dutch part)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SK', 'EU', 'Slovakia (Slovak Republic)', 'SVK', '703', 'Slovakia (Slovak Republic)');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SI', 'EU', 'Slovenia', 'SVN', '705', 'Republic of Slovenia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SB', 'OC', 'Solomon Islands', 'SLB', '090', 'Solomon Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SO', 'AF', 'Somalia', 'SOM', '706', 'Federal Republic of Somalia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ZA', 'AF', 'South Africa', 'ZAF', '710', 'Republic of South Africa');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GS', 'AN', 'South Georgia and the South Sandwich Islands', 'SGS', '239', 'South Georgia and the South Sandwich Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SS', 'AF', 'South Sudan', 'SSD', '728', 'Republic of South Sudan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ES', 'EU', 'Spain', 'ESP', '724', 'Kingdom of Spain');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('LK', 'AS', 'Sri Lanka', 'LKA', '144', 'Democratic Socialist Republic of Sri Lanka');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SD', 'AF', 'Sudan', 'SDN', '729', 'Republic of Sudan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SR', 'SA', 'Suriname', 'SUR', '740', 'Republic of Suriname');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SJ', 'EU', 'Svalbard & Jan Mayen Islands', 'SJM', '744', 'Svalbard & Jan Mayen Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SZ', 'AF', 'Eswatini', 'SWZ', '748', 'Kingdom of Eswatini');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SE', 'EU', 'Sweden', 'SWE', '752', 'Kingdom of Sweden');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('CH', 'EU', 'Switzerland', 'CHE', '756', 'Swiss Confederation');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('SY', 'AS', 'Syrian Arab Republic', 'SYR', '760', 'Syrian Arab Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TW', 'AS', 'Taiwan', 'TWN', '158', 'Taiwan, Province of China');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TJ', 'AS', 'Tajikistan', 'TJK', '762', 'Republic of Tajikistan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TZ', 'AF', 'Tanzania', 'TZA', '834', 'United Republic of Tanzania');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TH', 'AS', 'Thailand', 'THA', '764', 'Kingdom of Thailand');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TL', 'AS', 'Timor-Leste', 'TLS', '626', 'Democratic Republic of Timor-Leste');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TG', 'AF', 'Togo', 'TGO', '768', 'Togolese Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TK', 'OC', 'Tokelau', 'TKL', '772', 'Tokelau');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TO', 'OC', 'Tonga', 'TON', '776', 'Kingdom of Tonga');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TT', 'NA', 'Trinidad and Tobago', 'TTO', '780', 'Republic of Trinidad and Tobago');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TN', 'AF', 'Tunisia', 'TUN', '788', 'Tunisian Republic');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TR', 'AS', 'Türkiye', 'TUR', '792', 'Republic of Türkiye');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TM', 'AS', 'Turkmenistan', 'TKM', '795', 'Turkmenistan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TC', 'NA', 'Turks and Caicos Islands', 'TCA', '796', 'Turks and Caicos Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('TV', 'OC', 'Tuvalu', 'TUV', '798', 'Tuvalu');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('UG', 'AF', 'Uganda', 'UGA', '800', 'Republic of Uganda');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('UA', 'EU', 'Ukraine', 'UKR', '804', 'Ukraine');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('AE', 'AS', 'United Arab Emirates', 'ARE', '784', 'United Arab Emirates');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('GB', 'EU', 'United Kingdom of Great Britain and Northern Ireland', 'GBR', '826', 'United Kingdom of Great Britain & Northern Ireland');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('US', 'NA', 'United States of America', 'USA', '840', 'United States of America');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('UM', 'OC', 'United States Minor Outlying Islands', 'UMI', '581', 'United States Minor Outlying Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VI', 'NA', 'United States Virgin Islands', 'VIR', '850', 'United States Virgin Islands');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('UY', 'SA', 'Uruguay', 'URY', '858', 'Eastern Republic of Uruguay');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('UZ', 'AS', 'Uzbekistan', 'UZB', '860', 'Republic of Uzbekistan');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VU', 'OC', 'Vanuatu', 'VUT', '548', 'Republic of Vanuatu');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VE', 'SA', 'Venezuela', 'VEN', '862', 'Bolivarian Republic of Venezuela');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('VN', 'AS', 'Vietnam', 'VNM', '704', 'Socialist Republic of Vietnam');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('WF', 'OC', 'Wallis and Futuna', 'WLF', '876', 'Wallis and Futuna');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('EH', 'AF', 'Western Sahara', 'ESH', '732', 'Western Sahara');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('YE', 'AS', 'Yemen', 'YEM', '887', 'Yemen');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ZM', 'AF', 'Zambia', 'ZMB', '894', 'Republic of Zambia');
INSERT INTO countries (code, continent_code, name, iso3, nbr, full_name) VALUES ('ZW', 'AF', 'Zimbabwe', 'ZWE', '716', 'Republic of Zimbabwe');
commit;

type: custom:auto-entities
card:
type: entities
filter:
template: |-
{% set SENSOR = 'device_tracker.life360_papa' -%}
{%- for attr in states[SENSOR].attributes -%}
{{
{
'type': 'attribute',
'entity': SENSOR,
'attribute': attr,
'name': attr
}
}},
{%- endfor %}

Activer à la mano le mode userspace de systemd pour certains utilisateurs

[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)

\n# [ $LOGNAME@\h:$PWD [\t] [ohvers SID:${ORACLE_SID:-"no sid"}] ]\n#

Il y a aussi l’astuce pour voir si un ID Parrot est enregistré ( test sur un seul)
dans services Rfplayer mettre dans « device_adresss » l’identité et sa cde, si ok voir log
ici Mode YAML
en Mode UI
Log en TXT
Log en XML
Si la cde ou l'ID n'existe pas ici (OFF)

le log ne remonte pas d’info derriere « /reqNum> »

Log en XML avec un faut ID ou cde
En supplément la fonction Apprentissage du Parrot depuis HA

Dans l’outil de développement ‹ services › du GCE RFPlayer: send_command

    Vous pouvez faire en mode YAML (plus simple)
    il faut → automatic_add: false
    il faut-> protocol: '' <----cela n’est pas possible en mode UI

    dans la partie " command: " c’est là que nous entrons

    la commande à enregistrée avec son ID

    sa fonction

    et le message de rappel de sa fonction si besoin (reminder) maxi 30 caracteres entre crochet [message] POSSIBLE QUE DE A1 à B16

Exemple pour moi apprendre une commande ON, pour Mettre en fonction ma pompe, dans l’ID « B10 »
j’ai mis trop de caracteres dans le message d’info donc sera tronqué (Pompe Puit ON_ALL 0125C5CE - 1)
Exemple en mode YAML

service: rfplayer.send_command
data:
automatic_add: false
command: PARROTLEARN B10 ON [Pompe Puit ON_ALL 0125C5CE - 1232171904]
protocol: ''

image
image1156×308 16.2 KB

Si appuie sur APPELER LE SERVICE le RFPLAYER passe en attente d’envoie de code ( il faut être assez prés 50cm /1 m suivant la puissance de l’émetteur)
Info de Ziblue mode Parrot apprentissage

Il vous reste a initier cette commande PARROT dans HA qui produira un switch.parrot_« x »
Rappel méthode

Donc dans la page intégration du RFPLAYER on doit retrouver notre switch.parrot_b10 ( j’ai déjà renommer et mis icône)
switch.parrot_b10

Si on a un ON et un OFF ( en mode Parrot) on peut passé aussi par « /config/switch.yaml »
et ajouter un switch avec les commandes ON et OFF

• platform: template
  switches:
  pompepuit:
  friendly_name: 'Pompe Puit ON OFF Rfplayer'
  turn_on:
  service: rfplayer.send_command
  data:
  command: 'ON'
  protocol: PARROT
  automatic_add: false
  device_address: B10
  turn_off:
  service: rfplayer.send_command
  data:
  command: 'OFF'
  protocol: PARROT
  automatic_add: false
  device_address: B1

On devrait retrouver après redémarrage notre identité dans une carte bouton cela donne :
image
image897×534 26.2 KB

image

@+DÕ¿ÕM

sudo apt-get update 2>&1 | sed -ne 's?^.*NO_PUBKEY ??p' | xargs -r -- sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys

docker run --rm -v some_volume:/volume -v /tmp:/backup alpine tar -cjf /backup/some_archive.tar.bz2 -C /volume ./

And to restore it, just run:

docker run --rm -v some_volume:/volume -v /tmp:/backup alpine sh -c "rm -rf /volume/ /volume/..? /volume/.[!.]* ; tar -C /volume/ -xjf /backup/some_archive.tar.bz2"

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.