Oracle 12c PSU

Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail



Note: Change -n ch-orcldb-s02 to -n ch-orcldb-s01 when doing node 1.
Note: This patch 20024405 is a no conflict on orcl stage as it is not installed on this cluster.

1. Applying GI PSU Jul2017 Patch 25901062 patch manually on orcl Stage cluster:

=============================== Manual Steps ==========================

— stop GG
. Stop GoldenGate if running on the server.
. as it’s a 2 nodes RAC cluster, we need to make sure (recommended) to identify from where GG is running:
ps -ef | grep mgr
. this’ll tell you, GG is running from which node, it’s good to connect to that node and stop GG from there itself.
– stop GG steps:
ggsci
info all
stop e* – will stop all extracts, make sure the name is starting with e
stop p* – will stop all pumps, make sure the name is starting with p
stop jagent ! – if its running
stop mgr !
info all – can do this after every stop command too, usually stopping extracts take some time
– make sure … all stopped

— stop ACFS filesystem
1. Stop acfs file system. (as root)

a. # cd /u01/app/12.1.0.2/grid/bin – to find: cat /etc/oratab (this’ll give you the grid home location)
b. # ./srvctl status filesystem -d /dev/asm/goldengate-440
c. # ./srvctl stop filesystem -d /dev/asm/goldengate-440 – bcz was connected as ggsci from another session/node 1, it took some time, make sure no one connected, especially if we are stopping for all nodes, if stopping only on this node, then make sure no one connected to that file system on this node, there shouldn’t be anyone connected to this filesystem: /u05/app
d. # ./srvctl status filesystem -d /dev/asm/goldengate-440 – down for all the nodes

PS: can also do this, can even leave GG running on node 1, but it’s not recommended, or at least, I don’t have good experience of this.
# ./srvctl stop filesystem -d /dev/asm/goldengate-440 -n ch-orcldb-s01 – will only stop on one node

— stop all database services
2a. have to stop all database services (on this node only)
$ srvctl config database – if you don’t know the name of the db, known to srvctl
$ srvctl status service -d orclstage
$ srvctl status service -d orclstage | wc -l – 8 services are running on both nodes
– stop all:
for i in `srvctl status service -d orclstage|awk ‘{print $2}’`
do
srvctl stop service -d orclstage -i orclstage1 -s $i
done
– this’ll stop all the services @ node 1 only
$ srvctl status service -d orclstage – verify again, before proceeding further, services should only be running on the other node, not this one.

— stop Oracle home (optional)
2. srvctl stop home -o /u02/app/oracle/product/12.1.0.2/db_1 -t immediate -s /home/oracle/state_file_stop -n ch-orcldb-s01 (as oracle) – got error bcz of services – this is an optional step

3. a. Verify that nothing running from oracle home. crsctl stat res ora.orclprod.db
b. Make sure the following executables “make,ar,nm,ld” are in PATH.

— make sure perl softlink is configured

find / -name vendor_perl -print 2>/dev/null
cp -i /u01/app/12.1.0.2/grid/perl/lib/5.14.1/Env.pm /usr/share/perl5/vendor_perl

4. /u01/app/12.1.0.2/grid/crs/install/rootcrs.pl -prepatch (as root)

5. PATCH GI HOME (as grid):

opatch apply -oh /u01/app/12.1.0.2/grid -local /u03/setup/GI_PSU_Jul2017/25901062/25869825
opatch apply -oh /u01/app/12.1.0.2/grid -local /u03/setup/GI_PSU_Jul2017/25901062/25869830
opatch apply -oh /u01/app/12.1.0.2/grid -local /u03/setup/GI_PSU_Jul2017/25901062/21436941 – got warning, bcz the patch already installed – ignore
opatch apply -oh /u01/app/12.1.0.2/grid -local /u03/setup/GI_PSU_Jul2017/25901062/25755742

6. PATCH DB HOME (as oracle):

