博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
Oracle EBS R12 - Steps and Issues/Resolutions during R12.1.1 to R12.1.3 Upgration
阅读量:4175 次
发布时间:2019-05-26

本文共 4816 字,大约阅读时间需要 16 分钟。

This essay is based on Oracle Linux 5.7 x64 and Oracle E-Business suite R12.1.1 x64

0.

Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)
admsi.pl -patch_top="`pwd`" -appspass=apps -cli
1.
Document 761570.1
add _disable_fast_validate=TRUE
2.
--enable maintenance
create table invalids_b_9239089 as select * from dba_objects where status='INVALID';
Required Code levels
R12.AD.B.delta.3
(R12.AD.B.DELTA.3, Patch 9239089) (Doc ID 1077769.1)
create table invalids_a_9239089 as select * from dba_objects where status='INVALID';
select bug_number,last_update_date from ad_bugs where bug_number = 9239089;
select object_name,object_type,status from invalids_a_9239089 where object_id not in (select object_id from invalids_b_9239089);
3.
create table invalids_b_9239090 as select * from dba_objects where status='INVALID';
Doc.DI 1080973.1
Patch 9239090
create table invalids_a_9239090 as select * from dba_objects where status='INVALID';
select object_name,object_type,status from invalids_a_9239090 where object_id not in (select object_id from invalids_b_9239090);
select object_name,object_type,status from dba_objects where object_id not in (select object_id from invalids_b_9239090);
=================================================
Doc ID 1303269.1
During the relink phase of the installation of EBS Release 12 (12.1.1) on SLES
10 or Oracle Linux/RHEL 5.4 (Update 4 or higher), failures will result while
relinking the Advanced Supply Chain Planning (ASCP) executables MSO, MSC, MSR
and FEM.
 To fix this problem, users are required to replace the following line under
the Linux section of the $AD_TOP/bin/adrelinknew.sh:
CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh'
with
CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh
-Wl,--noinhibit-exec'
=================================================
adpatch.log
...
The following Oracle Reports objects did not generate successfully:
au      plsql   FABAL.pll
au      plsql   FARSV.pll
au      plsql   fadolif.pll
...
-------------------------------------------------
adwork001.log
Generating Oracle Reports files...
Generating report "FASUOPHI.rdf" with command:
/u01/apps/tech_st/10.1.2/bin/rwconverter userid=APPS/***** source=/u01/apps/apps
_st/appl/fa/12.0.0/reports/US/FASUOPHI.rdf dest=/u01/apps/apps_st/appl/admin/PRO
D/out/tmp001.rdf stype=rdffile dtype=rdffile overwrite=yes batch=yes compile_all
=yes
/u01/apps/tech_st/10.1.2/bin/rwconverter: error while loading shared libraries:
libXm.so.2: cannot open shared object file: No such file or directory
ERROR [code=127] generating report "FASUOPHI.rdf" from input file
/u01/apps/apps_st/appl/fa/12.0.0/reports/US/FASUOPHI.rdf
Generated    0 files successfully.
Generated    0 files with non-fatal warnings.
Generated    1 files with fatal errors.
adrepgen is exiting with status 1
...
rpm -ivh openmotif21-2.1.30-11.EL5.i386.rpm
=================================================
Invalid FFP Objects (Doc ID 1331911.1)
Latest Oracle HRMS Legislative Data Patch Available (HR Global / hrglobal)
(Doc ID 145837.1)
java oracle.apps.per.DataInstall apps apps thin oel57vis.example.com:1521:VIS
cd  $PER_TOP/patch/115/driver
adpatch hrglobal.drv
How To Compile Oracle Fast Formulas (Doc ID 155737.1)
$FF_TOP/bin/FFXBCP apps/apps 0 Y %% %%
=================================================
4.
create table invalids_b_9239095 as select * from dba_objects where status='INVALID';
Patch 9239095
create table invalids_a_9239095 as select * from dba_objects where status='INVALID';
select object_name,object_type,status from invalids_a_9239095 where object_id not in (select object_id from invalids_b_9239095);
5.
create table invalids_b_9817770 as select * from dba_objects where status='INVALID';
Patch 9817770
create table invalids_a_9817770 as select * from dba_objects where status='INVALID';
select object_name,object_type,status from invalids_a_9817770 where object_id not in (select object_id from invalids_b_9817770);
create table invalids_b_9966055 as select * from dba_objects where status='INVALID';
Patch 9966055
create table invalids_a_9966055 as select * from dba_objects where status='INVALID';
select object_name,object_type,status from invalids_a_9966055 where object_id not in (select object_id from invalids_b_9966055);
6.
. ./<APPL_TOP>/APPS<CONTEXT_NAME>.env
Run AutoConfig on the APPL_TOP
adautocfg.sh
Run the admkappsutil.pl utility to create the file appsutil.zip in the <INST_TOP>/admin/out directory.
perl <AD_TOP>/bin/admkappsutil.pl
perl $AD_TOP/bin/admkappsutil.pl
cd <RDBMS ORACLE_HOME>
. ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env
cd <ORACLE_HOME>
unzip -o appsutil.zip
perl adpreclone.pl dbTier
perl adpreclone.pl appsTier
7.
remove add _disable_fast_validate=TRUE
--disable maintenance
Reference:

Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)

转载地址:http://kwtai.baihongyu.com/

你可能感兴趣的文章
从MySQL高可用架构看高可用架构设计
查看>>
可以秒杀全场的SpringCloud微服务电商实战项目,文档贼全!
查看>>
java架构之路(多线程)synchronized详解以及锁的膨胀升级过程
查看>>
java架构之路(多线程)AQS之ReetrantLock显示锁的使用和底层源码解读
查看>>
百度现场面试:JVM+算法+Redis+数据库!(三面)
查看>>
java架构之路(多线程)JMM和volatile关键字
查看>>
创业感悟:技术兄弟为什么一直没有起来
查看>>
(转载)linux命令之十八locate 命令
查看>>
Linux发行光盘(红旗 5.0 SP2发行版,已不使用仅参考)
查看>>
linux下如何将文件打包、压缩并分割成制定大小
查看>>
CentOS6.5升级内核到3.10.28
查看>>
linux内核补丁安装和编译安装
查看>>
(转载)linux命令之十九find 命令
查看>>
(转载)linux命令之二十 find命令之exec
查看>>
(转载)linux命令之二十一find命令之xargs
查看>>
centos下C编程调用libvirt的API访问KVM虚拟机
查看>>
(转载)linux命令之二十四tar命令
查看>>
(转载)linux命令之二十五chgrp命令
查看>>
IntelLinux显卡驱动安装指南
查看>>
(转载)linux命令之二十六chown命令
查看>>