convert RAC to single-instance
We want to convert some RAC databases back to single-instance.
Can we do it by preserving all the data in the clustered ASM and by just:
1- - Installing NON-RAC 10.2 rdbms
2- - - Updating the init file by setting cluster_database = false
3- - Restart the database with the single-instance 10.2.0.4 ORACLE_HOME
- Also, updating all the listeners by listening on the hostname and not hostname-vip.
Any other considerations ?
Thanks.