Oracle 12c PSU


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:
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/ – 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}’`
srvctl stop service -d orclstage -i orclstage1 -s $i
– 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/ -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/ /usr/share/perl5/vendor_perl

4. /u01/app/ -prepatch (as root)

5. PATCH GI HOME (as grid):

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

6. PATCH DB HOME (as oracle):

/u03/setup/GI_PSU_Jul2017/25901062/25869825/custom/scripts/ -dbhome /u02/app/oracle/product/

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

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

/u03/setup/GI_PSU_Jul2017/25901062/25869825/custom/scripts/ -dbhome /u02/app/oracle/product/

7. /u01/app/ (as root)

8. /u01/app/ -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/ -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/ -s /home/oracle/state_file_stop -n ch-orcldb-s01 (as oracle)

4. /u01/app/ -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/

Roll back from DB home (as oracle):

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

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

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

Run the post script as root:
9. /u01/app/

10. /u01/app/ -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/ -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 (Jul2017) Both DB Homes and Grid Home
25869825 OCW PSU Both DB Homes and Grid Home
25869830 ACFS PSU 1 Only Grid Home
21436941 DBWLM PSU 1 Only Grid Home

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

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

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.

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

86 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!

  25. Hey just wanted to give you a quick heads up. The words in yopur post seem to be
    running off the screen in Ie. I’m noot sure if this iss a format
    issue or something to do with browser compatibility but I thought I’d poat
    to let you know. The esign ook great though!
    Hope you geet the issue fixed soon. Cheers

  26. Hi! I kow this is kind of off topic but I was
    wondering which blog platform are yyou using for
    this website? I’m getting sick and tired oof WordPress because I’ve had problems with hackers and I’m looking at alternatives for
    another platform. I would be fantastic if you could polint me in the direction of a
    good platform.

  27. Hello, i read your blog occasionally and i own a similar one
    and i was just wondering if you get a lot oof spam feedback?
    If so how do you prevent it, any plugin oor anything yoou can suggest?
    I get so much lately it’s driving me crazy so any support is
    very much appreciated.

  28. Hiya! I knmow this is kinda off topic but I’d figured I’d ask.
    Would you bbe interested iin trading links or maybe guest writing a blog post or vice-versa?
    My website goes over a lott of the same topoics as yours and I think we could greatly benefit from each other.
    If you might be interested feel free to send me an email.
    I look forward to hearing from you! Excellent blog by the way!

  29. Howdy! This blog post couldn’t be written any better!
    Looking through this article reminds me of my previous roommate!
    He always kept talking about this. I’ll forward this post to him.
    Pretty sure he’s going too have a reat read. Many thanks for sharing!

  30. I’ve been exploring for a little for any high qualiity articles or
    weblog posts in this sort of hopuse . Exploring in Yahoo I finally sttumbled upon this website.
    Reading this information So i’m happy to show that I’ve a very good uncanny feeling I discovered just what I needed.
    I most for sure will make certain to don?t put out of your mind tjis web
    site and give it a glance regularly.

  31. With havin so much content do you ever run into
    any issues of plagorism or copyright infringement? My website has
    a lot of completely unique content I’ve either written myself or outsourced but it seems a lot of it
    is popping it up all over the web without my authorization. Do you
    know any ways too help stop content from being ripped off?
    I’d definitelyy appreciate it.

  32. Attractive section of content. I just stunbled upon your web site and in accession capial to
    assert that I get in faht enjoyed account your blog posts.
    Any way I wilpl be subscribing to your augment and even I achievement
    you access consistently fast.

  33. Hi there would you mind stating which blog platform
    you’re working with? I’m planning to start my own blog in the near future but I’m having a
    tough time choosing between BlogEngine/Wordpress/B2evolution and Drupal.
    The reason I ask is because your layout seems different then most blogs
    and I’m looking for something unique.
    P.S My apologies for being off-topic but I had to ask!

  34. Thank you for the auspicious writeup. It in fact was a amusement account it.
    Look advanced to far added agreeable frokm you!
    However, how can we communicate?

  35. My prrogrammer iis trying to convince me to move to .net from PHP.
    I have always disliked the icea bbecause of the expenses.
    But he’s tryiong none the less. I’ve been using WordPres on a
    variety of websites for about a year and am
    concerned about switching to another platform. I have heard excellent things about
    Is theere a way I can ttransfer all my wordpress posts into it?
    Any help would be really appreciated!

  36. Thank you a lot ffor sharing thnis with all folks yoou really
    recognize what you are speaking approximately! Bookmarked.

    Kindly additionally consult with myy website =). We will have a link
    change arrangement among us

  37. Greetings from California! I’m bored to deatfh
    aat work so I decided to check out your site on my iphone
    during lunch break. I really like the knowledge
    you provide here and can’t wait to take a look when I get home.
    I’m shocked at how quick your blog loaded on my phone .. I’m
    not even using WIFI, just 3G .. Anyways, supetb

  38. hey there and thank you for your info – I have
    definitely picked upp anything new from right here.

    I did however expertise some technical issues using this web site, as I experienced to reload
    the website a lot of times previou to I could get
    it to load correctly. I had ben wondering if your
    web host is OK? Not that I am complaining, but sluggish loading
    instanxes times will sometimes affect your placement in google and
    could damage your high quality score if ads aand marketing with Adwords.
    Well I’m adding ths RSS to my e-mail and could look ouut for
    much more of your respective exciting content. Make ssure you update thks again very soon.

Leave a Reply

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