ITPub博客

OATM即Oracle Applications Tablespace Model，是Oracle EBS可选的表空间模型。OATM提供12个表空间模型用于管理本地表空间，"APPS_"开头的属于Oracle EBS的业务表空间，此外的三个为Oracle数据库的系统表空间，包括Temp空间，System表空间，Undo表空间。OATM是11i10发布的，11i之前，每个模块都有两个表空间，一个是数据表空间，另外一个索引表空间，造成了非常多的表空间，通过OATM可以有

打Patch前，往往需要通过adadmin命令把系统模式设置成Maintainance Mode，这里再多提供一个打开或者关闭Maintainance Mode的方法。(首先说明这种通过SQL的方式维护系统并不推荐，毕竟绕开了正式管理工具直接执行，提供这么个信息可以让大家开阔下思路，至少知道所有的管理命令在后台都对应了一些脚本，可以打开看看这些脚本，了解内部的内部机制)可以通过Sql直接执行1.SQL script to

客户化的Forms,Reports一般都是放到$CUX_TOP目录下（约定俗称），如果是初始化系统，那么这个目录是不存在的，那么创建这样一个客户化TOP的大体几步1.在$APPL_TOP下建立CUX目录，其目录结构和其它PROD_TOP的目录结构一样2.在$INST_TOP/appl/admin/<sid>_<hostname>.xml中加入CUX_TOP<CUX_TOP oa_var="s_cuxtop" oa_type="PROD_TOP" oa_enabled="FALSE">/.../appl/cux/12.0.0</CUX_TOP>3.

AD Merge Patch (command:admrgpch) is used to merge multiple patches into a single one. This is useful when we have to apply many patches to reduce the patching time. Note:it can\'t be used to merge patches of different releases, platforms or parallel modes.Command like:admrgpch -s <source> -d <desintation> -logfile <name> -merge_name <default is merged, so name it appropriately>---------------------------------------------------------

AD Utilities (Applications DBA Utilities) are programs which perform a variety of tasks, including generating files, updating your system, merging and applying patches, installing off-cycle products.  These AD Utilities are executable files in $AD_TOP/binUtility Executable/ Interface Role AD Administration adadmin Oracle Application Manager  Performs maintenance tasks on the Oracle

1. How to check used ports in oracle application systemNavigation: System Administrator ->  Oracle Application Manager - > Dashboard -> click the link of the apps server in the HOST column -> On the page Oracle Applications Hosts: <your_hostname>, click the "View configuration" button.2. How to check used port in Oracle Database System.check port list file: $RDBMS_ORACLE_HOME/install/portlist.ini3.Port Pools in R12what\'s port pool? check https://blogs.oracle.c

