一名数据库爱好者的专栏

Scheduler/Prereleaser Manager in System Hold, Fix Manager before resetting counters Status After Restarting EBS (Doc ID 2464700.1)In this DocumentSymptomsChangesCauseSolutionReferencesAPPLIES TO:Oracle Concurrent Processing - Version 12.1.3 to 12.1

os: oel 7.6ebs: R12.1.3报错信息Error: no `server' JVM at `/ebsfs/apps/apps_st/comn/clone/jre/lib/i386/server/libjvm.so'.# su - appldev$ cd /ebsfs/apps/apps_st/comn/clone/bin $ perl ./adcfgclone.pl appsTier Copyright (c) 2002 Oracle Corporation Redwo

现象，所有打印请求无法运行输出提交处理程序FNDCPOPP$ ps -fu applprod| grep -i opp applprod 10505 28012 6 08:53 ? 00:03:20 /ebsfs/EBSPROD/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=10505 -server -Xmx384m -XX:NewRatio=2 -

os: centos 7.6ebs: R12.1.3form 报错$ cat /ebsfs/EBSPROD2/inst/apps/EBSDEV22_oes09/logs/ora/10.1.3/j2ee/forms/forms_default_group_1/application.log20/06/08 18:48:19.871 formsweb: Forms session <3> exception stack trace: oracle.forms.engine.Runfo

必不可少的一些文档<<Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 (Doc ID 761566.1)>><<Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)>><<Using JDK 7.0 Latest Update wit

依赖包compat-libstdc+±296-2.96参考:https://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/

依赖包 xorg-x11-libs-compat-6.8.2参考:https://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/

依赖包 openmotif21-2.1.30参考:https://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux

os: centos 7.6ebs: R12.1.3启动 app 时报错如下# su - appldev2$ cd $ADMIN_SCRIPTS_HOME$ ./adstrtal.sh apps/apps++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-------------------------------------------------------------------

kill process# ps -fu appldev2 | awk '{print $2}' | xargs kill -9;ps -fu oradev2 | awk '{print $2}' | xargs kill -9;

deltrc.sh$ vi /home/oraprod/backup/scripts/deltrc.shfind /ebsfs/EBSPROD/db/tech_st/11.2.0/admin/EBSPROD_ovmoradb/diag/rdbms/ebsprod/EBSPROD/trace -name "EBSPROD*.trc" -mtime +7 | xargs rm -rffind /...

os: linux 5.8 ebs:12.1.3 patch:14332598这里以 p14332598 为例，列出打补丁的过程。查看补丁SELECT * FROM ad_applied_patches where 1=1 and patch_name in ('14332598') ; SELECT * FROM ad_bugs where 1...

opmn.xml 是由autoconfig生成的重要参数配置文件。通常的路径如下： /ebsfs/EBSPROD/inst/apps/EBSPROD_erp/ora/10.1.3/opmn/conf/opmn.xml通过调整java的启动参数和numprocs 可以提升系统的负载。文件描述&lt;!-- $Header: opmn_xml_1013.tmp 120.22.1201...

ebs 12.1.3 ，经常需要查看一些日志，这里自己记录一下，方便以后快速查找。# find /ebsfs/EBSPROD/inst -type f -mmin -100/ebsfs/EBSPROD/inst/apps/EBSPROD_erp/logs/appl/conc/log/javacache.log/ebsfs/EBSPROD/inst/apps/EBSPROD_erp/...

1）修改数据库登录用户apps密码，要求停app应用，不停数据库 FNDCPASS apps/apps 0 Y system/system SYSTEM APPLSYS apps2执行后注意查看输出日志2）修改EBS系统页面登录用户密码$ sqlplus apps/apps2DECLARE l_success boolean;BEGIN l_success := F...

添加完表空间，或者数据文件后记得执行下如下脚本。 或者克隆前执行也可以。# su - oraprod$ cd /ebsfs/EBSPROD/db/tech_st/11.2.0/appsutil/scripts/EBSPROD_ovmoradb$ perl ./adpreclone.pl dbTier# su - applprod$ cd /ebsfs/EBSPROD/inst/...