Oracle EBS DBA
文章平均质量分 66
田攀
tian.pan@qq.com
展开
-
Oracle EBS Concurrent Request:Gather Schema Statistics
Oracle EBS 的Concurrent Request"Gather Schema Statistics"是一个和性能相关的Concurrent Program,它会对表,列和索引的做数据采样,并生成统计信息。基于成本的优化器(Cost-Based Optimization CBO)会根据你的数据采样来评估执行计划,最终选取一个最高效的方式来执行SQL。补充一点:数据采样十分类似于问卷调查,原创 2012-06-23 13:47:57 · 5072 阅读 · 0 评论 -
odf-File and xdf-File
关于odf文件,写过一篇笔记,见:Oracle Apps ADODFCMP Utility, xdf和odf类似,都是数据库对象的描述文件,用于数据库表,视图,索引等等在不同数据库间的移植。根据NOTE:551325.1的说法,xdf将会逐步取代过去的odf,毕竟xdf的xml格式还是要比文本格式的odf有方便处理些。xdf对应的执行文件是$JAVA_TOP/oracle/apps/fnd/odf原创 2013-03-06 18:37:22 · 3724 阅读 · 0 评论 -
Oracle Apps ADODFCMP Utility
odf(Object Descriptor File),里边含有数据库对象的描述,用于创建数据库表,视图,索引等等。除了打patch可以打odf文件,我们还有个手工打odf的工具叫做ADODFCM($AD_TOP/bin下),名字拆开比较好记,AD表示Admin,ODF表示Object Descriptor File,CM表示Compilation。应用场景,比如发现数据库某张表没有被创建,但od原创 2012-07-31 15:28:27 · 3941 阅读 · 0 评论 -
Getting Started as an E-Business Suite DBA
一篇关于如何成为Oracle E-Business Suit DBA的文章,很短,但里边的提到的一些文档,链接和Webcase还是比较有价值的。 1. 从官方文档开始 E-Business Suite Documentation Library里有着各种值得收藏的文档,内容丰富,覆盖面广。所有想成为DBA可以从下面开始 Oracle E-Business Sui翻译 2013-02-22 11:15:26 · 3156 阅读 · 0 评论 -
ORA-01031: insufficient privileges
command 'sqlplus system/manager' works fine. But in case connect system/manager as sysdba, it will tell me "ORA-01031: insufficient privileges" error.[oracle@bej301441 ~]$ sqlplus system/manager as sy原创 2013-03-07 00:37:25 · 3586 阅读 · 0 评论 -
How to Login Oracle Applications Directly - fndvald.jsp
Oracle EBS标准登录页面的链接格式:http://hostname.domain:port/OA_HTML/AppsLogin,然后输入用户名、密码,就进入主页面(职责页)。有的客户可能会有这样的需求,是否可以绕过登录界面,直接进入系统主页。解决方法:可以使用如下的登录链接: URL> http://hostname.domain:port/OA_HTML/fndvald.jsp?us原创 2013-03-09 00:10:19 · 4072 阅读 · 0 评论 -
Using Profile:Java Color Scheme to set Forms Color
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原创 2013-02-25 11:04:59 · 3625 阅读 · 0 评论 -
ICX Timeout Profile Values
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原创 2012-08-30 16:28:22 · 3352 阅读 · 0 评论 -
Configure your SMTP Server in Linux/Unix
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原创 2013-02-27 16:49:17 · 5368 阅读 · 1 评论 -
Enable EBS environments for JRE 7
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原创 2013-03-05 17:07:00 · 7584 阅读 · 0 评论 -
Script – Database structure and file location
1.Control Filesset pagesize 500set linesize 130PromptPrompt Control Files Location >>>>col name format a60 heading "Control Files"select namefrom sys.v_$controlfile/2.Redo Log FilesPromptP原创 2013-03-04 15:23:21 · 2329 阅读 · 0 评论 -
E-Business Suit + Oracle Exadata
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 topic原创 2013-02-19 22:50:26 · 2475 阅读 · 0 评论 -
Number of Processes(Workers) for Concurrent Manager
一个Concurrent Manager可以调用多个进程(Worker)来同时做事务处理,如何修改Concurrent Manager所能调用的进程数(Worker数)System Admin >Concurrent > Define > Work ShiftsProcesses的数量就是将来Concurrent Manager能够调用的进程数量。更改完后,去Concurrent > Manage原创 2012-12-12 20:01:29 · 3356 阅读 · 0 评论 -
How to check Oracle Applications Web Server Version ?
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原创 2012-12-26 12:07:01 · 2078 阅读 · 0 评论 -
Attachments in Oracle Form
默认情况下“附件”按钮是灰显的,本文将展示如何让某个Form的附件按钮变亮,并能上传附件.以用户Form为例,我们想让用户上传自己的照片Pre-SetupsHelp > Diagnostics > Custom Code > Personalize,记录下Function Name并用Help > Diagnostics > Examine查看User Name字段和User ID字段对应的Fie原创 2012-12-21 13:19:01 · 4192 阅读 · 0 评论 -
Windows7(64 bit)下访问Forms Builder - Windows XP Mode
Windows7(64 bit)下Form Builder的安装和使用还是有很多问题,暂时好像也没有太好的解决方案。这里推荐一个的解决方案:微软提供了一款虚拟机软件(Windows XP Mode),虚拟机为XP系统,我们可以在虚拟机里安装Oracle Developer Suit10g.当然你也可以使用其他虚拟机软件,比如Oracle VM VirtualBox,Vmware...但在体验上,个原创 2013-01-09 16:48:05 · 3739 阅读 · 0 评论 -
Due to "No space left on device", Many Concurrent Manager are under 'No Manager' Status
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:-----------原创 2013-01-28 14:50:02 · 3357 阅读 · 0 评论 -
adstpall.sh:Exiting with status 137
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 thi原创 2013-01-31 15:06:21 · 3524 阅读 · 0 评论 -
How to Bounce Apache or OC4J for OAF Development
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 stop原创 2012-11-01 11:33:12 · 4066 阅读 · 0 评论 -
Script – Tablespace Information
Script 1: Tablespace informationSET linesize 150column tablespace_name format a20 heading 'Tablespace'column sumb format 999,999,999column extents format 9999column bytes format 999,999,999,999co原创 2013-03-04 15:33:44 · 2430 阅读 · 0 评论 -
Application ENV parameter:CLASSPATH and AF_CLASSPATH
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..原创 2013-03-11 17:57:10 · 3010 阅读 · 0 评论 -
多做备份,慎用rm
Server上,发现空间不足,于是想删除一些临时日志来腾点空间,以为自己已经在日志目录下了,也没仔细看,就直接运行rm命令了,结果把系统中很多非常关键的脚本都清掉了,惊出一身冷汗。本来就很忙,还花费了一下午的时间才把删除的文件重新恢复。从中也得到了些教训:1.备份,备份,还是备份;2.慎用或者不用rm命令;3.操作前,保持头脑清醒,知道自己在干什么;原创 2013-03-02 00:37:28 · 2841 阅读 · 2 评论 -
创建CUX_TOP
客户化的Forms,Reports一般都是放到$CUX_TOP目录下(约定俗称),如果是初始化系统,那么这个目录是不存在的,那么创建这样一个客户化TOP的几步:1.在$APPL_TOP下建立CUX目录,其目录结构和其它PROD_TOP的目录结构一样2.在$INST_TOP/appl/admin/_.xml中加入CUX_TOP/.../appl/cux/12.0.03.停止服务器4.运行Autoco原创 2013-07-24 17:08:56 · 4174 阅读 · 0 评论 -
使用SQL打开或关闭Maintainance Mode
打Patch前,往往需要通过adadmin命令把系统模式设置成Maintainance Mode,这里再多提供一个打开或者关闭Maintainance Mode的方法。(首先说明这种通过SQL的方式维护系统并不推荐,毕竟绕开了正式管理工具直接执行,提供这么个信息可以让大家开阔下思路,至少知道所有的管理命令在后台都对应了一些脚本,可以打开看看这些脚本,了解内部的内部机制)可以通过Sql直接执行1.S原创 2013-10-08 09:34:24 · 2680 阅读 · 0 评论 -
Concurrent FND scripts & Related Common SQL Decodes
Concurrent FND scripts$FND_TOP/sql 下有很多现成Concurrent Program相关脚本afimchk.sql Tells the status of the ICMafcmstat.sql Lists active manager processesafrqrun.sql Lists all the running,原创 2012-06-29 15:48:54 · 2987 阅读 · 0 评论 -
ORA-01653: unable to extend table FND_CONCURRENT_REQUESTS by 16 in tablespace APPS_TS_TX_DATA
EBS中做业务的时候报ORA-01653: unable to extend table FND_CONCURRENT_REQUESTS by 16 in tablespace APPS_TS_TX_DATA解决方法:应该是表空间不够引起的,可以通过Script – Tablespace Information里的脚本查看下。使用下边Query查看TablespcaceSELECT * FROM原创 2012-09-21 17:05:49 · 4259 阅读 · 0 评论 -
Note:1499475.1 - Inventory Analyzer
Doc ID 1499475.1 - Inventory Analyzer : Health Check For Common Inventory Data Issues, Critical Patches, And Setups 这个Note里边的Inventory Analyzer脚本会从多个维度对Oracle EBS的库存模块做一次检测,让DBA对库存模块系统运行状况有一个全面的了解,最大原创 2014-06-23 18:57:38 · 2021 阅读 · 0 评论 -
Oracle EBS 表空间模型 - “Oracle Applications Tablespace Model(OATM)”
OATM即Oracle Applications Tablespace Model,是Oracle EBS可选的表空间模型。OATM提供12个表空间模型用于管理本地表空间,"APPS_"开头的属于Oracle EBS的业务表空间,此外的三个为Oracle数据库的系统表空间,包括Temp空间,System表空间,Undo表空间:OATM是11i10发布的,11i之前,每个模块都有两个表空间,一个是数原创 2014-05-23 18:16:53 · 8333 阅读 · 0 评论 -
Oracle Apps User Monitor(监控用户)
Monitor Users如何监控当前哪些用户在干什么,Oracle Apps提供了一个监控这么功能(尽管还是比较简陋)。使用系统管理员用户登陆,到System Administrator职责下,Security > User > Monitor,然后F11, Ctrl-F11,就可以看到当下有哪些用户在干什么,比如这里的截图,用户PROJMFG在Order Information Super U原创 2012-08-17 10:53:21 · 4516 阅读 · 1 评论 -
如何更换Oracle EBS主界面右上角的Oracle Logo
解决方法:参见Note 1235273.1:R12 - How To Change The Forms Logo On The Right Hand Side Of The Navigator主要是替换$ORACLE_HOME/forms/java/frmall.jar这个JAR包中oracle/forms/icons/oracle_logo_light.gif右上角Logo图标是存在JAR包中,原创 2015-04-23 18:11:02 · 2986 阅读 · 0 评论 -
EBS R12,11i不同类型对象在系统中的数量
EBS R12,11i,不同类型对象在系统中的数量OBJECT_TYPECOUNT(11i)COUNT(R12)Count(R12)-Count(11i)SYNONYM18584079410-106430INDEX495916024710656PACKAGE50027552185191PACKAGE BODY48947539995052VIEW35638395943956TABLE30661365原创 2012-06-08 09:52:47 · 2123 阅读 · 0 评论 -
AD Merge Patch
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原创 2013-04-05 11:20:43 · 2519 阅读 · 0 评论 -
AD Utilities
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.原创 2013-04-03 17:55:24 · 2954 阅读 · 0 评论 -
Find all used ports list in EBS R12 Instance
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 p原创 2013-03-23 19:03:14 · 10816 阅读 · 0 评论 -
Concurrent Request:Inactive phase,No Manager status
Symptom随便submit一个request,发现几乎所有的Concurrent Manager都为No Manager状态,Phase为Inactive。Solution一个Concurrent Request的生命周期包含不同的阶段(Phase):Pending, Running, and Completed,并且对于每一个Phase,又可能会有不同的状态。Pending Phase -原创 2012-07-19 23:47:48 · 5663 阅读 · 0 评论 -
How to check whether the patches have been applied or not
AD_APPLIED_PATCHES contains the list of patches that were directly applied.AD_BUGS contains the list of all the patches that were directly applied or were contained in the patches that were directly a原创 2012-04-25 16:49:32 · 12184 阅读 · 0 评论 -
Scripts in $AD_TOP/sql
$AD_TOP/sql 下有许多非常有用的脚本。Script11.0.x10.7NCA10.7SC/16.1Descriptionadcompsc.plsxxxCompile objects in a given schemaadcpresp.sqlx The script duplicates rows in FND_RESPONSIBILITY in the following way: F原创 2013-05-10 22:48:16 · 3253 阅读 · 0 评论 -
EBS 11i和R12目录结构(EBS Directory structure)
===For Applmgr User===APPL_TOP: 11i:ASE>/applR12:/apps/apps_st/applNOTE:Oracle Applicaitons product files,including $INV_TOP,$AU_TOP....COMMON_TOP:11i:/comnR12:/apps/apps_st/comn(Common files such as原创 2012-05-29 00:54:00 · 5988 阅读 · 0 评论 -
Oracle Application Server上不同类型的文件所在的目录
各种文件类型所在的目录转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7432635原创 2012-04-06 15:48:12 · 2194 阅读 · 0 评论 -
Oracle EBS用户登录情况统计脚本
select distinct d.user_name from apps.fnd_logins a,v$session b, v$process c, apps.fnd_user dwhere b.paddr = c.addrand a.pid=c.pidand a.spid = b.processand d.user_id = a.user_idand (d.user_name =原创 2012-12-15 19:49:51 · 5101 阅读 · 0 评论