OracleOnDemand(OOD)项目中EBS打补丁的详细步骤
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了OracleOnDemand(OOD)项目中EBS打补丁的详细步骤,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2569字,纯文字阅读大概需要4分钟。
内容图文
![OracleOnDemand(OOD)项目中EBS打补丁的详细步骤](/upload/InfoBanner/zyjiaocheng/549/69bc311a2b2c48a99a32542b55efecd2.jpg)
Oracle On Demand(OOD)项目中EBS打补丁的详细步骤
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 -c patch_num2h>
#blackout DB node
/usr/local/git/bin/em-blackout-cmd -o start -t full -r 2 -d <2h> -u
#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
#health check
login instance from frontend, switch to Application Administrator responsibility, submit Active User request, check output.
内容总结
以上是互联网集市为您收集整理的OracleOnDemand(OOD)项目中EBS打补丁的详细步骤全部内容,希望文章能够帮你解决OracleOnDemand(OOD)项目中EBS打补丁的详细步骤所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。