最近安装
oracle的商务版本
环境:
- OS:Oracle Enterprise
Linux 5.3 (Lastest version)
- VM: Vmware
workstation 6.5
- Desktopell PC
- Application :Oracle E-Business Suite R12.1.1 VIS
Demo+ 简体中文补丁
安装配置步骤:
-
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
atch/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规划去操作