Oracle Database July 2017 OJVM Security Patch 26027162


Applying July 2017 OJVM security patch 26027162 on orcl prod clusters


Ensure ORACLE_HOME is set correctly, and that the $PATH definition has the following executables: make, ar, ld and nm.
unzip -d <PATCH_TOP_DIR> p26027162_12102_<PLATFORM_NAME>.zip
cd /u03/setup/security_patch_Jul2017_DB/26027162

2. opatch prereq CheckConflictAgainstOHWithDetail -ph ./

2a. Stop goldengate

3. For an Oracle RAC environment, shut down database services on the node to be patched.

for i in `srvctl status service -d orclprod|awk ‘{print $2}’`
srvctl stop service -d orclprod -i orclprod2 -s $i

4. srvctl stop instance -d orclprod -i orclprod2 -o immediate

Note: Switch instance name for another instance orclprod1 when doing node 1.

cd /u03/setup/security_patch_Jul2017_DB/26027162
opatch apply -local (Run this on both nodes, one at a time).

opatch lsinventory

7. srvctl start instance -d orclprod -i orclprod2

Note: Loading Modified SQL Files Into the Database after both nodes are patched.
On only one node, perform the following steps to start an Oracle RAC database in startup upgrade mode.


Post-install for database and beyond…..using either with or without startup upgrade mode.

—————Without startup upgrade mode——————

Note: Make sure all pdb’s are open.
Note: Take invalid objects count.

sqlplus ‘/as sysdba’
show pdbs;

alter session set container=orclRACPDB;

set lines 120
col object_name form a45
col owner form a20
select owner, object_name, object_type, status from dba_objects where status=’INVALID’ order by owner;
./datapatch -verbose (takes about 5 minutes, no outage)


### verify patch
set lines 200
col DESCRIPTION for a60
select PATCH_ID,ACTION,STATUS,DESCRIPTION,ACTION_TIME from dba_registry_sqlpatch order by action_time;

select PATCH_ID,ACTION,STATUS,DESCRIPTION,ACTION_TIME from registry$sqlpatch order by action_time;

col time form a40
col cause form a30
select time, name, CAUSE,status from pdb_plug_in_violations where status != ‘RESOLVED’;

11. Bounce Database: srvctl stop database -d orclprod -o immediate

12. Start goldengate.

TEST script:

for i in `srvctl status service -d orclprod|awk ‘{print $2}’`
echo $i “is running…”

================================ORACLE PROVIDED QUERY================================


select * from V$LOCKED_OBJECT where OBJECT_ID in (select object_id from All_Objects where OBJECT_NAME = ‘GV_$INSTANCE’);

select distinct to_name object_locked from v$object_dependency where to_address in ( select w.kgllkhdl address from dba_kgllock w, dba_kgllock h, v$session w1, v$session h1 where ((h.kgllkmod != 0) and (h.kgllkmod != 1) and ((h.kgllkreq = 0) or
(h.kgllkreq = 1))) and (((w.kgllkmod = 0) or (w.kgllkmod= 1)) and ((w.kgllkreq != 0) and (w.kgllkreq != 1))) and w.kgllktype = h.kgllktype and w.kgllkhdl = h.kgllkhdl and w.kgllkuse = w1.saddr and h.kgllkuse = h1.saddr);

=================FOR RAT VERIFICATION======================

select value from v$option where parameter = ‘Real Application Testing’;
select comp_name, status from dba_registry;
select owner, object_name, object_type, status from dba_objects where owner=’SYS’ and status <> ‘VALID’;