CLASSPATH=[JDK_TOP]/lib/dt.jar:[JDK_TOP]/lib/tools.jar:[JDK_TOP]/jre/lib/rt.jar:$JAVA_TOP/../lib/appsborg.zip:$JAVA_TOPand some other forms/mid server necessary lib.eg.frmall.jar,ewt3.jar,frmsrv.jar...-----------------------------------------------------AF_CLASSPATH=[JDK_TOP]/lib/dt.jar:[JDK_TOP]/lib/tools.jar:[JDK_TOP]/jre/lib/rt.jar:$JAVA_TOP/../lib/appsborg2.zip:$JAVA_TOPRelated Notes:Troubleshooting Classpath (Doc ID 184714.1)Upgrading Oracle Applications 11i to use JDK 1.3 (Doc ID 130091.

Oracle EBS标准登录页面的链接格式：http://hostname.domain:port/OA_HTML/AppsLogin，然后输入用户名、密码，就进入主页面(职责页)。有的客户可能会有这样的需求，是否可以绕过登录界面，直接进入系统主页。解决方法：可以使用如下的登录链接： URL> http://hostname.domain:port/OA_HTML/fndvald.jsp?username=<username>&password=<password>(也可指定语言:在链接后边加&langCode=US、&langCode=Z

关于odf文件，写过一篇笔记,见：Oracle Apps ADODFCMP Utility, xdf和odf类似，都是数据库对象的描述文件，用于数据库表，视图，索引等等在不同数据库间的移植。根据NOTE:551325.1的说法，xdf将会逐步取代过去的odf，毕竟xdf的xml格式还是要比文本格式的odf有方便处理些。xdf对应的执行文件是$JAVA_TOP/oracle/apps/fnd/odf2/FndXdfCmp(一java文件)odf对应的执行文件是$AD_TOP/bin/adodfcmp(脚本语言)xdf文件

What\'s needed to enable EBS environments for JRE 7? EBS customers should ensure that they are running JRE 7u17, at minimum, on Windows desktop clients. Of the compatibility issues identified with JRE 7, the most critical is an issue that prevents E-Business Suite Forms-based products from launching on Windows desktops that are running JRE 7.  Customers can prevent this issue -- and all other JRE 7 compatibility issues -- by ensuring that they have applied the latest certified patches

Server上，发现空间不足，于是想删除一些临时日志来腾点空间，以为自己已经在日志目录下了，也没仔细看，就直接运行rm命令了，结果把系统中很多非常关键的脚本都清掉了，惊出一身冷汗。本来就很忙，还花费了一下午的时间才把删除的文件重新恢复。从中也得到了些教训：1.备份，备份，还是备份；2.慎用或者不用rm命令；3.操作前，保持头脑清醒，知道自己在干什么；

Unable to connect SMTP port,There is a easy to check this.(ptian) ptian- telnet server_host 25Trying ip...telnet: Unable to connect to remote host: Connection refusedThis means probably, SMTP port 25 is not open.Solution:To resolve the issue,you need login with root user.1.Verify sendmail packagesIn order to configure sendmail, you will require the sendmail and sendmail-cf packages. [root@bej301441 oracle]$ rpm -qa | grep sendmail sendmail-doc-8.13.8-8.1.el5_7 sendmail-8.13.8-8.1.el5_7 sendmai

Java Color SchemeYou can use this profile to set different colours to the oracle apps forms.Need re-login after setting.The different colours:ColorExampleBlafBlueKhakiOlivePurpleRedTealTitanium  

一篇关于如何成为Oracle E-Business Suit DBA的文章，很短，但里边的提到的一些文档，链接和Webcase还是比较有价值的。 1. 从官方文档开始 E-Business Suite Documentation Library里有着各种值得收藏的文档，内容丰富，覆盖面广。所有想成为DBA可以从下面开始 Oracle E-Business Suite 12.1.3 Concepts Guide 2. 构建一个自己的测试环境 实践是最好的学习方法。你可以下

Steven Chan published a very good whitepaper about E-Business Suit + Oracle Exadata.Click: New Whitepaper: Deploying E-Business Suite on Exadata and Exalogic This whitepaper covers the following topics: Scalability and Sizing Examples - provides performance benchmark analysis with concurrent user counts, scaling analysis and sizing recommendationsDeployment Standards - includes recommendations for deploying the various components of the E-Business Suite architecture on ExastackMigration Stan

Can not stop Oracle Apps Server,error information:-----------------------------[oracle@bej301441 scripts]$ adstpall.sh apps/appsYou are running adstpall.sh version 120.10.12010000.4The logfile for this session is located at /u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441/logs/appl/admin/log/adstpall.log/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441/admin/scripts/adstpall.sh: line 242: 15124 Done               &nbsp

Found Many Concurrent Managers are under \'No Manager\' Status, Then I tried to restart Concurrent Manager like(http://blog.csdn.net/pan_tian/article/details/7765256)Then saw following error:--------------------------------------------------------------------------------------------------------------[oracle@bej301441 scripts]$ adcmctl.sh  start apps/apps diag=YYou are running adcmctl.sh version 120.17.12010000.5Starting concurrent manager for mc3yd213 ...Starting mc3yd213_0127@mc3yd213 In

Login Apps Servercd $IAS_ORACLE_HOME/Apache/Apache/bin./httpd -versionOutput:Server version: Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-ServerServer built:   Jul  7 2008 14:58:00

默认情况下“附件”按钮是灰显的，本文将展示如何让某个Form的附件按钮变亮，并能上传附件.以用户Form为例，我们想让用户上传自己的照片Pre-SetupsHelp > Diagnostics > Custom Code > Personalize，记录下Function Name并用Help > Diagnostics > Examine查看User Name字段和User ID字段对应的Field名称我们将会在后边的步骤里使用USER_ID和USER_NAMESetups接下来就在Application Developer职责下，要配置Atta

System Admin下有一个Profile："Hide Diagnostics menu entry"(中文环境叫“隐藏诊断菜单项”)，可以用这个Profile来设置是否显示Diagnostics菜单项。注：设置之后，需重新登陆设置成Yes，Diagnostics菜单项就隐藏起来，以防不明真相的用户操作设回成No，Diagnostics 菜单又显示出来。Related Topic:Profile:Utilities : Diagnostics