/u03/setup/GI_PSU_Jul2017/25901062/25869825/custom/scripts/prepatch.sh -dbhome /u02/app/oracle/product/12.1.0.2/db_1

opatch apply -oh /u02/app/oracle/product/12.1.0.2/db_1 -local /u03/setup/GI_PSU_Jul2017/25901062/25869825

opatch apply -oh /u02/app/oracle/product/12.1.0.2/db_1 -local /u03/setup/GI_PSU_Jul2017/25901062/25755742

/u03/setup/GI_PSU_Jul2017/25901062/25869825/custom/scripts/postpatch.sh -dbhome /u02/app/oracle/product/12.1.0.2/db_1

7. /u01/app/12.1.0.2/grid/rdbms/install/rootadd_rdbms.sh (as root)

8. /u01/app/12.1.0.2/grid/crs/install/rootcrs.pl -postpatch (as root)

Note: if the message, “A system reboot is recommended before using ACFS is shown, then a reboot is required….”

9. srvctl start home -o /u02/app/oracle/product/12.1.0.2/db_1 -s /home/oracle/state_file_stop -n ch-orcldb-s01 (as oracle)

10. Verify all resources on node-2 is up and running. Apply patch on node 1 now.

10a. mount -t acfs /dev/asm/goldengate-440 /u05/app

verify acfs is mounted

11. For each database instance running, run datapatch utility.

a. Startup instance (if not up). Note: This will be run one-time only for each database, not per instance.
b. sqlplus ‘/as sysdba’
c. alter pluggable database all open. (if not opened)
d. cd $ORACLE_HOME/OPatch
e. ./datapatch -verbose

11. Verify ACFS is available. Start Golden Gate.

Note: The steps from 0 to 9 will be repeated on each node in the cluster.

=========================ROLLBACK STEPS==================================

1. Stop any processes using acfs such as GG.
2. Stop acfs file system. (as root)
3. srvctl stop home -o /u02/app/oracle/product/12.1.0.2/db_1 -s /home/oracle/state_file_stop -n ch-orcldb-s01 (as oracle)

4. /u01/app/12.1.0.2/grid/crs/install/rootcrs.pl -prepatch -rollback (as root)

Roll back from GI home (as grid):
5. opatch nrollback -local -id %OCW TRACKING BUG%,%ACFS TRACKING BUG%,%RDBMS PSU TRACKING BUG%,%DBWLM TRACKING BUG% -oh /u01/app/12.1.0.2/grid

Roll back from DB home (as oracle):

6. /u03/setup/GI_PSU_Jul2017/25901062/%BUGNO%/%OCW TRACKING BUG%/custom/scripts/prepatch.sh -dbhome /u02/app/oracle/product/12.1.0.2/db_1

7. opatch nrollback -local -id %OCW TRACKING BUG%,%RDBMS PSU TRACKING BUG% -oh /u02/app/oracle/product/12.1.0.2/db_1

8. /u03/setup/GI_PSU_Jul2017/25901062/%BUGNO%/%OCW TRACKING BUG%/custom/scripts/postpatch.sh -dbhome /u02/app/oracle/product/12.1.0.2/db_1

Run the post script as root:
9. /u01/app/12.1.0.2/grid/rdbms/install/rootadd_rdbms.sh

10. /u01/app/12.1.0.2/grid/crs/install/rootcrs.pl -postpatch -rollback (as root)

Note: if the message, “A system reboot is recommended before using ACFS is shown, then a reboot is required….”

11. srvctl start home -o /u02/app/oracle/product/12.1.0.2/db_1 -s /home/oracle/state_file_start -n ch-orcldb-s01 (as oracle)

12. For each database instance running, run datapatch utility.

a. Startup instance (if not up)
b. sqlplus ‘/as sysdba’
c. alter pluggable database all open. (if not opened)
d. cd $ORACLE_HOME/OPatch
e. ./datapatch -verbose

