I would like to share one of my experience in a Project where we have a Scenario of moving our BPPM Oracle RAC Database Instance to a Oracle Standalone Database Instance. We just have backup of our RAC Database kept with all data in it.
We have restored the DB Backup from RAC to Standalone Oracle DB instance.
Further to this we have made changes in pronet.conf file over BPPM Application Server.
We need to replace the enteries of Oracle RAC with Oracle Standalone Instance. While doing these changes keep BPPM Application Server completely down.
RAC Instance Enteries which needs to be removed.
Standalone Enteries which needs to be placed.
Once this is done. Turn on BPPM Application.
Your BPPM will be up and running over Oracle Standalone Database.