Oracle Apps DBA
文章平均质量分 71
Oracle Apps DBA的相关文章(安装,维护,调优...)
田攀
tian.pan@qq.com
展开
-
How to Add a Icon to your Oracle Apps Toolbar item
1.准备图片,图片的格式为gif,不是icon或其他格式,图片像素:18×18 pixels把准备好的图片放到$OA_JAVA/oracle/apps/media下2.Forms PersonalizationTrigger:When-New-Form-Instance3.Personalization Action'Icon Name'特别要注意,不要加后缀的'.gif'效果原创 2013-01-17 11:51:07 · 2855 阅读 · 0 评论 -
Security Profiles
Oracle strongly recommends the following settings for these five security profiles:FND: Diagnostics -> NOFND Validation Level -> ERRORFND Function Validation Level ->ERRORFramework Validation Level ->原创 2013-01-23 10:15:44 · 2268 阅读 · 0 评论 -
Security Notes
Best Practices for Securing Oracle E-Business Suite403537.1 - Secure Configuration Guide for Oracle E-Business Suite Release 12189367.1 - Secure Configuration Guide for Oracle E-Business Suite Release原创 2013-01-23 10:28:02 · 2476 阅读 · 0 评论 -
JDeveloper经常黑屏的问题(Windows 7)
Windows 7下,使用JDeveloper(我的版本:10.1.3.3.0)过程中,屏幕经常会黑掉(尤其是拖动滚动条的时候),好像断电似的,并且会很慢,过一会才恢复过来,有时还会报“显示器驱动程序已停止响应,并且已恢复”的警告。解决方法:$JDEV_HOME\jdevbin\jdev\bin\jdev.conf中增加下边的选项AddVMOption -Dsun.java2d.noddra原创 2013-01-31 00:35:24 · 3169 阅读 · 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 评论 -
Top 10 Free Ways of Securing Your EBS Instance
Link:https://blogs.oracle.com/stevenChan/entry/webcast_replay_available_top_10covered the following topics: Check Profile SettingsChange Default PasswordsSecure APPLSYSPUBActivate Server SecurityImp原创 2013-02-20 12:03:45 · 1931 阅读 · 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 评论 -
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 评论 -
Start/Stop the Workflow Services in Oracle Apps
Navigation:Navigate to Workflow Administrator> Oracle Application Manager > Workflow Manager > Service Components > Workflow Agent Listener Services Start and Stop the Oracle Workflow Services--------原创 2013-02-27 11:48:22 · 6327 阅读 · 0 评论 -
多做备份,慎用rm
Server上,发现空间不足,于是想删除一些临时日志来腾点空间,以为自己已经在日志目录下了,也没仔细看,就直接运行rm命令了,结果把系统中很多非常关键的脚本都清掉了,惊出一身冷汗。本来就很忙,还花费了一下午的时间才把删除的文件重新恢复。从中也得到了些教训:1.备份,备份,还是备份;2.慎用或者不用rm命令;3.操作前,保持头脑清醒,知道自己在干什么;原创 2013-03-02 00:37:28 · 2841 阅读 · 2 评论 -
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 评论 -
$PROFILES$ in Examine
$PROFILES$.AFLOG_ENABLEDSpecifies if logging is enabled or not. The default value is NULL (False).$PROFILES$.AFLOG_FILENAMESpecifies the file where middle-tier log messages are written.$PROFILES$.AFLO原创 2013-03-06 12:07:42 · 4731 阅读 · 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 评论 -
Oracle的单点登录解决方案(Single Sign-On Solution)
Single Sign-On(SSO)即单点登录,简单说,就是通过用户的一次性鉴别登录,即可获得需访问系统和应用软件的授权,在此条件下,管理员无需修改或干涉用户登录就能方便的实施希望得到的安全控制。Oracle现有两套单点登录的解决方案:Oracle Access Manager,Oracle Single Sign-On Server (OSSO)。Oracle官方推荐Access Manage原创 2013-03-19 15:01:32 · 19496 阅读 · 1 评论 -
[News]Apple iPads Certified with Oracle E-Business Suite 12.1
Steven Chan最近发布消息,iPad(iOS 6.0+)已经可以访问EBS(12.1.3+)了。用户可以通过iPad来访问OA Framework页面的EBS功能,但还不支持访问Form。OverviewOracle E-Business Suite Release 12 (12.1.3 or higher) is now certified with iOS 6.0 and higher原创 2013-03-23 18:11:34 · 2222 阅读 · 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 评论 -
WebUtil Useful Reference
WebUtil Demo / DocumentationWebUtilHome Page on OTNWebUtil- A simplified guide to understanding WebUtil.WebUtil Version 1.0.6 - Production Release Notes FAQ Oracle Forms 10g WebUtil WebUtilDemoUsing W原创 2013-03-25 00:45:24 · 4080 阅读 · 0 评论 -
Error:APP-FND-00804
点Locator弹性域,报APP-FND-00804错,详细错误信息如下APP-FND-00804: Program error: Invalid arguments to the flexfield routines. Please inform your support representative that:Routine FDFGST unable to find flexfield qu原创 2013-04-03 16:37:04 · 3609 阅读 · 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 评论 -
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 评论 -
<<Oracle E-Business Suite : ERP DBA实践指南>> - 简评
相对于SAP,国内Oracle EBS方面的中文图书真是少之又少,据我了解现在市面上应该只有三本:第一本是《ORACLE财务管理系统教程》,06年出版,之前图书馆借过(市面上好像也不好买到),写的是Oracle EBS 11i的财务系统,不过因为R12的财务系统相较于11i已经有了较大的改变,所以觉得如果你是使用R12版本,那么这本书只能参考,收获应该有限。然后就是:赵杰夫的《Oracle EBS原创 2013-04-08 20:32:07 · 4148 阅读 · 1 评论 -
RDA(Remote Diagnostic Agent) Report for Oracle E-Business Suite
一个RDA报表能收集目标模块许多关键数据,比如目标模块的各个文件版本,JDBC版本,索引情况,Profile配置,系统版本,DB版本...一个Report在手,系统的配置信息你也基本就拿全了。使用方法:Start Oracle E-Business SuiteConnect to responsibility Application Diagnostics原创 2013-04-25 00:12:02 · 2901 阅读 · 0 评论 -
REP-3000: Internal error starting Oracle Toolkit
Open Oracle Reports with command rwbuilder.sh, encounter error: "REP-3000: Internal error starting Oracle Toolkit."[oracle@bej301441 ~]$ rwbuilder.shReport Builder: Release 10.1.2.3.0 - Production on原创 2013-04-27 11:50:33 · 5139 阅读 · 0 评论 -
APP-FND-01564: Oracle error 1403 in fdxwho
Oracle Form里查看Record History,报错:APP-FND-01564: Oracle error 1403 in fdxwho APP-FND-01564: Oracle error 1403 in fdxwhoCause: fdxwho failed due to ORA-01403: no data found.The SQL statement being execut原创 2013-04-28 16:08:57 · 7196 阅读 · 0 评论 -
Oracle EBS Key Patches
Release R12.0.X5082400 - 12.0.1(RUP1 FOR ORACLE APPLICATIONS RELEASE 12)5484000 - 12.0.2 Release Update Pack (RUP2)6141000 - 12.0.3 Release Update Pack (RUP3)6435000 - 12.0.4 Release Update Pack (RUP4原创 2013-05-09 00:30:34 · 2796 阅读 · 0 评论 -
Oracle Application Patch Types
Standalone (one-off) Patch:Addresses a single fix or enhancement. Standalone patches are released only when there is an immediate need for a fix or enhancement that cannot wait until an aggregate bund原创 2013-05-09 00:49:46 · 5215 阅读 · 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 评论 -
Oracle E-Business Suite Upgrade Documents
Oracle E-Business Suite Upgrade Guide Release 11i to 12.1PDF Version: LinkHTML Version:LinkNew Whitepaper: Planning Your E-Business Suite Upgrade from Release 11i to 12.1 (Second Edition) https://blog原创 2013-05-11 00:13:48 · 2258 阅读 · 0 评论 -
OPatch cannot find a valid oraInst.loc file to locate Central Inventory
命令:opatch lsinventory用于查看数据库所打Patch的列表。但运行的时候发现错误:[oracle@bej301441 OPatch]$ opatch lsinventoryInvoking OPatch 11.1.0.6.2Oracle Interim Patch Installer version 11.1.0.6.2Copyright (c) 2007, Oracl原创 2013-05-11 11:29:00 · 5806 阅读 · 0 评论 -
如何安装/升级Opatch
1.My Oracle Support (MOS), Link:http://support.oracle.com2. Patches & Updates页签下,Patch Name or Number输入6880880 , 并且选择正确的平台根据你的的Release版本来下载Opatch把旧的$ORACLE_HOME/Opatch目录备份,然后把刚下载的文件拷贝到对应的ORACLE_HOME下,原创 2013-05-11 12:05:48 · 6182 阅读 · 1 评论 -
Oracle EBS 11.5.10的下载方法
你可以从Oracle eDelivery下载最新版本的Oracle EBS R12.1.1,但要下载11.5.10的话,可以参考以下的步骤:1.登陆Oracle eDelivery2.'Product Pack'选择On Demand,然后选择你需要的平台。3.下载“Oracle E-Business Suite Certified Configuration Release 11.5.10 Me原创 2013-05-27 13:22:35 · 8047 阅读 · 0 评论 -
Security Warning:unsafe component, oracle.forms.engine.Main
Oracle EBS中,Material Workbench里钻取左边的SKU树,遇到以下Warning英文:Java has discovered application components that could indicate a security concern.Name: oracle.forms.engine.MainBlock potentially unsafe compone原创 2013-06-03 20:53:57 · 7531 阅读 · 0 评论 -
Oracle EBS在各平台下安装方法的搜集整理
兼听则明,偏信则暗。看书看文档都是这样,即使是同一主题,内容都可能大不相同,有的是因为方法不一样,有的是因为作者观点或视角不同,让文档内容有所出入,所以研究问题,多看些不同作者文档总归是好的。很多人都安装过EBS,也都写了总结,这些总结散落在网络各处,试着把这些文档搜集起来,方便后来人查阅。此文会持续更新...R12Oracle Application R12 (12.1.3) Installat原创 2013-06-13 21:29:36 · 6684 阅读 · 0 评论 -
Linux下使用ps命令来查看Oracle DB以及EBS相关的进程
Linux下可以使用ps命令来查看Oracle相关的进程使用ps来查看Oracle数据库相关的服务Oracle Listener这个命令会列出Oracle Net Listener的进程[oracle@bej301441 ~]$ ps -ef | grep tnslsnroracle 1999 29986 0 09:47 pts/2 00:00:00原创 2012-07-11 01:02:42 · 15871 阅读 · 0 评论 -
How to start&stop WMA MSCA(Mobile) port in R12/11i system
How to start&stop WMA MSCA(Mobile) port in R12/11i system Start Mobile new PortR12:cd $INST_TOP/admin/scripts11i:cd $MWA_TOP/binmwactl.sh start 10999Stop Mobile portR12:cd $INST_TOP/ad原创 2012-07-13 12:48:48 · 2155 阅读 · 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 评论 -
IE浏览器打开Oracle EBS,然后报安全信息的提示
IE浏览器打开Oracle EBS,然后报安全信息的提示安全信息本页不但包含安全的内容,也包含不安全的内容。是否显示不安全的内容。解决方法:IE > Internet选项 > 安全 > 自定义级别 > 显示混合内容 > 把"提示"改成"启用"原创 2012-08-10 11:03:23 · 2389 阅读 · 0 评论 -
IE browser is closing and crashing as soon as you open Oracle Apps
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 BrowsingTools > Internet Op原创 2012-08-10 11:10:53 · 1688 阅读 · 0 评论 -
Error:The system has not been taken off maintenance mode completely.
打patch之后,重启EBS Server,使用IE登陆时,报ErrorThe system has not been taken off maintenance mode completely. Please contact your System Administrator.从错误上看,貌似是Maintainance模式没有关闭,然后就使用adadmin关闭Mainte原创 2012-08-10 17:43:45 · 3445 阅读 · 0 评论