143 thoughts on “Oracle Database July 2017 OJVM Security Patch 26027162”

  1. Getting a greater computer keyboard makes web surfing less difficult.
    Also it doesn’t have to be another keyboard. Simply change the unit sideways, push the handle club in the internet
    browser and you’ll be preparediPhone movie This will give an individual access to a bigger computer keyboard to make your current inputting a piece
    of cake.

  2. Your kids will have genuine fun with the 3-in-1 kits. It makes a fun toy and a best birthday, Easter,
    or Christmas present. The plastic material is of high quality making this a
    really long lasting Inflatable toy. This fun dinosaur present set comes with four
    plastic dinosaurs in 3 favorite kids colors: blue, red
    and green. This set of toys will keep your children engage and immersed in imaginative play for hours.

    This dinosaur toys set was so much enjoyable for him.
    This LEGO package enables you to recreate one of the most
    legendary action sequences of the 2016 hit, ‘Jurassic World’.
    The image comes in practical dinosaur information that help your kids to instantly
    swing into action. They are made of high-quality and hand
    painting with total details. Puzzle gifts are awesome for young
    ones as they promote problem-solving abilities and establish hand-eye coordination. It
    likewise boosts their motor skills and improves their creative ability
    with imaginative play. It catches your kid creativity and sets him
    off on creative have fun with its appealing color designs.
    They are made from exceptional quality and are durable features
    brilliant colors which capture your kid’s
    imagination. Not just are dinosaurs fearsome, fascinating, and just plain cool, however they likewise supply an excellent way to inform kids about archaeology, paleontology, and natural history.

  3. Good day! I know this is kinda off topic but I was wondering which blog platform are you using for this website?
    I’m getting sick and tired of WordPress because I’ve had problems with
    hackers and I’m looking at options for another platform.
    I would be fantastic if you could point me in the direction of
    a good platform.

  4. Hey there just wanted to give you a quick heads up and let you know a few of
    the pictures aren’t loading properly. I’m not sure why but I think its a linking issue.
    I’ve tried it in two different web browsers and both show the same results.

  5. I was suggested this blog by my cousin. I’m not sure whether this post is written by him as nobody else know such detailed about my trouble.
    You’re incredible! Thanks!

  6. Hello! I could have sworn I’ve been to this site before but after checking through some of thhe post I realized it’s new to me.
    Anyhow, I’m definitely glad I found it and I’ll be book-marking
    andd checking back frequently!

  7. Having read this I believed it was very informative.
    I appreciate you taking the time and energy to put this information together.
    I once again find myself personally spending way ttoo much time both
    reading and commenting. But so what, it was still worth it!

  8. I was curious if you ever thought of changing the layout of your website?

    Its very well written; I love what youve got to say.
    But maybe you could a little more in the wayy of content so
    people could connect with it better. Youve got an awful lot
    of text for only having one or 2 images. Maybe you could space
    it out better?

  9. Should your Travel goes to be able to recreational areas or another
    place that will need passes, find them on the web. Many times you may can easily art
    print these both at home and save some money, also. The small charge for a
    real services are worth every penny to prevent extended lines.
    Furthermore, recreational areas at times provide timed
    accessibility, if they certainly, you can use the
    passes to have to the actual programs series.

  10. Hello! Do you know if they make any plugins to safeguard against hackers?
    I’m kinda paranoid about losing everything I’ve worked hard on. Any suggestions?

  11. I’m amazed, I must say. Rarely do I come across a blog that’s both educative and entertaining, and
    let me tell you, you have hit the nail on the head. The problem is something which
    too few men and women are speaking intelligently about.

    I’m very happy I came across this in my search for something regarding this.

  12. I’ve been browsing online greater than 3 hours nowadays,
    yet I by no means found any fascinating article like yours.
    It’s lovely value sufficient for me. In my opinion, if all site owners and bloggers made
    excellent content material as you did, the internet will probably be a lot more useful than ever before.

  13. Pretty section of content. I just stumbled upon your web site and in accession capital to assert that I get in fact enjoyed account your blog posts.

    Any way I will be subscribing to your feeds and
    even I achievement you access consistently quickly.

  14. You are so cool! I do not think I have read through a single thing like this before.
    So great to discover somebody with a few original thoughts on this subject.
    Really.. thank you for starting this up. This website is one thing that’s needed on the web, someone with a bit of originality!

  15. I know this if off topic but I’m looking into starting my own blog
    and was wondering what all is required to get setup? I’m assuming having a blog like yours would cost a pretty penny?

    I’m not very internet savvy so I’m not 100% positive.
    Any recommendations or advice would be greatly appreciated.
    Many thanks

  16. It’s the best time to make some plans for the future and it’s time to be happy.
    I have read this post and if I could I wish to suggest you few interesting
    things or suggestions. Maybe you can write next
    articles referring to this article. I desire to
    read even more things about it!

  17. When I initially commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment
    is added I get three emails with the same comment. Is there any
    way you can remove me from that service? Thanks!

  18. Wonderful article! This is the kind of info that are meant to be shared around the web.
    Disgrace on the seek engines for not positioning this put up upper!
    Come on over and talk over with my site . Thank you =)

  19. Greetings! Very useful advice in this particular post!
    It’s the little changes that produce the biggest changes.

    Thanks a lot for sharing!

  20. This is a very good tip particularly to those new to the blogosphere.
    Simple but very accurate information… Thanks for sharing this one.
    A must read article!

  21. Appreciating the persistence you put into your site
    and detailed information you offer. It’s nice to come across a blog every once in a while that isn’t the same out of date rehashed
    material. Great read! I’ve bookmarked your site and I’m including your
    RSS feeds to my Google account.

  22. This is very interesting, You are a very skilled blogger.

    I’ve joined your rss feed and look forward to seeking more of your wonderful post.

    Also, I have shared your site in my social networks!

Leave a Reply

Your email address will not be published. Required fields are marked *