Removal of Rac from Prod server

[senthil]

Hi Erman,


Greetings!!


DB Version: 10.2.0.4 with Rac ( NON ASM)
Apps Version: 12.0.4
PLatform: Windows server 2003 SP2

Erman,

Our production is running with rac cluster. Before it was 2 node, then due to some issues we have removed the another node. Now its running with single node rac cluster, we want to remove the RAC Cluster now and make it as normal database without RAC & ASM.

Please let me know the possiblities and note id's.

Thanks for your help!

Regards
--Senthil

[ErmanArslansOracleBlog]

You should first remove the database cluster registry entries using srvctl and then convert your db to non-rac using cluster_database=false and then you need to disable thread2 and drop undo2 (the redo and undo of the second instance)

The blog post in the following url seems explaining it -> https://avdeo.com/2010/02/26/converting-a-rac-database-to-single-instance-database-oracle-rac-10g/

However, if you want to remove the clustering software completely, then there are more things to do..

[senthil]

Hi Erman,


Thanks for your reply.

I will work on this steps and let you know after that.


Regards,
-Senthil

[senthil]

Hi Erman,

Steps i did:

1. Removed the database as per the steps in link which you sent
2. Removed crs home
3. Installed new oracle home and restored DB
4. Copied new appsutil component from application server to DB

Its working fine now.

Thanks for your help!


Thanks
-SenthilPrasath