I am changing my database from MYSQL to ORACLE can I still use the information on MYSQL and convert to ORACLE or will I have to do a clean install of the platform? Will the database communicate? Also does anyone have any good network diagramns of moodle in MYSQL and ORacle I want to make sure its housed correctly. right now its housed 2 CPU INtel Xeon 7.5gb Ram and 30gb storage the database is on RDS machine 4 CPU with 15gb ram, 100gb storage with 500Mbps connection all teh sites are on a load balance to distribute the load in case of heavy usage.
Firstly, it's a *very* bad plan to use Oracle as the back end for Moodle. Oracle isn't meant for this sort of thing and you may see performance issues. Also, nobody tests with Oracle so you have a high chance of bugs.
Use MySQL or PostgreSQL which are recommended and fully supported.
I believe Postgres is a bit more like Oracle than MySQL,