I have a database in an oracle_home that is 188.8.131.52.0 and can not at the moment patch the home to 184.108.40.206.0 yet. I have another oracle_home that is 220.127.116.11.0 so I am planning on moving this particular database over. Because the major builds are the same, differences being the patchset, is it safe to shut the database down, move files to the new home, change environment variables, and bring it back online in the new home. If so, which scripts if any do I need to run against the database once it is back online?
So basically by moving the datafiles to the other home, I am just going to skipp the installing of the new binaries step, and once the database is opened, start with the catpatch.sql script as instructed in the readme and all other necessary scripts in the following steps? It sounds easy enough....am I missing anything?