随笔分类 - EBS_admin
摘要：<<攻>>Oracle EBS密码安全机制做的并不完善，还有漏洞，已经看到很多的帖子在讲如何破解密码.最牛的是“Oracle 11i / 12 APPS Password Cracker”这一篇文章（需FQ）,破解密码都不用费力的....http://symplik.blogspot.com/2010/07/oracle-11i-12-apps-password-cracker.html“How to find out Oracle Apps password??”http://www.appsdbatraining.com/2011/05/05/how-to-find
阅读全文
摘要：Online Patching就是允许用户在运行时打patch，并且无需重启服务器。以前如果用户要打patch，用户必须重启应用服务，这个很麻烦并且让会造成几个小时的停机，给客户也造成了成本的损失，12.2以后引入Online Patching,就不会有这样的烦恼了,对于EBS DBA绝对是一个福音 R12.2 OLP的实现方式：12.2引入了双文件系统(一个是run time文件系统，另一个是patching文件系统)，包括APPL_TOP, Common Top, Oracle Home, Web Home等等. 那么对于DB来说，在runtime和patching文件系统，是怎么管理数据
阅读全文
摘要：这是先整理了一个流程思路,过一段时间在把文档整理出来.
阅读全文
摘要：群中一个朋友问到,执行如下命令遇到错误.而且之前没有做过任何改动操作,很少奇怪.一般这个错误应该是环境变量没有加载或classpath 设置的问题,但是网友没有改动操作,就只能去看adclonectx.pl这个文件了.看到这段话,心里明白了一大半,猜测出问题的原因了,但是为什么?我们继续往下看这里perl 脚本去拼$CLASSPATH,如果$ADCONFIG $XMLPARSERV2 $JDBCCLASSES ,这些变量的提取的路径大家可以去看一下.到这里我们的问题也就解决了.
阅读全文
摘要：Are you good DBA ? Are you comfortable in UNIX/Linux environment ? Are you confortable with Oracle Installations/Backups(RMAN)/Recoveries/Tuning/upgrades ? Have atleast 1 year experience as Oracle DBA ? OCP is preferred and in future it is mandatory ? If yes, then you are right choice for Oracl...
阅读全文
摘要：OpenWorld 2011 的文档已经可以下载了,大家可以看一下涉及EBS方面的文档.OpenWorld is fast approaching. It's going to be a very busy conference for us. We have 25 sessions, three Hands-On Labs, two Meet the Experts round-table discussions, and five demoground booths planned just for E-Business Suite Applications Technology
阅读全文
摘要：allows you to create standby databases for disaster recovery. Oracle Data Guard Broker provides an easy interface to configure standby databases and to perform role transitions with a single command for switchover and failover. It logically groups the primary and standby databases into a broker conf
阅读全文
摘要：检查Linux的java版本,系统自带版本为1.4.2[root@erpdemo Desktop]# java -versionjava version "1.4.2"gij (GNU libgcj) version 4.1.2 20080704 (Red Hat 4.1.2-44)Copyright (C) 2006 Free Software Foundation, Inc.This is free software; see the source for copying conditions. There is NOwarranty; not even for MER
阅读全文
摘要：A customer recently reported an issue where they needed to bounce their E-Business Suite application tier (mid-tier) servers once a week to resolve stability issues. This shouldn't be necessary. We recommend against bouncing EBS application servers regularly. We've done a lot of work with th
阅读全文
摘要：I am pleased to announce our next ATG Live Webcast, scheduled for Thursday, 25-Aug-2011. The event is titled:我很高兴的告诉大家ATG LIVE直播将在2011-8-25 星期四如期开始,会议议题:EBS调优Tuning All Layers of E-Business SuiteThis one-hour webcast provides an overview of how Oracle E-Business Suite system administrators, DBAs, de
阅读全文
摘要：检查Linux的java版本,系统自带版本为1.4.2[root@erpdemo Desktop]# java -versionjava version "1.4.2"gij (GNU libgcj) version 4.1.2 20080704 (Red Hat 4.1.2-44)Copyright (C) 2006 Free Software Foundation, Inc.This is free software; see the source for copying conditions. There is NOwarranty; not even for MER
阅读全文
摘要：In this article I will try to explain some of the mysteries around the "Java Caching Framework," as this is a commonly misunderstood technology (which is probably due to it being well-hidden from the casual observers view).This article will be an introduction to the topic, rather than tryi
阅读全文
摘要：I'm still doggedly plowing through our article backlog following our two-month blogging hiatus. Almost done. Here's a long-outstanding response to a FAQ about new browsers.As of today, Internet Explorer 8 and Firefox 3.6 are the latest Windows desktop clients certified for Oracle E-Business
阅读全文
摘要：今天解决一个AP发票验证的性能问题,从metalink上找了补丁,在测试环境上测试一下,问题就接踵而来.1,在apply patch的时候,出现如下提示:The following Oracle Reports objects did not generate successfully:apreports/USAPXAPRVL.rdf感觉这个问题影响不大,就选择"Y"继续打完补丁,类似这种问题,可以查看一下后台日志,看看有没有什么具体的原因造成的或看看这个报表的代码,再不行就从metalink上去碰运气了,因为Oracle的打patch而导致另外的问题出现,相信大家都遇到过
阅读全文
摘要：相信做EBS dba的朋友都做过clone吧?从11.5.6的手动clone到11i.5.8 的autoconfig到R12更强大的clone.其实原理无外乎就是重建控制文件(修改SID),修改$CONTEXT_FILE文件中的路径/端口等.然后再去修改APP.对于APP从源机器到目标机器,可以打包FTP,磁带,带库等等方式去恢复,而对于DB一般采用2种方式:冷备或RMAN热备; 我遇到的问题就出现了: 因为近期把DB的归档模式打开,顺便也就备份了一下,Time:2010-02-08:15:00:00(春节还在加班,辛苦吧).以下为clone步骤:1. restore cold backup
阅读全文
摘要：OS: Win 7 64 IE 8.0 ERP: R12.1.1 --------------------------- solution:现在R12已经认证IE8,并且可以正常访问EBS系统，但是目前只能打开一个窗口，如果用其他用户再次登录，会显示“您的登录会话已无效。正在退出Oracle Applications” Previous releases of Internet Explorer have allowed users to logon to the same Oracle E-Business Suite environment concurrently from the sa
阅读全文