ITPub博客

Here is the small post which describes the potential placed where log files and trace files are present and can be cleaned up. This is requied when you want to free up space on the system.Cleaning up R12 instance:Following are the locations in applmgr side which you can check and clean up. Be careful while cleaning up the log files, because some might be needed for analysis or might contan errors for some reproducible test case. So if you delete some log file which is needed, you might have to

有一个小技巧，Oracle EBS登陆后可以绕过职责和功能的选择过程，就可以直接打开某个特定的Form，这样整个的登陆过程会更快.方法：Oracle Application Home Page > Preferences > Start Page，输入起始的\'Responsibility\'和\'Page\'，Apply之后，重新登陆，就可以绕过职责和功能的选择过程，直接打开某个特定的Form or Page另外，如果设置了Start Page，那么Oracle Application Home Page这个页面就不会展示了

login to your instance with putty or any other software cd $ADMIN_SCRIPTS_HOMER12adoacorectl.sh stop adoacorectl.sh startadoacorectl.sh status(optional)11ish $COMMON_TOP/admin/scripts/adapcctl.sh stopsh $COMMON_TOP/admin/scripts/adapcctl.sh startOAF Server和Form Server是不同的，所以重启Apache Server不会影响Form Server.Bouncing the Apache or OC4J will impact only the self service pages.It won\'t bounce the form server.Bouncing Apache will not disconnect the connected users from the

Below list of  log file locations could be helpful for your issue:Before start please notice PROD is my SID- Start/Stop script log files$COMMON_TOP/admin/log/SID_HOTSNAME/You can find below txt in this path:adadmat.txt adalnctl.txt adcmctl.txt adfmcctl.txt adupdbid.txtadadmprf.txt adapcctl.txt addisctl.txt adfmsctl.txt adupdlobs.txtFor to can check adstrtal.sh, adstpall.sh  scripts log file, you can use same path.For those sh, The log file creation sytax is:dd=`date ‘+%m%d%H%M

Below list of  log file locations could be helpful for your issue:- Apache, OC4J and OPMN:$LOG_HOME/ora/10.1.3/Apache$LOG_HOME/ora/10.1.3/j2ee$LOG_HOME/ora/10.1.3/opmn- Startup/Shutdown Log files:$INST_TOP/logs/appl/admin/log- Patch log:$APPL_TOP/admin/$SID/log/- Autoconfig log file:Apps:$INST_TOP/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.logDb:$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>/adconfig.log$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>/NetServiceHand

What\'s Cloning? - Cloning is the process of creating an identical copy of an already existing Oracle Applications system.FAQ:FAQ: Cloning Oracle Applications Release 11i [ID 216664.1]For cloning process please follow below references:Cloning Oracle Applications Release 12 with Rapid Clone [ID 406982.1]Cloning Oracle Applications Release 11i with Rapid Clone [ID 230672.1]Also check:Rapid Clone Documentation Resources, Release 11i and 12 [ID 799735.1]Descriptive Checklist for performing Rapid C

Oracle Apps DBA可以从System Administrator >> Concurrent : Manager >> Administer里查看所有Concurrent Manager运行的状态,其实如果仅仅是查看的话，也可以通过下边这个脚本来查看. SELECT DECODE(CONCURRENT_QUEUE_NAME,\'FNDICM\',\'Internal Manager\',\'FNDCRM\',\'Conflict Resolution Manager\',\'AMSDMIN\',\'Marketing Data Mining Manager\',\'C_AQCT_SVC\',\'C AQCART Service\',\'FFTM\',\'FastFormula Transaction Manager\',\'FNDCPOPP\',\'Output Post Processor\',\'FNDSCH\',\'Schedul

Oracle EBS中做业务的时候报ORA-01653: unable to extend table FND_CONCURRENT_REQUESTS by 16 in tablespace APPS_TS_TX_DATA解决方法：应该是表空间不够引起的，可以通过Script – Tablespace Information里的脚本查看下。使用下边Query查看TablespcaceSELECT * FROM dba_data_files WHERE tablespace_name=\'APPS_TS_TX_DATA\'使用下边SQL增加一个数据文件到Tablespace中ALTER tablespace APPS_TS_TX_DATAADD datafile \'/u01/oracle/mc3yd213/db/apps_st/data/tx_data54.d

Apps Server上运行 sh -c "`awk -F= \'$1 ~ /^JSERVJAVA.*$/ {print $2}\' $ADMIN_SCRIPTS_HOME/java.sh` -version;" Example: [oracle@PROD ~]$ sh -c "`awk -F= \'$1 ~ /^JSERVJAVA.*$/ {print $2}\' $ADMIN_SCRIPTS_HOME/java.sh` -version;" java version "1.6.0_10" Java(TM) SE Runtime Environment (build 1.6.0_10-b33) Java HotSpot(TM) Server VM (build 11.0-b15, mixed mode) [oracle@bej301441 ~]$

