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 -u -c patch_num
#blackout db node
 /usr/local/git/bin/em-blackout-cmd -o start -t full  -r 2 -d -u -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
#health check
login instance from frontend, switch to application administrator responsibility, submit active user request, check output.
，