Oracle E-Business Suite R12.1.1 安裝配置問題總結

環境：
- OS：Oracle Enterprise Linux 5.3 (Lastest version)
- VM: Vmware workstation 6.5
- Desktop:Dell PC
- Application :Oracle E-Business Suite R12.1.1 VIS Demo+ 簡體中文補丁
[@more@]

Oracle E-Business Suite R12.1.1 安裝配置問題總結

安裝配置步驟：
- 上下載EBS for Linux X86 安裝介質
- 安裝Vmware workstation 6.5
- 在VM上安裝Oracle Enterprise Linux 5.3（可以在 下載）
- ftp ebs zip file to Linux
- unzip zip file on linux
- 安裝 Oracle E-Business Suite R12.1.1 Visom Demo
- 安裝EBS 中文補丁
- 效能稍微調整（因為是測試用，很多引數沒必要那麼大）

當中的問題總結：

- 安裝Linux 儘量把所有包都選擇上，否則，安裝EBS中會出現錯誤
- 調整 Linux 的某些引數
- 檢查EBS 需要的OS的包
- 做重要的下面兩個命令，否則EBS中有錯誤
# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6
- 修改如下，否則DB 會有錯誤
以root身份，透過以下命令查詢SELinux的模式：getenforce 預設應當返回Enforcing
透過以下命令更改模式：setenforce 0
然後再次查詢getenforce，應該返回permissive了

- 安裝完畢，主畫面沒問題，進去FORM出現錯誤，解決方法：
[oracle@r12test opmn]$ vi HTTP_Server~1.log
[oracle@r12test opmn]$ pwd
/u01/oracle/VIS/inst/apps/VIS_r12test/logs/ora/10.1.3/opmn
[oracle@r12test opmn]$

09/08/10 17:31:50 Start process
--------
/u01/oracle/VIS/inst/apps/VIS_r12test/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/u01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

--------
09/08/10 17:31:52 Start process
--------
/u01/oracle/VIS/inst/apps/VIS_r12test/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/u01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
32,1 Bot
ln -s /usr/lib/libdb-4.3.so /usr/lib/libdb-3.3.so

[root@r12test ~]# ln -s /usr/lib/libgdbm.so /usr/lib/libdb.so.2

had to use this instead:
ln -s /usr/lib/libgdbm.so.2 /usr/lib/libdb.so.2

[root@r12test ~]# ls -rtl /usr/lib/libdb.so.2
lrwxrwxrwx 1 root root 19 Aug 10 17:47 /usr/lib/libdb.so.2 -> /usr/lib/libgdbm.so

- 打中文補丁前，先打如下補丁：
Patch 8508724
- 打到最後還剩8個的時候出現錯誤。
Applying 6678700_PTB - 12.1.1 : Upgrade Patch

Fails on : FAILED: file XLIFFLoader.class on worker 1.

--------details-------------------------
Invoking Utility XLIFFLoader ...
Class: oracle.apps.xdo.oa.util.XLIFFLoader
Method: processXLIFF
Arguments: UPLOAD -DB_USERNAME &un_apps -DB_PASSWORD &pw_apps -JDBC_CONNECTION &jdbc_db_addr
-APPS_SHORT_NAME OFA -TEMPLATE_CODE FADTXD -FILE_NAME
&fullpath:fa:patch/115/publisher/templates/PTB:FADTXD.xlf
TimeStamp : [Wed Jul 01 22:53:56 BRT 2009]
==========================================================
XLIFFLoader started: Wed Jul 01 22:53:56 BRT 2009

[FILE_NAME]
[/d01/oracle/VIS/apps/apps_st/appl/fa/12.0.0/patch/115/publisher/templates/PTB/FADTXD.xlf]
[APPS_SHORT_NAME] [OFA]
[UPLOAD] [UPLOAD]
[DB_USERNAME] [APPS]
[JDBC_CONNECTION]
[(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)
(HOST=.)(PORT=)))(CONNECT_DATA=(SID=)))]
[DB_PASSWORD] [*****]
[TEMPLATE_CODE] [FADTXD]

Target file: FADTXD.xlf
[070109_105356316][][EXCEPTION] java.io.UTFDataFormatException: Invalid UTF8 encoding.
at oracle.xml.parser.v2.XMLUTF8Reader.checkUTF8Byte(XMLUTF8Reader.java:160)
at oracle.xml.parser.v2.XMLUTF8Reader.readUTF8Char(XMLUTF8Reader.java:203)
at oracle.xml.parser.v2.XMLUTF8Reader.fillBuffer(XMLUTF8Reader.java:120)
at oracle.xml.parser.v2.XMLByteReader.saveBuffer(XMLByteReader.java:450)
at oracle.xml.parser.v2.XMLReader.fillBuffer(XMLReader.java:2488)
at oracle.xml.parser.v2.XMLReader.tryRead(XMLReader.java:1089)
at oracle.xml.parser.v2.XMLReader.scanXMLDecl(XMLReader.java:3047)
at oracle.xml.parser.v2.XMLReader.pushXMLReader(XMLReader.java:521)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:288)
at oracle.apps.xdo.oa.util.TemplateTranslator.createMLSTemplates(TemplateTranslator.java:238)
at oracle.apps.xdo.oa.util.XLIFFLoader.processUpload(XLIFFLoader.java:738)
at oracle.apps.xdo.oa.util.XLIFFLoader.process(XLIFFLoader.java:586)
at oracle.apps.xdo.oa.util.XLIFFLoader.processXLIFF(XLIFFLoader.java:1153)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.apps.ad.worker.AdJavaWorker.invokeUtility(AdJavaWorker.java:503)
at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:356)

Exception while parsing base template
==========================================================
Done calling the utility function. Return Code = [1] TimeStamp = [Wed Jul 01 22:53:56 BRT 2009]
Updating task with status 1

AD Worker error:
The utility XLIFFLoader returned error for the above task.

解決方法
-- To implement the solution, please execute the following steps::
1. In a separate UNIX session, set the APPS environment.

2. Then run the following commands from the command line.
Please note each is a single command.

In these commands, it is assumed the APPS username and password is apps/apps. If this is not correct then please change them approriately in this section:
-DB_USERNAME apps -DB_PASSWORD apps

Command to reload US XML
adjava -ms128m -mx256m -nojit oracle.apps.xdo.oa.util.XDOLoader UPLOAD
-DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION
"(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTO=tcp)(HOST=)(PORT=)))(CONNECT_DATA=(SID=)))"
-LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME OFA -LOB_CODE FADTXD -LANGUAGE 00
-XDO_FILE_TYPE XML-DATA-TEMPLATE -FILE_NAME
$FA_TOP/patch/115/publisher/defs/FADTXD.xml

_______________________________________________________________________
.
Command to reload US RTF
.
adjava -ms128m -mx256m -nojit oracle.apps.xdo.oa.util.XDOLoader UPLOAD
-DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION
"(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=)))(CONNECT_DATA=(SID=)))"
-LOB_TYPE TEMPLATE_SOURCE -APPS_SHORT_NAME OFA -LOB_CODE FADTXD -LANGUAGE en
-TERRITORY US -XDO_FILE_TYPE RTF -TRANSLATE Y -FILE_NAME
$FA_TOP/patch/115/publisher/templates/US/FADTXD.rtf

Once the commands have completed successfully, restart the failed worker and verify the equivalent language script runs successfully.

以上做完就基本完成了，別的問題還沒遇到。。

宣告：以上只是系統測試，正式生產環境請嚴格安裝ORACLE 正式文件操作和正常的IT規劃去操作，
這些只是本人觀點，並不代表任何組織和個人。。呵呵