不知道怎么搞得，Oracle EBS主界面上方的‘Favorites’下拉列表消失了，取而代之这个列表跑到了页面下方，很容易就忽略掉了 解决方法： 主界面 -> Preferences ，不知道谁把Accessibility Features设置成Screen Reader Optimized模式了，改回成None，然后返回主界面就能看到Favorites列表了

ICX:Session Timeout - This profile option determines the length of time (in minutes) of inactivity in a user\'s form session before the session is disabled.  Note that disabled does not mean terminated or killed.  The user is provided the opportunity to re-authenticate and re-enable their timed-out session. If the re-authentication is successful, the disabled session is re-enabled and no work is lost. Otherwise, the session is terminated without saving pending work.  This functi

Accessibility Standard Accessibility - Renders the pages accessible for users using assistive technology, but ensures that pages are formatted correctly for sighted users. Screen Reader Optimized - Optimizes the pages for screen readers. This may degrade the output for sighted users. None - This mode removes markup that is only needed by assistive technology users, such as table summary information, to make the page smaller and faster. The resultant pages may include behaviors that

发现菜单里“Close Other Forms”灰显，不允许更改 Solution System Administrator,Navigate to Security > Responsibility > Define. Query the responsibility in which you want to allow to control the Close Other Forms option. In the Menu Exclusions, enter a function Name: Navigator: Disable Multiform Save changes.

Monitor Users如何监控当前哪些用户在干什么，Oracle Apps提供了一个监控这么功能（尽管还是比较简陋）。使用系统管理员用户登陆，到System Administrator职责下，Security > User > Monitor，然后F11, Ctrl-F11,就可以看到当下有哪些用户在干什么，比如这里的截图，用户PROJMFG在Order Information Super User职责下监控的粒度是由系统Profile “Sign-On:Audit Level”来控制的NONE - No monitoring.USER - Will only

A) Select the "Generate Applications Files menu" option. B) Then select the "Generate forms files" option. C) Choose the number of workers, the default is recommended and is based off the number of CPUs in your server. D) Enter "yes" at this prompt to regenerate PL/SQL library files (.pll extension) E) Enter "yes" at this prompt to regenerate Forms Menu files (.mmb -> .mmx extension) F) Enter "yes" at this prompt to

1.如何从数据库查询当前系统是否处于Maintainance模式 SQL> SELECT FND_PROFILE.VALUE(\'APPS_MAINTENANCE_MODE\') FROM DUAL; If it is in Maintenance Mode the above query will show as follows:FND_PROFILE.VALUE(\'APPS_MAINTENANCE_MODE\') --------------------------------------------------------- MAINT If it is not in Maintenance Mode the above query will show as follows: FND_PROFILE.VALUE(\'APPS_MAINTENANCE_MODE\') --------------------------------------------------------- NOR

ADADMIN用途ADADMIN主要用于Oracle Apps文件系统和数据库的维护工作，是Apps DBA常用的工具。（ADADMIN执行文件位于$AD_TOP/bin下）使用方法[oracle@bej301441 ~]$ adadmin如果ADADMIN命令无法运行，很可能是环境变量没有设置，可以运行下". $APPL_TOP/instance.env"来设置环境变量。adadmin执行过程中，需要数据库system用户的密码和apps用户的密码ADADMIN的菜单项介绍ADADMIN有5个一级菜单，每个一级

打patch之后,重启EBS Server，使用IE登陆时，报Error The system has not been taken off maintenance mode completely. Please contact your System Administrator. 从错误上看，貌似是Maintainance模式没有关闭，然后就使用adadmin关闭Maintenance模式，但是disable Maintenance模式之后，还是报同样的错。 下边的SQL也表明，现在服务器不是处于Maintenance模式: select fnd_profile.value(\'APPS_MAINTENANCE_MODE\') from dual; Outp

If your IE browser is closing and crashing as soon as you open Oracle Apps, then you can try the following steps to avoid the browser from crashing. 1) Disable Tabbing Browsing Tools > Internet Options > General > Tabs > Settings > Uncheck Enable Tabbed Browsing 2) Add the URL for the Oracle Apps to your Trusted Sites Tools > Internet Options > Security 3) Go to Tools > Internet Options > Advanced > Click on Tools, Internet Options, then the Advanced

IE浏览器打开Oracle EBS，然后报安全信息的提示 安全信息 本页不但包含安全的内容，也包含不安全的内容。是否显示不安全的内容。 解决方法： IE > Internet选项 > 安全 > 自定义级别 > 显示混合内容 > 把"提示"改成"启用"