ITPub博客

一般在EBS R12.1 关闭之后，可能还有很多scheduled job进程在后期运行而没有结束，且这些运行的某些信息是保存在数据库的， 所以我们在重新开启EBS 之前需要做一些动作，清理掉数据库中的一些数据， 查看进程是否都...

Oracle EBS R12.1.3 ,  Oracle 11.2.0.3    报错信息：   FDPSTP failed due to ORA-20100: Error: FND_FILE failure. Unable to create file, o5302826.tmp . 解决方法： 检查 $APPLPTMP 环境变量对应的目录，并保持与数据库参数utl_file_dir对应的值一致，utl_file_dir 修改后需...

Oracle EBS环境下查找数据源(Form篇)http://blog.csdn.net/cunxiyuan108/article/details/5813428

EBS相关日志和参数http://itserverlive.blog.51cto.com/970886/267560

Oracle EBS环境下查找数据源(OAF篇)http://www.2cto.com/database/201109/104171.html

关于Oracle E-Business Suite并发处理机制（Current Processing）

EBS R12.1.3  以sysadmin登录， 职责 system administrator -> Concurrent -> Program -> Define -> F11 -> 在Program栏位输入报表名称如 HW AR Accounts Receivable Balance Report -> CTRL+F11 -> 查询出来后点击左下方的check box : Enable Trace -> 点击菜单下的保存图标 -> 退出后以选择合适的职责提交一...

EBS R12.1.3用户使用自己的账号登录EBS应用时发现非常慢，等了1分多钟还未登入，IE进度条显示35%, 管理员使用其他账号或 sysadmin 登录非常快，怀疑是对用户做了一些设置，检查用户profile , 重点针对 Debug 相关profile进行检查。 发现如下profile针对用户账号是开启状态。sysadmin登录-> profile -> system ...

E. R12 Installation Logs ========================== Database Tier Installation logs:$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log $RDBMS_ORAC...

Services (new concept introduced in R12) define the set of processes that will be started on each application node. These services can be activated or deactivated on a specific application tier/node..Type of Application ServicesApplication tier processes are broadly classified in to five ...

EBS R12.1.3 并发管理器如果出现问题， 一般重新启动即可解决，但有时候adcmctl.sh stop 仍然关闭不了， 还是有很多并发管理器进程在系统中运行， 这时我们可以使用kill 来进行清理，之后需要执行oracle提供的cmclean.sql 来清理并发请求 。 Kill 并发管理器进程 - 如果是 LINUX : ps  -ef |grep FNDLIBR|gr...

ORACLE EBS的Request和后台数据库Session通过apps.fnd_concurrent_requests.oracle_process_id字段和v$process.spid字段关联。[@more@]下面的SQL可以根据Request ID找到对应的Session信息:-select *from v$sessionwhere paddr in (select addr from v$process where spid = (select b.oracle_process_id from apps.fnd_concurrent_requests b where b.request_id = &req_number))或者进一步找到正在运行的SQL:-select sql_textfrom v$sqltext_with_newlineswhere hash_value in (select SQL_HASH_VALUE from v$session

ORACLE EBS的Request和后台数据库Session通过apps.fnd_concurrent_requests.oracle_process_id字段和v$process.spid字段关联。[@more@]下面的SQL可以根据Request ID找到对应的Se...

Oracle EBS R12.1.3 ,  AIX 6.1 1.  用管理员职责登陆EBS，进入系统管理员-->OAM设置-->Site Map-->Notification Mailer发现Workflow Notification Mailer状态为已停止。 2、 点击Start启动，提示“...

I would like to share some important things here. You all might know these, but Oracle Apps newbie will get benefited. As we know that, when ever any Concurrent Request is submitted, log and output files are stored in $APPLCSF/$APPLOG and $APPLCSF/$APPLOUT directories respectively. Apart from *.re...

Listeners are the Service Components with in Oracle Workflow.Following are the types:Workflow Agent Listener: Process inbound messages on Business Event System agents in the database.Workflow Java Agent Listener : This is only Limited to E-Business Suite Only: This process i...

[sql] view plain copy print?SET PAGESIZE 400  SET LINESIZE 120  SET PAGESIZE 50  COLUMN COMPONENT_NAME FORMAT A45  COLUMN&nbsp...

Oracle E-Business Suite uses three OC4J (oacore, oafm & forms) for Java Applications including Forms and HTTP Server for static HTML content.All these four components are managed (including startup/shutdown) by OPMN (OracleProcess Manager & Notification) A. Script to start/stop OPMN in R12 ...

Goal:       To change the Web Listener Port number in Oracle E-Business Suite Release 12 This will be illustrated with a practical example using the following Hostname,Domain, Port numbers:      -Host Name: myhost    &nbsp...

http://blog.csdn.net/pan_tian/article/details/7734892