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?
The database version is "almost" the same (10.2.0.4 to 10.2.0.5) so it pprobably works.But of course, the best option ( the correct one) is to make the upgrade.
¿do you have console access like dba to your database?
In that case, you can do a "startup upgrade "
You can look at <a href="http://docs.oracle.com/cd/B19306_01/server.102/b14238/upgrade.htm#i1011482">Oracle® Database Upgrade Guide 10g Release 2 (10.2)</a>
or you can follow the steps like if you were upgrading the database. The upgrade from 10.2.0.4 to 10.2.0.5 was made by patch 8202632 , you can look at the "README" of this patch and follow the point "11.4.2 Upgrading a Release 10.2 Database" ,