顯示具有 JDE 標籤的文章。 顯示所有文章
顯示具有 JDE 標籤的文章。 顯示所有文章

2014年5月8日 星期四

2014年3月4日 星期二

JDE - Apply POC patch for RIGHT_CLICK_COPYPASTE

--e1oas03

cd /u01/OracleAS_1/j2ee/PD_e1oas03/applications/PD_e1oas03/webclient

/bin/cp -p ./WEB-INF/lib/E1Menu_JAR.jar /u01/backup/20140304_POC
/bin/cp -p ./WEB-INF/lib/Maf2Extensions_JAR.jar /u01/backup/20140304_POC
/bin/cp -p ./js/JSGridMessageHandler.js /u01/backup/20140304_POC
/bin/cp -p ./js/jdeMenu.js /u01/backup/20140304_POC
/bin/cp -p ./js/Form.js /u01/backup/20140304_POC

ll /u01/backup/20140304_POC
ll /u01/POC/20120213_RIGHT_CLICK_COPYPASTE

/bin/cp -f /u01/POC/20120213_RIGHT_CLICK_COPYPASTE/*.jar ./WEB-INF/lib/

/bin/cp /u01/POC/20120213_RIGHT_CLICK_COPYPASTE/*.js ./js/

OAS - 如何調整OAS使用的初始記憶體


如何調整OAS使用的初始記憶體

[root@e1oas03 ~]# ps -ef|grep PD
oracle    3751  3702  0 Feb27 ?        00:06:57 /u01/OracleAS_1/jdk/bin/java -server -Djava.security.policy=/u01/OracleAS_1/j2ee/PD_e1oas03/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -XX:MaxPermSize=128m -Xms32m -Xmx768m -Doracle.ons.oraclehome=/u01/OracleAS_1 -Doracle.home=/u01/OracleAS_1 -Doracle.ons.oracleconfighome=/u01/OracleAS_1 -Doracle.ons.clustername=default -Doracle.ons.instancename=OracleAS_1.e1oas03.rgp.raritan.com -Dopmn.compatible=904 -Doracle.ons.indexid=PD_e1oas03.default_group.1 -Doracle.ons.numprocs=1 -Doracle.ons.uid=208867310 -Doracle.oc4j.groupname=default_group -Doracle.oc4j.instancename=PD_e1oas03 -Doracle.oc4j.islandname=default_group -Doracle.opmn.routingid=g_rt_id -DOPMN=true -jar oc4j.jar -config /u01/OracleAS_1/j2ee/PD_e1oas03/config/server.xml -properties -ports default-web-site:ajp:12501,rmi:12401,rmis:12701,jms:12601

Server Manager: PD_e1oas03 Java Environment Runtime Detail 
Heap Memory Used (Bytes)
18866208
Committed Heap Memory Size (Bytes)
33488896
Maximum Allowed Memory Size (Bytes)
775487488

[root@e1oas01 ~]# ps -ef|grep PD
root      3929  3791  2 Mar02 ?        00:52:28 /u01/OracleAS_1/jdk/bin/java -server -Xmx1024m -Xms1024m -Djava.security.policy=/u01/OracleAS_1/j2ee/PD_e1oas01/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -XX:MaxPermSize=128m -Doracle.ons.oraclehome=/u01/OracleAS_1 -Doracle.home=/u01/OracleAS_1 -Doracle.ons.oracleconfighome=/u01/OracleAS_1 -Doracle.ons.clustername=default -Doracle.ons.instancename=OracleAS_1.e1oas01.rgp.raritan.com -Dopmn.compatible=904 -Doracle.ons.indexid=PD_e1oas01.default_group.1 -Doracle.ons.numprocs=1 -Doracle.ons.uid=1843732547 -Doracle.oc4j.groupname=default_group -Doracle.oc4j.instancename=PD_e1oas01 -Doracle.oc4j.islandname=default_group -Doracle.opmn.routingid=g_rt_id -DOPMN=true -jar oc4j.jar -config /u01/OracleAS_1/j2ee/PD_e1oas01/config/server.xml -properties -ports default-web-site:ajp:12501,rmi:12401,rmis:12701,jms:12601

Server Manager: PD_e1oas01 Java Environment Runtime Detail 
Heap Memory Used (Bytes)
720447720
Committed Heap Memory Size (Bytes)
999358464
Maximum Allowed Memory Size (Bytes)
1034027008 

[root@e1oas02 ~]# ps -ef|grep PD
root      3895  3768  0 Mar02 ?        00:19:58 /u01/OracleAS_1/jdk/bin/java -server -Xmx1024m -Xms1024m -Djava.security.policy=/u01/OracleAS_1/j2ee/PD_e1oas02/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -XX:MaxPermSize=128m -Doracle.ons.oraclehome=/u01/OracleAS_1 -Doracle.home=/u01/OracleAS_1 -Doracle.ons.oracleconfighome=/u01/OracleAS_1 -Doracle.ons.clustername=default -Doracle.ons.instancename=OracleAS_1.e1oas02.rgp.raritan.com -Dopmn.compatible=904 -Doracle.ons.indexid=PD_e1oas02.default_group.1 -Doracle.ons.numprocs=1 -Doracle.ons.uid=745174371 -Doracle.oc4j.groupname=default_group -Doracle.oc4j.instancename=PD_e1oas02 -Doracle.oc4j.islandname=default_group -Doracle.opmn.routingid=g_rt_id -DOPMN=true -jar oc4j.jar -config /u01/OracleAS_1/j2ee/PD_e1oas02/config/server.xml -properties -ports default-web-site:ajp:12503,rmi:12403,rmis:12703,jms:12603

Server Manager: PD_e1oas02 Java Environment Runtime Detail 
Heap Memory Used (Bytes)
902440864
Committed Heap Memory Size (Bytes)
995164160
Maximum Allowed Memory Size (Bytes)
1034027008 

修改方式:

登入application control   http://e1oas03:7777/em/console/








這個步驟之後要restart linux server
shutdown -r now


確認修改之後的結果


[root@e1oas03 ~]# ps -ef|grep PD
oracle    3750  3700 15 05:25 ?        00:00:16 /u01/OracleAS_1/jdk/bin/java -server -Xmx1024m -Xms1024m -Djava.security.policy=/u01/OracleAS_1/j2ee/PD_e1oas03/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -XX:MaxPermSize=128m -Doracle.ons.oraclehome=/u01/OracleAS_1 -Doracle.home=/u01/OracleAS_1 -Doracle.ons.oracleconfighome=/u01/OracleAS_1 -Doracle.ons.clustername=default -Doracle.ons.instancename=OracleAS_1.e1oas03.rgp.raritan.com -Dopmn.compatible=904 -Doracle.ons.indexid=PD_e1oas03.default_group.1 -Doracle.ons.numprocs=1 -Doracle.ons.uid=208867341 -Doracle.oc4j.groupname=default_group -Doracle.oc4j.instancename=PD_e1oas03 -Doracle.oc4j.islandname=default_group -Doracle.opmn.routingid=g_rt_id -DOPMN=true -jar oc4j.jar -config /u01/OracleAS_1/j2ee/PD_e1oas03/config/server.xml -properties -ports default-web-site:ajp:12501,rmi:12402,rmis:12702,jms:12602


2014年1月16日 星期四

JDE - issue, reserved by xxx

It's the JDE system behavior to provide the application/data consistency. When one session is editing/processing specific data entry, other sessions could not change the same data entry, even using same JDE account. This situation(reserved by xxx) could caused by program design, system operation method or web browser  timeout.

Refer to document: User Record Reservations P00095

2013年12月11日 星期三

JDE - E1 Web Client ActiveX Controls for Media Object and Grid Export / Import FAIL WITH INTERNET EXPLORER X64



Why 64-bit IE doesn’t work on JDE? Any solution for this?
è 可以使用 64-bit IE,但是因為JDE ActiveX contrls 無法支援64-bit IE,所以用到以下兩個功能時有限制。
n   Media Object
n   Grid Export/Import
 è If you use ActiveX controls, use the 32-bit edition of Internet Explorer instead of the 64-bit edition.

IE10 is another issue we have discussed but no conclusion yet.

è IE10 Support begins with 8.98.4.12


32-bit IE9

64-bit IE9



可以查看以下文件:
A. E1: MOBJ: Working with E1 Web Client ActiveX Controls for Media Object and Grid Export / Import (Doc ID 1056203.1)
It does not matter if you are using a 64-bit Windows OS or not. A 32-bit Internet Explorer browser must be used. ActiveX controls are not yet supported with the 64-bit browser. See Bug 12973392 ACTIVEX CONTROL FAIL WITH INTERNET EXPLORER X64


Manual install / File Location on Server

As an example, files jdeexpimpU.cab or jdewebctlsU.cab, are stored on the JAS server in the following location:

http://<JAS_SERVER_NAME/jde/axctls/

example path on weblogic server
C:\jde_home\SCFHA\targets\<instance>\owl_deployment\webclient.ear\app\webclient.war\axctls

There are two files in the E1 web install directory:
    For 8.95 and below, the files are jdewww/axctls/jdeexpimp.cab (for active x control for import/export) and jdewww/axctls/jdewebctls.cab (for active x control for media objects).
    For 8.96 and above, the file names are jdeexpimpU.cab and jdewebctlsU.cab.
You can find them on the JAS server too, under /webclient/web/axctls.
The ActiveX control install files are OCX files within those cab archives.


  1. 在PY_e1oas01上面 To enable the HTML rich text editor set the value of SupportActiveXIE to FALSE in the jas.ini under the [OWWEB] section or Unselect the "Use ActiveX Controls" check box under the server manager web runtime properties.
  2. Restart PY_e1oas02 to let the change effective
  3. Using 32-bit IE9 connect to PY_e1oas01,可以使用 HTML rich text editor 來新增 Text File
  4. Using 64-bit IE9 connect to PY_e1oas01,可以使用 HTML rich text editor 來新增 Text File - Text3
  5. 相同的設定在 PY_e1oas03上面做一次,在開啟檔案時出現" Internet Explorer 無法顯示網頁"的錯誤訊息,可能需要重新deploy instance來看看,可否解決這個問題。
  6. There are differences in the activeX (RTF) and ADF HTML editor.  Once you switch a file from ActiveX to HTML, there will be a change in the text file format.  This is due to font limitations.  Once a file is converted to HTML, or created via HTML, it will be read only with ActiveX.

因為 Export to excel randomly fails with SupportActiveXIE set to FALSE
When exporting data to Excel using the ALL option, most of the times it does not work, the user receives a blank excel worksheet .This only occurs with Internet Explorer and not on Firefox and is reported with Bug 13391456 GRID EXPORT TO EXCEL FAILS IN NON-ACTIVEX MODE - INTERMITTENT ISSUE and is fixed in Tools Release 8.98.4.7.
所以最好upgrade Tools Release 到8.98.4.12之後,再來試著用 SupportActiveXIE set to FALSE



B. E1: JAS: Web Browser Master Checklist for Internet Explorer (Doc ID 1267490.1)

Internet Explorer Notes on ActiveX Controls:

  •  Internet Explorer 64-bit browser is not supported.  The ActiveX controls are currently only built for use with Internet Explorer 32-bit version provided with a Windows 32-bit or x64 installation.  

C. Bug 12973392 : ACTIVEX CONTROL FAIL WITH INTERNET EXPLORER X64

POTENTIAL WORKAROUNDS
  =====================
  Use 32-bit Internet Explorer browser






D. JD Edwards EnterpriseOne 9.1.X Web Client Support Statement (Doc ID 1487909.1)

For certain functionality, such as Media Objects or Exporting from the Grid to Microsoft Excel, JD Edwards EnterpriseOne uses 32-bit ActiveX controls.  If you use ActiveX controls, use the 32-bit edition of Internet Explorer instead of the 64-bit edition. For more information about 32-bit and 64-bit Internet Explorer, refer to Microsoft Knowledge Base Article #896457.




Grid Export / Import








JDE - 升級 upgrade Tools Release to 9.1 with application still 9.0

如果要升級到tools release 9.1 with application 9.0,我目前理解的步驟是:
Steps:
1.      目前主要的HTML Server 都要從 Oracle Application Server改成 WebLogic Server (重新安裝)
2.      升級Enterprise server and DB server OS,從 OEL5U2 à OEL5U5
3.      升級Database 兩版本,從11.2.0.1 à 11.2.0.3
4.      在升級Tools Release 之前,要完成component更新 安裝 5 ESU (TL913001JL21519, JL21835, JL21683, JL21509, JL18390)
5.      依序升級新版Tools Release for
l   Server Manager
l   Enterprise Server
l   WLS
l   Deployment Server
6.      Check and the know issues with tools 8.1.3 can be fixed or ignored  “Tools 9.1 Update 3 Known Issues and Workarounds (Doc ID 1543253.1).xlsx”
7.      Full package build and deploy
8.      Training User to be familiar with new version UI
9.      Testing

如果只是單純要支援IE10,簡單升級 tools release 8.98.4.6 à 8.98.4.12即可支援。
Steps:
1.      依序升級新版Tools Release for
l   Server Manager
l   Enterprise Server
l   WLS
l   Deployment Server
2.      Full package build and deploy

3.      Testing


Comparison between tools release 8.98.x and 9.1.x: 



Remark 1: Two one off patches are needed to be applied manually
1. Disable Row Exit Menu on right click
2. xxxxxx

Remark 2: Due to the way javascript (.js) files are managed by the browser, it is good practice to clear the browser cache after a tools release upgrade or any time there is a javascript error message and then retry.

2013年12月4日 星期三

JDE - JDBC Driver的安裝心得





Check JDBC Driver version:

http://www.oracledistilled.com/java/determine-jdbc-driver-version/

[oracle@e1oas03 OracleAS_1]$ head jdbc/Readme.txt
Oracle JDBC Drivers release 10.1.0.2.0 (10g) README
=====================================================
What Is New In This Release ?
-----------------------------
New classes file name for JDK 1.4 and beyond
    Beginning with this release the classes files for JDK 1.4 and


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

[oracle@e1oas03 20131203]$ /u01/OracleAS_1/jdk/bin/java -cp ./:/u01/OracleAS_1/jdbc/lib/ojdbc14.jar JDBCVersionInfo
Driver Name: Oracle JDBC driver
Driver Version: 10.1.0.5.0



Applicable for Oracle 10g R2 JDBC Driver:
Oracle JDBC driver patch p4711863 is required for Oracle Application Server 10g R3 (10.1.3.1.0). This patch was built for database release 10.2.0.2, and can only be applied to this release. At this time there is no patch for database release 10.2.0.3, however, it has been verified that JDBC 10.2.0.2 is compatible with JDBC 10.2.0.3.
Applicable for Oracle 11g JDBC Driver:

Oracle 11g JDBC driver is supported with Oracle Application Server 10g (10.1.3.x) only.




透過Oracle官方建議的方式,deploy一個小的程式來檢查  JDBC Driver version。

http://<server>:<port>/drvtest/dbdetails.jsp

Driver Version: 10.1.0.5.0






透過Oracle官方建議的方式,透過Server Manager 升級 JDBC Driver version。

再檢查一次
http://<server>:<port>/drvtest/dbdetails.jsp
Driver Version: 10.1.0.5.0







手動進入ASC,安裝 ojdbc5.jar 11.1.0.7.0 ,再手動修改 $ORACLE_HOME/j2ee/<container-name>/config/system-application.xml

<import-shared-library name="oracle.jdbc" min-version="10.1.0.7"/>


再檢查一次
http://<server>:<port>/drvtest/dbdetails.jsp
Driver Version: 11.1.0.7.0












2013年11月15日 星期五

Oracle Product - Oracle Lifetime Support Policy lifecycle



http://www.oracle.com/us/support/lifetime-support/index.html

1.      JDE Application’s requirement with Database
Tools 8.9x  - Oracle database 10gR2, 11gR1 and 11gR2
Tools 9.1    - Oracle database 11gR2

2.      Oracle Lifetime Support Policy – JDE


3.      Oracle Lifetime Support Policy – Database
 



4.      The difference of Premier, Extended and Sustaining Support
 




2013年10月30日 星期三

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 3rd.  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的細節。








2013年10月22日 星期二

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







2013年10月17日 星期四

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.

2013年10月11日 星期五

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




2013年1月29日 星期二

JDE - P01RS01 Configuration Utilities



建立 JDE menu時,除了手動作業,還可以使用excel先編輯目錄結構,然後用P-program來做批 次處理。


P01RS01 Configuration Utilities 可以批次處理(export/import)task view and task
會呼叫P01RS002 Pre-Configuration Task View

但要小心,有些不明的規則隱藏在這些程式後端,譬如create new task view and import from excel file,P01RS002會在F00950中,新增一筆action security,讓*PUBLIC, *ALL 都無法change。
要特別注意。




JDE - Processing Option and Data Selection Security


針對特定user開放修改 processing option





2013年1月3日 星期四

Oracle Linux - 在Linux Server上面設定網路印表機


關於在Linux Server上面設定網路印表機,可以參考鳥哥的文章。

印表機對於linux server 的支援度: http://www.openprinting.org/printers

http://linux.vbird.org/linux_basic/0610hardware.php#cups

只要你購買的印表機有支援 postscript ,那麼安裝起來應該是很輕鬆的才是。我們在上面提到的印表機支援網站中, 裡面的驅動程式很多就是 postscript 印表機描述檔案 (Postscript Printer Description)

這些列印的 PPD 驅動程式檔放在哪裡呢?其實就放在 /usr/share/cups/model/ 底下

以下透過socket, IPP, SMB三種方式來實作Linux server下的網路印表機,都可以工作的很好。

實作環境:
OS: Oracle Linux 5.5  Hostname: testdb3
Printer: Epson AL M2310  Pirnter Name:

實作步驟:
1. 在下列網址download ppd file for Epson M2310
http://www.openprinting.org/driver/eplaser

2. 在testdb3上面透過socket的方式,並搭配M2310 ppd file --> 可以成功的列印





3. 在testdb3上面透過ipp的方式,並搭配M2310 ppd file --> 可以成功的列印



4. 在testdb3上面透過samba的方式,並搭配M2310 ppd file --> 可以成功的列印


http://foo2zjs.rkkda.com/
cp -p HP-LaserJet_Pro_P1606dn.ppd /etc/cups/ppd


曾經設定過的印表機:
Epson AcuLaser M2310
HP Color LaserJet 2605dn
HP LaserJet 1606dn

2012年11月30日 星期五

2012年11月27日 星期二

JDE - Oracle HTTP Server - start using oracle account


Oracle 10g HTTP Server: Solving "[crit] (13)Permission denied: make_sock: could not bind to port 83"

There is a trick that httpd port under 1024 need to run as root initially. (e.g. port=83)
Here's the configuration steps:

1. su -

2. cd /u01/OracleAS_1/Apache/Apache/bin

3. chown root .apachectl

4. chmod 6750 .apachectl

5. ls -al .apachectl

6. su - oracle
   cd /u01/OracleAS_1/opmn/bin
   ./opmnctl stopall
   ./opmnctl startall



[root@e1oas03 init.d]# cat /etc/init.d/ias
#!/bin/sh
#
# Author : Arun Singh, Novell Inc.
#
# 1. Add root to dba and oinstall group to function this script properly
#
# 2. Create this file in /etc/init.d directory (ias) and use "chkconfig ias on"
# You can put these and other commands in a single file (startup or shutdown)
# and use as single command. This example is to make instruction clear.
# $ORACLE_HOME/dcm/bin/dcmctl startup
# $ORACLE_HOME/opmn/bin/opmnctl start
# $ORACLE_HOME/bin/emctl start iasconsole
#
### BEGIN INIT INFO
# Provides: ias
# Required-Start: $network $syslog $remote_fs raw
# Required-Stop:
# Default-Start: 3 5
# Default-Stop: 0 1 2 6
# Description: Start the Oracle iAS
### END INIT INFO
ORACLE_BASE=/u01
ORACLE_HOME=$ORACLE_BASE/OracleAS_1
ORA_OWNER=oracle
case "$1" in
'start')
echo -n "Satring Oracle iAS"
#su - $ORA_OWNER --command="$ORACLE_HOME/dcm/bin/dcmctl start" &
#su - $ORA_OWNER --command="$ORACLE_HOME/opmn/bin/opmnctl start" &
su - $ORA_OWNER --command="$ORACLE_BASE/JDE_HOME/bin/startAgent" &
su - $ORA_OWNER --command="$ORACLE_HOME/opmn/bin/opmnctl startall" &
#su - $ORA_OWNER --command="$ORACLE_HOME/bin/emctl start iasconsole" &
;;
'stop')
echo -n "Stopping Oracle iAS"
#su - $ORA_OWNER --command="$ORACLE_HOME/dcm/bin/dcmctl shutdown" &
su - $ORA_OWNER --command="$ORACLE_HOME/opmn/bin/opmnctl stopall" &
su - $ORA_OWNER --command="$ORACLE_BASE/JDE_HOME/bin/stopAgent" &
#su - $ORA_OWNER --command="$ORACLE_HOME/bin/emctl stop iasconsole" &
;;
'status')
echo -n "Checking for Oracle iAS"
su - $ORA_OWNER --command="$ORACLE_HOME/bin/emctl status iasconsole" &
;;
*)
echo "Usage: $0 {start|stop|status}"
exit 1
esac
#
exit
[root@e1oas03 init.d]#

cd /sbin
chkconfig --add ias
chkconfig --list|grep ias

2012年11月2日 星期五

JDE - 簡易版的DR for Deployment Server

JDE Deployment Server 上面的檔案數量很多,所以他的 異地備援,特別是跨國際的異地備援,如果沒有使用Storage level or file system level的工具,會是一個困難。

這邊想到一個簡單的方式,可以解決這個問題。
1. 將Deployment Server(ServerA) P2V 轉換成 VM(ServerB),並更改主機名稱後開機。
2. 在此ServerB上面安裝FastCopy軟體,排成每天利用Fastcopy sync ServerA的JDE目錄到dropbox folder。

3. 則dropbox目錄會自動被分到雲端。
4. 將ServerB 的 VM image file copy 到遠端機房,並且改名為ServerC後開啟。
5. 在ServerC也安裝dropbox,設定好 Dropbox location。
6. 之後如果ServerA上面有任何檔案異動,則會每天自動透過dropbox機制sync到遠端去。


另可以參考其他的copy and sync工具:
http://www.wretch.cc/blog/dlinktwblog/10029894

2012年8月29日 星期三

JDE - AP/TOOLS/middleware version compatibility


Compatibility

Go to http://tools91.steltix.com/jde (demo/demo) to feel how powerful the Tools 9.1 can provide to you !
This is the 1st one (maybe the only one) globally the server application 9.0 version with Tools 9.1 which is offered by E1 silver partner from Netherlands. This link will only valid until mid of this month. So, have a look & feel before you have to upgarde your system to 9.0 and ups.


application 9.0 version with Tools 9.1



9.1 is only support weblogic
若是原本使用OAS 的客戶,在規劃升級到9.1時,必須Install Weblogic server. 並不會影響原有程式執行



結論:


Tools 8.98 (incl update 1-4)    -> JDE E1 APPLICATION 8.11, 8.12, 9.0
                                            -> OAS, Weblogic

Tools 9.1                              -> JDE E1 APPLICATION 9.0, 9.1
                                           -> Weblogic


另外要注意的是搭配 Tools 9.1.X
如果Application是9.1版,local database要使用 Oracle Database Enterprise Edition
如果Application是9.0版以前(含),local database可用 Oracle Database Enterprise Edition or Microsoft SQL Server 2005 Express Edition


JDE Local Database

The JD Edwards EnterpriseOne Tools 9.1.x Deployment Server requires a database management system to be installed locally on the Deployment Server itself. With JD Edwards EnterpriseOne Applications releases prior to 9.1, customers have a choice between Oracle Database Enterprise Edition and Microsoft SQL Server 2005 Express Edition as the local database. Distinct Deployment Server installation CDs (or downloadable images from Oracle E-Delivery) are available for each database. Beginning with JD Edwards EnterpriseOne Applications 9.1 Microsoft SQL Server Express is not supported as the local database (see section “Microsoft SQL Server 2005 Express Edition” below).

The database that is installed on the Deployment Server will be the database propagated to Development Clients via the package build and deployment process.


JDE Application 和 Tools release的相容性對照表,可以參照 UPDATE CENTER
https://updatecenter.oracle.com  裡面的 
EnterpriseOne Tools Releases

JDEdwards OneWorld EnterpriseOne Application Releases
Application Release XE/ERP8 8.10 8.11 8.11 SP1 8.12 9.0 9.1
Compatible
Tools Release
SP23/24 X X X X X X
  8.93 X X X X X
  8.94 8.94 X X X X
  8.95 8.95 8.95 X X X
  8.9 8.96 8.96 8.96 X X
  8.97 8.97 8.97 8.97 X X
  8.98 8.98 8.98 8.98 8.98 X
  8.98.1 8.98.1 8.98.1 8.98.1 8.98.1 X
  X 8.98.2 8.98.2 8.98.2 8.98.2 X
  X 8.98.3 8.98.3 8.98.3 8.98.3 X
  X 8.98.4 8.98.4 8.98.4 8.98.4 X
  X X X X 9.1.0.0 9.1.0.0
  X X X X 9.1.2.0 9.1.2.0
  X X X X 9.1.3.0 9.1.3.0