Tuesday, October 26, 2010

How to enable and disable RAC option in version 9.2.0.1 to 11.1.0.8

REASON

1.                   Sometimes for ORACLE RAC DB you need to check backup/restore on server with not linked RAC option
2.                   Restore DB to new server where RAC option is not enabled and you can get
ORA-00439: feature not enabled: Real Application Clusters
3.                   If you try DBCA with no RAC servers and cluster manager with a linked RAC option into oracle you can get
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:if_not_found failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: skgxpvaddr9


CHECK IF RAC_ON or RAC_OFF

cd $ORACLE_HOME/rdbms/lib
nm -r libknlopt.a | grep -c kcsm.o
If above command returns 0, then RAC is not linked. If it returns >= 1, then it is linked.
#spfile

alter system set cluster_database=false scope=spfile;


ENABLE RAC OPTION 

cd $ORACLE_HOME/rdbms/lib
shutdown everything
make -f ins_rdbms.mk rac_on ioracle

DISABLE RAC OPTION 

cd $ORACLE_HOME/rdbms/lib
shutdown everything
make -f ins_rdbms.mk rac_off ioracle

34 comments:

  1. Thanks a bunch for sharіng this wіth all pеople you
    really knоw ωhat yοu're talking approximately! Bookmarked. Kindly additionally seek advice from my site =). We can have a hyperlink exchange arrangement among us

    My website ... single family homes for rent mckinney

    ReplyDelete
  2. Superior to view you posting on this topic, I'd like to your bookmarks. Continue up to the pleasant task.

    My weblog poetryoffood.com/your-stories/bernadinex/traveling-suggestions-going-allow-you

    ReplyDelete
  3. Overctivation ߋf tҺe immune system mаy result in elevated inflammatory ɑnd immune proteins potentiallү leading tߋ reduced carrier proteins, partiсularly albumin, setting a biodhemical environment аssociated with sub-optimal aging.
    Thіs research, whiich ѡaѕ performed jointly at the
    Roddenberry Center fߋr Stem Cell Rеsearch аt Gladstone аnd the
    Broad Center off Regeneration Medicine ɑnd Stem Cell Rеsearch at UCSF, involved usung а 'cocktail' of reprogramming genes ɑnd chemical compounds to transform human skin cells into cells tҺat resembled tҺe
    endoderm. սsing hands-free voice and touch-screen controls
    viaa Bluetooth-enabled phones.

    Feel free tο visit my web site :: regeneracja pompy wtryskowej

    ReplyDelete
  4. Which at the finish of the day individuals enjoying
    these games, have lease car funds, or just dont have the funds to purchase their platinum solely armors.

    Obtaining that additional help coupled with advice, this zodiac personal of sorts,
    could anticipate or at the actual least, indicate a truly generalized account from folks personality make-up.
    Zynga has now created its own website so that people playing Farm - Ville through Facebook will jump over to their site and then be able to get better things than they can get playing
    the other version.

    Also visit my web site :: arcane legends hack

    ReplyDelete
  5. Yesterday, while I was at work, my cousin stole my iPad and tested
    to see if it can survive a forty foot drop, just so she can be a youtube sensation. My
    apple ipad is now destroyed and she has 83 views.
    I know this is completely off topic but
    I had to share it with someone!

    Visit my web blog :: asistenta sociala

    ReplyDelete
  6. Everything is very open with a really clear clarification of the challenges.
    It was really informative. Your site is useful.
    Many thanks for sharing!

    My web-site - install gimp by running

    ReplyDelete
  7. Your mode of describing everything in this article is genuinely pleasant, all
    be capable of easily understand it, Thanks a lot.

    Here is my weblog ... best muscle building supplements for men

    ReplyDelete
  8. Exellent article , im going to bookmark your site , have a look also on my site Visit my site also

    ReplyDelete
  9. Have you been seeking good exposure to the skills and qualified professional capabilities on LinkedIn? The very best resolution is thru Buying LinkedIn Endorsements, Connections and Followers. website to buy linkedin connections

    ReplyDelete
  10. There's nothing freely available on earth, but guarantee that you Buy facebook reviews only from the valid sources for productive recognition online. buy facebook 5 star ratings

    ReplyDelete
  11. Have you been looking for real real YouTube likes? Leave behind your headaches, we can extensively direct you to how to buy youtube views

    ReplyDelete
  12. Have you been seeking to ways to get popularity swiftly? You simply require to Buy Facebook Followers to get renowned on internet. buy followers on facebook

    ReplyDelete
  13. It is evident that no concern how fascinating your posts are, on your ID, people will certainly never ever include their likes on these occasions such as photos and also video clips without strong 'ask for activity'. buy real usa facebook likes

    ReplyDelete
  14. In case you are being assured round-the-clock Support and lifetime replacement then do not rethink as you Buy facebook reviews from a vendor. buy facebook fanpage reviews

    ReplyDelete
  15. Facebook is a dazzling platform which provides its customers immense probabilities to expand their perspectives. usa facebook likes

    ReplyDelete
  16. Constantly get the ICO done by professional white paper authors as they do substantial research study and have a detailed understanding of the blockchain and bitcoin market. ico white paper writing services

    ReplyDelete
  17. All the interested candidates who want to Apply Online form for any given vacancy for NTRCA Job Circular 2021 Bangladesh job, must firstly, check official notification carefully and then, You can directly Online Apply Application form by Just following Few steps or offline Application form

    ReplyDelete