测试与质量的关系 测试有助于提高软件的质量,但是提高软件的质量不能依赖于测试。测试与质量的关系很象在考试中“检查”与“成绩”的关系。 学习好的学生,在考试时通过认真检查能减少因疏忽而造成的答题错误,从而“提高”了考试成绩(取得他本来就该得的好成绩)。 而学习差的学生,他原本就不会做题目,无论检查多么细心,也不能提高成绩。 所以说,软件的高质量是设计出来的,而不是靠测试修补出来的。 I love U software testing

Oracle E-Business Suite R12.1.1 安装配置问题总结

上一篇 / 下一篇  2010-05-25 10:02:04

最近安装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:faatch/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规划去操作

TAG:

 

评分:0

我来说两句

日历

« 2024-03-23  
     12
3456789
10111213141516
17181920212223
24252627282930
31      

数据统计

  • 访问量: 94053
  • 日志数: 112
  • 图片数: 1
  • 文件数: 1
  • 书签数: 1
  • 建立时间: 2007-01-16
  • 更新时间: 2010-06-28

RSS订阅

Open Toolbar