This content has been marked as final. Show 6 replies
why you want to recreate the controlfile, does the mount point locations are changing from old server to new server?
if you recreating controlfile new incarnation starts, keep in mind.
you have the downtime to upgrade.. :)
take cold backup and move to new server.
create the directory structure as exist in PFILE including CRD files.
upgrade database(need to add sysaux TBS)
change hostname in listner.ora/tnsnames.ora files.
799727 wrote:Yes you can direct upgrade from 9.2 => 10.2,please refer upgrade guide
Is it possible not to move the files from the mounted drive and treat it as it is and then upgrade the database from Oracle 9.2 to Oracle 10.2?