环境：
- 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+ 简体中文补丁
Oracle E-Business Suite R12.1.1 安装配置问题总结
安装配置步骤：
- http://edelivery.oracle.com/ 上下载EBS for Linux X86 安装介质
- 安装Vmware workstation 6.5
- 在VM上安装Oracle Enterprise Linux 5.3（可以在http://edelivery.oracle.com/ 下载）
- 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=<host>.<domain>)(PORT=<port>)))(CONNECT_DATA=(SID=<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=<host.dimain- taken from error message above>)(PORT=<port- taken from error message above>)))(CONNECT_DATA=(SID=<sid - taken from error message above>)))"
-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=<host.dimain- taken from error message above>)(PORT=<port- taken from error message above>)))(CONNECT_DATA=(SID=<sid - taken from error message above>)))"
-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规划去操作，
这些只是本人观点，并不代表任何组织和个人。。呵呵
