Hey DBA-Mates,
Oracle always tries to provide all the information which will be helping to customer and informed decisions about when and what patches to apply on servers. Our exposes bugs resolved by this patch and do a search against the knowledge base to check if there any articles or documents might be relate to this patch. After apply the patches, how we will come to check that the patches has been applied or not on the servers.
Oracle always tries to provide all the information which will be helping to customer and informed decisions about when and what patches to apply on servers. Our exposes bugs resolved by this patch and do a search against the knowledge base to check if there any articles or documents might be relate to this patch. After apply the patches, how we will come to check that the patches has been applied or not on the servers.
As we all know we apply the patches to fix any bugs or
issue in our either oracle database or application. It may be either
small or big bugs or issues, which depends on situations. As per my
experiences, my suggestion is always go through readme.txt or readme.html file in patch directory before
applying the patches. And you may have noticed, always readme.html is clear by
looking way and colorful which helps a lots for understanding. It’s just my opinion,
depends on person to person.
Please find the below query to check.
SQL>set pages 1000
SQL>set linesize 100
SQL>column APPLIED_PATCH_ID format 9999999999
SQL>column PATCH_NAME format a16
SQL>column CREATION_DATE format a16
SQL>column BUG_ID format 9999999999
SQL>column BUG_NUMBER format a16
SQL>SELECT APPLIED_PATCH_ID,PATCH_NAME,CREATION_DATE
SQL>set pages 1000
SQL>set linesize 100
SQL>column APPLIED_PATCH_ID format 9999999999
SQL>column PATCH_NAME format a16
SQL>column CREATION_DATE format a16
SQL>column BUG_ID format 9999999999
SQL>column BUG_NUMBER format a16
SQL>SELECT APPLIED_PATCH_ID,PATCH_NAME,CREATION_DATE
FROM apps.ad_applied_patches where patch_name='&PatchNO'
union
SELECT BUG_ID,BUG_NUMBER,CREATION_DATE
union
SELECT BUG_ID,BUG_NUMBER,CREATION_DATE
FROM apps.ad_bugs where bug_number='&PatchNO'
/
/
If we have the patch number, we can check
the patch details from below query:
To get or find out all
the patch details by giving patch number as input:
SQL>SELECT to_char(r.patch_run_id) patch_run_id
,t.name appl_top
,d.driver_file_name driver_file_name
,l.language language
,to_char(r.start_date,'YYYY/MM/DD HH24:MI:SS') start_date
,to_char(r.end_date,'YYYY/MM/DD HH24:MI:SS') end_date
,r.patch_top patch_top
FROM ad_appl_tops t
,ad_patch_drivers d
,ad_patch_runs r
,ad_patch_driver_langs l
WHERE t.appl_top_id = r.appl_top_id
and r.patch_driver_id = d.patch_driver_id
and l.patch_driver_id = d.patch_driver_id
and d.driver_file_name like '%&p_bug_number%'
order by r.patch_run_id
/
From above query, it will prompt for patch number, which we need to give as input. Please give the patch number and get all the details about that patch.
SQL>SELECT to_char(r.patch_run_id) patch_run_id
,t.name appl_top
,d.driver_file_name driver_file_name
,l.language language
,to_char(r.start_date,'YYYY/MM/DD HH24:MI:SS') start_date
,to_char(r.end_date,'YYYY/MM/DD HH24:MI:SS') end_date
,r.patch_top patch_top
FROM ad_appl_tops t
,ad_patch_drivers d
,ad_patch_runs r
,ad_patch_driver_langs l
WHERE t.appl_top_id = r.appl_top_id
and r.patch_driver_id = d.patch_driver_id
and l.patch_driver_id = d.patch_driver_id
and d.driver_file_name like '%&p_bug_number%'
order by r.patch_run_id
/
From above query, it will prompt for patch number, which we need to give as input. Please give the patch number and get all the details about that patch.
Hope above query may useful and helpful. For any
concerns, please write to us either in comment box or contact us @ora-data.blogspot.com
Below are some more useful and helpful links:
Regards,
Exceptional post һowever , І was wanting to knoᴡ if
ReplyDeleteｙoս coulod write a litte mߋгe on this topic? I'd be very grateful
if y᧐u coᥙld elaborate a ⅼittle bit mоre. Bless yߋu!
I'm really enjoying the design and layout of your website.
ReplyDeleteIt'sa very eaqsy on the eyes which makes it much more pleasant for me to come here and visit more often.
Did you hire out a developer to create your theme?
Excellent work!
I think that what you posted was actually very reasonable.
ReplyDeleteHowever, think on this, suppose you were to write a awesome headline?
I am not suggesting your content isn't solid, however suppose
you added something to maybe grab folk's attention? I mean "How to check and get details about patch applied" is a little plain. You
should peek at Yahoo's home page and watch how they create news headlines to grab people to click.
You might try adding a video or a related picture or two to
get people interested about everything've got to say.
In my opinion, it would bring your website a little
bit more interesting.
Dear User,
ReplyDeleteThank you very much for your feedback.
Regards,
ora-data Team
Dear User,
ReplyDeleteThank you very much for your valuable feedback.
Please follow us on our Facebook page:Our Facebook Page
Regards,
ora-data Team
Great info. Lucky me I discovered your blog by accident (stumbleupon).
ReplyDeleteI've bookmarked it for later!