EBS patching steps in Oracle On Demand(OOD) projects
#check if patch applied & count of invalid objects, create invalids table & replace 7777777 with patch number
select name,user from v$database;
select BUG_NUMBER, LAST_UPDATE_DATE, success_flag from ad_bugs where bug_number=xxx;
create table apps.invalids_13jul12_7777777 as select * from dba_objects where status='INVALID';
select count(*) from dba_objects where status='INVALID';
#copy patch to stage area
cp /tmp/pxxx.zip /dxxx1i/applcsf
#unzip patch zip
unzip pxxx.zip
#check if all prerequisites meet, such as merge or prerequisite patch need
view readme
#switch user
pbrun impdba -u apdxxx1i
#list all available targets on host
/usr/local/git/bin/em-blackout-cmd -s
#list all active blackouts on host, if there's already active blackouts on specific instance, it means other people have already booked this time slot
/usr/local/git/bin/em-blackout-cmd -o list
#blackout APP node
/usr/local/git/bin/em-blackout-cmd -o start -t "DXXX1I" -r 2 -d <2h> -u <apdxxx1i> -c patch_num
#blackout DB node
/usr/local/git/bin/em-blackout-cmd -o start -t full -r 2 -d <2h> -u <ordxxx1i> -c patch_num
#stop all app service($ADMIN_SCRIPT_HOME), make sure no errors except timeout relative issue.
adstpall.sh apps/apps
#wait several minutes till all FNDLIBR process quit
ps -ef | grep FNDLIBR | grep dxxx1i
#enable maintence mode
adadmin
#cd patch directory & patch, logfile name format patchnum_13jul12.log
adpatch
#check log see if any errors, seach error
view patchnum_13jul12.log
/error
##check if patch applied & count of invalid objects, drop invalids table if no more invalids
select name,user from v$database;
select BUG_NUMBER, LAST_UPDATE_DATE, success_flag from ad_bugs where bug_number=xxx;
select object_name,object_type,owner,LAST_DDL_TIME from dba_objects where status='INVALID' and object_name||object_type||owner not in (select object_name||object_type||owner from apps.invalids_13jul12_7777777);
select count(*) from dba_objects where status='INVALID';
drop table apps.invalids_13jul12_7777777;
#disable maintence mode
adadmin
#start all app service($ADMIN_SCRIPT_HOME), make sure no errors except timeout relative issue.
adstrtal.sh apps/apps
#disable blackout(APP&DB)
#list all active blackouts on host
/usr/local/git/bin/em-blackout-cmd -o list
#Stop blackout
/usr/local/git/bin/em-blackout-cmd -o stop -n <blackout name from above command>
#health check
login instance from frontend, switch to Application Administrator responsibility, submit Active User request, check output.
分享到:
相关推荐
它是一个Open OnDemand应用程序,旨在以用户身份运行。特征创建文件/文件夹查看文件编辑文件(配置了) 重命名/复制/粘贴/删除文件上传大文件下载档案发射终端(配置了 )新安装从所有sys应用程序的构建目录开始,...
阶段,要明确用户提出了哪些功能要求,为完成这些要求,系统应有哪些构件,采用什么样的结构,并写出详细的需求规约。OOA中引入了许多面向对象的概念和原则,如,对象、属性、服务 、继承、封装等,并利用这些概念和原则来...
而《OOD启思录》被读者评价为“面向对象设计领域中的Effective C++”——正如Effective C++能帮助你迈向C++专家层面,《OOD启思录》能帮助你迈入OOD殿堂。 本书提供了改进面向对象设计的真知灼见。 全书共11章...
面向对象设计(OOD)思想(示例代码见文末下载连接)收藏 有了思想才能飞翔,缺乏灵活就象少了轮子的汽车,难以飞奔。为了更好的理解设计思想,结合一个尽可能简洁的实例来说明OOD、设计模式及重构。通过下面的代码,...
这个存储库的master分支由puppet自动部署到ondemand节点上的/ var / www / ood / apps / sys /中。 如果要在用户开发环境中进行部署以进行修改,请遵循以下说明。 # create the development folder if you still ...
看外国专家简单明了讲解如何解释OOD及设计
OOD设计很好的教材,高清 OOD启思录
OOD启思录
Java OOA & OOD & UML
1.Click on the "ON" button (lower right-hand corner) to turn the ATM on. 2.Enter the number of $20 bills you want to have be in the cash dispenser at the start of the simulation when you are prompted ...
面向对象设计OOD 面向对象设计OOD 面向对象设计OOD 面向对象设计OOD
ooa,ood介绍的入门资料,请想用,谢谢
ood启思录读书笔记
面向对象技术的C++ OOD实践 面向对象技术的C++ OOD实践
面向对象分析(OOA)、面向对象设计(OOD)与UML的基础教程
OOD-Principles-In-Swift, 关于Bob叔叔的文章,基于OOD的原理 import Swiftimport Foundation Swift 4中的OOD原理使用 Xcode 9游乐场( OOD-Principles-In-Swift.playground.zip )的短备忘单。 也兼
如何向妻子解释面向对象设计(OOD)
本文不讨论“怎么做需求分析”,也不讨论“怎么做编码实现”,更不讨论“设计模式是否有用或是否有必要”等问题,本文主要讨论“怎么利用设计模式做软件设计”。 当我们讨论设计模式时,我们不是要解决一个问题,...