JDE - Schedule jobs, Daylight Savings Rules

原由:

It looks like there’s some issue with the daylight saving time for US Eastern Time zone.  Our schedule jobs for Easter Time Zone are running one hour late starting yesterday, Oct 28.  The US daylight savings time ends at this Sunday, Nov 3^rd.  Can you please adjust the system to reflect the correct time?

This is the US daylight saving time rule:

·     begins at 2:00 a.m. on the second Sunday of March and

·     ends at 2:00 a.m. on the first Sunday of November

Solution:

1.       先用 P983051 找到 該地區所使用的 P91300 的version，確認使用的是哪一個Daylight Savings Rule。
2.      再用 P00085 來調整該 Daylight Savings Rule的細節。

1. 
   

Giant 捷安特 公路車的分類 - 使用概念構圖

Giant 捷安特的公路車，種類繁多，只看網頁會不知道如何選擇。我做了一個簡單的分類表格，用概念構圖的方式來表達，可以幫助消費者來選擇到自己需要的公路車產品。

JDE - 如何讓修改過的batch version 生效? How to submit version specs?

• 如何讓修改(data selection, processing option)過的batch version 生效?

1. Build and deploy an update package or 

2. Do a submit version specs even if you update the data selection from web client.

The only difference between update data selection from web client and fat client is you do not need to check in and check out on the web client.

• How to bumit version specs?

To submit version specs, 

1. select the version from BV
2. go to Form->Advanced and select Submit Version Specifications Only 
3. submit the UBE version to the server

JDE - Default job queue

1. 從fat client 設定 default job queue

2. 如果要仔細控制每一個Batch Version執行的job queue

You can assign a job queue to a batch version. You need to first check out the version using BV and then go to Row Exit Version Detail. That is the place to define the job queue. Remember to check it in and build and deploy an update package after you have finished defining the job queue.

JDE - 如何設定 Inactive Timeout (session timeout)

1. For OAS 10.1.3:

修改OAS Session timeout value 

Log in to the Oracle Enterprise Manager

Select your OC4J container
Click on "Applications" Link
Click on link for your E1 JAS OC4J, Ex: "EA_JS_81"
Click on the link for webmodule, "webclient"
Click on link for "Administration"
Under "Go to Task" column, click on icon for "Configuration Properties"
Set the Session timeout value in Seconds
Restart the OC4J instance

Session timeout value  => 3600

Update the UserSession value in the relevant JAS.INI:

EnterpriseOne HTML Server -> Instance Name -> Configuration -> Web Runtime ->  Cache Configuration -> User Session Cache Timeout -> 5400000

修改Http Server Timeout值

修改Http Server Timeout值 => 5400

/u01/OracleAS_1/Apache/Apache/conf/httpd.conf

2. For Oracle WebLogic Server (WLS)

Modify the web.xml and restart the instance  - default 60mins

The web.xml file is missing the session-timeout descriptors.  The session defaults to 1 hour.

[root@e1wls04 u01]# find . -name 'web.xml'|grep webclient.war 

./oracle/Middleware/user_projects/domains/PD_e1wls04/servers/PD900_e1wls04/stage/PD_e1wls04/app/webclient.war/WEB-INF/web.xml
./JDE_HOME/targets/PD_e1wls04/owl_deployment/webclient.ear/app/webclient.war/WEB-INF/web.xml

Make a backup of the above two web.xml files. Add the following stanza at the end (right before </web-app>) of both these web.xml files:

<session-config>
<session-timeout>60</session-timeout>
</session-config>

NOTE:
The DOWNSIDE of this extensive timeout value is that the user session will be kept in memory for a longer time which in turn the JVM will support fewer sessions.  If more sessions get created (more users login) and remain in memory for a longer time there is a chance that an OutOfMemory condition will be reached.  Consider fewer users per (JVM) JAS instance if user sessions are going to be "alive" for a longer time.  Oracle Support recommends a timeout value of 30 minutes with 60 minutes being the high end.

Update the UserSession value in the relevant JAS.INI:

EnterpriseOne HTML Server -> Instance Name -> Configuration -> Web Runtime ->  Cache Configuration -> User Session Cache Timeout -> 5400000

Linux Server - upgrade and 指定要boot的os image file

