JDE 64 Bit Full Package

 

In order to do first 64 Bit Full package for Fresh Install (when 32 bit Package not build), then add these specs to Base Full package. 

Add Specs to Full Package -
INSERT INTO DV920.F98710DV920FA SELECT * FROM DV920.F98710 WHERE THOBNM = 'F00942T';
INSERT INTO DV920.F98710DV920FA SELECT * FROM DV920.F98710 WHERE THOBNM = 'F98780R';
INSERT INTO DV920.F98710DV920FA SELECT * FROM DV920.F98710 WHERE THOBNM = 'F98780H';

INSERT INTO DV920.F98711DV920FA SELECT * FROM DV920.F98711 WHERE TDOBNM = 'F00942T';
INSERT INTO DV920.F98711DV920FA SELECT * FROM DV920.F98711 WHERE TDOBNM = 'F98780R';
INSERT INTO DV920.F98711DV920FA SELECT * FROM DV920.F98711 WHERE TDOBNM = 'F98780H';

INSERT INTO DV920.F98712DV920FA SELECT * FROM DV920.F98712 WHERE TPOBNM = 'F00942T';
INSERT INTO DV920.F98712DV920FA SELECT * FROM DV920.F98712 WHERE TPOBNM = 'F98780R';
INSERT INTO DV920.F98712DV920FA SELECT * FROM DV920.F98712 WHERE TPOBNM = 'F98780H';

INSERT INTO DV920.F98713DV920FA SELECT * FROM DV920.F98713 WHERE TLOBNM = 'F00942T';
INSERT INTO DV920.F98713DV920FA SELECT * FROM DV920.F98713 WHERE TLOBNM = 'F98780R';
INSERT INTO DV920.F98713DV920FA SELECT * FROM DV920.F98713 WHERE TLOBNM = 'F98780H';

Start Weblogic Admin Server, Node Manager and Server Manager Agent on Linux

 

Start Weblogic Admin Server, Node Manager and Server Manager Agent on Linux

1 Create system service files:

1.1 adminserver system service file

# vi /usr/lib/systemd/system/wls_adminserver.service

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

[Unit]

Description=WebLogic Adminserver Service

After=network.target 

[Service]

Type=simple

WorkingDirectory=/apps/oracle/middleware/user_projects/domains/E1_HTTP

ExecStart=/apps/oracle/middleware/user_projects/domains/E1_HTTP/bin/startWebLogic.sh

ExecStop=/apps/oracle/middleware/user_projects/domains/E1_HTTP/stopWebLogic.sh

User=oracle

Group=oinstall

[Install]

WantedBy=multi-user.target

1.2 nodemanager system service file

# vi /usr/lib/systemd/system/wls_nodemanager.service

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

[Unit]

Description=WebLogic NodeManager Service

After=network.target 

[Service]

Type=simple

WorkingDirectory=/apps/oracle/middleware/user_projects/domains/E1_HTTP

ExecStart=/apps/oracle/middleware/user_projects/domains/E1_HTTP/bin/startNodeManager.sh

ExecStop=/apps/oracle/middleware/user_projects/domains/E1_HTTP/bin/stopNodeManager.sh

User=oracle

Group=oinstall

[Install]

WantedBy=multi-user.target

1.3 JDE SM Agent system service file

# vi /usr/lib/systemd/system/wls_smagent.service

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

[Unit]

Description=Server Manager Agent Service

After=network.target

[Service]

Type=oneshot

WorkingDirectory=/apps/jde_home_agent/SCFHA

ExecStart=/apps/jde_home_agent/SCFHA/bin/startAgent

ExecStop=/apps/jde_home_agent/SCFHA/bin/stopAgent

RemainAfterExit=yes

User=oracle

Group=oinstall

[Install]

WantedBy=multi-user.target

3) Test the system service :

3.1 start system service

# systemctl start wls_adminserver.service

# systemctl start wls_nodemanager.service

# systemctl start wls_smagent.service

3.2 stop system service

# systemctl stop wls_adminserver.service

# systemctl stop wls_nodemanager.service

# systemctl stop wls_smagent.service

4) Set the service to start automatically at systm reboot :

# systemctl enable wls_adminserver.service

# systemctl enable wls_nodemanager.service

# systemctl enable wls_smagent.service

# systemctl list-unit-files|grep wls

JDE Julian and Calendar Date

JDE Excel Date Conversion

Julain to Gregorian Date

=DATE(YEAR("01/01/"&TEXT(1900+INT(A1/1000),0)),MONTH("01/01/"&TEXT(1900+INT(A1/1000),0)),DAY("01/01/"&TEXT(1900+INT(A1/1000),0)))+MOD(A1,1000)-1

Gregorian to Julian

=(YEAR(A1)-2000+100)*1000+A1-DATE(YEAR(A1),"01","01")+1

Linux Change Time Zone

 

1. View Time Zone 

Timedatectl

2. List Time Zone

timedatectl list-timezones

timedatectl list-timezones |grep Denver

timedatectl list-timezones | grep York

3. Set Time Zone

Based on timezone value need to set here is eg to set Denver or New York Time Zone

timedatectl set-timezone America/Denver

timedatectl set-timezone America/New_York

4.View Time Zone to verify timezone is set as required

Timedatectl

Reference - https://linuxize.com/post/how-to-set-or-change-timezone-in-linux/

JDE OMW SQL

 

To see List of Object 

1. List of Object Not-Checked Out and No- Token

SELECT FROM SY920.F98222 WHERE POOMWCHS='0' AND 'POOOMWOST='02' AND POOMWPOS1='0' AND POOMWPON1=0 AND POOMWPRJID='Project Name'

2. List of Object Not-Checked Out but have Token

SELECT FROM SY920.F98222 WHERE POOMWCHS='0' AND 'POOOMWOST='02' AND POOMWPOS1='1' AND POOMWPRJID='Project Name'

3. List of Object Checked Out and have Token

SELECT FROM SY920.F98222 WHERE POOMWCHS='1' AND 'POOOMWOST='03' AND POOMWPOS1='1' AND POOMWPRJID='Project Name'

4.  JDE OMW Token Release using SQL

UPDATE  SY920.F98222  SET POOMWPOS1='0',POOMWPON1=0 WHERE POOMWOST='02' AND POOMWPOS1='1'  AND POOMWPRJID LIKE '%2022%'

Print Weblogic Java GC Detail

 

Print GC Detail for Java  in Weblogic. Add this parameter in  server start section of Managed Server and restart service

Create Folder D:\Temp\GCLOG

 -Xloggc:D:\Temp\GCLOG\Prod_3278.log -verbose:gc -XX:+PrintGCDateStamps -XX:-PrintGCDetails

Restart Service and see GC logs in D:\Temp\GCLOG

To View Log you can see in Power Shell also using 

cd  D:\Temp\GCLOG

Get-Content -Path Prod_3278.log -Tail 50