=======================Patch information============================

25755742 DB PSU 12.1.0.2.170718 (Jul2017) Both DB Homes and Grid Home
25869825 OCW PSU 12.1.0.2.170718 Both DB Homes and Grid Home
25869830 ACFS PSU 12.1.0.2.170718Foot 1 Only Grid Home
21436941 DBWLM PSU 12.1.0.2.5Footref 1 Only Grid Home

======================= start GG ===================================

at the time of starting GG, encounter issue, it’s a know problem:

Solution:
Fix for golden gate issue after jul 2017 grid psu:
Added the line below in extract parameter file:
tranlogoptions _dbfilterddl
then once caught up, commented the parameter and bounced the extract.

steps:
stop extract
edit extract.prm file
add this line: tranlogoptions _dbfilterddl
start extract … wait for it to be completely sync
as it’s good
stop the extract again
edit extract.prm file
comment the same line — tranlogoptions _dbfilterddl

51 thoughts on “Oracle 12c PSU”

  1. We are a group of volunteers and opening a new scbeme in our community.
    Your web site offered us with valuable information to
    work on. You’ve done an impressive job and our whole
    community will be thankful to you.

  2. When I initiaslly commented I appear to have clicked on the -Nootify me when neww
    comments are added- checkbox and from now on each time a comment
    is added I recieve four emails with the same comment.

    There has to be a way you can remove me from that service?

    Thank you!

  3. Hello There. I found your blog using msn. This iis an extremely well
    written article. I will be sure to bookmark it
    and come baack to read more oof your useful information. Thanks for the
    post. I will certainly return.

  4. Attractive part off content. I simply stumbled upon your weblog and in accession capital to claim that
    I get in fact enjoyed account your blog posts. Any way I’ll be subscrkbing for your augment
    aand even I fulfillmen you get entry to constantly quickly.

  5. Good day I am so excited I found your website, I really found
    you by mistake, while I was browsing on Google for something else,
    Anyways I am here now and would just like to
    say many thanks for a marvelous post and a all round thrilling blog (I
    also love the theme/design), I don’t have time to read through it all at the moment but I have book-marked it and also included your RSS feeds, so when I have time I will be back
    to read more, Please do keep up the fantastic work.

  6. Hello just wanted to give you a quihk heas up. The text in your article seemm to be
    rujning off the screen in Internet explorer. I’m not sure if this is a format issue or something to do with browser compatibility
    but I figured I’d post to let you know. The style and design look great though!
    Hope you get the problem solved soon. Manny thanks

  7. Hi, I do believe this is a great web site.
    I stumbledupon it 😉 Iam going to revisit once again since
    I book-marked it. Monbey and freerom is the greatest way
    to change, may yoou bee rich and contjnue to guide others.

  8. Hey I know this is off topic but I was wonfering if you knew of anyy
    widdgets I could addd to my blog that automattically tweet my newest twitter updates.

    I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would hazve some experience with something like this.

    Please let me know if you run into anything.
    I truly enjoy reading your blog and I lok forward to your new updates.

  9. Nice post. I learn something new and challenging on sites I stumbleupon every day.
    It’s always interesting to read content from other authors and use a littlee something from
    other web sites.

  10. Undeniably believe that which you stated. Your favorite justification seemed to be on the internet the
    simplest thing to be aware of. I say to you, I definitely get irked while people consider worries
    that they plainly don’t know about. You managed to hit the nail upon the top as well as defined out the
    whole thing without having side effect , people coould taie a
    signal. Will probably bbe back to get more. Thanks

  11. Hey very nice website!! Guy .. Excellent .. Superb .. I will bookmark your
    web site and take the feeds additionally?
    I’m glad to search out a lot of useful info here in the put up, we’d like
    develop extra techniques in this regard, thanks for sharing.

    . . . . .

  12. Goood day! I know this iis inda off topic but I was wondering whjch blog platform are you using for this website?

    I’m getting fed up of WordPress because I’ve haad problems with
    hackers and I’m looking at options for another platform.
    I would be awesome if you could point me in the direction of a good platform.

  13. Astropay satın al komutu iile işlem yapmak ve alışveriş
    sitelerinde kullanılabileceğiniz astroppay puanlarına sahip olmak için öncelikle yukarıda verdiğimiz
    adrese giriş yapmak ve astropay’a üye olmak zorundasınız.
    Bu üyelik sayesinde astropay puanı alna ve alışveriş sitelerine transfer etme şansına ulaşabilirsiniz.
    Astropay da diğer ödeme araçları gibi farklı para birimlewri ile alınabilen bir puan sistemine sahiptir.
    Kur farkı olarak ortaya çıkan ve astropay sitesinin komisyon ücreti olarak sitenin kendi hesaplarında kalan ücretler düşüldükten sonra kalan paranız ile astropay puanı
    alarak bahis sitelerine bu puanları transfer
    edebilmektesiniz. Astropay günümüzde birçok alışveriş sitesi ile de anlaşmalı bir site olduğu için anlaşmalı olduğu her siteye astropay puanını gönderme şansınız bulunmaktadır.

  14. What i don’t understood is inn reality how you’re not
    really much more well-liked than you may be now. You are very intelligent.
    You already know therefore considerably in terms of this subject,
    prduced me personally imagije it from a lot of numerous
    angles. Its like men and women are not involved until it is
    something to do with Lady gaga! Your individual stuffs nice.

    Always take care of it up!

  15. I was wondering if you ever considered changing the page layout of ypur website?
    Its very well written; I love what youve got to say. Butt
    maybe you could a little more in the way of content so people could connect with
    it better. Youve got an awfjl lot oof text for oonly
    having one orr two pictures. Maybe you could space it
    out better?

  16. Someone necessarily help to make significantly
    articles I would state. This is the very first
    time I frequented your website page and up to now? I surprised with the research you made to create this particular submit incredible.
    Excellent job!

  17. Excelent article. Keep poosting such kind of info on your blog.
    Im really impresxed by your blog.
    Hello there, You have done a great job. I’ll definitely
    digg it and for mmy part recommend to my friends. I am confident they’ll be benefited from this web site.

  18. I don’t even know the way I finished up here, however I believed this put uup was
    good. I ddo nott realize who you aree however
    definitely you’re going to a famous blogger if you happen to are
    not already. Cheers!

  19. Hiya very nice web site!! Guy .. Excellent .. Superb ..
    I’ll bookmark your website and take the feeds additionally?
    I am satisfied to search out numerous helpful info right here
    within the publish, we’d like work outt more techniques on thiks
    regard, thanks for sharing. . . . . .

  20. May I simply just sayy what a relief to uncover someone that really knows what they are discussing
    on thhe web. You certaihly know how tto bring an issue to
    light and make it important. More people must read this and understand this side
    of the story. I can’t believe you’re not more popular because you certainly havve the gift.

  21. Aperson essentiaslly assist to make critically articles I would
    state. That is the very first time I frequented your website pag and to this point?
    I surprised with the analysis you made to create this actual put up amazing.
    Great job!

  22. Its like you read my mind! Youu seem to know a lott about this, like you wrote the book in iit or something.
    I think that you cann do with some pics to driove the message home a
    little bit, but instead oof that, thgis is fantastic blog.
    A great read. I will definitely be back.

  23. I do beelieve alll the concepts you’ve offered for yor post.

    They are very convincing and will definitwly work. Still, the posfs arre too quick for beginners.
    May just you please lengthen them a bit from next time? Thank
    you for the post.

  24. Hey! I’m at work surfing around your blog from
    my new iphone 3gs! Just wanted to say I love reading through your blog and look forward to
    all your posts! Cartry on the superb work!

Leave a Reply

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