Oracle Database July 2017 OJVM Security Patch 26027162

Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail



Applying July 2017 OJVM security patch 26027162 on orcl prod clusters

SECTION A:

1. PRE-CHECKS STEPS:
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}’`
do
srvctl stop service -d orclprod -i orclprod2 -s $i
done
———————-

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

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

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

6. VERIFICATION STEPS:
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.

SECTION B:

Post-install for database 12.1.0.2 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.

8.
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;
—————————————————————
9.
cd $ORACLE_HOME/OPatch
./datapatch -verbose (takes about 5 minutes, no outage)

10.
SECTION C:

### 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}’`
do
echo $i “is running…”
done

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

SELECT SID, OWNER, OBJECT, TYPE FROM V$ACCESS WHERE OBJECT = ‘GV_$INSTANCE’ ;

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’;

114 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. https://hellboyfull.co/

  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.

Leave a Reply

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