ITPub博客

EBS R12.1.3

应用opatch  cd   6488072opatch apply   卸载opatch  opatch  rollback -id  6488072   -invPtrLoc $IAS_ORACLE_HOME/oraInst.loc -oh $IAS_ORACLE_HOM...

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

 Login to the System Administrator Responsibility.Open the System -> Profiles form.Search for profiles using '%BNE%LOG%' This should return three profiles.BNE Server Log Level - This should...

http://www.oracle.com/technetwork/cn/developer-tools/adf/downloads/index.html  

sysadmin 登入EBS , System Administrator =>  concurrent: manager => define =>F11，然后在Manager后输入Standard Manager  =>  ctrl+F11  =>  可以调整cache size => 点击...

Patch log files:$APPL_TOP/admin/<SID>/log/adpatch.lgii.e. /appltest/testappl/admin/TEST/log/adpatch.lgiErrors and warnings are$APPL_TOP/admin/<SID>/log/adpatch.logi.e. /appltest/testappl/admin...

关于merge patch的一些限制：In general, you can safely merge any Oracle Applications patch with any other OracleApplications patch. Older split driver patches can be merged with newer unifieddr...

appl用户需要整理的文件夹: $COMMON_TOP/admin/log/SID_HOST/* $COMMON_TOP/admin/out/SID_HOST/* $APPL_TOP/admin/SID/log $APPL_TOP/admin/SID/out /usr/tmp $IAS_ORACLE_HOME/Apach...

软件克隆完成后，sqlplus  /nolog 登录无问题，但是以sqlplus  “/as sysdba”登录的时候提示没有权限。解决方法如下：cd $ORACLE_HOME/rdbms/libvi config.s修改group名称(string 后面的“”)为d...

克隆系统后清除node信息（apps用户下操作）exec  fnd_conc_clone.setup_clean;    run the following in SQL*Plus. Note that this will delete all data from system tables such as F...

如何查看某个erp系统是 form. servlet 还是 socket 模式 ，以及使用的端口号 。 env | grep appsweb.cfg  查看form. 配置文件所在路径，在这个文件里面找到serverPort=xxx  即可看到 form. 使用的端口号 ...

Use only FND_STATS or the Gather Schema and Gather Table Statistics Concurrent Programs. Do NOT USE the analyze or dbms_stats command directly. It is not supported, and results in sub...

System Administrator  =>  Concurrent => Mananager => Requests => 最下端按钮 Submit a New Request => Single Request  =>  选择一个Name, 不清楚具体字段意思可以点击help按钮 =>&...

EBS R12.1.2  ,  需要安装部署ISG,   有3个opatch 需要安装， 还特别提示需要执行  $INST_TOP/ora/10.1.3/.env  然后执行。 听顾问说主要是为了在 ORAC...

select event,count(*) from gv$session_wait group by event order by count(*) desc; SELECT s.sid,s.serial#,p.spid, t.sql_text FROM v$session s, v$sql t, v$process p WHERE s.event LIKE 'row ...

In this link, we had mentioned about tracing a concurrent program, but the drawback of this method is it doesnt yield information about the BIND variable values. So in this post we will talk a...

  - Go to ‘Functional Administrator‘ responsibility. (If you have ‘System Administrator’ responsibility or you are a SYSADMIN user then you can assign ‘Functional Administrator...

Using Distributed ADStart AutoPatch or AD Controller with Distributed AD worker optionsOn one of your shared application tier file system nodes, start your AutoPatch or AD Administration s...

EBS R12   官方文档地址 ： http://docs.oracle.com/cd/B34956_01/current/html/docset.html