yum：
CentOS 與 Fedora 所常用的自動升級機制，透過 FTP 或 WWW 來進行線上升級以及線上直接安裝套件；
up2date：
這是 Red Hat 所使用的自動升級機制，需要註冊才能使用，並且依據付費與否而管制其流量；

//****************************************************************************
mount -o ro,loop /source/Enterprise-R5-U5-Server-x86_64-dvd.iso /mnt

vi /etc/yum.repos.d/local.repo
[local]
name=local
baseurl=file:///mnt/Server/
enabled=1
gpgcheck=0

yum repolist

yum list update

yum update

shutdown -r now


//*****************************************************************************




Oracle Linux 5
# cd /etc/yum.repos.d
# wget https://public-yum.oracle.com/public-yum-el5.repo

# grep -B 5 enabled=1 public-yum-el5.repo

Oracle Linux 6
# cd /etc/yum.repos.d
# wget https://public-yum.oracle.com/public-yum-ol6.repo

Oracle VM 2
# cd /etc/yum.repos.d
# wget https://public-yum.oracle.com/public-yum-ovm2.repo

Enable the appropriate repository by editing the yum configuration file

Open the yum configuration file in a text editor
Locate the section in the file for the repository you plan to update from, e.g. [el4_u6_base]
Change enabled=0 to enabled=1
Begin using yum, for example:

yum repolist --to show the registered channels and you see we are including everything including the latest published RPMs.

yum list

yum install firefox



//*****************************************************************************



Reference:

1. yum upgrade - OL5_u5 to OL5_u6:
http://surachartopun.com/2011/01/yum-upgrade-ol5u5-to-ol5u6.html

2. http://husnusensoy.wordpress.com/2013/02/13/upgrade-to-oracle-enterprise-linux-5-9-andso-uek2/


Oracle Linux: Upgrade between major releases is not supported (Doc ID 821668.1)


//*****************************************************************************

Bootloader default 會找第一個 Title，可以修改 default來做指定。

[root@testdb4 grub]# pwd
/boot/grub

[root@testdb4 grub]# more grub.conf

# grub.conf generated by anaconda
#
# Note that you do not have to rerun grub after making changes to this file
# NOTICE:  You have a /boot partition.  This means that
#          all kernel and initrd paths are relative to /boot/, eg.
#          root (hd0,0)
#          kernel /vmlinuz-version ro root=/dev/VolGroup00/LogVol00
#          initrd /initrd-version.img
#boot=/dev/xvda
default=0   <== default會找第一個title
timeout=5
splashimage=(hd0,0)/grub/splash.xpm.gz
hiddenmenu
title Oracle Linux Server (2.6.18-274.el5xen)
        root (hd0,0)
        kernel /vmlinuz-2.6.18-274.el5xen ro root=/dev/VolGroup00/LogVol00 rhgb quiet numa=off
        initrd /initrd-2.6.18-274.el5xen.img
title Oracle Linux Server (2.6.32-200.13.1.el5uek)
        root (hd0,0)
        kernel /vmlinuz-2.6.32-200.13.1.el5uek ro root=/dev/VolGroup00/LogVol00 rhgb quiet numa=off
        initrd /initrd-2.6.32-200.13.1.el5uek.img
title Enterprise Linux (2.6.18-194.el5xen)
        root (hd0,0)
        kernel /vmlinuz-2.6.18-194.el5xen ro root=/dev/VolGroup00/LogVol00 rhgb quiet numa=off
        initrd /initrd-2.6.18-194.el5xen.img

DR 異地備援 - windows server 適用的超低成本方案

你們公司有沒有花大錢做DR? 
檔案異地抄寫? 
頻寬不足怎麼辦? 

分享各位一個妙招，尤其適用windows server。
1. 將主機先做虛擬化，一式兩份。 A1 -> A2 and A3
2. A2放到同機房，A3放到異地機房。
3. 在A2 and A3上面安裝dropbox軟體。
4. 在A2，安裝fastcopy，將A1需要傳送到異地的資料，作差異同步到A2的dropbox folder。
5. 這些檔案，就會利用dropbox的同步機制，自動複製一份到雲端，也會複製一份到remote site的A3。

版權沒有，歡迎引用，設定成功後請我喝咖啡即可。