Hi
If I restore an oracle 10.2.0.4 database (RHEL 4.7, 64bit) to a server which has Oracle 10.2.0.5 binaries (RHEL 4.7 64bit), would it work? Or is there a script that I must run to upgrade the database from 10.2.0.4 to 10.2.0.5?
The reason I am asking is that our database servers are being managed by 3rd party. One server has 10.2.0.4 and other has 10.2.0.5. I have to bring both databases to new server. I cannot upgrade the 10.2.0.4 on 3rd party's server.
I can prepare the new server with 10.2.0.4, restore 10.2.0.4 database and upgrade it to 10.2.0.5. Then bring over the other 10.2.0.5 database (from2nd server). I want to avoid doing this exercise multiple times (for DEV/Tes/QA/PROD). What maybe a better approach?
Best regards